Database Error Msg in Log Database Error Msg in Log
 

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]

Main Menu

Database Error Msg in Log

Started by alanz01, August 10, 2011, 04:21:09 PM

Previous topic - Next topic

0 Members and 1 Guest are viewing this topic.

alanz01

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
CPG 1.5.12 / Curve Theme / modified color scheme
Plugins (in order):
- External Tracker 2.6
- Social Sharing 1.5
- First Visit Hint 1.0
- Add Meta Description 1.5
- SEF URLs
- Image Preloader 1.4

Αndré

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

alanz01

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
CPG 1.5.12 / Curve Theme / modified color scheme
Plugins (in order):
- External Tracker 2.6
- Social Sharing 1.5
- First Visit Hint 1.0
- Add Meta Description 1.5
- SEF URLs
- Image Preloader 1.4

Αndré

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.

alanz01

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).
CPG 1.5.12 / Curve Theme / modified color scheme
Plugins (in order):
- External Tracker 2.6
- Social Sharing 1.5
- First Visit Hint 1.0
- Add Meta Description 1.5
- SEF URLs
- Image Preloader 1.4

Αndré