mangos zero Issue with equipped armor sql

[JPlady42]

I'm having an issue on my server with about 10 people online.

 

Item's seem temporary. When relogging, any equipped armor that they just obtained disappears.

It throws out this sql error

 

SQL ERROR: Incorrect key file for table '.\characters\item_instance.MYI'; try to repair it
SQL: can not execute 'INSERT INTO item_instance (guid,owner_guid,data) VALUES (?, ?, ?)'
SQL ERROR: Incorrect key file for table '.\characters\item_instance.MYI'; try to repair it
SQL: can not execute 'INSERT INTO item_instance (guid,owner_guid,data) VALUES (?, ?, ?)'
SQL ERROR: Incorrect key file for table '.\characters\item_instance.MYI'; try to repair it
SQL: can not execute 'INSERT INTO item_instance (guid,owner_guid,data) VALUES (?, ?, ?)'
SQL ERROR: Incorrect key file for table '.\characters\item_instance.MYI'; try to repair it
 

[JPlady42]

Did exactly what it said, repaired table, and it works now. Sorry for thread.

 

[iltuocapo]

4 hours ago, JPlady42 said:

I'm having an issue on my server with about 10 people online.

 

Item's seem temporary. When relogging, any equipped armor that they just obtained disappears.

It throws out this sql error

 

SQL ERROR: Incorrect key file for table '.\characters\item_instance.MYI'; try to repair it
SQL: can not execute 'INSERT INTO item_instance (guid,owner_guid,data) VALUES (?, ?, ?)'
SQL ERROR: Incorrect key file for table '.\characters\item_instance.MYI'; try to repair it
SQL: can not execute 'INSERT INTO item_instance (guid,owner_guid,data) VALUES (?, ?, ?)'
SQL ERROR: Incorrect key file for table '.\characters\item_instance.MYI'; try to repair it
SQL: can not execute 'INSERT INTO item_instance (guid,owner_guid,data) VALUES (?, ?, ?)'
SQL ERROR: Incorrect key file for table '.\characters\item_instance.MYI'; try to repair it
 

Sounds like a char saving problem. Look inside mangosd.conf there "s a setting for this