Page 1 of 1

Search problem

Posted: Fri Oct 17, 2008 8:45 am
by vickyg2003
I'm getting the following error


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

INSERT INTO phpbb_search_results (search_id, session_id, search_array) VALUES(157579450, '064e402cbd66b3b47a563b191d33b30b', 'a:7:{s:14:"search_results";s:79:"7838, 8811, 9808, 10016, 10093, 10141, 10156, 10158, 10160, 10164, 10166, 10167";s:17:"total_match_count";i:12;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 : 684
File : search.php

Posted: Fri Oct 17, 2008 6:56 pm
by The Robman
were you searching posts or files, and what search criteria were you using?

Posted: Mon Oct 20, 2008 9:06 am
by vickyg2003
Obviously all fixed now. I was searching posts. Both the posts since last login and posts for last 2 days were giving me fits.

Posted: Mon Oct 20, 2008 9:50 am
by The Robman
I didn't fix anything, so I can only assume that one of the databases was offline and the ISP fixed it themselves.