SQL like a pig for me, boy…

Forums Forums Farktography General Chat Farktography Pub and Grill SQL like a pig for me, boy…

Viewing 4 posts - 1 through 4 (of 4 total)
  • Author
  • #2540

    Could not insert search results


    SQL Error : 1062 Duplicate entry ‘1109047394’ for key 1

    INSERT INTO os_core_phpbb_search_results (search_id, session_id, search_time, search_array) VALUES(1109047394, ‘3a39fd4e8d7ce2202d2604ec2a4c2154’, 1328591726, ‘a:7:{s:14:”search_results”;s:34:”3150, 3249, 3250, 3318, 3323, 3327″;s:17:”total_match_count”;i:6;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 : 736
    File : search.php

    I’m having withdrawals…


    I’ve seen that a couple times, randomly, but I’m not sure what’s going on. Is it still doing this for you>?


    nope, all clear this morning. 🙂


    Search functionality seems to be the bane of all web forums. I help admin a large cycling forum running vBulletin and it seems like search has never worked right through countless versions of the software. I gave up and usually use google and site: to get good results.

    The software geek in would say the root problem is that the software is trying to insert a search record with the same unique identifier as one that already exists, of course, this is the “well no shit Sherlock” answer, but doesn’t help discovering WHY it is trying to do this. It is, however, why I use GUIDs and not auto-incremental integers for nearly all of my identifier fields.

Viewing 4 posts - 1 through 4 (of 4 total)
  • You must be logged in to reply to this topic.