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: There was an error while processing a database query  (Read 3720 times)

0 Members and 1 Guest are viewing this topic.

jipjip

  • Coppermine newbie
  • Offline Offline
  • Posts: 18
There was an error while processing a database query
« on: September 07, 2014, 08:26:43 pm »

There was an error while processing a database query

goes away if I refresh the page

http://hotcelebs.co.uk/index.php
Logged

jipjip

  • Coppermine newbie
  • Offline Offline
  • Posts: 18
Re: There was an error while processing a database query
« Reply #1 on: September 07, 2014, 08:29:52 pm »

•Sep 07, 2014 at 05:10 PM - While executing query 'SELECT r.pid, r.aid, filepath, filename, url_prefix, pwidth, pheight, filesize, ctime, r.title, r.keywords, r.votes, pic_rating, hits, caption, r.owner_id FROM cpg15x_pictures AS r
 WHERE ((aid = 5 ) )AND approved='YES'
 ORDER BY filename DESC, pid DESC
 LIMIT 0 ,-12' in include/functions.inc.php on line 1307 the following error was encountered:
 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 '-12' at line 4
•Sep 07, 2014 at 05:56 PM - While executing query 'SELECT r.pid, r.aid, filepath, filename, url_prefix, pwidth, pheight, filesize, ctime, r.title, r.keywords, r.votes, pic_rating, hits, caption, r.owner_id, pic_raw_ip, pic_hdr_ip FROM cpg15x_pictures AS r
 WHERE ((aid = 5 ) OR (keywords like '%Aaliyah%' ))
 ORDER BY filename DESC, pid DESC
 LIMIT 0 ,-20' in include/functions.inc.php on line 1307 the following error was encountered:
 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 '-20' at line 4
•Sep 07, 2014 at 05:56 PM - While executing query 'SELECT r.pid, r.aid, filepath, filename, url_prefix, pwidth, pheight, filesize, ctime, r.title, r.keywords, r.votes, pic_rating, hits, caption, r.owner_id, pic_raw_ip, pic_hdr_ip FROM cpg15x_pictures AS r
 WHERE ((aid = 5 ) )
 ORDER BY filename DESC, pid DESC
 LIMIT 0 ,-14' in include/functions.inc.php on line 1307 the following error was encountered:
 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 '-14' at line 4
•Sep 07, 2014 at 05:56 PM - While executing query 'SELECT r.pid, r.aid, filepath, filename, url_prefix, pwidth, pheight, filesize, ctime, r.title, r.keywords, r.votes, pic_rating, hits, caption, r.owner_id, pic_raw_ip, pic_hdr_ip FROM cpg15x_pictures AS r
 WHERE ((aid = 4 ) )
 ORDER BY filename DESC, pid DESC
 LIMIT 0 ,-2' in include/functions.inc.php on line 1307 the following error was encountered:
 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 '-2' at line 4
•Sep 07, 2014 at 06:01 PM - While executing query 'SELECT r.pid, r.aid, filepath, filename, url_prefix, pwidth, pheight, filesize, ctime, r.title, r.keywords, r.votes, pic_rating, hits, caption, r.owner_id, pic_raw_ip, pic_hdr_ip FROM cpg15x_pictures AS r
 WHERE ((aid = 8 ) OR (keywords like '%Malin Akerman Photos, Pictures and Images%' ))
 ORDER BY filename DESC, pid DESC
 LIMIT 0 ,-7' in include/functions.inc.php on line 1307 the following error was encountered:
 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 '-7' at line 4
•Sep 07, 2014 at 06:01 PM - While executing query 'SELECT r.pid, r.aid, filepath, filename, url_prefix, pwidth, pheight, filesize, ctime, r.title, r.keywords, r.votes, pic_rating, hits, caption, r.owner_id, pic_raw_ip, pic_hdr_ip FROM cpg15x_pictures AS r
 WHERE ((aid = 5 ) )
 ORDER BY filename DESC, pid DESC
 LIMIT 0 ,-23' in include/functions.inc.php on line 1307 the following error was encountered:
 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 '-23' at line 4
•Sep 07, 2014 at 06:01 PM - While executing query 'SELECT r.pid, r.aid, filepath, filename, url_prefix, pwidth, pheight, filesize, ctime, r.title, r.keywords, r.votes, pic_rating, hits, caption, r.owner_id, pic_raw_ip, pic_hdr_ip FROM cpg15x_pictures AS r
 WHERE ((aid = 5 ) )
 ORDER BY filename DESC, pid DESC
 LIMIT 0 ,-15' in include/functions.inc.php on line 1307 the following error was encountered:
 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 '-15' at line 4
•Sep 07, 2014 at 06:01 PM - While executing query 'SELECT r.pid, r.aid, filepath, filename, url_prefix, pwidth, pheight, filesize, ctime, r.title, r.keywords, r.votes, pic_rating, hits, caption, r.owner_id, pic_raw_ip, pic_hdr_ip FROM cpg15x_pictures AS r
 WHERE ((aid = 5 ) OR (keywords like '%Dianna Agron Photos, Pictures and Images%' ))
 ORDER BY filename DESC, pid DESC
 LIMIT 0 ,-25' in include/functions.inc.php on line 1307 the following error was encountered:
 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 '-25' at line 4
•Sep 07, 2014 at 06:01 PM - While executing query 'SELECT r.pid, r.aid, filepath, filename, url_prefix, pwidth, pheight, filesize, ctime, r.title, r.keywords, r.votes, pic_rating, hits, caption, r.owner_id, pic_raw_ip, pic_hdr_ip FROM cpg15x_pictures AS r
 WHERE ((aid = 5 ) OR (keywords like '%Aaliyah%' ))
 ORDER BY filename DESC, pid DESC
 LIMIT 0 ,-16' in include/functions.inc.php on line 1307 the following error was encountered:
 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 '-16' at line 4
•Sep 07, 2014 at 06:01 PM - While executing query 'SELECT r.pid, r.aid, filepath, filename, url_prefix, pwidth, pheight, filesize, ctime, r.title, r.keywords, r.votes, pic_rating, hits, caption, r.owner_id, pic_raw_ip, pic_hdr_ip FROM cpg15x_pictures AS r
 WHERE ((aid = 8 ) OR (keywords like '%Dianna Agron Photos, Pictures and Images%' ))
 ORDER BY filename DESC, pid DESC
 LIMIT 0 ,-5' in include/functions.inc.php on line 1307 the following error was encountered:
 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 '-5' at line 4
•Sep 07, 2014 at 06:01 PM - While executing query 'SELECT r.pid, r.aid, filepath, filename, url_prefix, pwidth, pheight, filesize, ctime, r.title, r.keywords, r.votes, pic_rating, hits, caption, r.owner_id, pic_raw_ip, pic_hdr_ip FROM cpg15x_pictures AS r
 WHERE ((aid = 8 ) )
 ORDER BY filename DESC, pid DESC
 LIMIT 0 ,-6' in include/functions.inc.php on line 1307 the following error was encountered:
 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 '-6' at line 4
•Sep 07, 2014 at 06:01 PM - While executing query 'SELECT r.pid, r.aid, filepath, filename, url_prefix, pwidth, pheight, filesize, ctime, r.title, r.keywords, r.votes, pic_rating, hits, caption, r.owner_id, pic_raw_ip, pic_hdr_ip FROM cpg15x_pictures AS r
 WHERE ((aid = 10 ) OR (keywords like '%Malin Akerman Photos, Pictures and Images%' ))
 ORDER BY filename DESC, pid DESC
 LIMIT 0 ,-2' in include/functions.inc.php on line 1307 the following error was encountered:
 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 '-2' at line 4
•Sep 07, 2014 at 06:02 PM - While executing query 'SELECT r.pid, r.aid, filepath, filename, url_prefix, pwidth, pheight, filesize, ctime, r.title, r.keywords, r.votes, pic_rating, hits, caption, r.owner_id, pic_raw_ip, pic_hdr_ip FROM cpg15x_pictures AS r
 WHERE ((aid = 9 ) OR (keywords like '%Malin Akerman Photos, Pictures and Images%' ))
 ORDER BY filename DESC, pid DESC
 LIMIT 0 ,-5' in include/functions.inc.php on line 1307 the following error was encountered:
 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 '-5' at line 4
•Sep 07, 2014 at 06:02 PM - While executing query 'SELECT r.pid, r.aid, filepath, filename, url_prefix, pwidth, pheight, filesize, ctime, r.title, r.keywords, r.votes, pic_rating, hits, caption, r.owner_id, pic_raw_ip, pic_hdr_ip FROM cpg15x_pictures AS r
 WHERE ((aid = 8 ) OR (keywords like '%Malin Akerman Photos, Pictures and Images%' ))
 ORDER BY filename DESC, pid DESC
 LIMIT 0 ,-17' in include/functions.inc.php on line 1307 the following error was encountered:
 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 '-17' at line 4
•Sep 07, 2014 at 06:02 PM - While executing query 'SELECT r.pid, r.aid, filepath, filename, url_prefix, pwidth, pheight, filesize, ctime, r.title, r.keywords, r.votes, pic_rating, hits, caption, r.owner_id, pic_raw_ip, pic_hdr_ip FROM cpg15x_pictures AS r
 WHERE ((aid = 5 ) )
 ORDER BY filename DESC, pid DESC
 LIMIT 0 ,-10' in include/functions.inc.php on line 1307 the following error was encountered:
 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 '-10' at line 4
•Sep 07, 2014 at 06:02 PM - While executing query 'SELECT r.pid, r.aid, filepath, filename, url_prefix, pwidth, pheight, filesize, ctime, r.title, r.keywords, r.votes, pic_rating, hits, caption, r.owner_id, pic_raw_ip, pic_hdr_ip FROM cpg15x_pictures AS r
 WHERE ((aid = 5 ) )
 ORDER BY filename DESC, pid DESC
 LIMIT 0 ,-17' in include/functions.inc.php on line 1307 the following error was encountered:
 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 '-17' at line 4
•Sep 07, 2014 at 06:15 PM - While executing query 'SELECT r.pid, r.aid, filepath, filename, url_prefix, pwidth, pheight, filesize, ctime, r.title, r.keywords, r.votes, pic_rating, hits, caption, r.owner_id, pic_raw_ip, pic_hdr_ip FROM cpg15x_pictures AS r
 WHERE ((aid = 14 ) OR (keywords like '%Malin Akerman Photos, Pictures and Images%' ))
 ORDER BY filename DESC, pid DESC
 LIMIT 0 ,-5' in include/functions.inc.php on line 1307 the following error was encountered:
 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 '-5' at line 4
•Sep 07, 2014 at 06:21 PM - While executing query 'SELECT r.pid, r.aid, filepath, filename, url_prefix, pwidth, pheight, filesize, ctime, r.title, r.keywords, r.votes, pic_rating, hits, caption, r.owner_id, pic_raw_ip, pic_hdr_ip FROM cpg15x_pictures AS r
 WHERE ((aid = 5 ) )
 ORDER BY filename DESC, pid DESC
 LIMIT 0 ,-3' in include/functions.inc.php on line 1307 the following error was encountered:
 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 '-3' at line 4
•Sep 07, 2014 at 06:21 PM - While executing query 'SELECT r.pid, r.aid, filepath, filename, url_prefix, pwidth, pheight, filesize, ctime, r.title, r.keywords, r.votes, pic_rating, hits, caption, r.owner_id, pic_raw_ip, pic_hdr_ip FROM cpg15x_pictures AS r
 WHERE ((aid = 11 ) )
 ORDER BY filename DESC, pid DESC
 LIMIT 0 ,-2' in include/functions.inc.php on line 1307 the following error was encountered:
 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 '-2' at line 4
•Sep 07, 2014 at 06:21 PM - While executing query 'SELECT r.pid, r.aid, filepath, filename, url_prefix, pwidth, pheight, filesize, ctime, r.title, r.keywords, r.votes, pic_rating, hits, caption, r.owner_id, pic_raw_ip, pic_hdr_ip FROM cpg15x_pictures AS r
 WHERE ((aid = 5 ) )
 ORDER BY filename DESC, pid DESC
 LIMIT 0 ,-7' in include/functions.inc.php on line 1307 the following error was encountered:
 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 '-7' at line 4
•Sep 07, 2014 at 06:21 PM - While executing query 'SELECT r.pid, r.aid, filepath, filename, url_prefix, pwidth, pheight, filesize, ctime, r.title, r.keywords, r.votes, pic_rating, hits, caption, r.owner_id, pic_raw_ip, pic_hdr_ip FROM cpg15x_pictures AS r
 WHERE ((aid = 8 ) )
 ORDER BY filename DESC, pid DESC
 LIMIT 0 ,-3' in include/functions.inc.php on line 1307 the following error was encountered:
 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 '-3' at line 4
•Sep 07, 2014 at 06:24 PM - While executing query 'SELECT r.pid, r.aid, filepath, filename, url_prefix, pwidth, pheight, filesize, ctime, r.title, r.keywords, r.votes, pic_rating, hits, caption, r.owner_id, pic_raw_ip, pic_hdr_ip FROM cpg15x_pictures AS r
 WHERE ((aid = 5 ) OR (keywords like '%Malin Akerman Photos, Pictures and Images%' ))
 ORDER BY filename DESC, pid DESC
 LIMIT 0 ,-6' in include/functions.inc.php on line 1307 the following error was encountered:
 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 '-6' at line 4
•Sep 07, 2014 at 06:24 PM - While executing query 'SELECT r.pid, r.aid, filepath, filename, url_prefix, pwidth, pheight, filesize, ctime, r.title, r.keywords, r.votes, pic_rating, hits, caption, r.owner_id, pic_raw_ip, pic_hdr_ip FROM cpg15x_pictures AS r
 WHERE ((aid = 11 ) )
 ORDER BY filename DESC, pid DESC
 LIMIT 0 ,-9' in include/functions.inc.php on line 1307 the following error was encountered:
 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 '-9' at line 4
•Sep 07, 2014 at 06:25 PM - While executing query 'SELECT r.pid, r.aid, filepath, filename, url_prefix, pwidth, pheight, filesize, ctime, r.title, r.keywords, r.votes, pic_rating, hits, caption, r.owner_id, pic_raw_ip, pic_hdr_ip FROM cpg15x_pictures AS r
 WHERE ((aid = 5 ) )
 ORDER BY filename DESC, pid DESC
 LIMIT 0 ,-24' in include/functions.inc.php on line 1307 the following error was encountered:
 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 '-24' at line 4
Logged

jipjip

  • Coppermine newbie
  • Offline Offline
  • Posts: 18
Re: There was an error while processing a database query
« Reply #2 on: September 07, 2014, 08:30:38 pm »

•2014-09-06 14:50:10 - Garbage collection deleted logs/global.log.php
•2014-09-06 19:57:25 - Garbage collection deleted logs/database.log.php
Logged

jipjip

  • Coppermine newbie
  • Offline Offline
  • Posts: 18
Re: There was an error while processing a database query
« Reply #3 on: September 08, 2014, 10:19:24 am »

how to fix?
Logged

Αndré

  • Administrator
  • Coppermine addict
  • *****
  • Country: de
  • Offline Offline
  • Gender: Male
  • Posts: 15765
Re: There was an error while processing a database query
« Reply #4 on: September 08, 2014, 12:29:25 pm »

Try if it still happens when you disable the plugin engine (http://hotcelebs.co.uk/pluginmgr.php).
Logged

jipjip

  • Coppermine newbie
  • Offline Offline
  • Posts: 18
Re: There was an error while processing a database query
« Reply #5 on: September 08, 2014, 08:13:15 pm »

which plug in or all of them?
Logged

Αndré

  • Administrator
  • Coppermine addict
  • *****
  • Country: de
  • Offline Offline
  • Gender: Male
  • Posts: 15765
Re: There was an error while processing a database query
« Reply #6 on: September 08, 2014, 08:21:20 pm »

Set "Plugin API enabled" to "No". Alternatively, you can also uninstall all plugins manually.
Logged

jipjip

  • Coppermine newbie
  • Offline Offline
  • Posts: 18
Re: There was an error while processing a database query
« Reply #7 on: September 09, 2014, 12:35:31 pm »

ok, I will re ask the question in a different way, how can I tell what is causing the db errors, I have 8 plug ins, turning them all off wont tell me which is the one (s) which is causing the errors
Logged

Αndré

  • Administrator
  • Coppermine addict
  • *****
  • Country: de
  • Offline Offline
  • Gender: Male
  • Posts: 15765
Re: There was an error while processing a database query
« Reply #8 on: September 09, 2014, 12:52:35 pm »

Turn off the plugin API to find out if a plugin causes the issue at all. If it does, you can re-enable the plugin engine and uninstall each plugin one by one to find out which one causes the issue. It will also help if you post the actual database error message (you need to enable debug mode in the config priorly).

However, I don't get an error message when I view your gallery today.
Logged

jipjip

  • Coppermine newbie
  • Offline Offline
  • Posts: 18
Re: There was an error while processing a database query
« Reply #9 on: September 10, 2014, 04:36:06 pm »

I posted the drror log file.

and all it said was error connecting to the db
Logged

Αndré

  • Administrator
  • Coppermine addict
  • *****
  • Country: de
  • Offline Offline
  • Gender: Male
  • Posts: 15765
Re: There was an error while processing a database query
« Reply #10 on: September 10, 2014, 05:09:50 pm »

Sorry, it looked like the debug output. Have you already tested to turn off the plugin engine and/or uninstall single plugins?
Logged

jipjip

  • Coppermine newbie
  • Offline Offline
  • Posts: 18
Re: There was an error while processing a database query
« Reply #11 on: September 11, 2014, 05:32:05 pm »

yes it took ages
Logged

Αndré

  • Administrator
  • Coppermine addict
  • *****
  • Country: de
  • Offline Offline
  • Gender: Male
  • Posts: 15765
Re: There was an error while processing a database query
« Reply #12 on: September 11, 2014, 08:18:34 pm »

Disabling the plugin engine doesn't take ages, so I assume you've tracked down the issue to one or more plugins. If so, please resolve your thread according to the board rules.
Logged

jipjip

  • Coppermine newbie
  • Offline Offline
  • Posts: 18
Re: There was an error while processing a database query
« Reply #13 on: September 11, 2014, 08:43:45 pm »

DISABLING EVERY PLUG IN AND REINSTALLING THE PLUG INNS TOOK AGES
Logged

jipjip

  • Coppermine newbie
  • Offline Offline
  • Posts: 18
Re: Re: There was an error while processing a database query
« Reply #14 on: September 11, 2014, 08:44:49 pm »

Disabling the plugin engine doesn't take ages, so I assume you've tracked down the issue to one or more plugins. If so, please resolve your thread according to the board rules.

?????????????????
Logged

Αndré

  • Administrator
  • Coppermine addict
  • *****
  • Country: de
  • Offline Offline
  • Gender: Male
  • Posts: 15765
Re: There was an error while processing a database query
« Reply #15 on: September 12, 2014, 09:03:49 am »

If you expect support, you need to provide details. I told you to check if the issue still exists if you disable the plugin engine. You still haven't posted if this solved your issue.
Logged

phill104

  • Administrator
  • Coppermine addict
  • *****
  • Country: gb
  • Offline Offline
  • Gender: Male
  • Posts: 4858
    • Windsurf.me
Re: There was an error while processing a database query
« Reply #16 on: September 12, 2014, 10:44:12 am »

DISABLING EVERY PLUG IN AND REINSTALLING THE PLUG INNS TOOK AGES

You only needed to disable the plugin engine (API) which is just a couple of clicks.
Logged
It is a mistake to think you can solve any major problems just with potatoes.
Pages: [1]   Go Up
 

Page created in 0.035 seconds with 20 queries.