Big error gallery dont works anymore

[AmanM]

I have criticall error whith the gallery first  i've i wanted to do something whitch runs a datbase query like deleting images and more.
So i went to drop some tables and renew them but now i get this error.

Code Select Expand

[quote]While executing query "SELECT a.aid, count( p.pid )  AS pic_count, max( p.pid )  AS last_pid, max( p.ctime )  AS last_upload, a.keyword FROM cpg1410_albums AS a  LEFT JOIN cpg1410_pictures AS p ON a.aid = p.aid AND p.approved =  'YES' WHERE a.aid IN ()GROUP BY a.aid" on 0

mySQL error: 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 ')GROUP BY a.aid' at line 1[/quote]


http://www.saifuworld.org/gallery/

User for testing

Name:test
Password:test

Thanks already

[Nibbler]

Looks like you emptied your config table. Repopulate it using the defaults in include/basic.sql

[AmanM]

Thanks it's fixed but now i have a problem i have a category named Movies and all the categorys in that are now displayed on the index and not in the movie category maby you can help me whith that.

Your the best nibbler i would searched all night to find this.

[Nibbler]

That's a config setting - number of levels of categories to display. Please try to keep to one question per thread as per the rule.

[AmanM]

Ok sorry Nibbler wont do it again