PDA

View Full Version : Problem with Database


SpanishHarlem
03-30-2006, 12:04 PM
Hello, There seem's to be a problem with my database. I went to bed last night and everything was fine. Got a couple of msn's and pm's that they get an error when trying to post.

I tried this morning to post and this is what I get.

Database error in vBulletin 3.5.0:

Invalid SQL:

SELECT posthash.threadid
FROM posthash AS posthash
WHERE posthash.userid = 3 AND
posthash.dupehash = 'e79e05e50fbfea41d716068331748119' AND
posthash.dateline > 1143725245;

MySQL Error : Can't open file: 'posthash.MYI' (errno: 145)
Error Number : 1016
Date : Thursday, March 30th 2006 @ 08:32:25 AM
Script : http://canadian-freebies-n-stuff.com/forum/newthread.php
Referrer :
IP Address : 74.12.40.96
Username : CherBear
Classname : vb_database

I don't know stuff that has to do with the upgrading or even installing and neither does the person who has allowed me to host through his server. He is just a guy who has allowed me to run off of his server as a favour.

The tech guy I used to have told me that he would help teach me this stuff but when he sold his hosting business he but all up and disapeared. Is there anything I can do. I have over 2,000 member's who are driving me nuts.

Thank's in Advance.

TTG
03-30-2006, 12:10 PM
Run the Repair Utility at the bottom of the admincp in the Import and Maintenance section.

SpanishHarlem
03-30-2006, 12:15 PM
Thank you. That seemed to work.

Strike3ForumsMH
07-24-2007, 05:22 PM
I had the same error, panicked and then remembered vbulletin.org so thanks to TTG as well!

Working fine again.

:)