[solved?]Search Error, Sql Error Duplicate Entry


Subject: [solved?]Search Error, Sql Error Duplicate Entry
!Update!
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?





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)

Here is an example on my website....
This is the error
Code: [Download] [Hide] [Select]
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

Thanks in advance!

Profile PM  
Subject: 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.


Page 1 of 1


  
You cannot post new topics
You cannot reply to topics
You cannot edit your posts
You cannot delete your posts
You cannot vote in polls
You cannot attach files
You can download files
You cannot post calendar events

   

This is a "Lo-Fi" version of our main content. To view the full version with more information, formatting and images, please click here.

Powered by Icy Phoenix based on phpBB
Generation Time: 0.93s (PHP: 2% SQL: 98%)
SQL queries: 31 - Debug Off - GZIP Enabled