forum.coppermine-gallery.net

Support => cpg1.4.x Support => Older/other versions => cpg1.4 upgrading => Topic started by: AmanM on March 05, 2007, 12:14:00 am

Title: Big error gallery dont works anymore
Post by: AmanM on March 05, 2007, 12:14:00 am

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]

[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

Title: Re: Big error gallery dont works anymore
Post by: Nibbler on March 05, 2007, 12:15:46 am

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

Title: Re: Big error gallery dont works anymore
Post by: AmanM on March 05, 2007, 06:19:23 pm

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.

Title: Re: Big error gallery dont works anymore
Post by: Nibbler on March 05, 2007, 06:43:26 pm

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.

Title: Re: Big error gallery dont works anymore
Post by: AmanM on March 05, 2007, 08:30:40 pm

Ok sorry Nibbler wont do it again