Page 1 of 1

What the..?

PostPosted: Wed Jun 13, 2007 5:03 pm
by Ryan
I pushed the button at the top to look at my posts, & this came up.



Could not insert search results

DEBUG MODE

SQL Error : 1062 Duplicate entry '449767452' for key 1

INSERT INTO phpbb_search_results (search_id, session_id, search_time, search_array) VALUES(449767452, 'cee98fb157c828276b5dbcf2c89cc32b', 1181772042, 'a:7:{s:14:"search_results";s:308:"2275, 3964, 6066, 6320, 7219, 7242, 7252, 7669, 7689, 7757, 7767, 7770, 7772, 7773, 8070, 8097, 8247, 8248, 8251, 8258, 8260, 8301, 8316, 8324, 8358, 8366, 8426, 8503, 8504, 8539, 9487, 9489, 9916, 10469, 10555, 10665, 10671, 10672, 10673, 10706, 10708, 10709, 10710, 10712, 10715, 10717, 10730, 10751, 10752";s:17:"total_match_count";i:49;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:"return_chars";i:200;}')

Line : 706
File : search.php





WTF!!!!????

PostPosted: Wed Jun 13, 2007 9:44 pm
by Beyond
It happens sometimes when a database transaction failed. Let's blame mysql, sometimes it happen.

In this case the easier thing to do is to logout and login again.