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.

 All Forums
 SQL Server 2008 Forums
 Transact-SQL (2008)
 Need to help someone with MySQL

Author  Topic 

mikebird
Aged 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)

bandi
Master 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
Go to Top of Page
   

- Advertisement -