Okay I have seen some strange errors from time to time in the log but I guessed it was due to experimenting with installing plugins which maybe are outdated like these errors:
While executing query 'SELECT * FROM cpg15x_pictures AS r LEFT JOIN cpg15x_albums ON cpg15x_albums.aid = r.aid WHERE (1) AND filename like '%.jpg' AND approved = 'YES' AND filename not like 'youtube_%' ORDER BY RAND() LIMIT ' in plugins/photocols/codebase.php on line 300 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 '' at line 1
While executing query 'SELECT * FROM cpg15x_pictures AS r LEFT JOIN cpg15x_albums ON cpg15x_albums.aid = r.aid WHERE (1) AND filename like '%.jpg' AND approved = 'YES' AND filename not like 'youtube_%' AND p.votes >= '1' ORDER BY pic_rating DESC, r.votes DESC, pid DESC LIMIT 30' in plugins/collageplus/codebase.php on line 253 the following error was encountered:
Unknown column 'p.votes' in 'where clause'
Previously I just thought that the plugins aren't working on the latest version but there have been users on the forum who run them, so maybe there is something wrong with me. I've got several other kinds of errors, here are a few which happen perodically but aren't always the same:
25. September 2014 um 06:08 - 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
INNER JOIN cpg15x_albums AS a ON a.aid = r.aid
INNER JOIN cpg15x_categories AS c2 ON c2.cid = category WHERE (c2.lft BETWEEN 5 AND 6)
AND approved = 'YES'
ORDER BY ctime DESC, pid DESC
LIMIT 0 ,10' in include/functions.inc.php on line 1504 the following error was encountered:
Got error -1 from storage engine
Sep 26, 2014 at 05:24 AM - While executing query 'SELECT COUNT(*) FROM cpg15x_pictures AS p
INNER JOIN cpg15x_albums AS r ON r.aid = p.aid
WHERE (1)
AND approved = 'YES'
AND (ctime >
OR ctime = AND pid > 1514)' in include/functions.inc.php on line 2160 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 'OR ctime = AND pid > 1514)' at line 6
?? 08, 2014 at 01:46 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 = 2 ) )AND approved='YES'
ORDER BY ctime DESC, pid DESC
LIMIT 0 ,-141' 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 '-141' at line 4
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 'OR hits = AND pid < 6217)' at line 6
Dec 20, 2014 at 03:46 AM - While executing query 'SELECT COUNT(*) FROM cpg15x_pictures
WHERE ((aid='240' AND aid NOT IN (416)) ) AND approved='YES'
AND (ctime < '' OR ctime = '' AND pid < )' in include/functions.inc.php on line 2089 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 ')' at line 3
Jan 03, 2015 at 12:21 PM - While executing query 'SELECT COUNT(*) FROM cpg15x_pictures AS p
INNER JOIN cpg15x_albums AS r ON r.aid = p.aid
WHERE (r.aid = 387) AND r.aid NOT IN (416)
AND approved = 'YES'
AND (hits >
OR hits = AND pid < 6233)' in include/functions.inc.php on line 2212 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 'OR hits = AND pid < 6233)' at line 6
Any hints why this is happening and does it need fixing? My PHP version is 5.3.13 and the MySQL is 5.5.32. I haven't edited anything in functions.inc.php or any other of the core files.