| 
                
Please start any new threads on our new 
    site at https://forums.sqlteam.com.  We've got lots of great SQL Server
    experts to answer whatever question you can come up with. 
    
        | 
                
                    | 
                            
                                | Author | Topic |  
                                    | mikebirdAged Yak Warrior
 
 
                                        529 Posts | 
                                            
                                            |  Posted - 2013-08-12 : 06:55:06 
 |  
                                            | I have a server running vbulletin and it had a power outage this morning, I now have a situation where the server is reporting the following:Database error in vBulletin 3.8.2:Invalid SQL:REPLACE INTO search(userid, ipaddress, personal,searchuser, forumchoice,sortby, sortorder, searchtime,showposts, orderedids, dateline,displayterms, searchhash, completed)VALUES(4, '86.155.201.22', 1,'rf860', '','post.dateline', 'DESC', 0.23376,1, (Removed some code here to be able to post this) |  |  
                                    | bandiMaster Smack Fu Yak Hacker
 
 
                                    2242 Posts | 
                                        
                                          |  Posted - 2013-08-12 : 07:04:02 
 |  
                                          | MySQL Error : Duplicate entry '21080356' for key 'PRIMARY'here Error message is self exploratory.... You are trying to insert 21080356 to primary key column which is already exist in the table...In your code we haven't seen 21080356 value... I think some where else that error caused...Note: Any way this is SQL Server forum. So you can get quick response by posting in the relevant form like www.dbforums.com--Chandu |  
                                          |  |  |  
                                |  |  |  |  |  |