Register Members List Search Today's Posts Mark Forums Read

Reply
 
Thread Tools
  #1  
Old 12 Jun 2008, 20:57
captainron19's Avatar
captainron19 captainron19 is offline
 
Join Date: Mar 2006
Database Problem

Today my VPS Server went down. Ever since it has gotten back up and running I am receiving database errors when someone tries to create a post.

I contacted the server company and they stated they restarted the VPS but they can do nothing about the database since it is MYSQL and it is above their control.

Can anyone offer any suggestions? The error I receive is as follows: ....

Database error in vBulletin 3.7.1:

Invalid SQL:
MySQL Error : Duplicate entry '67198' for key 1
Error Number : 1062
Request Date : Thursday, June 12th 2008 @ 04:45:42 PM
Error Date : Thursday, June 12th 2008 @ 04:45:44 PM
Reply With Quote
  #2  
Old 12 Jun 2008, 22:47
Opserty Opserty is offline
 
Join Date: Apr 2007
Is that the complete error? (Copy and Paste it from the error page, View the HTML source if the full message isn't displayed)

(Be sure to censor your IP address. )
Reply With Quote
  #3  
Old 12 Jun 2008, 23:37
captainron19's Avatar
captainron19 captainron19 is offline
 
Join Date: Mar 2006
Here is the full error

Database error in vBulletin 3.7.1:

Invalid SQL:
INSERT INTO post
(showsignature, allowsmilie, username, userid, title, pagetext, iconid, visible, parentid, threadid, dateline, ipaddress, attach)
VALUES
(0, 1, 'DisneyFan101', 409, '', '\"And talk to me for hours\".', 0, 1, 67130, 75, 1213312640, '* removed *', 0);

MySQL Error : Duplicate entry '67198' for key 1
Error Number : 1062
Request Date : Thursday, June 12th 2008 @ 07:17:20 PM
Error Date : Thursday, June 12th 2008 @ 07:17:20 PM
Script : http://disney-forums.com/forums/newr...postreply&t=75
Referrer : http://disney-forums.com/forums/newr...uote=1&p=67130
IP Address : xxxxx
Username : DisneyFan101
Classname : vB_Database
MySQL Version :

Last edited by King Kovifor; 12 Jun 2008 at 23:55.
Reply With Quote
  #4  
Old 13 Jun 2008, 10:23
Marco van Herwaarden Marco van Herwaarden is offline
 
Join Date: Jul 2004
AdminCP -> Maintenance -> Repair / Optimize Tables -> Fix Unique Indexes
__________________
Marco van Herwaarden
Ex vBulletin.org Coordinator
Reply With Quote
Reply



Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off


New To Site? Need Help?

All times are GMT. The time now is 09:19.

Layout Options | Width: Wide Color: