Advanced search  

News:

CPG Release 1.6.26
Correct PHP8.2 issues with user and language managers.
Additional fixes for PHP 8.2
Correct PHP8 error with SMF 2.0 bridge.
Correct IPTC supplimental category parsing.
Download and info HERE

Pages: [1]   Go Down

Author Topic: Critical Database Error  (Read 5993 times)

0 Members and 1 Guest are viewing this topic.

cjkline83

  • Coppermine newbie
  • Offline Offline
  • Posts: 6
Critical Database Error
« on: June 26, 2004, 04:03:32 am »

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.

Quote
"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:

Quote
"Critical error

There was an error while processing a database query."

The good news is that the picture really is private.
« Last Edit: June 26, 2004, 12:45:19 pm by cjkline83 »
Logged

Joachim Müller

  • Dev Team member
  • Coppermine addict
  • ****
  • Offline Offline
  • Gender: Male
  • Posts: 47843
  • aka "GauGau"
    • gaugau.de
Re: Critical Database Error
« Reply #1 on: June 26, 2004, 06:38:01 am »

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
Logged

cjkline83

  • Coppermine newbie
  • Offline Offline
  • Posts: 6
Re: Critical Database Error
« Reply #2 on: June 26, 2004, 12:45:39 pm »

This thread has been modified as you wish, sir.

Thank you.
Logged

Joachim Müller

  • Dev Team member
  • Coppermine addict
  • ****
  • Offline Offline
  • Gender: Male
  • Posts: 47843
  • aka "GauGau"
    • gaugau.de
Re: Critical Database Error
« Reply #3 on: June 26, 2004, 01:14:20 pm »

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

GauGau
Logged

cjkline83

  • Coppermine newbie
  • Offline Offline
  • Posts: 6
Re: Critical Database Error
« Reply #4 on: June 26, 2004, 09:22:22 pm »

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.
Logged

Joachim Müller

  • Dev Team member
  • Coppermine addict
  • ****
  • Offline Offline
  • Gender: Male
  • Posts: 47843
  • aka "GauGau"
    • gaugau.de
Logged
Pages: [1]   Go Up
 

Page created in 0.037 seconds with 19 queries.