Skip to toolbar

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
    Posts
  • #2540
    chupathingie
    Participant

    Could not insert search results

    DEBUG MODE

    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…

    #43992
    Elsinore
    Keymaster

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

    #43993
    chupathingie
    Participant

    nope, all clear this morning. 🙂

    #43994
    Barracuda
    Participant

    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.