PhotoPost Community - MySQL Error after upgrading to PHP5

PhotoPost Community (http://www.photopost.com/forum/)

- Photopost Pro Installation & Upgrades (http://www.photopost.com/forum/photopost-pro-installation-upgrades/)

- - MySQL Error after upgrading to PHP5 (http://www.photopost.com/forum/photopost-pro-installation-upgrades/137105-mysql-error-after-upgrading-php5.html)

MySQL Error after upgrading to PHP5

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

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.