Earthquake923
SB90's Mechanized Monsters
Joined: 16 Apr 2005
Post Count: 1982
Location: Terana Plains
179201 Potch
0 Soldiers
778121 Nation Points
|
Posted: Tue Apr 04, 2006 4:38 pm Post subject: Debug Error |
|
|
I received this error today(04/04) when ever I tried using the view posts since last log in link.
Could not insert search results
DEBUG MODE
SQL Error : 1062 Duplicate entry '1787189608' for key 1
INSERT INTO phpbb_search_results (search_id, session_id, search_array) VALUES(1787189608, '0c36b7ec56d74a29a59853f6aa256411', 'a:7:{s:14:"search_results";s:124:"1809, 3221, 3418, 4796, 6027, 7258, 8124, 8393, 8548, 8610, 8617, 8632, 8667, 8673, 8679, 8681, 8699, 8703, 8708, 8709, 8710";s:17:"total_match_count";i:21;s:12:"split_search";N;s:7:"sort_by" ;i:0;s:8:"sort_dir";s:4:"DESC";s:12:"show_results";s:6:"topics";s:12:"r eturn_chars";i:200;}')
Line : 722
File : search.php
Uhm, I guess I am just reporting it _________________ If anybody asks about the avatar, I did it for Jess. |
|
Vextor
Joined: 09 Mar 2004
Post Count: 12086
Location: Hell
11331071 Potch
23689 Soldiers
160 Nation Points
|
Posted: Tue Apr 04, 2006 5:28 pm Post subject: |
|
|
Interesting to see how this happened. What likely happened was that somebody else was searching at the exact millisecond, which is something that should happen only once in a billion times or something. Because of that, the same search request ID was created for two separate searches, leading to a duplicate entry. |
|