Roster Error, please help.

by **nazeeh** » Wed Jul 05, 2006 5:54 am

Hi!

My roster was working just fine (latest version) and suddenly for no reason I can figure out, when I view a character's stats, I get this error:

016: Can't open file: 'roster_items.MYI'. (errno: 145)

Anyone know what that's all about?

Thanks!

by **Anaxent** » Wed Jul 05, 2006 6:00 am

Login to your phpmyadmin and try to repair your tables and optimize.

by **nazeeh** » Wed Jul 05, 2006 8:48 am

hmm....

I logged on Phpmysqladmin and yeah... roster_items table shows as "in use" and i can't access it or anything.

Is that a mysql adminstration issue from my provider's side?

by **Anaxent** » Wed Jul 05, 2006 8:50 am

Yes it is they should be able to go in and repair the .myi files of the DB unless you have some sort of cpanel that will allow you to see the table and repair other than phpmyadmin

by **nazeeh** » Wed Jul 05, 2006 9:09 am

Ok...fixed it... dropped the table and recreated it. Fortunately had a back of the database, so even table contents where restored.

Thanks for the tip!