Hi,
I upgraded to 1.5.14 yesterday and this morning I was checking the logs "just because." I noticed this error in the database log multiple times:
Aug 09, 2011 at 03:59 AM - 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 cpg_pictures AS r
WHERE ((aid = 4 ) OR (keywords like '%Images, photographs, pictures, Italy. Rome, Ravenn%' ))AND approved='YES'
ORDER BY filename ASC, pid ASC
LIMIT ,1' in include/functions.inc.php on line 1305 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 '1' at line 4
There are a series of these from yesterday (August 9) PRIOR to my upgrade; nothing in the log after I upgraded. The content of each entry is the same except for the time stamp. Is this something I should be worried about and if so what should I do?
Thanks!
http://www.alanzeleznikar.com/photography
Quote from: alanz01 on August 10, 2011, 04:21:09 PM
nothing in the log after I upgraded. [..] Is this something I should be worried about
If you don't get error messages now, you don't need to be worried ;)
Well...
QuoteAug 10, 2011 at 07:52 AM - 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 cpg_pictures AS r
WHERE ((aid = 2 ) OR (keywords like '%Deserts%' ))AND approved='YES'
ORDER BY filename ASC, pid ASC
LIMIT ,1' in include/functions.inc.php on line 1305 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 '1' at line 4
Aug 10, 2011 at 12:00 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 cpg_pictures AS r
WHERE ((aid = 14 ) )AND approved='YES'
ORDER BY filename ASC, pid ASC
LIMIT ,1' in include/functions.inc.php on line 1305 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 '1' at line 4
I didn't get an error message while browsing your gallery (I just tested the album with the ID '2', as it occurred in the error message). Just to make sure: you run update.php while you upgraded? If you could find out when these error messages occur, we maybe have a clue what it might be.
Yes, I ran update.php as part of the upgrade and then yesterday I ran "update database" from the Configuration menu (is that the same thing?).
No new messages today at least so far (it's 5:17 AM in California as I post this).