Problem

Lysu Davanum · Post by **Lysu Davanum** » Wed Jan 05, 2005 6:57 am

Could not insert search results

DEBUG MODE

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

INSERT INTO phpbb_search_results (search_id, session_id, search_array) VALUES(1001378134, '5e13b29260bc04cee556e3a0fc804f86', 'a:7:{s:14:"search_results";s:1086:"67206, 67546, 67796, 68627, 68745, 69353, 69369, 69387, 69392, 69397, 69400, 69406, 69409, 69416, 69448, 69455, 69462, 69469, 69480, 69483, 69486, 69492, 69504, 69510, 69513, 69518, 69525, 69530, 69534, 69538, 69542, 69546, 69549, 69556, 69558, 69563, 69568, 69571, 69576, 69578, 69580, 69586, 69600, 69604, 69612, 69615, 69623, 69634, 69639, 69643, 69653, 69663, 69667, 69670, 69685, 69688, 69693, 69699, 69701, 69892, 69931, 70000, 70014, 70020, 70065, 70068, 70078, 70087, 70090, 70131, 70143, 70250, 70253, 70259, 70273, 70282, 70286, 70291, 70314, 70324, 70337, 70344, 70358, 70582, 70667, 71038, 71106, 71114, 71409, 71443, 71477, 71663, 71667, 71685, 71724, 71726, 71746, 71754, 72056, 72061, 72091, 72232, 72486, 72544, 72600, 74737, 74752, 75427, 75429, 75430, 75864, 76209, 76462, 76585, 76590, 77413, 77549, 77757, 77759, 78034, 78035, 78057, 78060, 78091, 78093, 78155, 78803, 78828, 79775, 80772, 83546, 84749, 93136, 94523, 95595, 99353, 104384, 104585, 105086, 105295, 105298, 105706, 105790, 110394, 110550, 111042, 114245, 163249, 163255, 163281, 163408, 163577, 163581";s:17:"total_match_count";i:153;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 : 684
File : /var/www/html/community/forums/search.php

I got this when searching for posts for some user. I asked someone else to do the same, but it worked with them. What is wrong?

Kasume · Post by **Kasume** » Wed Jan 05, 2005 1:17 pm

What did you search for?

Lysu Davanum · Post by **Lysu Davanum** » Wed Jan 05, 2005 1:18 pm

For posts of a user...just search posts of this user. I have tried with many.

Kasume · Post by **Kasume** » Wed Jan 05, 2005 1:18 pm

Okay, which user?

Lysu Davanum · Post by **Lysu Davanum** » Wed Jan 05, 2005 3:41 pm

Any user sweetheart. I've tried with so many, but it keeps saying the same thing.

GMcFly · Post by **GMcFly** » Wed Jan 05, 2005 3:58 pm

Maybe a IE problem? no...
i hope Alatar knows why it was.

i move it in the problem forum

Cedric Kilmar · Post by **Cedric Kilmar** » Wed Jan 05, 2005 8:13 pm

First of all, i think its weird that you're the only one who has this Problem, as it seems to be a problem with the database... Did you start a search immediately before a server crash or the worm-attack? something like that? I have no other explanation for that. But as far as i see its not a problem on the side of the client. Therefore YOU can't do anything...

Someone should take a look on that entry in the database, maybe its a broken record. Otherwise recreate the table would be my last idea...

just my thoughts....

PO Cedric

-EDIT-

Another idea came in my mind.
Maybe there's a bug in the php-file before this Query, maybe the wrong id was delivered to the query? But this wouldn't explain why it is just you, who has this problem...