Log in

View Full Version : Zoning = Items Deleted

Jibbatwinkers
06-01-2006, 10:43 AM
Hey, was wandering if anyone could help me with a problem I ran into. I was running my server (Zebuxoruk) and the power went out. Got it all back up and was going fine, then when I zoned my items were deleted. Same with a few other players on my server. I'm assuming the zone server and the DB aren't speaking to eachother anymore.

Someone on my server said this has happened on other servers and it's fairly easy to fix, I can't get it to work was curious if anyone knew. The Zebuxoruk Server thanks you in advance!

Edit: Found something, not sure what this means but I know it's wrong. SQL DB Reports:

Error

SQL query: DocumentationEdit

SELECT COUNT( * ) AS num
FROM `eq`.`inventory`

MySQL said: Documentation
#1016 - Can't open file: 'inventory.MYI'. (errno: 145)
Scorpious2k
06-01-2006, 11:37 AM
Hey, was wandering if anyone could help me with a problem I ran into. I was running my server (Zebuxoruk) and the power went out. Got it all back up and was going fine, then when I zoned my items were deleted. Same with a few other players on my server. I'm assuming the zone server and the DB aren't speaking to eachother anymore.

Someone on my server said this has happened on other servers and it's fairly easy to fix, I can't get it to work was curious if anyone knew. The Zebuxoruk Server thanks you in advance!

Edit: Found something, not sure what this means but I know it's wrong. SQL DB Reports:

Error

SQL query: DocumentationEdit

SELECT COUNT( * ) AS num
FROM `eq`.`inventory`

MySQL said: Documentation
#1016 - Can't open file: 'inventory.MYI'. (errno: 145)

You may have a broken table or tables. Try repairing them.
Jibbatwinkers
06-01-2006, 11:45 AM
Not really sure how to repair, GM that usually does SQL is asleep, I've worked with it though so I wouldn't be lost if someone told me how to do it.
Jibbatwinkers
06-01-2006, 12:28 PM
Alright just typed this in my SQL Query:

repair table inventory;

and we have ourselves a fix. Thanks for the suggestion.
Scorpious2k
06-01-2006, 02:07 PM
Alright just typed this in my SQL Query:

repair table inventory;

and we have ourselves a fix. Thanks for the suggestion.

Glad to help.