need more fast help!

[Martin]

this is the latest error I'm getting:

Database error in vBulletin: Invalid SQL: INSERT INTO post (postid,threadid,title,username,userid,dateline,pagetext,allowsmilie,email,signature,ipaddress,iconid,visible) VALUES (NULL,35390,'','',1130,961460523,'test',1,0,0,'207.203.127.45',0,1)
mysql error: Got error 127 from table handler
mysql error number: 1030
Date: Monday 19th of June 2000 08:22:03 PM

I searched the mySQL reference and I cannot find "error 127" anywhere.

Again, thanx are appreciated...

[Freddie Bingham]

From that sql I can see that the Thread Title and Username are both being sent to the server as blank when they can't be. Why? Got me.

[Martin]

that's what I couldn't figure out.

I looked at the "post" table with PHPmyAdmin and very few of the posts still had Title and Username info.

I just lost 162,000+ posts.

[Martin]

I *did* get the board back up again, but 99.9% of the threads show up with no posts, even though they show up in the forums and if you post to them the post still gets counted. I wish John or James could be here to help me out with this. I hate to lose a whole month....

[Freddie Bingham]

Is this after you ran the mysql repair util?

You have no backups to restore?

[Martin]

nope

I wish I could figger out how to do a cron job on the DB in NT. The problem is, I have a LOT of posts. Thats a HUGE dump.

I guess another alternative would be to try to set up through task manager to copy all the files to a backup folder rather doning a dump, but I'm not familiar enough with NT to do that...