PDA

View Full Version : error going back to new post page


deth
01-06-2005, 06:34 AM
was reading a toipc, hit back and got this



Could not insert search results

DEBUG MODE

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

INSERT INTO phpbb_search_results (search_id, session_id, search_array) VALUES(471721278, '548d8d496078d5879c8ec388ce416e09', 'a:7:{s:14:"search_results";s:173:"20463, 21249, 21391, 21543, 21699, 21952, 21971, 22025, 22028, 22037, 22048, 22051, 22054, 22072, 22075, 22078, 22080, 22087, 22089, 22093, 22094, 22098, 22099, 22100, 22101";s:17:"total_match_count";i:25;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 : 712
File : /home/jabbasworld/public_html/search.php

ZfrkS62
01-13-2005, 02:41 PM
i just got the same message as Deth did, but i think it said line 717 instead of 712

LiveForSpeed.Looney
01-13-2005, 05:23 PM
well obviously you had previously run a search for something, and then when you hit back you must have hit it more than once sending you back to the submit page for the search and therefore trying to submit the same details with same session, hence the error

fix = be more careful/patient hitting the back button :wink:

ZfrkS62
01-13-2005, 07:28 PM
actually i just clicked on the "view posts since last visit" link on the home page. and i only clicked it once :wink:

wow2000
01-13-2005, 07:44 PM
well that also uses search.php and of course basically runs a search query to find all the topics for you.. I just tried it and no errors for me so far, but I'm a little busy with something else right now so i will check further later :)