flat assembler
> Feedback > an attempt to login |
| Author |
|
|
just posted, thought it might be important to tomasz
Code: phpBB Critical Error Error creating new session DEBUG MODE SQL Error 1062 Duplicate entry '7d24caddc693d5c84ee2ce4caecb111f' for key 'PRIMARY' INSERT INTO phpbb_sessions session_id, session_user_id, session_start, session_time, session_ip, session_page, session_logged_in, session_admin VALUES '7d24caddc693d5c84ee2ce4caecb111f', -1, 1531616954, 1531616954, '5994010f', 0, 0, 0 Line 187 File sessions.php _________________ Asm For Wise Humans |
|||
15 Jul 2018, 01:13 |
|
|
I looked into it and I think I found the reason for this error sometimes occurring.
The board was checking if the UPDATE of session table succeeded by checking the result of "mysql_affected_rows" function and this method failed if session table already contained the exact same data and update did nothing. The board assumed that update did nothing because there was no such row in the table and tried to create the session entry, which failed as seen above. I attempted a correction, please let me know if the error ever returns. |
|||
|
15 Jul 2018, 05:08 |
|
|
Code: phpBB Critical Error Error creating new session DEBUG MODE SQL Error 1062 Duplicate entry '54b9c4a149b12e7692c9a595836aa673' for key 'PRIMARY' INSERT INTO phpbb_sessions session_id, session_user_id, session_start, session_time, session_ip, session_page, session_logged_in, session_admin VALUES '54b9c4a149b12e7692c9a595836aa673', -1, 1539094493, 1539094493, '6da1a877', -1, 0, 0 Line 198 File sessions.php _________________ Asm For Wise Humans |
|||
|
09 Oct 2018, 14:16 |
|
< Last Thread | Next Thread > |
Forum Rules:
|