MySQL Error after upgrading to PHP5

oldford · June 30th, 2008, 11:02 AM

I just upgraded to php5 and have started getting some email error reports like the one below. I only get a few a day and when I go in to the Gallery everything appears to work normally. I can see all photos, upload and delete.

I'm on PP version 5.3.

Thanks!

Quote:

An error was encountered during execution of the query:

UPDATE session SET lastactivity = '1214830209' , location = '/photos/showgallery.php/cat/all/si/Joey's' WHERE host='74.6.18.235'

The query returned with an errorcode of:

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 's' WHERE host='74.6.18.235'' at line 1

Chuck S · June 30th, 2008, 03:18 PM

What version of the program are you running I would suggest you run the latest version to be compatible

Code:

Content visible to verified customers only.

I show this line in our vb3.php file which is correct and may not be in your old version.