Critical Database Error

[cjkline83]

When attempting to test the ability to view a private file (seeing if the file really is private), I get the following error after I have logged out and selected user albums.

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

And this is displayed in the skin:

"Critical error

There was an error while processing a database query."

The good news is that the picture really is private.

[Joachim Müller]

It would have been easier for supporters if you actually split your posting into two different threads (we have a policy of one question per thread). Edit you above posting to show only the privacy issue and start a new thread for the ecards issue on the bbs integration board.

GauGau

[cjkline83]

This thread has been modified as you wish, sir.

Thank you.

[Joachim Müller]

did you manually enter the url into the address bar, or did you browse your gallery? Please post a link.

GauGau

[cjkline83]

did you manually enter the url into the address bar, or did you browse your gallery? Please post a link.

GauGau

When I manually enter in the address http://cjkline83.shacknet.nu/cm/index.php?theme=classic (or any other theme) it works. But if attempting to switch to a different theme from the scripts drop down bar, it errors as described above taking the user to the link of http://cjkline83.shacknet.nu/php/php.exe?theme=eyeball

Thanks in advance.

[Joachim Müller]

http://forum.coppermine-gallery.net/index.php?topic=2140.0

GauGau