Announcement

  •  » Engine
  •  » Rating details in "Administration Home" for webmaster/admin

#1 2014-01-10 10:47:11

Bertus Laufs
Guest

Rating details in "Administration Home" for webmaster/admin

After upgrading to the latest version and logging on as an admin, when I wish to get detail of the image ratings under "Administrator Home-Photos-Rating" I receive the following return instead of the rating analysis:

Warning:  [mysql error 1064] You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ORDER BY date DESC' at line 4
SELECT *
FROM xof_rate AS r
WHERE r.element_id=
ORDER BY date DESC; in /home/dpcsanet/public_html/CMS/include/dblayer/functions_mysqli.inc.php on line 834


Notice: Trying to get property of non-object in /home/dpcsanet/public_html/CMS/include/dblayer/functions_mysqli.inc.php on line 171

Fatal error: Call to a member function fetch_assoc() on a non-object in /home/dpcsanet/public_html/CMS/include/dblayer/functions_mysqli.inc.php on line 181

How can I fix this?

 

#2 2014-01-10 14:20:35

flop25
Piwigo Team
2006-07-06
7037

Re: Rating details in "Administration Home" for webmaster/admin

First Hello?

Then you should try to reupload all files of Piwigo by overwriting existing files, first.


To get a better help : Politeness like Hello-A link-Your past actions precisely described
Check my extensions : more than 30 available
who I am and what I do : http://fr.gravatar.com/flop25
My gallery : an illustration of how to integrate Piwigo in your website

Offline

 

#3 2014-01-11 12:22:09

Bertus Laufs
Guest

Re: Rating details in "Administration Home" for webmaster/admin

Hi flop25

Ho rude of me! Thank you for offering a solution - I have reuploaded all the Piwigo files and the request for "Ratings" still return the same reply. Anything else I can try?

Regards

B

 

#4 2014-01-11 15:10:47

flop25
Piwigo Team
2006-07-06
7037

Re: Rating details in "Administration Home" for webmaster/admin

Ok then the next step is to check third party extension: disable plugins

did you have ratings before? check the xof_rate table, in your database


To get a better help : Politeness like Hello-A link-Your past actions precisely described
Check my extensions : more than 30 available
who I am and what I do : http://fr.gravatar.com/flop25
My gallery : an illustration of how to integrate Piwigo in your website

Offline

 

#5 2014-01-12 16:31:25

Bertus Laufs
Guest

Re: Rating details in "Administration Home" for webmaster/admin

Hi flop25

No changes after I disabled all plugins. Used to have ratings before - it disappeared after the last upgrade.

Just for clarification - the rating I am referring to is the query capability in the Administrators section, once logged on as administrator.

I am not sure where to find the db you are referring to.

Kind regards

B

 

#6 2014-01-12 17:32:27

Bertus Laufs
Guest

Re: Rating details in "Administration Home" for webmaster/admin

Another thing - it seems that xof_rate must be contained in /functions_mysq1i.inc.php - but after I downloaded and reinstalled 2.5.3 it is not there. Does this help?

Regards
B

 

#7 2014-01-15 18:05:08

Bertus Laufs
Guest

Re: Rating details in "Administration Home" for webmaster/admin

Hi

Any other potential solutions?

Regards

Bert

 

#8 2014-01-15 18:11:40

flop25
Piwigo Team
2006-07-06
7037

Re: Rating details in "Administration Home" for webmaster/admin

If that's not a corrupted file or a bad extensions, I'm short of solutions...


To get a better help : Politeness like Hello-A link-Your past actions precisely described
Check my extensions : more than 30 available
who I am and what I do : http://fr.gravatar.com/flop25
My gallery : an illustration of how to integrate Piwigo in your website

Offline

 

#9 2014-01-15 21:15:26

rvelices
Piwigo Team
2005-12-29
1960

Re: Rating details in "Administration Home" for webmaster/admin

Bertus Laufs wrote:

Hi

Any other potential solutions?

Regards

Bert

can you install the plugin rv db integrity and have a run from the Tools / Maintenance page in the admin ?

I have a feeling that your db is not ok ... Did you manually (using sql or phpmyadmin ...) played with the database ?

Offline

 

#10 2014-01-17 11:35:50

Bertus Laufs
Guest

Re: Rating details in "Administration Home" for webmaster/admin

Hi rvelices

Thank you for your response.

This started when I upgraded to 2.5.3 - and the problem is in the database, as stipulated above. I downloaded piwigo from the website and re-installed, but found the same error. I tried your solution which confirms that the problem is in the database:

DB Integrity Check
Test    Result
#xof_images.id (7 references)    1 FAILED
1 error references; #xof_rate.element_id referring to #xof_images.id
#xof_categories.id (7 references)     Passed
#xof_tags.id (1 references)     Passed
#xof_groups.id (2 references)     Passed
Pemalinks (1 references)     Passed
#images(id,storage_category_id) dans #image_category (1 references)     Passed

I am not sure how to fix this.

Thank you for the support

Bertus

 

#11 2014-01-17 23:26:11

rvelices
Piwigo Team
2005-12-29
1960

Re: Rating details in "Administration Home" for webmaster/admin

- backup your database (just in case)
- launch the following query

Code:

DELETE FROM xof_rate 
WHERE element_id NOT IN (SELECT id FROM xof_images)

Offline

 

#12 2014-01-21 08:52:46

Bertus Laufs
Guest

Re: Rating details in "Administration Home" for webmaster/admin

Hi rvelices

I am stumped!

Please explain the workflow to launch the code you suggested.

Kindest regards

Bertus

PS. I am rather stupid here, am I not? :-D

 

#13 2014-01-21 09:50:25

flop25
Piwigo Team
2006-07-06
7037

Re: Rating details in "Administration Home" for webmaster/admin

in your databse manager/interface, usually phpMyAdmin, use tab Export and the tab Execute Sql


To get a better help : Politeness like Hello-A link-Your past actions precisely described
Check my extensions : more than 30 available
who I am and what I do : http://fr.gravatar.com/flop25
My gallery : an illustration of how to integrate Piwigo in your website

Offline

 
  •  » Engine
  •  » Rating details in "Administration Home" for webmaster/admin

Board footer

Powered by FluxBB

github twitter newsletter Donate Piwigo.org © 2002-2022 · Contact