Register to post in forums, or Log in to your existing account
 

Post new topic  Reply to topic     Home » Forums » Website or Forum problems
TonDiening
GURU


Joined: 26 Jul 2001
Posts: 1958
Location: Canada

PostPosted: Tue Mar 28, 2006 2:48 pm   

Search errors
 
I use search quite heavily and get sometimes errors like the follows:
Is this a layer8 problem or something lower :)

http://forums.zuggsoft.com/phpbb/search.php?search_id=unanswered

General Error

Could not insert search results

DEBUG MODE

Code:

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

INSERT INTO phpbb_search_results (search_id, session_id, search_array) VALUES(2045793205, 'e57ad0a877d8eb683d735c298fb02f86', 'a:7:{s:14:"search_results";s:21328:"16903, 16887, 16867, 16863, 16855, 16851, 16846, 16830, 16815, 16793, 16790, 16789, 16780, 16776, 16767, 16761, 16739, 16723, 16714, 16676, 16636, 16614, 16556, 16542, 16523, 16510, 16507, 16474, 16470, 16441, 16424, 16416, 16415, 16406, 16395, 16390, 16389, 16387, 16371, 16366, 16355, 16334, 16324, 16321, 16310, 16309, 16299, 16292, 16278, 16267, 16263, 16254, 16248, 16247, 16233, 16227, 16185, 16163, 16148, 16131, 16126, 16101, 16098, 16097, 16092, 16067, 16066, 16060, 16057, 16047, 16029, 16024, 16017, 16014, 16009, 16005, 15994, 15989, 15981, 15976, 15961, 15952, 15943, 15941, 15935, 15913, 15910, 15909, 15905, 15890, 15880, 15879, 15875, 15834, 15822, 15801, 15796, 15795, 15783, 15776, 15771, 15751, 15750, 15749, 15736, 15699, 15635, 15632, 15616, 15614, 15613, 15565, 15564, 15534, 15529, 15527, 15523, 15507, 15498, 15492, 15489, 15483, 15465, 15463, 15462, 15443, 15427, 15398, 15397, 15396, 15392, 15387, 15377, 15370, 15367, 15364, 15363, 15362, 15358, 15336, 15331, 15330, 15314, 15302, 15278, 15274, 15254, 15250, 15227, 15203, 15155, 15154, 15148, 15139, 15138, 15137, 15129, 15126, 15123, 15113, 15110, 15108, 15084, 15008, 15005, 15004, 15002, 14998, 14967, 14916, 14852, 14790, 14778, 14776, 14773, 14771, 14748, 14644, 14622, 14606, 14573, 14564, 14531, 14511, 14499, 14498, 14464, 14431, 14428, 14403, 14379, 14370, 14364, 14338, 14327, 14326, 14319, 14315, 14314, 14304, 14303, 14277, 14274, 14273, 14261, 14255, 14234, 14224, 14223, 14221, 14219, 14214, 14211, 14210, 14170, 14169, 14168, 14155, 14154, 14152, 14151, 14146, 14141, 14137, 14136, 14121, 14097, 14082, 14077, 14060, 14054, 14045, 14036, 14031, 14029, 14028, 14027, 14018, 14016, 13987, 13981, 13980, 13970, 13968, 13929, 13920, 13811, 13809, 13803, 13786, 13783, 13763, 13756, 13749, 13716, 13664, 13660, 13649, 13638, 13634, 13619, 13615, 13614, 13602, 13576, 13546, 13529, 13516, 13505, 13501, 13485, 13478, 13468, 13439, 13437, 13393, 13389, 13365, 13353, 13329, 13309, 13286, 13284, 13274, 13262, 13216, 13210, 13206, 13194, 13189, 13174, 13117, 13112, 13108, 13094, 13075, 13069, 13066, 13028, 13019, 12992, 12926, 12884, 12883, 12878, 12876, 12872, 12853, 12843, 12842, 12810, 12697, 12670, 12660, 12633, 12627, 12622, 12607, 12604, 12601, 12598, 12575, 12574, 12568, 12547, 12543, 12532, 12518, 12517, 12506, 12502, 12467, 12347, 12333, 12325, 12294, 12269, 12265, 12260, 12237, 12226, 12210, 12205, 12195, 12190, 12187, 12184, 12179, 12174, 12171, 12160, 12151, 12148, 12138, 12136, 12115, 12111, 12099, 12056, 12042, 12040, 12030, 12028, 12027, 12021, 11904, 11889, 11836, 11805, 11790, 11766, 11754, 11745, 11741, 11740, 11731, 11716, 11685, 11683, 11680, 11670, 11666, 11651, 11649, 11638, 11635, 11611, 11596, 11582, 11566, 11563, 11514, 11484, 11468, 11464, 11461, 11439, 11438, 11434, 11433, 11431, 11428, 11409, 11402, 11388, 11385, 11371, 11354, 11350, 11336, 11327, 11313, 11278, 11277, 11273, 11252, 11235, 11224, 11223, 11213, 11184, 11159, 11147, 11142, 11139, 11134, 11100, 11092, 11084, 11078, 11067, 11033, 11029, 11012, 11010, 11001, 10990, 10981, 10980, 10979, 10975, 10974, 10973, 10938, 10931, 10911, 10909, 10906, 10895, 10864, 10863, 10834, 10797, 10708, 10700, 10696, 10692, 10691, 10685, 10680, 10672, 10667, 10648, 10642, 10638, 10602, 10591, 10587, 10581, 10528, 10522, 10518, 10510, 10499, 10491, 10481, 10480, 10470, 10437, 10436, 10428, 10412, 10404, 10400, 10385, 10384, 10378, 10369, 10368, 10350, 10318, 10317, 10316, 10315, 10295, 10271, 10255, 10205, 10143, 10142, 10139, 10113, 10111, 10096, 10050, 10017, 10014, 10008, 9972, 9962, 9910, 9858, 9847, 9829, 9825, 9823, 9816, 9815, 9806, 9775, 9734, 9725, 9716, 9713, 9698, 9695, 9685, 9652, 9651, 9636, 9633, 9617, 9614, 9559, 9548, 9542, 9522, 9503, 9455, 9447, 9427, 9426, 9404, 9387, 9369, 9317, 9315, 9313, 9305, 9301, 9294, 9276, 9273, 9263, 9245, 9238, 9228, 9227, 9223, 9196, 9182, 9181, 9175, 9174, 9173, 9148, 9138, 9135, 9132, 9066, 9046, 9025, 8937, 8933, 8898, 8883, 8865, 8849, 8847, 8843, 8842, 8841, 8824, 8807, 8798, 8779, 8768, 8731, 8721, 8655, 8645, 8630, 8613, 8611, 8605, 8597, 8591, 8574, 8569, 8568, 8564, 8542, 8534, 8533, 8517, 8454, 8453, 8451, 8437, 8429, 8426, 8413, 8388, 8326, 8293, 8247, 8229, 8228, 8224, 8207, 8202, 8199, 8191, 8143, 8078, 8064, 8018, 8000, 7991, 7985, 7976, 7927, 7924, 7889, 7872, 7870, 7858, 7857, 7839, 7807, 7740, 7672, 7652, 7628, 7620, 7592, 7587, 7574, 7524, 7504, 7442, 7239, 7068, 6881, 6825, 6813, 6782, 6781, 6778, 6630, 6602, 6572, 6516, 6505, 6504, 6503, 6499, 6489, 6463, 6458, 6449, 6327, 6325, 6310, 6307, 6306, 6298, 6295, 6278, 6277, 6196, 6182, 6133, 6122, 6030, 6016, 6002, 6001, 5867, 5863, 5722, 5719, 5571, 5539, 5359, 5357, 5334, 5309, 5251, 5244, 5237, 5231, 5222, 5220, 5209, 5204, 5192, 5191, 5188, 5170, 5156, 5105, 5081, 5074, 5015, 4999, 4967, 4943, 4908, 4903, 4746, 4730, 4718, 4717, 4681, 4611, 4600, 4584, 4558, 4557, 4555, 4519, 4505, 4499, 4475, 3972, 3929, 3761, 3760, 3441, 3198, 3165, 2821, 2743, 2517, 2411, 2372, 2370, 2368, 2361, 2306, 2220, 2203, 2108, 2097, 1812, 1744, 1713, 1639, 1566, 1552, 1498, 1441, 1422, 1399, 1307, 16939, 16966, 16968, 16969, 16974, 16978, 16983, 17004, 17013, 17017, 17018, 17021, 17051, 17052, 17055, 17057, 17071, 17091, 17115, 17118, 17127, 17159, 17161, 17170, 17201, 17204, 17205, 17206, 17222, 17259, 17263, 17277, 17302, 17323, 17334, 17348, 17367, 17373, 17374, 17377, 17398, 17401, 17415, 17441, 17527, 17528, 17543, 21035, 21033, 17556, 21034, 21032, 17558, 19841, 17561, 17563, 17564, 17566, 17601, 17577, 17583, 17598, 17600, 17602, 17608, 17617, 17619, 17625, 19837, 19836, 17654, 17659, 17660, 17664, 17668, 17729, 17736, 17742, 17750, 17753, 17774, 17777, 17782, 17786, 17825, 17832, 17835, 17842, 17879, 17880, 17881, 17882, 17883, 17884, 17885, 17886, 17887, 17888, 17889, 17890, 17891, 17877, 17878, 17874, 17875, 17876, 17892, 17893, 17894, 17895, 17896, 17898, 17899, 17900, 17901, 17902, 17903, 17904, 17905, 17906, 17907, 17908, 17909, 17910, 17911, 17912, 17913, 17914, 17915, 17916, 17917, 17918, 17919, 17920, 17921, 17922, 17923, 17924, 17925, 17926, 17927, 17928, 17929, 17930, 17931, 17932, 17933, 17934, 17935, 17936, 17937, 17938, 17939, 17940, 17941, 17942, 17943, 17944, 17945, 17946, 17947, 17948, 17949, 17950, 17951, 17952, 17953, 17954, 17955, 17956, 17957, 17958, 17959, 17960, 17961, 17962, 17963, 17964, 17965, 17966, 17967, 17968, 17969, 17970, 17971, 17972, 17974, 17975, 17976, 17977, 17978, 17979, 17980, 17981, 17982, 17983, 17984, 17985, 17986, 17987, 17988, 17989, 17990, 17991, 17992, 17993, 17994, 17995, 17996, 17997, 17998, 17999, 18000, 18001, 18002, 18003, 18004, 18005, 18006, 18007, 18008, 18009, 18010, 18011, 18012, 18013, 18014, 18015, 18016, 18017, 18018, 18019, 18020, 18021, 18022, 18023, 18024, 18026, 18027, 18028, 18029, 18030, 18031, 18032, 18033, 18034, 18035, 18036, 18037, 18038, 18039, 18040, 18041, 18042, 18043, 18044, 18045, 18046, 18047, 18048, 18049, 18050, 18051, 18052, 18053, 18054, 18056, 18057, 18058, 18059, 18060, 18061, 18062, 18063, 18064, 18065, 18066, 18067, 18068, 18069, 18070, 18071, 18072, 18073, 18074, 18075, 18076, 18077, 18078, 18079, 18080, 18081, 18082, 18083, 18084, 18085, 18086, 18087, 18088, 18089, 18090, 18091, 18092, 18093, 18094, 18095, 18096, 18097, 18098, 18099, 18100, 18101, 18102, 18103, 18104, 18105, 18106, 18107, 18108, 18109, 18110, 18111, 18112, 18113, 18114, 18115, 18116, 18117, 18118, 18119, 18120, 18121, 18122, 18123, 18124, 18125, 18126, 18127, 18128, 18129, 18130, 18131, 18132, 18133, 18134, 18135, 18136, 18137, 18138, 18139, 18140, 18141, 18142, 18143, 18144, 18145, 18146, 18147, 18148, 18149, 18150, 18151, 18152, 18153, 18154, 18155, 18156, 18157, 18158, 18159, 18160, 18161, 18163, 18164, 18165, 18166, 18167, 18168, 18169, 18170, 18171, 18172, 18173, 18174, 18176, 18177, 18178, 18179, 18180, 18181, 18182, 18183, 18184, 18185, 18186, 18187, 18188, 18189, 18190, 18191, 18192, 18193, 18194, 18195, 18196, 18197, 18198, 18199, 18200, 18201, 18202, 18203, 18204, 18205, 18206, 18207, 18208, 18209, 18210, 18211, 18212, 18213, 18214, 18215, 18216, 18217, 18218, 18219, 18220, 18222, 18223, 18224, 18225, 18226, 18227, 18228, 18229, 18230, 18232, 18233, 18234, 18235, 18236, 18237, 18238, 18239, 18240, 18241, 18242, 18243, 18244, 18245, 18246, 18247, 18248, 18249, 18250, 18251, 18252, 18253, 18254, 18255, 18256, 18257, 18258, 18259, 18260, 18261, 18262, 18263, 18264, 18265, 18266, 18267, 18268, 18269, 18270, 18271, 18272, 18273, 18274, 18275, 18276, 18277, 18278, 18279, 18280, 18281, 18282, 18283, 18284, 18285, 18286, 18287, 18288, 18289, 18290, 18291, 18292, 18293, 18294, 18295, 18296, 18297, 18298, 18299, 18300, 18301, 18302, 18303, 18304, 18305, 18306, 18307, 18308, 18309, 18310, 18311, 18312, 18313, 18314, 18315, 18316, 18317, 18318, 18319, 18320, 18321, 18322, 18323, 18324, 18325, 18326, 18327, 18328, 18329, 18330, 18331, 18332, 18333, 18334, 18335, 18336, 18337, 18338, 18339, 18340, 18341, 18342, 18343, 18344, 18345, 18346, 18347, 18348, 18350, 18351, 18352, 18353, 18354, 18355, 18356, 18357, 18358, 18359, 18360, 18361, 18362, 18363, 18364, 18365, 18366, 18367, 18368, 18369, 18370, 18371, 18372, 18373, 18374, 18375, 18376, 18377, 18378, 18379, 18380, 18381, 18382, 18383, 18384, 18385, 18386, 18387, 18388, 18389, 18390, 18391, 18392, 18393, 18394, 18395, 18396, 18397, 18398, 18399, 18400, 18401, 18402, 18403, 18404, 18405, 18406, 18407, 18408, 18409, 18411, 18412, 18413, 18414, 18417, 18422, 18439, 18454, 18455, 18456, 18458, 18459, 18460, 18461, 18462, 18463, 18464, 18465, 18466, 18467, 18468, 18469, 18470, 18471, 18472, 18475, 18476, 18477, 18478, 18479, 18481, 18488, 18489, 18490, 18494, 18497, 18498, 18500, 18505, 18508, 18509, 18510, 18511, 18512, 18513, 18516, 20173, 18518, 18519, 18520, 18521, 18522, 18523, 18524, 18525, 18526, 18527, 18528, 18529, 18530, 18531, 18532, 18533, 18534, 18535, 18536, 18538, 18539, 18540, 18541, 18542, 18543, 18544, 18545, 18546, 18547, 18549, 18551, 18552, 18553, 20179, 18555, 18556, 18557, 18558, 18559, 18560, 20166, 18562, 18563, 18564, 18565, 20399, 18569, 18570, 18571, 18572, 18573, 18574, 20160, 18576, 18577, 18578, 18579, 20159, 18582, 18583, 18584, 18585, 18586, 19940, 18588, 18589, 18590, 18591, 19939, 18594, 18595, 19938, 18597, 18598, 18599, 18600, 19912, 18602, 18603, 18604, 18605, 18606, 18607, 18608, 18609, 18610, 18611, 18612, 18613, 18614, 18615, 18616, 18617, 20971, 18620, 18621, 18622, 18623, 18624, 18625, 18626, 21788, 18628, 18629, 21787, 21786, 21785, 21784, 18634, 21783, 21782, 21781, 21780, 21779, 18640, 21778, 21777, 21776, 21775, 18645, 18646, 18647, 18648, 21774, 21773, 18651, 18653, 18656, 18661, 18662, 18663, 18664, 18665, 18666, 18667, 18668, 20514, 18670, 18672, 20513, 18674, 18675, 18676, 18677, 18678, 18679, 18680, 18681, 18682, 18683, 18684, 18685, 18686, 18687, 18688, 18689, 18690, 18691, 18692, 18693, 18694, 18695, 18696, 18697, 18698, 18699, 18700, 18701, 18702, 18703, 20512, 20511, 20510, 20509, 20508, 18710, 18711, 20191, 18713, 20190, 18715, 20189, 20188, 20187, 18720, 18722, 18723, 18724, 18725, 18726, 18727, 18728, 20165, 20164, 20163, 20162, 18734, 18735, 18736, 18737, 18738, 18739, 18740, 18741, 18742, 18743, 18744, 18745, 20891, 20161, 18753, 18754, 18755, 18756, 18757, 18758, 18759, 18760, 18762, 18763, 18764, 18765, 18766, 18767, 18768, 18769, 18770, 18771, 18772, 18773, 18774, 18775, 20360, 20358, 18780, 18781, 18782, 18783, 18784, 18785, 18786, 20357, 20342, 18789, 20311, 20310, 20309, 20308, 18794, 20157, 20318, 18797, 20988, 18800, 21016, 21015, 21772, 21014, 21013, 21012, 21011, 21010, 21771, 21009, 21008, 21007, 21006, 21005, 21004, 21002, 21001, 21000, 20999, 20998, 20997, 20996, 20995, 20994, 20993, 18829, 20992, 20991, 20990, 20989, 18834, 18835, 18836, 18837, 18838, 18839, 18840, 18841, 18842, 20234, 20235, 20233, 20232, 20231, 20230, 20229, 20228, 20227, 20226, 20225, 20224, 20223, 18858, 18859, 18860, 20356, 20355, 18863, 18864, 18865, 20354, 18867, 18868, 18869, 18870, 18871, 20353, 20352, 20351, 20350, 20349, 20348, 20347, 20346, 20345, 20344, 20343, 18884, 18885, 18886, 18887, 18888, 18889, 18890, 18891, 18892, 18893, 18894, 18895, 18896, 18897, 18900, 18901, 18902, 18903, 18904, 18905, 18906, 18907, 18908, 18909, 18910, 18911, 18912, 18914, 18916, 18917, 18918, 20129, 20128, 20127, 18924, 18925, 18926, 18927, 18928, 18929, 18930, 18931, 18932, 18933, 18934, 18935, 18936, 18937, 18938, 18939, 18940, 18941, 18942, 18943, 18944, 18945, 18946, 18947, 18948, 18949, 18950, 18951, 18952, 18953, 18954, 18955, 18956, 18957, 18958, 18959, 18960, 18961, 18962, 18963, 18964, 18965, 18966, 18967, 18968, 18969, 18970, 18971, 18972, 18973, 18974, 18975, 18976, 18977, 18978, 18979, 18980, 18981, 18982, 18983, 18984, 18985, 18986, 18987, 18988, 18989, 18990, 18991, 18992, 18993, 18994, 18995, 19839, 18997, 18998, 18999, 19001, 19002, 19003, 19004, 19005, 19006, 19007, 19008, 19009, 19010, 19011, 19012, 19013, 19014, 19015, 19016, 19017, 19018, 19019, 19020, 19021, 19022, 19023, 19024, 19025, 19026, 19027, 19028, 19029, 19030, 19031, 19032, 19033, 19034, 19035, 19036, 19037, 19038, 19039, 19040, 19041, 19044, 19045, 19046, 19047, 19048, 19049, 19050, 19051, 19052, 19053, 19054, 19055, 19056, 19057, 19058, 19059, 19060, 19061, 19062, 19063, 19064, 19065, 19066, 19067, 19068, 19069, 19070, 19071, 19072, 19073, 19074, 19075, 19076, 19077, 19078, 19079, 19080, 19115, 19092, 19093, 19094, 19095, 19096, 19097, 19098, 19099, 19100, 19101, 19102, 19103, 19104, 19105, 19106, 19107, 19108, 19109, 19110, 19111, 19112, 19113, 19114, 19122, 19123, 19124, 19130, 19131, 19132, 19134, 19138, 19140, 19141, 19142, 19143, 19144, 19145, 19146, 19147, 19148, 19149, 19150, 19151, 19152, 19153, 19154, 19155, 19156, 19157, 19158, 19159, 19160, 19161, 19162, 19163, 19164, 19165, 19176, 19167, 19168, 19170, 19171, 19172, 19173, 19174, 19190, 19191, 19192, 19193, 19194, 19195, 19196, 19197, 19198, 19199, 19200, 19201, 19202, 19203, 19204, 19206, 19207, 19208, 19209, 19210, 19211, 19212, 19213, 19214, 19215, 19216, 19217, 19218, 19219, 19220, 19221, 19222, 19223, 19224, 19225, 19226, 19227, 19228, 19229, 19230, 19231, 19232, 19233, 19234, 19249, 19250, 19251, 19252, 19253, 19254, 19255, 19256, 19257, 19258, 19259, 19260, 19261, 19262, 19263, 19264, 19265, 19266, 19267, 19268, 19269, 19270, 19271, 19272, 19273, 19274, 19275, 19276, 19277, 19278, 19279, 19280, 19281, 19282, 19284, 19285, 19286, 19287, 19288, 19289, 19290, 19291, 19292, 19293, 19294, 19295, 19296, 19297, 19298, 19299, 19300, 19301, 19302, 19303, 19304, 19305, 19306, 19307, 19308, 19309, 19310, 19311, 19312, 19313, 19314, 19315, 19316, 19317, 19318, 19319, 19320, 19321, 19322, 19323, 19324, 19325, 19326, 19327, 19328, 19329, 19333, 19339, 19342, 19348, 19357, 19358, 19359, 19362, 19364, 19367, 19371, 19372, 19373, 19374, 19376, 19385, 19390, 19391, 19392, 19393, 19394, 19395, 19396, 19397, 19407, 19409, 19412, 19413, 19414, 19416, 19424, 21003, 19427, 19430, 19440, 19473, 19474, 19481, 19482, 19496, 19511, 19513, 19520, 19523, 19526, 19530, 19548, 19551, 19561, 19565, 19566, 19569, 19582, 19583, 19587, 19594, 19596, 19598, 19599, 19610, 19616, 19628, 19641, 19653, 19678, 19685, 19709, 19717, 19793, 19794, 19799, 19824, 19831, 19835, 19838, 19842, 19963, 19848, 19849, 19850, 19851, 19913, 19854, 19910, 19857, 19858, 19859, 19860, 19861, 19863, 19907, 19866, 19868, 19906, 19905, 19871, 19911, 19909, 19908, 19899, 19914, 19915, 19916, 19917, 19918, 19919, 19920, 19921, 19922, 19924, 19925, 19926, 19927, 19928, 19929, 19930, 19931, 19932, 19933, 19934, 19935, 19936, 19937, 19941, 19942, 19943, 19944, 19945, 19946, 19947, 19948, 19949, 19950, 19964, 19965, 19966, 19996, 20001, 20012, 20019, 20020, 20219, 20074, 20076, 20107, 20116, 20117, 20130, 20131, 20132, 20148, 20149, 20150, 20152, 20153, 20154, 20167, 20174, 20175, 20176, 20177, 20180, 20181, 20182, 20183, 20184, 20185, 20186, 20192, 20193, 20194, 20195, 20196, 20197, 20198, 20203, 20205, 20206, 20207, 20208, 20209, 20210, 20211, 20212, 20213, 20214, 20215, 20216, 20217, 20218, 20220, 20221, 20222, 20236, 20237, 20238, 20239, 20240, 20241, 20242, 20243, 20244, 20245, 20246, 20247, 20248, 20251, 20259, 20260, 20261, 20262, 20263, 20264, 20265, 20266, 20267, 20269, 20270, 20271, 20272, 20273, 20274, 20275, 20276, 20277, 20278, 20279, 20280, 20281, 20282, 20284, 20285, 20286, 20287, 20288, 20289, 20290, 20291, 20292, 20293, 20294, 20295, 20296, 20297, 20298, 20299, 20301, 20302, 20303, 20304, 20305, 20306, 20312, 20313, 20314, 20315, 20316, 20317, 20319, 20331, 20361, 20362, 20363, 20364, 20365, 20366, 20367, 20368, 20369, 20370, 20371, 20372, 20374, 20375, 20376, 20377, 20378, 20379, 20380, 20381, 20382, 20383, 20384, 20385, 20386, 20387, 20388, 20389, 20390, 20391, 20392, 20393, 20394, 20395, 20396, 20397, 20398, 20403, 20404, 20405, 20406, 20407, 20408, 20409, 20410, 20411, 20412, 20413, 20414, 20415, 20416, 20417, 20418, 20419, 20438, 20444, 20445, 20463, 20471, 20476, 20481, 20484, 20485, 20488, 20515, 20516, 20517, 20518, 20519, 20520, 20521, 20522, 20523, 20524, 20526, 20527, 20528, 20529, 20530, 20531, 20532, 20548, 20551, 20554, 20570, 20571, 20572, 20573, 20574, 20575, 20576, 20577, 20578, 20579, 20580, 20581, 20582, 20583, 20584, 20585, 20586, 20587, 20588, 20589, 20590, 20591, 20592, 20593, 20594, 20595, 20596, 20597, 20598, 20599, 20600, 20601, 20602, 20603, 20604, 20605, 20606, 20607, 20608, 20609, 20610, 20611, 20612, 20613, 20614, 20615, 20616, 20617, 20618, 20619, 20620, 20621, 20622, 20623, 20631, 20632, 20633, 20860, 20859, 20858, 20638, 20639, 20640, 20641, 20642, 20643, 20644, 20645, 20646, 20647, 20648, 20649, 20650, 20651, 20654, 20655, 20656, 20657, 20659, 20660, 20661, 20662, 20663, 20664, 20665, 20666, 20667, 20668, 20669, 20670, 20671, 20672, 20673, 20674, 20675, 20676, 20677, 20678, 20679, 20680, 20681, 20682, 20683, 20684, 20685, 20686, 20687, 20688, 20689, 20690, 20691, 20692, 20693, 20694, 20695, 20696, 20697, 20698, 20699, 20700, 20701, 20702, 20703, 20704, 20705, 20706, 20708, 20729, 20738, 20739, 20745, 20746, 20747, 20748, 20755, 20757, 20758, 20759, 20761, 20762, 20763, 20764, 20765, 20766, 20767, 20768, 20769, 20770, 20772, 20774, 20775, 20776, 20777, 20778, 20779, 20780, 20781, 20782, 20783, 20784, 20785, 20786, 20787, 20788, 20789, 20790, 20791, 20792, 20793, 20803, 20813, 20820, 20821, 20822, 20823, 20824, 20825, 20826, 20827, 20828, 20829, 20830, 20831, 20832, 20833, 20834, 20835, 20836, 20837, 20838, 20839, 20842, 20843, 20849, 20850, 20851, 20852, 20853, 20854, 20855, 20857, 20861, 20871, 20873, 20874, 20875, 20876, 20877, 20878, 20879, 20880, 20881, 20882, 20883, 20884, 20885, 20887, 20892, 20893, 20894, 20895, 20896, 20897, 20898, 20899, 20900, 20901, 20902, 20903, 20904, 20905, 20906, 20907, 20917, 20918, 20919, 20920, 20921, 20922, 20923, 20924, 20925, 20926, 20927, 20928, 20929, 20930, 20931, 20932, 20933, 20934, 20935, 20936, 20937, 20938, 20939, 20940, 20941, 20942, 20943, 20944, 20945, 20946, 20947, 20948, 20951, 20952, 20953, 20954, 20955, 20956, 20957, 20958, 20959, 20960, 20961, 20962, 20967, 20968, 20969, 20970, 20972, 20973, 20974, 20976, 21770, 21769, 21768, 20982, 20983, 20984, 20985, 20986, 20987, 21017, 21018, 21019, 21020, 21021, 21022, 21023, 21024, 21025, 21026, 21027, 21028, 21029, 21030, 21031, 21042, 21043, 21051, 21059, 21060, 21061, 21066, 21070, 21071, 21085, 21086, 21087, 21088, 21089, 21090, 21091, 21092, 21094, 21095, 21096, 21102, 21103, 21104, 21107, 21111, 21112, 21116, 21117, 21118, 21119, 21120, 21121, 21122, 21123, 21124, 21125, 21126, 21127, 21128, 21129, 21130, 21131, 21132, 21135, 21140, 21141, 21142, 21143, 21144, 21147, 21148, 21149, 21151, 21152, 21153, 21154, 21155, 21156, 21157, 21158, 21159, 21160, 21161, 21162, 21163, 21164, 21165, 21166, 21167, 21168, 21169, 21170, 21171, 21172, 21173, 21174, 21175, 21176, 21177, 21178, 21179, 21180, 21181, 21182, 21183, 21184, 21185, 21186, 21187, 21188, 21189, 21190, 21194, 21195, 21196, 21197, 21198, 21199, 21200, 21212, 21216, 21224, 21236, 21270, 21276, 21277, 21352, 21304, 21320, 21324, 21330, 21338, 21341, 21345, 21354, 21369, 21376, 21377, 21385, 21397, 21393, 21406, 21409, 21414, 21450, 21453, 21456, 21457, 21458, 21459, 21460, 21466, 21467, 21474, 21475, 21476, 21480, 21489, 21491, 21493, 21501, 21507, 21512, 21530, 21534, 21543, 21544, 21547, 21551, 21554, 21556, 21558, 21561, 21563, 21568, 21569, 21573, 21574, 21575, 21581, 21592, 21594, 21618, 21625, 21644, 21650, 21653, 21660, 21673, 21678, 21687, 21688, 21691, 21693, 21708, 21709, 21713, 21714, 21727, 21737, 21750, 21758, 21794, 21809, 21831, 21833, 21844, 21854, 21856, 21858, 21868, 21876, 21880, 21881, 21908, 21919, 21926, 21948, 21972, 21973, 21978, 21999, 22006, 22012, 22016, 22019, 22023, 22033, 22056, 22057, 22058, 22061, 22066, 22068, 22080, 22087, 22088, 22108, 22123, 22126, 22147, 22150, 22170, 22190, 22194, 22210, 22217, 22221, 22230, 22242, 22595, 22251, 22269, 22283, 22298, 22320, 22329, 22339, 22348, 22387, 22416, 22421, 22437, 22440, 22462, 22470, 22487, 22491, 22492, 22493, 22503, 22516, 22529, 22542, 22553, 22560, 22566, 22580, 22585, 22601, 22603, 22627, 22636, 22640, 22656, 22659, 22663, 22664, 22666, 22675, 22705, 22715, 22719, 22770, 22781, 22799, 22828, 22836, 22838, 22842, 22877, 22888, 22900, 22983, 23060, 23072, 23095, 23138, 23147, 23193, 23199, 23217, 23279, 23281";s:17:"total_match_count";i:3084;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 : 699
File : search.php


Last edited by TonDiening on Tue Mar 28, 2006 3:01 pm; edited 1 time in total
Reply with quote
Taz_test
Newbie


Joined: 28 Mar 2006
Posts: 5

PostPosted: Tue Mar 28, 2006 2:57 pm   
 
I've been having these issues along with my reply notifications too. The problem is trying to replicate them, it doesn't always happen and I had a go at trying to come up with a full step replication but failed.

I did mail Zugg direct with the error minus the actual SQL string, because it also happens on the http://forums.zuggsoft.com/phpbb/search.php?search_id=newposts link as well.
Reply with quote
TonDiening
GURU


Joined: 26 Jul 2001
Posts: 1958
Location: Canada

PostPosted: Tue Mar 28, 2006 3:00 pm   
 
General Error

Could not insert search results

DEBUG MODE
Here is the string I get for all posts by Taz_test:

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

INSERT INTO phpbb_search_results (search_id, session_id, search_array) VALUES(877550463, 'e57ad0a877d8eb683d735c298fb02f86', 'a:7:{s:14:"search_results";s:26:"91274, 91276, 91292, 91298";s:17:"total_match_count";i:4;s:12:"split_search";N;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 : 699
File : search.php
Reply with quote
Taz_test
Newbie


Joined: 28 Mar 2006
Posts: 5

PostPosted: Tue Mar 28, 2006 3:13 pm   
 
I believe once you get the error it will happen while trying lots of different searches.

If you close your browser and open again the problem will have gone.

It's the steps we need from the working search to the broken search in order to figure out what is going wrong.
Reply with quote
TonDiening
GURU


Joined: 26 Jul 2001
Posts: 1958
Location: Canada

PostPosted: Tue Mar 28, 2006 3:33 pm   
 
Flush cookies, off line files etc.


New IE window.

Each line is a step.

Not Logged in:
http://forums.zuggsoft.com/phpbb/search_full.php?per_page=10
Search found 77 matches for: test

http://forums.zuggsoft.com/phpbb/search.php?search_author=Taz_test
General Error
SQL Error : 1062 Duplicate entry '1072579035' for key 1

http://forums.zuggsoft.com/phpbb/search_full.php?per_page=10
Search found 77 matches for: test


Logged in:
http://forums.zuggsoft.com/phpbb/search_full.php?per_page=10
Search found 77 matches for: test

http://forums.zuggsoft.com/phpbb/search.php?search_author=Taz_test
General Error
SQL Error : 1062 Duplicate entry '1724609271' for key 1

http://forums.zuggsoft.com/phpbb/search.php?search_author=hellojack
General Error
SQL Error : 1062 Duplicate entry '435293020' for key 1

http://forums.zuggsoft.com/phpbb/search_full.php?per_page=10
Search found 77 matches for: test


My knowledge ends there.
Reply with quote
Zugg
MASTER


Joined: 25 Sep 2000
Posts: 23379
Location: Colorado, USA

PostPosted: Tue Mar 28, 2006 8:06 pm   
 
I notice that you always get the error when doing an author search. The search_full.php is the search routine that I wrote which uses the MySQL full-text search engine. The search.php script is the normal search script that comes with PHPBB. I've always had issue with the PHPBB search, which is why I wrote my own. But again, any work on this will have to wait until the first beta of CMUD is released. I have to stay focused on that.
Reply with quote
Display posts from previous:   
Post new topic   Reply to topic     Home » Forums » Website or Forum problems All times are GMT
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
© 2009 Zugg Software. Hosted on Wolfpaw.net