forum.coppermine-gallery.net
Support => cpg1.5.x Support => cpg1.5 miscellaneous => Topic started by: jipjip 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
-
•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
-
•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
-
how to fix?
-
Try if it still happens when you disable the plugin engine (http://hotcelebs.co.uk/pluginmgr.php).
-
which plug in or all of them?
-
Set "Plugin API enabled" to "No". Alternatively, you can also uninstall all plugins manually.
-
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
-
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.
-
I posted the drror log file.
and all it said was error connecting to the db
-
Sorry, it looked like the debug output. Have you already tested to turn off the plugin engine and/or uninstall single plugins?
-
yes it took ages
-
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.
-
DISABLING EVERY PLUG IN AND REINSTALLING THE PLUG INNS TOOK AGES
-
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.
?????????????????
-
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.
-
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.