Register for your free account! | Forgot your password?

Go Back   elitepvpers > Popular Games > Metin2 > Metin2 Private Server
You last visited: Today at 21:16

  • Please register to post and access all features, it's quick, easy and FREE!

Advertisement



MySQL Tables error!! ( Item_Proto )

Discussion on MySQL Tables error!! ( Item_Proto ) within the Metin2 Private Server forum part of the Metin2 category.

Reply
 
Old   #1
 
elite*gold: 0
Join Date: Apr 2009
Posts: 80
Received Thanks: 12
MySQL Tables error!! ( Item_Proto )

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
Jovanymha is offline  
Old 01/29/2013, 09:19   #2
 
elite*gold: 80
Join Date: Dec 2012
Posts: 480
Received Thanks: 61
Replace the Backup of the item proto table
[SA]ChilleXx is offline  
Thanks
1 User
Old 01/29/2013, 09:41   #3
 
Jukiii's Avatar
 
elite*gold: 0
Join Date: Oct 2010
Posts: 182
Received Thanks: 31
Be more specific what king of error...
Jukiii is offline  
Thanks
1 User
Old 01/29/2013, 10:15   #4
 
elite*gold: 0
Join Date: Apr 2009
Posts: 80
Received Thanks: 12
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

Jovanymha is offline  
Old 01/29/2013, 10:24   #5
 
lucy08's Avatar
 
elite*gold: 0
Join Date: Jul 2009
Posts: 154
Received Thanks: 161
go to /var/db/ in Filezilla and change permisions for "mysql" to 777

done.
lucy08 is offline  
Thanks
1 User
Old 01/29/2013, 11:52   #6
 
elite*gold: 0
Join Date: Apr 2009
Posts: 80
Received Thanks: 12
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 :/ ?
Jovanymha is offline  
Old 01/29/2013, 12:55   #7
 
elite*gold: 0
Join Date: Jan 2013
Posts: 26
Received Thanks: 9
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
.Mystery is offline  
Thanks
1 User
Old 01/29/2013, 13:34   #8
 
elite*gold: 0
Join Date: Apr 2009
Posts: 80
Received Thanks: 12
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 ? :/
Jovanymha is offline  
Old 01/29/2013, 14:31   #9
 
elite*gold: 0
Join Date: Jan 2013
Posts: 26
Received Thanks: 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.
.Mystery is offline  
Thanks
1 User
Old 01/29/2013, 15:39   #10
 
elite*gold: 0
Join Date: Apr 2009
Posts: 80
Received Thanks: 12
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
Jovanymha is offline  
Reply


Similar Threads Similar Threads
[help] mysql data loop betwean differend tables
01/29/2012 - EO PServer Hosting - 2 Replies
hi all i was wondering if some1 know why this is refusing to work $charshout = mysql_query("SELECT * FROM cq_user WHERE (`account_id` LIKE '".$_SESSION."' )"); while ($user = mysql_fetch_assoc($charshout)) { $i = $i+1; $shoutpersonal = mysql_query("SELECT * FROM cq_ad_log WHERE (`user_name` LIKE '".$user."') ORDER BY publish_time ASC LIMIT 5"); }
[ERROR] Mysql can't connect to local Mysql server through socket
10/08/2011 - Metin2 Private Server - 3 Replies
Hallo Liebe Com, Undzwar habe ich ein Problem mit Mysql. Als ich Mysql installiert habe konnte ich Problemlos drauf connecten,auch mit navicat.Aber als ich die Serverfiles (2011er) installiert habe und rebootet habe ging aufeinmal mysql nichtmehr.Wenn ich mysql -p eingebe steht dann da: Wenn ich den Startbefehl eingebe steht da: Was kann das sein? Und es passiert immer nur nach der Serverfiles installation. Ich habe den Server schon 3x resetten lassen und es passierte immer das...
[ERROR] Mysql can't connect to local Mysql server through socket
11/06/2010 - Metin2 Private Server - 5 Replies
I just recently tried to configure a DNS server for MT2.. It came up with this error ERROR: 2002 (HY000): Can't connect to local Mysql server through socket '/tmp/mysql.sock' (2) Do I need to do a fresh installation of FBSD? :S Thanks.
Tables only read MySql Problem
10/28/2010 - Metin2 Private Server - 3 Replies
Joooo, Quote: Table 'player.item_proto' is read only Egal was ich da mach, die Fehlermeldung kommt 1x Alle Tables rausgenommen sql Backup eingespielt: Table 'player.item_proto' is read only Alles raus Myi/Myd Backup eingespielt: Table 'player.item_proto' is read only Alles raus, cleane Db, von Profifighter eingespielt:



All times are GMT +2. The time now is 21:16.


Powered by vBulletin®
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc.
This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

Support | Contact Us | FAQ | Advertising | Privacy Policy | Terms of Service | Abuse
Copyright ©2024 elitepvpers All Rights Reserved.