PDA

View Full Version : Help


[D]Vincent
06-20-2002, 09:23 AM
Vincent]Okay my server shut down for like an hour saying connetstion timed out, and when it started working again I was getting alot of MySQL errors, there was one when people tried going to main lounge. But I fixed that but creating a second main lounge and doing mass move with the threads in the first one to the second. Now there's one with Moving a thread individually and posting a new trhead, probably many others but that's all I've found in the past ten minutes -_-" when I try and post a new thread I get this error.

Database error in vBulletin 2.2.6:

Invalid SQL: INSERT INTO thread (threadid,title,lastpost,forumid,open,replycount,p ostusername,postuserid,lastposter,dateline,iconid, visible,attach) VALUES (NULL,'drthj','1024567321','2','1','0','Dark Vincent','1','Dark Vincent','1024567321','0','1','0')
mysql error: Duplicate entry '505' for key 1

mysql error number: 1062

Date: Thursday 20th of June 2002 11:02:01 AM
Script: http://www.fflounge.com/board/board/newthread.php
Referer: http://www.fflounge.com/board/newthread.php?s=&action=newthread&forumid=2

When I try and move a trhead I get this error.

Database error in vBulletin 2.2.6:

Invalid SQL: INSERT INTO thread (threadid,title,lastpost,forumid,pollid,open,reply count,postusername,postuserid,lastposter,dateline, views,iconid,visible) VALUES (NULL,'New Forum Icons','1024565872','2','502',10,'5','Dark Vincent','1','Dark Vincent','1024550797','27','0','1')
mysql error: Duplicate entry '505' for key 1

mysql error number: 1062

Date: Thursday 20th of June 2002 11:06:51 AM
Script: http://www.fflounge.com/board/board/postings.php
Referer: http://www.fflounge.com/board/postings.php?action=move&threadid=502

At the top of the vbstats page I get this error.

Warning: MySQL: Unable to save result set in /usr/local/psa/home/vhosts/fflounge.com/httpdocs/board/vbstats.php on line 88

Warning: Supplied argument is not a valid MySQL result resource in /usr/local/psa/home/vhosts/fflounge.com/httpdocs/board/vbstats.php on line 88

That's all the errors I've found so far. Anyone know what to do and if they can help me?

Logician
06-20-2002, 10:12 AM
probably there are problems with your MYSQL db. You can try to repair your database (first close your board, better rename the board directory) or restore a backup if you have a recent one. Check "repair MYSQL database" keywords in here and vbulletin.com for more info.. (I'm assuming you didnt hack your board right before the errors you get)