PDA

View Full Version : MySQL error in PhotoPost Pro


jdgriswold
December 8th, 2006, 11:04 AM
Hi, we just started using the Photopost and got the following errors emailed to us:

<error>

REPLACE INTO phpbb_sessions (session_id,session_user_id,session_start,session_time,session_ip,session_pa
ge,session_logged_in)
VALUES ('2606e4cdba9fca980122c29974bd89f4',, 1165587460, 1165587460, '45a8ae2a', '0', '1')

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 ' 1165587460, 1165587460, '45a8ae2a', '0', '1')' at line 2


--- Also, got this message ---
An error was encountered during execution of the query:

DELETE FROM phpbb_sessions WHERE session_user_id=

The query returned with an errorcode of:

</ error>


I'm using integration with phpBB2 for users, which is why you see "phpbb_".
MySQL version is 4.0.27.
We are using 1and1.com hosting, so I do not have access to reconfigure MySQL server-wide.

Can anyone help, please? I very famliar with MS SQL Server, but not MySQL.

Thanks.

Chuck S
December 8th, 2006, 12:48 PM
http://www.photopost.com/forum/showthread.php?t=129221&highlight=REPLACE+INTO+phpbb_sessions