"View Posts Since Last Visit" problem

[Kuan]

I use this feature quite often to see what is going on and the new posts. A problem that I have encountered recently though is the following message popping up when I click on that link.

General Error

Could not insert search results

DEBUG MODE

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

INSERT INTO phpbb_search_results (search_id, session_id, search_time, search_array) VALUES(1650847940, '36bc616030455ba1877e5cf00d5d3ec4', 1298396286, 'a:7:{s:14:"search_results";s"15, 3128, 3335, 3761, 5622, 6367, 8984, 9122, 9132, 10136, 10977, 11521, 11616, 11948, 12390, 12538, 13243, 13272, 14196, 14210, 14218, 14432, 14791, 14902, 15020, 15098, 15187, 15289, 15294, 15338, 15389, 15489, 15509, 15530, 15535, 15572, 15582, 15583, 15636, 15639, 15649, 15671, 15688, 15725, 15746, 15772, 15807, 15829, 15852, 15860, 15868, 15876, 15887, 15902, 15908, 15910, 15919, 15921, 15923, 15927, 15935, 15938, 15945, 15948, 15950, 15953, 15965, 15975, 15989, 15990, 15991, 15996, 15998, 16007, 16011, 16012, 16015, 16016, 16019, 16020, 16022, 16027, 16044, 16050, 16058, 16063, 16064, 16070, 16073, 16074, 16075, 16077, 16078, 16082, 16088, 16089, 16090, 16091, 16092, 16098, 16100, 16103, 16104, 16105, 16106, 16107, 16108, 16109, 16110, 16119, 16121, 16122, 16124, 16126, 16128, 16131, 16136, 16137, 16140, 16147, 16149, 16154, 16156, 16159, 16169, 16174, 16178, 16180, 16186, 16191, 16192, 16195, 16198, 16204, 16206, 16207, 16208, 16211, 16215, 16217, 16218, 16222, 16223, 16225, 16226, 16233, 16237, 16239, 16242, 16245, 16255, 16256, 16257, 16258, 16259, 16263, 16266, 16268, 16269, 16270, 16272, 16273, 16274, 16275, 16277, 16279, 16280, 16281, 16282, 16283, 16285, 16288, 16291, 16293, 16294, 16295, 16297, 16298, 16299, 16303, 16304, 16305, 16306, 16309, 16311, 16312, 16313, 16315, 16322, 16324, 16327, 16330, 16332, 16337, 16338, 16339, 16342, 16344, 16352, 16355, 16381, 16389, 16390, 16391, 16397, 16401, 16403, 16404, 16405, 16410, 16417, 16420, 16423, 16429, 16430, 16436, 16437, 16438, 16441, 16445, 16452, 16467, 16476, 16477, 16481, 16482, 16486";s:17:"total_match_count";i:227;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 : 890
File : search.php

[Board]

View posts since last visit is all I use and I have never witnessed this error... odd. I use Google Chrome 9.0.597.98 if that has anything to do with it.

[otseng]

Use this link to clear out the results:
http://debatingchristianity.com/forum/i ... ark=forums

Hopefully that will reset it and remove the error for you.

[Kuan]

Looks like it worked, thanks!

[Kuan]

I screwed up....I didnt knock on wood...

It didnt fix the problem, now I got this:

Could not insert search results

DEBUG MODE

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

INSERT INTO phpbb_search_results (search_id, session_id, search_time, search_array) VALUES(850001595, '36bc616030455ba1877e5cf00d5d3ec4', 1298397605, 'a:7:{s:14:"search_results";s:5:"16488";s:17:"total_match_count";i:1;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 : 890
File : search.php

[Kuan]

View posts since last visit is all I use and I have never witnessed this error... odd. I use Google Chrome 9.0.597.98 if that has anything to do with it.

Maybe it is the browser, im using firefox though and I have never had an issue. Although when I had chrome it worked completley fine.

[otseng]

No, it's not the browser. Some data is hanging around in that table. I've cleared the table. Give it another try.

[Kuan]

No, it's not the browser. Some data is hanging around in that table. I've cleared the table. Give it another try.

Its working now! Thanks!