http://www.icyphoenix.com/viewtopic.php?f=35&t=7327
-----------------------------------
OwnageWorld
Thu 19 Aug, 2010 19:11

[solved?]Search Error, Sql Error Duplicate Entry
-----------------------------------
[color=#FF0000][b]!Update![/b] [/color]
[b]It looks like its working now... I was logged in when all the errors happened.... I just logged out, and as a guest there were no errors at all... and when I logged in again, they were completely gone!

Could this be a session problem or something?[/b]




Im getting an ugly error when I try to do a random search...
I already tried to optimalize DB, repair search tables and did search table maintenance....

Version: newest (1.3.0.53a patch)

[url=http://www.fluks.net/search.php?search_keywords=parkour&return_chars=10000]Here is an example on my website....
This is the error
[code linenumbers=false]
Could not insert search results

DEBUG MODE

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

INSERT INTO ip_search_results (search_id, session_id, search_time, search_array) VALUES(964260839, 'e4051606ab70511bc4999c2a33ee6edf', 1282237637, 'a:8:{s:14:"search_results";s:13:"150, 578, 642";s:17:"total_match_count";i:3;s:12:"split_search";a:1:{i:0;s:7:"parkour";}s:7:"sort_by";s:0:"";s:5:"psort";s:4:"time";s:8:"sort_dir";s:4:"DESC";s:12:"show_results";s:5:"posts";s:12:"return_chars";i:10000;}')

Line : 1149
File : search.php[/code]
Thanks in advance!


-----------------------------------
Mighty Gorgon
Tue 31 Aug, 2010 12:43

Re: [solved?]Search Error, Sql Error Duplicate Entry
-----------------------------------
It is really a strange error, maybe was related to a wrong session.

Let me know if you have it again.