forum.coppermine-gallery.net

Support => cpg1.5.x Support => cpg1.5 miscellaneous => Topic started by: alanz01 on August 10, 2011, 04:21:09 pm

Title: Database Error Msg in Log
Post by: alanz01 on August 10, 2011, 04:21:09 pm

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:

Code: [Select]

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

Title: Re: Database Error Msg in Log
Post by: Αndré on August 10, 2011, 05:03:30 pm

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 ;)

Title: Re: Database Error Msg in Log
Post by: alanz01 on August 10, 2011, 10:27:11 pm

Well...

Quote

Aug 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

Title: Re: Database Error Msg in Log
Post by: Αndré on August 10, 2011, 10:52:17 pm

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.

Title: Re: Database Error Msg in Log
Post by: alanz01 on August 11, 2011, 02:20:10 pm

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).

Title: Re: Database Error Msg in Log
Post by: Αndré on August 11, 2011, 02:56:50 pm

Quote from: alanz01 on August 11, 2011, 02:20:10 pm

is that the same thing?

Yes.