sql sessions errors

[pengrus]

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!

[Chuck S]

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

Content visible to verified customers only.

[pengrus]

Thanks Chuck. I have applied that per your instruction.

[pengrus]

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

[Chuck S]

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.

[pengrus]

Hi Chuck,

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

[Chuck S]

Content visible to verified customers only.