flat assembler
Message board for the users of flat assembler.

flat assembler > Feedback > phpBB : Critical Error

Author
Thread Post new topic Reply to topic
kerr



Joined: 24 Feb 2016
Posts: 145
phpBB : Critical Error

Error creating new session

DEBUG MODE

SQL Error : 1062 Duplicate entry 'ada52a8be155b7494382a16b0a9096b4' 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 ('ada52a8be155b7494382a16b0a9096b4', -1, 1496034024, 1496034024, '7e591177', 0, 0, 0)

Line : 187
File : sessions.php

_________________
I hope we will be good friends.
Post 29 May 2017, 05:02
View user's profile Send private message Reply with quote
revolution
When all else fails, read the source


Joined: 24 Aug 2004
Posts: 16149
Location: Hyperborea
What were you doing at the time that triggered the error?
Post 29 May 2017, 05:14
View user's profile Send private message Visit poster's website Reply with quote
kerr



Joined: 24 Feb 2016
Posts: 145
This mistake has been around for a long time.
Post 29 May 2017, 05:35
View user's profile Send private message Reply with quote
YONG



Joined: 16 Mar 2005
Posts: 8000
Location: 22° 15' N | 114° 10' E
Probably caused by a corrupt session table in the database. Just wait a few minutes and/or restart your browser.

Wink
Post 29 May 2017, 05:39
View user's profile Send private message Visit poster's website Reply with quote
kerr



Joined: 24 Feb 2016
Posts: 145
yes .
Post 29 May 2017, 05:48
View user's profile Send private message Reply with quote
revolution
When all else fails, read the source


Joined: 24 Aug 2004
Posts: 16149
Location: Hyperborea
Same error, different line number
Code:
phpBB : Critical Error

Error creating new session

DEBUG MODE

SQL Error : 1062 Duplicate entry '9c1b9f262703e26764d94f7c78322c47' 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 ('9c1b9f262703e26764d94f7c78322c47', 908, 1542644427, 1542644427, '0101a8c0', -2, 1, 0)

Line : 198
File : sessions.php     
From this URL
https://board.flatassembler.net/search.php?search_id=recentposts

I tried again after 2.3 seconds and the error has gone.
Post 19 Nov 2018, 16:30
View user's profile Send private message Visit poster's website Reply with quote
DimonSoft



Joined: 03 Mar 2010
Posts: 454
Location: Belarus
<OffTop>Nice example to show for people thinking hashes never have collisions. The same for GUIDs.</OffTop>
Post 19 Nov 2018, 17:35
View user's profile Send private message Visit poster's website Reply with quote
revolution
When all else fails, read the source


Joined: 24 Aug 2004
Posts: 16149
Location: Hyperborea
DimonSoft wrote:
<OffTop>Nice example to show for people thinking hashes never have collisions. The same for GUIDs.</OffTop>
That usually only happens when the hashes are generated badly. The hash functions themselves are mostly okay. If the hashes are done correctly even MD5 takes a lot of effort to create a duplicate.
Post 19 Nov 2018, 20:46
View user's profile Send private message Visit poster's website Reply with quote
DimonSoft



Joined: 03 Mar 2010
Posts: 454
Location: Belarus
revolution wrote:
DimonSoft wrote:
<OffTop>Nice example to show for people thinking hashes never have collisions. The same for GUIDs.</OffTop>
That usually only happens when the hashes are generated badly. The hash functions themselves are mostly okay. If the hashes are done correctly even MD5 takes a lot of effort to create a duplicate.

Definitely. It’s often enough to have the same source data (including salt) which might even be the case this time. It just seems phpBB developers didn’t think enough about that, and having hash being a primary key is obviously a bad idea: due to birthday problem we don’t need 2^128 hashes for a collision to happen and due to obviously uneven distribution of the source data the probability of collision increases significantly.
Post 19 Nov 2018, 22:39
View user's profile Send private message Visit poster's website Reply with quote
Display posts from previous:
Post new topic Reply to topic

Jump to:  


< Last Thread | Next Thread >
Forum Rules:
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
You can attach files in this forum
You can download files in this forum


Copyright © 1999-2018, Tomasz Grysztar.

Powered by rwasa.