Ut oh! SQL Error

[shivers]

Hey Kurt, when I click on "View posts since last visit" I get this:

General Error

Could not insert search results

DEBUG MODE

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

INSERT INTO phpbb_search_results (search_id, session_id, search_time, search_array) VALUES(1193951034, 'f66074096595d63c8beef4a7a7a5a99c', 1187228324, 'a:7:{s:14:"search_results";s:82:"29465, 29548, 29557, 29560, 29566, 29567, 29571, 29574, 29575, 29576, 29577, 29578";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 : 706
File : search.php

[Kurt]

Hmmmm...I could not reproduce it.

But we have an odd sql setup here that was leftover from when we switched servers almost three years ago,

[shivers]

I guess it fixed itself. I no longer have that problem.

[Kurt]

It was probably spambots making too many automated requests for the search function. They do that to check if their registrations have made it on the board and into google.