"Find all posts by" Error

  • daremedy
  • Professor
  • Professor
  • daremedy
  • Posts: 911

Post 3+ Months Ago

I was just trying to look up one of my posts from a while ago, went to my profile and clicked on the "Find all posts by daremedy" link and it came up with the error below. I checked a few other profiles, and they all throw errors. Something you should look into.

Quote:

Could not insert search results

DEBUG MODE

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

INSERT INTO phpbb_search_results (search_id, session_id, search_array) VALUES(326186583, '261eda84d5c6bf80bc0c46f89877ee0b', 'a:7:{s:14:"search_results";s:7038:"161947, 162533, 162535, 162557, 162582, 163010, 163023, 163811, 163817, 163839, 168149, 168155, 168502, 168503, 168873, 169099, 169105, 169124, 169161, 169210, 169272, 169278, 169280, 169303, 169309, 169311, 169314, 169438, 169445, 169448, 169450, 169454, 169563, 169568, 169633, 169635, 169729, 169738, 169746, 169749, 169833, 169841, 169848, 169859, 169978, 170176, 170248, 170250, 170264, 170401, 170404, 170420, 170421, 170431, 170446, 170457, 170469, 170642, 170736, 170737, 170752, 170757, 170836, 170838, 170862, 170865, 170866, 170973, 171031, 171033, 171076, 171083, 171091, 171095, 171138, 171166, 171287, 171292, 171303, 171452, 171453, 171457, 171556, 171657, 171662, 171760, 171784, 171936, 175396, 175700, 175701, 176002, 176004, 176006, 176049, 176142, 176148, 176155, 176330, 176338, 176393, 176397, 176578, 176611, 176621, 176729, 176730, 176736, 176844, 176983, 176989, 176990, 176991, 177045, 177186, 177189, 177190, 177192, 177195, 177196, 177690, 177693, 177938, 178010, 178016, 178019, 178027, 178051, 178055, 178059, 178061, 178283, 178408, 178410, 178438, 178448, 178458, 178472, 178623, 178646, 178719, 178909, 179063, 179066, 179069, 179102, 179414, 179518, 179524, 179533, 179537, 179689, 180011, 180475, 180477, 180669, 180672, 180830, 180836, 180976, 180978, 180981, 180984, 180985, 181588, 181685, 181687, 182150, 182159, 182163, 182171, 182373, 182374, 182525, 182529, 182715, 182720, 182722, 182807, 182808, 182842, 182889, 182890, 182947, 183333, 183340, 183374, 183521, 183524, 183619, 183735, 183763, 183764, 183976, 183978, 183979, 183986, 183988, 183989, 184290, 184294, 184296, 184361, 184365, 184371, 184508, 184594, 184597, 184598, 184599, 184605, 184856, 184859, 184873, 185062, 185071, 185109, 185513, 185525, 185530, 185533, 185546, 185678, 185713, 185898, 185900, 185914, 185921, 186039, 186040, 186054, 186140, 186328, 186335, 186640, 186644, 187057, 187070, 187085, 187116, 187126, 187132, 187174, 187210, 187487, 187490, 187494, 187875, 187995, 187998, 188042, 188046, 188048, 188054, 188058, 188076, 188169, 188171, 188172, 188231, 188240, 188244, 188472, 188556, 188559, 188561, 188567, 188569, 188611, 189160, 189172, 189173, 189408, 189414, 189446, 189520, 189658, 189866, 189870, 189872, 189961, 190015, 190588, 190596, 190601, 190716, 190724, 190732, 190748, 191026, 191029, 191327, 191542, 191544, 191610, 191628, 191630, 191669, 191807, 191819, 191861, 191867, 192054, 192060, 192063, 192066, 192078, 192088, 192156, 192159, 192177, 192181, 192210, 192212, 192261, 192264, 192623, 192627, 192631, 192746, 193027, 193152, 193168, 193419, 193451, 193454, 193459, 193461, 193469, 193478, 193480, 193487, 193494, 193500, 193512, 193516, 193521, 193636, 193653, 193662, 193673, 193788, 193814, 193822, 193832, 193838, 194012, 194049, 194233, 194245, 194318, 194341, 194345, 194347, 194351, 194356, 194364, 194373, 194521, 194534, 194544, 194549, 194550, 194610, 194612, 194632, 194663, 194685, 194687, 194718, 194726, 194729, 194748, 194753, 194772, 194816, 194820, 194822, 194825, 194844, 194850, 194855, 194858, 194874, 194877, 195137, 195148, 195155, 195179, 195183, 195185, 195187, 195193, 195195, 195242, 195461, 195478, 195672, 195684, 195698, 195710, 195713, 195787, 195793, 196016, 196027, 196032, 196039, 196158, 196164, 196193, 196325, 196328, 196329, 196344, 196362, 196367, 196378, 196565, 196569, 196570, 196573, 196583, 196592, 196597, 196600, 196605, 196610, 196669, 196672, 196674, 196679, 196694, 196819, 196820, 196822, 196828, 196861, 196868, 196873, 196880, 196980, 197000, 197441, 197443, 197451, 197555, 197558, 197561, 197603, 197611, 197621, 197639, 197657, 197720, 197724, 197726, 197731, 197753, 197765, 197767, 197777, 197779, 197789, 197795, 197819, 197905, 198157, 198160, 198168, 198189, 198474, 198492, 198563, 198642, 198656, 198825, 198977, 198985, 199023, 199024, 199031, 199055, 199197, 199202, 199208, 199244, 199252, 199267, 199314, 199349, 199359, 199391, 199511, 199581, 199716, 199725, 199739, 199744, 199750, 199759, 199845, 199863, 200014, 200047, 200123, 200127, 200134, 200142, 200149, 200231, 200271, 200284, 200289, 200331, 200425, 200504, 200507, 200518, 200538, 200540, 200543, 200666, 200690, 200699, 200727, 200936, 200941, 200952, 200959, 201020, 201024, 201039, 201179, 201401, 201402, 201720, 201721, 201913, 201914, 201918, 201920, 201921, 201924, 201990, 201991, 202412, 202416, 203014, 203018, 203024, 203236, 203239, 203244, 203250, 203341, 203433, 203434, 203437, 203439, 203448, 203533, 203724, 203732, 203737, 203738, 203748, 203787, 204104, 204111, 204114, 204117, 206120, 206127, 206329, 206330, 206678, 206683, 206820, 206997, 207001, 207050, 207166, 207169, 207301, 207418, 207534, 207537, 207540, 207628, 207654, 207749, 207751, 207754, 207877, 208082, 208083, 208085, 208087, 208090, 208151, 208156, 208272, 208276, 208991, 209001, 209014, 209366, 209371, 209372, 209394, 209450, 209475, 209536, 209759, 209873, 209877, 210154, 210158, 210299, 210302, 210397, 210398, 210406, 210408, 210781, 210785, 210839, 210973, 211196, 211198, 211203, 211622, 211633, 211639, 211644, 211837, 211838, 211839, 213387, 213521, 214898, 215068, 215233, 215240, 215351, 215518, 215903, 215913, 216038, 216040, 216399, 219395, 219398, 219415, 219418, 219435, 219812, 219819, 221831, 222277, 222284, 223928, 225321, 228549, 228581, 229021, 229136, 229886, 231566, 232091, 232094, 232383, 242128, 242247, 242463, 242487, 243699, 243708, 243710, 243736, 244120, 244122, 244330, 244425, 244546, 244550, 244555, 244715, 244717, 244719, 244726, 244872, 244959, 245756, 245964, 246963, 247305, 247306, 247309, 247320, 247323, 247329, 247760, 247773, 247778, 247781, 247801, 247966, 248374, 248507, 248663, 248668, 248690, 248711, 248714, 248925, 249077, 249169, 249180, 249193, 249642, 249694, 249818, 249827, 249833, 249836, 250013, 250016, 250024, 250071, 250261, 250541, 250551, 251490, 252377, 252390, 252396, 252399, 252635, 252652, 252662, 252806, 253163, 253169, 253177, 253684, 253685, 254638, 254924, 255384, 255599, 256057, 256069, 260899, 261076, 268194, 270167, 270169, 270172, 270178, 270494, 270498, 270502, 270506, 270508, 270775, 271442, 271443, 271444, 271838, 271842, 271847, 271854, 271859, 272040, 272044, 272045, 272461, 273016, 273027, 273246, 273252, 273363, 273964, 282594, 283175, 283481, 284123, 284135, 284230, 284398, 284659, 284668, 284750, 285007, 285010, 285432, 285433, 285778, 285894, 287373, 287524, 293467, 293472, 293803, 298951, 299009, 299016, 299017, 301599, 301762, 301766, 301787, 301788, 302061, 302099, 302882, 302883, 303105, 303109, 303800, 303803, 304402, 304405, 304408, 304489, 304618, 304693, 304925, 305205, 305210, 305779, 306572, 306673, 308719, 308721, 308802, 308807, 308809, 308811, 308814, 308818, 308823, 308826, 308829, 308832, 309117, 309124, 309365, 309916, 309918, 309930, 309973, 309979, 310018, 310022, 310253, 310262, 310956, 310960, 310970, 311454, 311564, 311812, 312640, 312751, 313030, 313750, 314092, 314097, 314105, 314770, 319597, 319603, 321647, 321653, 321655, 322190, 322193";s:17:"total_match_count";i:880;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 : 706
File : search.php
  • Anonymous
  • Bot
  • No Avatar
  • Posts: ?
  • Loc: Ozzuland
  • Status: Online

Post 3+ Months Ago

  • ATNO/TW
  • Super Moderator
  • Super Moderator
  • User avatar
  • Posts: 23456
  • Loc: Woodbridge VA

Post 3+ Months Ago

Seems to be OK for me. I checked yours, mine and a few others. I have noticed some random "lag" in OZZU page load time the last couple days. Might have just caught MySQL when it was burping on something.
  • daremedy
  • Professor
  • Professor
  • daremedy
  • Posts: 911

Post 3+ Months Ago

Eeeesh! Guess I jumped the gun on that one. I was trying it for almost a full minute and got fed up! Everything is back to normal. Carry on, nothing to see here. :banana:

Post Information

  • Total Posts in this topic: 3 posts
  • Users browsing this forum: No registered users and 4 guests
  • 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 post attachments in this forum
 
 

© 1998-2014. Ozzu® is a registered trademark of Unmelted, LLC.