Database error

[Steve Machol]

See this thread:

http://www.vbulletin.com/forum/showthread.php?threadid=69171

[mclark2112]

I am having the same problems. Sometimes it is the user table sometimes the thread table. The errors just started a week ago, and they are happening about twice a day.

What else could be going wrong. I am still using 2.6
and am going to upgrade to 2.9 as soon as I fix this.

[Jay Krupp]

That was actually really funny.

Haha, thanks, I'll try it.

[vBR]

I bet at parties you let other people tell jokes and you chip in with the punch line, right?

[Steve Machol]

It's a gift.

[vBR]

I don't believe it.
How do you do it?
You picked exactly the right moment to beat me to it with the query.

[Steve Machol]

Your user table is corrupted. To fix this run this query in phpMyAdmin:

REPAIR TABLE user;

[Jay Krupp]

Database error in vBulletin Control Panel 2.2.9:

Invalid SQL: SELECT user.*,userfield.* FROM user LEFT JOIN userfield ON
userfield.userid=user.userid WHERE user.userid='1'
mysql error: Can't open file: 'user.MYI'. (errno: 145)

mysql error number: 1016

Date: Thursday 10th of April 2003 12:08:40 AM
Script: http://www.rhymenreason.net/forum/forum/admin/
Referer:

Database error in vBulletin 2.2.9:

Invalid SQL: SELECT user.*,userfield.* FROM user LEFT JOIN userfield ON
userfield.userid=user.userid WHERE user.userid='1'
mysql error: Can't open file: 'user.MYI'. (errno: 145)

mysql error number: 1016

Date: Thursday 10th of April 2003 12:10:14 AM
Script: http://www.rhymenreason.net/forum/forum/
Referer:

Each sent in seperate emails.

[vBR]

View your forums again with the correct technical email set and let it mail you the error report.

[Jay Krupp]

Yes.

I haven't tried individual threads, but I'd assume it was the same. Everything else on the site works except the vb at this point.

[vBR]

So you receive the error just by viewing your forum home?

[Jay Krupp]

That's just the thing. It happened when I was not online.

I got on my computer and found it.

[vBR]

I understood all of that up until "duplicate the error."

How would I do that?

What were you doing when the error happened?
Can you make the error happen again?

[Jay Krupp]

I understood all of that up until "duplicate the error."

How would I do that?

[vBR]

And let's say the address it would be sent to is inactive. Then how would a person go about fixing it?

As admin you keep the address active or change it in /admin/config.php.

// technical email address - any error messages will be emailed here
$technicalemail = "[email protected]";

If that address is inactive, update it to an active one and try to duplicate the error.