phpBB : Critical Error

Index > Feedback > phpBB : Critical Error

Author

Thread

kerr

Joined: 24 Feb 2016
Posts: 156

kerr

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.

29 May 2017, 05:02

revolution
When all else fails, read the source

Joined: 24 Aug 2004
Posts: 17943
Location: In your JS exploiting you and your system

revolution

What were you doing at the time that triggered the error?

29 May 2017, 05:14

kerr

Joined: 24 Feb 2016
Posts: 156

kerr

This mistake has been around for a long time.

29 May 2017, 05:35

YONG

Joined: 16 Mar 2005
Posts: 8000
Location: 22° 15' N | 114° 10' E

YONG

Probably caused by a corrupt session table in the database. Just wait a few minutes and/or restart your browser.

Wink

29 May 2017, 05:39

kerr

Joined: 24 Feb 2016
Posts: 156

kerr

yes .

29 May 2017, 05:48

revolution
When all else fails, read the source

Joined: 24 Aug 2004
Posts: 17943
Location: In your JS exploiting you and your system

revolution

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.

19 Nov 2018, 16:30

DimonSoft

Joined: 03 Mar 2010
Posts: 897
Location: Belarus

DimonSoft

<OffTop>Nice example to show for people thinking hashes never have collisions. The same for GUIDs.</OffTop>

19 Nov 2018, 17:35

revolution
When all else fails, read the source

Joined: 24 Aug 2004
Posts: 17943
Location: In your JS exploiting you and your system

revolution

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.

19 Nov 2018, 20:46

DimonSoft

Joined: 03 Mar 2010
Posts: 897
Location: Belarus

DimonSoft

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.

19 Nov 2018, 22:39

DimonSoft

Joined: 03 Mar 2010
Posts: 897
Location: Belarus

DimonSoft

Code:

phpBB : Critical Error

Error creating new session

DEBUG MODE

SQL Error : 1062 Duplicate entry '2d7e75fd2fcda1f3b95583078ebd65c2' 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 ('2d7e75fd2fcda1f3b95583078ebd65c2', 3860, 1563471420, 1563471420, '25d63946', 0, 1, 0)

Line : 198
File : sessions.php

18 Jul 2019, 17:38

< 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