search error

[SmartieParts]

Aside from some general "slowness", the search isn't working (for me). I keep getting an error such as this

Could not insert search resultsDEBUG MODESQL Error : 1062 Duplicate entry '1252910419' for key 1INSERT INTO phpbb_search_results (search_id, session_id, search_time, search_array) VALUES(1252910419, '579b237e98acd85dab1691b328c240b6', 1158249429, 'a:7:{s:14:"search_results";s:1057:"1467, 2007, 4333, 4340, 4350, 4444, 4689, 4706, 5610, 5613, 5791, 5824, 5829, 6494, 6531, 7492, 7590, 8252, 8625, 11028, 11114, 11315, 11499, 12261, 12270, 12281, 12517, 12525, 15104, 15148, 15668, 15855, 15937, 15984, 15985, 16127, 16562, 17078, 17090, 17099, 17111, 17113, 17115, 17138, 17141, 17143, 17249, 17544, 17608, 17844, 18267, 19643, 21264, 24007, 24519, 25850, 26794, 26883, 27052, 29000, 31264, 31317, 35053, 36312, 36397, 36835, 36883, 37240, 37259, 37331, 37365, 37413, 37647, 37863, 38332, 38753, 38822, 39097, 39429, 39620, 39626, 39980, 40016, 40078, 40088, 40126, 40458, 41434, 41475, 41578, 42232, 42326, 44671, 44745, 46108, 47800, 50147, 51354, 51373, 51420, 51611, 53270, 53277, 53326, 53511, 54492, 55151, 55365, 56022, 56854, 57478, 57808, 58911, 59116, 60195, 60356, 62135, 63902, 63909, 64071, 64077, 64382, 64675, 64979, 66205, 66210, 67138, 67150, 67291, 67577, 67979, 68646, 68806, 68906, 68912, 69069, 69130, 70311, 71742, 75882, 77403, 78043, 78259, 79340, 79532, 79584, 79853, 80670, 81230, 81289, 81740, 81822, 81832, 85512";s:17:"total_match_count";i:154;s:12:"split_search";a:2:{i:0;s:3:"mud";i:1;s:5:"flaps";}s:7:"sort_by";i:0;s:8:"sort_dir";s:4:"DESC";s:12:"show_results";s:5:"posts";s:12:"return_chars";i:200;}')Line : 712File : search.php

- Steven

[ARTZ]

You should hold on to that... it looks like the Caramilk Secret!!!

[SMRD]

or the "S_Mack Code" - the true nature and styling of the mysterious 2008 fortwo

[TFM]

Hmmm, was that only the once?or is it repeatable?

[SmartieParts]

hey... fogot about this thread :)It happened multiple times in the 10 minutes I was using it that day... has been fine since. - Steven

[SmartieParts]

happening again:

Could not insert search resultsDEBUG MODESQL Error : 1062 Duplicate entry '1583580944' for key 1INSERT INTO phpbb_search_results (search_id, session_id, search_time, search_array) VALUES(1583580944, '76ea69c56ba18448020c2b716a404bb6', 1158860072, 'a:7:{s:14:"search_results";s:1780:"1454, 2149, 4380, 4388, 4392, 5390, 5401, 5418, 5476, 5478, 5479, 5496, 5592, 5830, 6659, 6660, 6672, 6812, 6839, 8761, 9061, 9109, 9346, 9504, 9506, 9586, 9612, 9624, 9639, 9829, 9837, 10005, 11453, 11501, 11934, 12402, 12440, 12453, 12510, 12998, 14818, 15492, 17049, 18413, 18810, 19806, 19849, 19863, 20392, 20431, 20573, 21040, 21307, 21316, 21449, 21472, 21519, 21792, 21797, 21798, 21802, 22519, 24347, 24405, 24440, 24512, 25363, 25435, 25530, 25554, 25789, 25792, 26304, 26350, 26652, 26837, 26964, 28177, 29217, 29374, 29377, 31185, 31188, 31189, 31267, 31349, 31765, 32052, 32074, 32122, 32400, 32518, 33423, 34135, 34310, 34467, 34475, 34670, 35077, 35424, 35642, 35686, 36506, 36870, 37108, 37284, 37539, 38255, 38514, 38518, 38531, 38546, 38972, 38984, 39046, 39359, 39578, 40888, 41665, 42093, 42097, 42253, 43036, 44720, 45986, 46563, 46635, 46952, 47702, 48991, 49341, 49920, 49970, 50584, 50788, 51507, 51755, 51842, 51934, 52209, 52666, 52838, 52843, 52932, 52952, 53435, 53662, 54497, 54847, 54882, 57622, 57709, 59672, 59854, 60009, 60014, 60283, 60440, 61071, 61298, 61366, 61371, 62319, 63349, 63996, 64355, 64388, 65257, 65511, 66270, 66282, 66707, 66716, 66991, 67037, 67068, 67070, 67072, 67096, 67104, 67118, 67127, 67130, 67145, 67147, 67162, 67302, 67333, 67442, 67520, 67540, 67579, 67970, 68014, 68028, 68093, 68094, 68691, 68767, 69218, 69230, 69248, 69275, 69287, 69399, 69482, 69604, 70030, 72761, 73208, 74724, 75153, 75399, 75507, 75521, 75644, 77283, 77327, 77328, 77334, 77335, 77495, 78113, 78817, 79078, 79410, 79936, 80341, 80598, 80604, 80641, 80643, 80674, 80714, 80756, 80798, 82094, 82272, 82358, 82698, 82943, 83437, 83523, 84265, 84457, 84502, 84565, 84789, 84881, 85186, 85655, 85662, 86053, 87404, 88068, 88105, 88426, 88430, 88440";s:17:"total_match_count";i:259;s:12:"split_search";a:2:{i:0;s:3:"ski";i:1;s:4:"rack";}s:7:"sort_by";i:0;s:8:"sort_dir";s:4:"DESC";s:12:"show_results";s:5:"posts";s:12:"return_chars";i:200;}')Line : 712File : search.php

- Steven

[TFM]

what words are you searching for or is it just any words? Could be that HUGE 120meg file is unhappy again...