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 Error: There was an error while processing a database query  (Read 2612 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.021 seconds with 19 queries.