Advanced search  

News:

cpg1.5.48 Security release - upgrade mandatory!
The Coppermine development team is releasing a security update for Coppermine in order to counter a recently discovered vulnerability. It is important that all users who run version cpg1.5.46 or older update to this latest version as soon as possible.
[more]

Pages: [1]   Go Down

Author Topic: Critical Error: There was an error while processing a database query  (Read 2506 times)

0 Members and 1 Guest are viewing this topic.

voldermort28

  • Coppermine newbie
  • Offline Offline
  • Posts: 2

sorry all, but I cannot  access my gallery without login. When I access into my page, there is notification board with the message: Critical Error: There was an error while processing a database query

when I read log of database, it say:
Code: [Select]
While executing query 'SELECT * FROM cpg15x_firstpictures AS p WHERE filename like '%.jpg' AND filename not like 'youtube_%' AND approved = 'YES' AND AND p.aid NOT IN (1)   AND `aid` = 2 ORDER BY position ASC LIMIT 10' in plugins/slideshowit/codebase.php on line 142

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 p.aid NOT IN (1)   AND `aid` = 2 ORDER BY position ASC LIMIT 10' at line 1


I think the error due to remote_video plugin, but I cannot fix it @.@
Logged

Αndré

  • Administrator
  • Coppermine addict
  • *****
  • Country: de
  • Offline Offline
  • Gender: Male
  • Posts: 15764
Re: Critical Error: There was an error while processing a database query
« Reply #1 on: February 03, 2011, 09:10:33 pm »

I think the error due to remote_video plugin, but I cannot fix it @.@
I think it's the slideshowit plugin:
Code: [Select]
While executing query '...' in plugins/slideshowit/codebase.php on line 142
Logged

voldermort28

  • Coppermine newbie
  • Offline Offline
  • Posts: 2
Re: Critical Error: There was an error while processing a database query
« Reply #2 on: February 04, 2011, 07:27:33 am »

 ;D thank you. slideshowit plugin is the reason. But this mean I cannot use this plugin in my site :(. Can you give me the recommendation.

one more error with my website, I dont understand why I open my site with chrome, it always appear in germany, I config english in admin config, but it still germany. :(, It just in english with firefox or opera
Logged

Αndré

  • Administrator
  • Coppermine addict
  • *****
  • Country: de
  • Offline Offline
  • Gender: Male
  • Posts: 15764
Re: Critical Error: There was an error while processing a database query
« Reply #3 on: February 04, 2011, 09:00:09 am »

Please respect our board rules (e.g. post a link to your gallery, search the board, read the docs, one question per thread, etc.).
Logged
Pages: [1]   Go Up
 

Page created in 0.019 seconds with 20 queries.