Forum Search is screwy.

[TheDarkArchon]

Well, for me at least.

When I search for new posts, I get this debug dump

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

INSERT INTO phpbb_search_results (search_id, session_id, search_time, search_array) VALUES(1844444536, 'c925605d34ffc48c076294426a444d1c', 1151332076, 'a:7:{s:14:"search_results";s:140:"70, 2560, 2774, 2926, 2927, 3205, 3259, 3313, 3431, 3560, 3590, 3627, 3703, 3707, 3713, 3725, 3727, 3730, 3739, 3740, 3743, 3744, 3745, 3747";s:17:"total_match_count";i:24;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

 

[Callum]

We seem to be getting alot of MySQL errors lately. Maybe we need a new Database?

 

[Blitzzo]

You mean we need a new server?

 

[Silver Sonic]

Tools like myphp could fix it when someone knows what table in the database is to repair but I don´t have an error in the search results

 

[Callum]

You mean we need a new server?

No, database. A MySQL database keeps the forums working properly, contains all the forum data, and should be working properly.