Not Sure, I think MySQL Problems..

[thinkjose]

• PHP Version : 4.1.2
• MySql Version : 3.23.45
• Apache Version : ?
• OS: Unix?
• Errors : <!-- Database error in vBulletin 2.2.1:
  
  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.MYD'. (errno: 145)
  
  mysql error number: 1016
  
  Date: Tuesday 12th of March 2002 07:43:40 PM
  Script: http://pgnx.4dgaming.com/forums/forums/
  Referer:
  -->
• Editing Files : No

Version Running, 2.2.1, Cannot Upgrade because of mysql problem.

[thinkjose]

I was just told by my host that they upgraded Mysql, I'll see If I can find out what version it ran before.

[George L]

you have a corrupted user table

you need to repair it via one of the following methods (WITH forum CLOSED!)

1. via phpmyadmin

using query

REPAIR TABLE user;

2. or using mysqlcheck repair for 3.23.38 and above

i.e. in shell/telnet/ssh type while mysql is running and forum is CLOSED:

mysqlcheck -r -u mysqlusername -p databasename

3. via myisamchk repair functions while mysql is shutdown/stopped in shell/telnet/ssh type :

myisamchk -r -u root -p databasename

option #3 most likely requires server and mysql root access to first stop mysql and then run myisamchk repair options.

[thinkjose]

How can I close my forum? It doesn't let me do anything, thanks for responding.

[George L]

Originally posted by Coolj
How can I close my forum? It doesn't let me do anything, thanks for responding.

oh in that case you can use method 1 or 2 to repair the forums

[Jux]

I'm having the same problem, and I was hoping someone could point me in the direction for more clairification on how to repair the tables with mysqlcheck. I don't know too much about Telnet, and I don't know how to access the right directory to run the check.

Thanks for the help, I know, I'm a bad webmaster. Heh.

[George L]

Originally posted by Jux
I'm having the same problem, and I was hoping someone could point me in the direction for more clairification on how to repair the tables with mysqlcheck. I don't know too much about Telnet, and I don't know how to access the right directory to run the check.

Thanks for the help, I know, I'm a bad webmaster. Heh.

1. log into your server via SSH/telnet
2. type

mysqlcheck -r -u mysqlusername -p databasename

that's it

of course you need to be running mysql 3.23.38 or higher for mysqlcheck support

[Jux]

It keeps telling me that the "mysqlcheck" command is not found. I'm pretty sure it's the right version of MySQL, but I'm going to cal my webhosting company now.

[thinkjose]

I get this error when trying to view the admin log..
Also, When I try and backup my database, problems occur//////

[ Nevermind, I repaired the adminlog table and everything was fixed. ]