NationStates Jolt Archive


WTF, search thing screwy O_o

Imperial Forces
24-11-2003, 04:25
I was serarching form my posts, and I got this:

Could not insert search results

DEBUG MODE

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

INSERT INTO phpbb_search_results (search_id, session_id, search_array) VALUES(1871247847, '87fe4aa34cbd22cc44286817eb4306e2', 'a:7:{s:14:"search_results";s:5278:"3890, 4136, 4203, 4236, 4257, 4259, 4279, 4298, 4328, 4331, 4334, 4335, 4344, 4364, 4384, 4387, 4416, 4462, 4464, 4470, 4480, 4482, 4485, 4524, 4549, 4615, 4662, 4746, 4789, 4795, 4797, 4799, 4808, 4826, 4833, 4835, 4843, 4846, 4872, 4891, 4907, 4913, 4916, 4931, 4952, 4953, 4963, 4983, 5032, 5046, 5057, 5119, 5142, 5148, 5220, 5223, 5228, 5232, 5306, 5367, 5448, 5480, 5487, 5492, 5501, 5578, 5625, 5632, 5635, 5636, 5642, 5767, 5808, 5809, 5814, 5815, 6076, 6517, 6551, 6772, 6786, 7199, 7656, 7875, 8004, 8005, 8007, 8008, 8053, 8135, 8192, 8240, 8243, 8244, 8246, 8251, 8394, 8402, 8408, 8410, 8423, 8427, 8469, 8487, 8490, 8498, 8503, 8504, 8509, 8547, 8560, 8562, 8580, 8589, 8641, 8642, 8643, 8648, 8650, 8686, 8746, 8754, 8757, 8788, 8804, 8806, 8815, 8818, 8866, 8899, 8923, 8940, 8942, 8945, 8970, 9034, 9036, 9057, 9064, 9115, 9143, 9156, 9165, 9208, 9221, 9225, 9238, 9249, 9250, 9255, 9257, 9274, 9311, 9329, 9351, 9353, 9368, 9370, 9374, 9384, 9396, 9402, 9407, 9409, 9415, 9418, 9425, 9428, 9438, 9439, 9442, 9443, 9446, 9451, 9452, 9467, 9468, 9476, 9578, 9594, 9598, 9603, 9607, 9642, 9654, 9723, 9725, 9727, 9732, 9736, 9739, 9744, 9782, 9890, 9895, 9896, 9902, 9903, 9941, 9953, 9962, 10086, 10178, 10224, 10269, 10282, 10284, 10288, 10306, 10355, 10380, 10476, 10482, 10485, 10509, 10532, 10551, 10575, 10576, 10608, 10616, 10627, 10642, 10643, 10647, 10682, 10686, 10785, 10836, 10837, 10865, 10954, 10959, 11056, 11078, 11089, 11333, 11375, 11411, 11419, 11421, 11423, 11430, 12462, 13017, 13556, 15014, 15271, 15273, 15275, 15279, 15282, 15287, 15319, 15380, 15638, 15639, 15641, 15645, 15647, 15663, 15679, 15702, 15705, 15746, 16080, 16090, 16091, 16206, 16255, 16264, 16272, 16290, 16406, 16407, 16453, 16463, 16468, 16469, 16550, 16772, 16831, 16920, 17052, 17075, 17121, 17135, 17137, 17144, 17146, 17435, 17444, 17498, 17500, 17503, 17511, 17566, 17568, 17572, 17584, 17847, 17864, 17929, 17976, 18064, 18378, 18684, 18751, 18817, 19193, 19216, 19242, 19273, 19662, 19919, 20479, 20856, 20994, 21002, 21004, 21009, 21640, 22425, 22568, 22572, 22918, 22986, 23240, 23697, 25132, 25211, 25614, 26096, 26282, 26296, 26306, 26307, 26317, 27228, 28250, 28265, 28482, 28738, 28740, 28819, 28927, 28977, 29730, 29742, 29744, 29757, 29770, 30131, 30833, 30857, 30923, 31355, 31513, 31520, 31530, 31647, 31747, 31766, 31767, 31782, 31823, 31835, 31980, 32429, 32440, 32446, 32460, 32792, 32800, 33896, 33905, 36160, 36619, 40182, 41193, 46913, 47549, 48342, 48412, 48433, 51426, 52433, 52599, 52605, 52609, 52633, 52938, 53058, 53122, 53506, 53667, 53675, 53842, 53991, 54000, 54049, 54053, 54090, 54218, 54378, 54547, 54550, 54709, 55048, 55188, 55369, 55598, 55625, 55635, 55638, 55642, 55667, 55903, 56767, 56898, 56974, 57299, 57648, 57793, 57953, 57974, 57987, 57989, 59362, 59702, 60147, 60321, 60431, 60641, 60870, 60900, 61313, 61989, 62205, 62263, 62327, 62485, 62621, 62627, 62652, 62988, 63180, 63183, 63210, 63214, 63246, 63271, 63282, 63494, 63524, 63855, 63866, 63879, 64333, 64394, 64426, 64443, 64454, 64455, 64649, 65008, 65032, 65048, 65052, 65343, 65344, 65376, 65566, 65629, 65657, 65708, 65746, 65866, 65911, 65925, 65943, 66059, 66141, 66187, 66194, 66274, 66611, 66635, 66642, 66838, 66845, 66860, 66895, 67171, 67230, 67253, 67492, 67512, 67613, 67993, 68039, 68145, 68244, 68407, 68432, 68508, 68769, 68775, 68781, 69072, 69105, 69125, 69126, 69128, 69136, 69146, 69152, 69158, 69346, 69468, 69473, 69543, 69590, 69601, 69730, 70109, 70218, 70349, 70415, 70521, 70681, 70787, 70815, 70977, 70992, 71311, 71485, 71509, 71722, 71735, 71737, 71746, 71754, 71758, 71759, 71760, 71775, 71798, 71803, 72054, 72070, 72091, 72095, 72096, 72110, 72118, 72455, 72723, 72772, 72782, 73141, 73148, 73149, 73150, 73152, 73358, 73360, 73365, 73423, 73440, 73443, 73473, 73474, 73491, 73709, 73759, 73762, 73776, 73810, 73823, 73827, 73828, 74131, 74358, 74365, 74401, 74416, 74513, 74528, 74722, 74793, 74810, 74903, 74907, 74983, 75007, 75064, 75085, 75110, 75112, 75114, 75294, 75398, 75413, 75890, 76011, 76055, 76059, 76091, 76229, 76231, 76251, 76331, 76333, 76338, 76707, 76708, 76716, 77219, 77816, 77825, 77830, 78071, 78338, 78380, 78388, 78422, 78436, 78463, 78483, 78491, 78499, 78516, 78542, 78544, 78553, 78883, 78901, 78906, 78955, 78970, 78971, 79283, 79285, 79291, 79294, 79353, 79562, 79578, 79607, 79609, 79623, 79626, 79645, 79651, 79662, 79835, 79930, 79972, 79974, 80180, 80196, 80228, 80252, 80305, 80314, 80333, 81056, 81073, 81498, 81606, 81705, 81706, 81783, 81791, 82013, 82119, 82134, 82216, 82220, 82235, 82264, 82356, 82365, 82414, 82498, 82501, 82512, 82531, 82532, 82555, 82556, 82564, 82579, 82587, 82588, 82603, 82605, 82655, 82929, 82941, 83279, 83280, 83302, 83305, 83314, 83317, 83323, 83565, 83581, 83594, 83752, 83801, 84261, 84263, 84270, 84273, 84284, 84288, 84289, 84432, 84619, 84652, 86921, 88727, 89091, 89330, 89589, 89911, 89917, 89926, 90018, 90062, 90178, 90237, 90406, 90472, 90496, 90576, 91070, 91129, 91560, 91862, 91964, 91971, 92384, 92468, 92547, 92680, 92683, 92703, 92710, 92711, 92916, 92928, 92932, 93021, 93108, 93333, 93378, 93437, 93924, 93969, 94802, 95296, 95312, 95458, 95460, 95495, 95773, 95777, 95853, 95905, 95908, 95929, 95999, 96082, 96192, 96200, 96229, 96243, 96244, 96267";s:17:"total_match_count";i:783;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 : 598
File : /home/nation/public_html/forum/search.php

I tired it again, but it did the same thing?
SalusaSecondus
24-11-2003, 04:48
Just wait a while, it will fix itself.

http://www.weirdozone.0catch.com/projects/nationstates/salusasecondus/salusasecondus2.jpg
SalusaSecondus
Tech Modling