MySQL Tables error!! ( Item_Proto )

01/28/2013 23:09 Jovanymha#1
Hello Epvp ,

I am facing this problem please if someone could help me ..

I am using serverfiles by zauberhazzex and started to make changes in itemproto

Then , after reboot , i try to login in game , it takes me to choose channel...

I tried to fix the tables ( extended ) but all give an error .
So i started with the serverfiles from 0 , when i add the itemproto back up . same thing happens.

Anyone could help me please ? thank you alot :)
01/29/2013 09:19 [SA]ChilleXx#2
Replace the Backup of the item proto table :)
01/29/2013 09:41 Jukiii#3
Be more specific what king of error...
01/29/2013 10:15 Jovanymha#4
Helloo , Thank you for your Reply

The thing i discovered , is that even if i dont touch any table , and i try to repair tables ( extended ) they give me an error !!

This Picture Shows when i Repair (extended ) and without touching or making changes to the tables

[Only registered and activated users can see links. Click Here To Register...]
01/29/2013 10:24 lucy08#5
go to /var/db/ in Filezilla and change permisions for "mysql" to 777

done.
01/29/2013 11:52 Jovanymha#6
I managed to know where to change the permission , but its already set to 0777 , when i type 777 i cant enter the OK button , so i guess 0777 is the same ? And what to do :/ ?
01/29/2013 12:55 .Mystery#7
Quote:
Originally Posted by Jovanymha View Post
I managed to know where to change the permission , but its already set to 0777 , when i type 777 i cant enter the OK button , so i guess 0777 is the same ? And what to do :/ ?
Try
PHP Code:
chown -R mysql:mysql /var/db/mysql
01/29/2013 13:34 Jovanymha#8
Thanks .Mystery .
Now The tables are working good , but i don't know what is the problem , when i try to log in , it takes me to choose ch ! any idea ? :/
01/29/2013 14:31 .Mystery#9
Quote:
Originally Posted by Jovanymha View Post
Thanks .Mystery .
Now The tables are working good , but i don't know what is the problem , when i try to log in , it takes me to choose ch ! any idea ? :/
Need to take a look on the syserrs from worldservers.
01/29/2013 15:39 Jovanymha#10
Sorry guys , but it turns out to be an error caused by the Backup lol!
i did everything again , and works fine , thanks Again all :)