SQL like a pig for me, boy…

[chupathingie]

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…

[Elsinore]

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

[chupathingie]

nope, all clear this morning. 🙂

[Barracuda]

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.

[Author]

Posts