Print Page - Critical Error on my board

Title: Critical Error on my board
Post by: arrs on October 15, 2004, 10:36:26 PM

Hello, all

Ive got a problem with my gallery i did post before but I didnt get it fixed any ideas?
I get the following when Im logged out when I click on the user galleries.If Im logged in it works and everything else seems to be fine is well.

QuoteCritical error

There was an error while processing a database query.

While executing query "SELECT count(*) FROM sw50gallery_albums as a WHERE category = '1' and AND a.aid NOT IN (2,4,8) " 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 'AND a.aid NOT IN (2,4,8)' at line 1

File: /homepages/43/d94096769/htdocs/southwest50s.co.uk/gallery/include/functions.inc.php - Line: 110

I dont know if this helps as I dont know anything about MySql and this is probarly useless info but in sw50gallery_albums under the Run SQL query/queries on database dbname it says SELECT * FROM `sw50gallery_albums` WHERE 1

website www.southwest50s.co.uk/forum (beware very bright :))
username chris
password test
Thanks

James

Title: Re: Critical Error on my board
Post by: Joachim Müller on October 16, 2004, 08:22:48 AM

you already have been told on the other thread to upgrade coppermine from cpg1.3.0 to cpg1.3.2

Joachim

Title: Re: Critical Error on my board
Post by: arrs on October 17, 2004, 11:19:31 AM

Sorry mate I forgot about lol.

Will do now.

Cheers

Title: Re: Critical Error on my board
Post by: arrs on October 17, 2004, 01:18:17 PM

Well that sorted it, Cheers

The rotate still doesnt work but thats not a problem

Thank you very much :)

coppermine-gallery.com/forum

Support => cpg1.3.x Support => Older/other versions => cpg1.3 (BBS) Integration / Bridging => Topic started by: arrs on October 15, 2004, 10:36:26 PM