sql sessions errors
 

I got many error notifications like this lately:

---------------------
An error was encountered during execution of the query:

REPLACE INTO phpbb_sessions (session_id,session_user_id,session_start,session_time,session_ip,session_page,session_logged_in)
VALUES ('357c23a64544764a6834c265c38f662f',, 1162932489, 1162932489, '46a79de2', '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 ' 1162932489, 1162932489, '46a79de2', '0', '1')' at line 2

--------------------------------

Any idea what caused this?

Thanks!

You can edit your phpbb2.php integration file and encapsulate the userid variable like this

Thanks Chuck. I have applied that per your instruction.

I now get this error after the code change:

------------------------------------------

An error was encountered during execution of the query:

DELETE FROM phpbb_sessions WHERE session_user_id=

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 '' at line 1

do the same sort of thing this is not because of the patch only related

place single quotes around the userid variable in the delete query.

Hi Chuck,

Could you please let me know the details of codes need to be changed? I am not very good at. Thanks!