		elitepvpers > Popular Games > Metin2 > Metin2 Private Server
Mysql Problem

You last visited: Today at 19:21

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

Advertisement

Advertise with us!

Mysql Problem

Discussion on Mysql Problem within the Metin2 Private Server forum part of the Metin2 category.

07/22/2012, 20:33	#1
~~radsj1993~~ elite*gold: 0 The Black Market: 1/0/0 Join Date: Apr 2010 Posts: 185 Received Thanks: 7	Mysql Problem Hey Com. Ich habe gerade das hier genutzt um die aktuelle item_proto von .de zu beseitzen. Nun kann ich mich nicht mehr einloggen. Syserr von Channel 1 Spoiler SYSERR: Jul 22 16:51:49 :: hupsig: SIGHUP, SIGINT, SIGTERM signal has been received. shutting down. SYSERR: Jul 22 16:54:37 :: heart_idle: losing 32 seconds. (lag occured) SYSERR: Jul 22 17:10:16 :: ChildLoop: AsyncSQL: query failed: Unknown column 'vnum' in 'field list' (query: INSERT DELAYED INTO log (type, time, who, x, y, what, how, hint, ip, vnum) VALUES('ITEM', NOW(), 1, 0, 0, 10000017, 'SET_SOCKET', '', '', 72702) errno: 1054) SYSERR: Jul 22 17:10:30 :: RunState: LUA_ERROR: [string "devilscatacomb"]:8: attempt to perform arithmetic on field `dc_map_index' (a nil value) SYSERR: Jul 22 17:10:30 :: WriteRunningStateToSyserr: LUA_ERROR: quest devilscatacomb.start click SYSERR: Jul 22 17:10:59 :: GetMoveMotionSpeed: cannot find motion (name Blauer Tod race 1095 mode 0) SYSERR: Jul 22 17:10:59 :: GetMoveMotionSpeed: cannot find motion (name Blauer Tod race 1095 mode 0) SYSERR: Jul 22 17:10:59 :: GetMoveMotionSpeed: cannot find motion (name Blauer Tod race 1095 mode 0) SYSERR: Jul 22 17:10:59 :: GetMoveMotionSpeed: cannot find motion (name Blauer Tod race 1095 mode 0) SYSERR: Jul 22 17:10:59 :: GetMoveMotionSpeed: cannot find motion (name Blauer Tod race 1095 mode 0) SYSERR: Jul 22 17:10:59 :: GetMoveMotionSpeed: cannot find motion (name Blauer Tod race 1095 mode 0) SYSERR: Jul 22 17:10:59 :: GetMoveMotionSpeed: cannot find motion (name Blauer Tod race 1095 mode 0) SYSERR: Jul 22 17:10:59 :: GetMoveMotionSpeed: cannot find motion (name Blauer Tod race 1095 mode 0) SYSERR: Jul 22 17:10:59 :: GetMoveMotionSpeed: cannot find motion (name Blauer Tod race 1095 mode 0) SYSERR: Jul 22 17:10:59 :: GetMoveMotionSpeed: cannot find motion (name Blauer Tod race 1095 mode 0) SYSERR: Jul 22 17:10:59 :: GetMoveMotionSpeed: cannot find motion (name Blauer Tod race 1095 mode 0) SYSERR: Jul 22 17:10:59 :: GetMoveMotionSpeed: cannot find motion (name Blauer Tod race 1095 mode 0) SYSERR: Jul 22 17:10:59 :: GetMoveMotionSpeed: cannot find motion (name Blauer Tod race 1095 mode 0) SYSERR: Jul 22 17:10:59 :: GetMoveMotionSpeed: cannot find motion (name Blauer Tod race 1095 mode 0) SYSERR: Jul 22 17:10:59 :: GetMoveMotionSpeed: cannot find motion (name Blauer Tod race 1095 mode 0) SYSERR: Jul 22 17:10:59 :: GetMoveMotionSpeed: cannot find motion (name Blauer Tod race 1095 mode 0) SYSERR: Jul 22 17:10:59 :: GetMoveMotionSpeed: cannot find motion (name Blauer Tod race 1095 mode 0) SYSERR: Jul 22 17:10:59 :: GetMoveMotionSpeed: cannot find motion (name Blauer Tod race 1095 mode 0) SYSERR: Jul 22 17:11:00 :: GetMoveMotionSpeed: cannot find motion (name Blauer Tod race 1095 mode 0) SYSERR: Jul 22 17:11:00 :: GetMoveMotionSpeed: cannot find motion (name Blauer Tod race 1095 mode 0) SYSERR: Jul 22 17:11:00 :: GetMoveMotionSpeed: cannot find motion (name Blauer Tod race 1095 mode 0) SYSERR: Jul 22 17:11:07 :: ChildLoop: AsyncSQL: query failed: Unknown column 'vnum' in 'field list' (query: INSERT DELAYED INTO log (type, time, who, x, y, what, how, hint, ip, vnum) VALUES('ITEM', NOW(), 2, 2818, 0, 10000017, 'SET_SOCKET', '', '', 72702) errno: 1054) SYSERR: Jul 22 17:11:38 :: ChildLoop: AsyncSQL: query failed: Unknown column 'vnum' in 'field list' (query: INSERT DELAYED INTO log (type, time, who, x, y, what, how, hint, ip, vnum) VALUES('ITEM', NOW(), 1, 28, 0, 10000017, 'SET_SOCKET', '', '', 72702) errno: 1054) SYSERR: Jul 22 18:18:08 :: hupsig: SIGHUP, SIGINT, SIGTERM signal has been received. shutting down. SYSERR: Jul 22 18:21:48 :: ReadEtcDropItemFile: No such an item (name: Èò»ö ´ó±â+) SYSERR: Jul 22 18:21:48 :: Boot: cannot load ETCDropItem: locale/germany/etc_drop_item.txt SYSERR: Jul 22 18:28:31 :: ReadEtcDropItemFile: No such an item (name: Èò»ö ´ó±â+) SYSERR: Jul 22 18:28:31 :: Boot: cannot load ETCDropItem: locale/germany/etc_drop_item.txt SYSERR: Jul 22 18:33:43 :: ReadEtcDropItemFile: No such an item (name: Èò»ö ´ó±â+) SYSERR: Jul 22 18:33:43 :: Boot: cannot load ETCDropItem: locale/germany/etc_drop_item.txt SYSERR: Jul 22 18:59:17 :: regen_load: No mob data by vnum 8030 SYSERR: Jul 22 18:59:17 :: SpawnMob: SpawnMob: no mob data for vnum 8030 SYSERR: Jul 22 18:59:17 :: regen_load: No mob data by vnum 8030 SYSERR: Jul 22 18:59:17 :: SpawnMob: SpawnMob: no mob data for vnum 8030 SYSERR: Jul 22 19:00:49 :: heart_idle: losing 31 seconds. (lag occured) SYSERR: Jul 22 19:06:24 :: hupsig: SIGHUP, SIGINT, SIGTERM signal has been received. shutting down. SYSERR: Jul 22 19:06:40 :: hupsig: SIGHUP, SIGINT, SIGTERM signal has been received. shutting down. SYSERR: Jul 22 19:17:31 :: ReadEtcDropItemFile: No such an item (name: Èò»ö ´ó±â+) SYSERR: Jul 22 19:17:31 :: Boot: cannot load ETCDropItem: locale/germany/etc_drop_item.txt SYSERR: Jul 22 19:21:29 :: ReadEtcDropItemFile: No such an item (name: Èò»ö ´ó±â+) SYSERR: Jul 22 19:21:29 :: Boot: cannot load ETCDropItem: locale/germany/etc_drop_item.txt SYSERR: Jul 22 19:35:15 :: socket_connect: HOST localhost:15000, could not connect. SYSERR: Jul 22 19:35:15 :: heart_idle: losing 75 seconds. (lag occured) SYSERR: Jul 22 19:36:30 :: socket_connect: HOST localhost:15000, could not connect. SYSERR: Jul 22 19:36:30 :: heart_idle: losing 75 seconds. (lag occured) SYSERR: Jul 22 19:37:45 :: socket_connect: HOST localhost:15000, could not connect. SYSERR: Jul 22 19:37:45 :: heart_idle: losing 75 seconds. (lag occured) SYSERR: Jul 22 19:39:00 :: socket_connect: HOST localhost:15000, could not connect. SYSERR: Jul 22 19:39:00 :: heart_idle: losing 75 seconds. (lag occured) SYSERR: Jul 22 19:40:15 :: socket_connect: HOST localhost:15000, could not connect. SYSERR: Jul 22 19:40:15 :: heart_idle: losing 75 seconds. (lag occured) SYSERR: Jul 22 19:41:30 :: socket_connect: HOST localhost:15000, could not connect. SYSERR: Jul 22 19:41:30 :: heart_idle: losing 75 seconds. (lag occured) SYSERR: Jul 22 19:42:45 :: socket_connect: HOST localhost:15000, could not connect. SYSERR: Jul 22 19:42:45 :: heart_idle: losing 75 seconds. (lag occured) SYSERR: Jul 22 19:44:00 :: socket_connect: HOST localhost:15000, could not connect. SYSERR: Jul 22 19:44:00 :: heart_idle: losing 75 seconds. (lag occured) SYSERR: Jul 22 19:45:15 :: socket_connect: HOST localhost:15000, could not connect. SYSERR: Jul 22 19:45:15 :: heart_idle: losing 75 seconds. (lag occured) SYSERR: Jul 22 19:46:30 :: socket_connect: HOST localhost:15000, could not connect. SYSERR: Jul 22 19:46:30 :: heart_idle: losing 75 seconds. (lag occured) SYSERR: Jul 22 19:47:45 :: socket_connect: HOST localhost:15000, could not connect. SYSERR: Jul 22 19:47:45 :: heart_idle: losing 75 seconds. (lag occured) SYSERR: Jul 22 19:49:00 :: socket_connect: HOST localhost:15000, could not connect. SYSERR: Jul 22 19:49:00 :: heart_idle: losing 75 seconds. (lag occured) SYSERR: Jul 22 19:50:15 :: socket_connect: HOST localhost:15000, could not connect. SYSERR: Jul 22 19:50:15 :: heart_idle: losing 75 seconds. (lag occured) SYSERR: Jul 22 19:51:30 :: socket_connect: HOST localhost:15000, could not connect. SYSERR: Jul 22 19:51:31 :: heart_idle: losing 75 seconds. (lag occured) SYSERR: Jul 22 19:52:46 :: socket_connect: HOST localhost:15000, could not connect. SYSERR: Jul 22 19:52:46 :: heart_idle: losing 75 seconds. (lag occured) SYSERR: Jul 22 19:54:01 :: socket_connect: HOST localhost:15000, could not connect. SYSERR: Jul 22 19:54:01 :: heart_idle: losing 75 seconds. (lag occured) SYSERR: Jul 22 19:55:16 :: socket_connect: HOST localhost:15000, could not connect. SYSERR: Jul 22 19:55:16 :: heart_idle: losing 75 seconds. (lag occured) SYSERR: Jul 22 19:56:31 :: socket_connect: HOST localhost:15000, could not connect. SYSERR: Jul 22 19:56:31 :: heart_idle: losing 75 seconds. (lag occured) SYSERR: Jul 22 19:57:46 :: socket_connect: HOST localhost:15000, could not connect. SYSERR: Jul 22 19:57:46 :: heart_idle: losing 75 seconds. (lag occured) SYSERR: Jul 22 19:59:01 :: socket_connect: HOST localhost:15000, could not connect. SYSERR: Jul 22 19:59:01 :: heart_idle: losing 75 seconds. (lag occured) SYSERR: Jul 22 20:00:16 :: socket_connect: HOST localhost:15000, could not connect. SYSERR: Jul 22 20:00:16 :: heart_idle: losing 75 seconds. (lag occured) SYSERR: Jul 22 20:01:31 :: socket_connect: HOST localhost:15000, could not connect. SYSERR: Jul 22 20:01:31 :: heart_idle: losing 75 seconds. (lag occured) SYSERR: Jul 22 20:02:46 :: socket_connect: HOST localhost:15000, could not connect. SYSERR: Jul 22 20:02:46 :: heart_idle: losing 75 seconds. (lag occured) SYSERR: Jul 22 20:04:01 :: socket_connect: HOST localhost:15000, could not connect. SYSERR: Jul 22 20:04:01 :: heart_idle: losing 75 seconds. (lag occured) SYSERR: Jul 22 20:05:16 :: socket_connect: HOST localhost:15000, could not connect. SYSERR: Jul 22 20:05:16 :: heart_idle: losing 75 seconds. (lag occured) SYSERR: Jul 22 20:06:31 :: socket_connect: HOST localhost:15000, could not connect. SYSERR: Jul 22 20:06:31 :: heart_idle: losing 75 seconds. (lag occured) SYSERR: Jul 22 20:07:46 :: socket_connect: HOST localhost:15000, could not connect. SYSERR: Jul 22 20:07:46 :: heart_idle: losing 75 seconds. (lag occured) SYSERR: Jul 22 20:09:01 :: socket_connect: HOST localhost:15000, could not connect. SYSERR: Jul 22 20:09:01 :: heart_idle: losing 75 seconds. (lag occured) SYSERR: Jul 22 20:10:16 :: socket_connect: HOST localhost:15000, could not connect. SYSERR: Jul 22 20:10:16 :: heart_idle: losing 75 seconds. (lag occured) SYSERR: Jul 22 20:11:31 :: socket_connect: HOST localhost:15000, could not connect. SYSERR: Jul 22 20:11:31 :: heart_idle: losing 75 seconds. (lag occured) SYSERR: Jul 22 20:12:46 :: socket_connect: HOST localhost:15000, could not connect. SYSERR: Jul 22 20:12:46 :: heart_idle: losing 75 seconds. (lag occured) SYSERR: Jul 22 20:14:01 :: socket_connect: HOST localhost:15000, could not connect. SYSERR: Jul 22 20:14:01 :: heart_idle: losing 75 seconds. (lag occured) SYSERR: Jul 22 20:15:16 :: socket_connect: HOST localhost:15000, could not connect. SYSERR: Jul 22 20:15:16 :: heart_idle: losing 75 seconds. (lag occured) SYSERR: Jul 22 20:16:31 :: socket_connect: HOST localhost:15000, could not connect. SYSERR: Jul 22 20:16:31 :: heart_idle: losing 75 seconds. (lag occured) SYSERR: Jul 22 20:17:46 :: socket_connect: HOST localhost:15000, could not connect. SYSERR: Jul 22 20:17:46 :: heart_idle: losing 75 seconds. (lag occured) SYSERR: Jul 22 20:19:01 :: socket_connect: HOST localhost:15000, could not connect. SYSERR: Jul 22 20:19:01 :: heart_idle: losing 75 seconds. (lag occured) SYSERR: Jul 22 20:20:16 :: socket_connect: HOST localhost:15000, could not connect. SYSERR: Jul 22 20:20:16 :: heart_idle: losing 75 seconds. (lag occured) SYSERR: Jul 22 20:21:31 :: socket_connect: HOST localhost:15000, could not connect. SYSERR: Jul 22 20:21:31 :: heart_idle: losing 75 seconds. (lag occured) SYSERR: Jul 22 20:22:46 :: socket_connect: HOST localhost:15000, could not connect. SYSERR: Jul 22 20:22:47 :: heart_idle: losing 75 seconds. (lag occured) SYSERR: Jul 22 20:24:02 :: socket_connect: HOST localhost:15000, could not connect. SYSERR: Jul 22 20:24:02 :: heart_idle: losing 75 seconds. (lag occured) SYSERR: Jul 22 20:25:17 :: socket_connect: HOST localhost:15000, could not connect. SYSERR: Jul 22 20:25:17 :: heart_idle: losing 75 seconds. (lag occured) SYSERR: Jul 22 20:26:32 :: socket_connect: HOST localhost:15000, could not connect. SYSERR: Jul 22 20:26:32 :: heart_idle: losing 75 seconds. (lag occured) SYSERR: Jul 22 20:27:47 :: socket_connect: HOST localhost:15000, could not connect. SYSERR: Jul 22 20:27:47 :: heart_idle: losing 75 seconds. (lag occured) SYSERR: Jul 22 20:29:02 :: socket_connect: HOST localhost:15000, could not connect. SYSERR: Jul 22 20:29:02 :: heart_idle: losing 75 seconds. (lag occured) SYSERR: Jul 22 20:30:17 :: socket_connect: HOST localhost:15000, could not connect. SYSERR: Jul 22 20:30:17 :: heart_idle: losing 75 seconds. (lag occured) Auth Spoiler SYSERR: Jul 22 18:33:43 :: SetBilling: cannot find login key 0 SYSERR: Jul 22 18:34:59 :: heart_idle: losing 31 seconds. (lag occured) SYSERR: Jul 22 18:56:04 :: hupsig: SIGHUP, SIGINT, SIGTERM signal has been received. shutting down. SYSERR: Jul 22 19:00:49 :: heart_idle: losing 31 seconds. (lag occured) SYSERR: Jul 22 19:06:22 :: hupsig: SIGHUP, SIGINT, SIGTERM signal has been received. shutting down. SYSERR: Jul 22 19:06:40 :: hupsig: SIGHUP, SIGINT, SIGTERM signal has been received. shutting down. SYSERR: Jul 22 19:17:32 :: SetBilling: cannot find login key 0 SYSERR: Jul 22 19:18:40 :: hupsig: SIGHUP, SIGINT, SIGTERM signal has been received. shutting down. SYSERR: Jul 22 19:19:54 :: socket_connect: HOST localhost:15000, could not connect. SYSERR: Jul 22 19:19:54 :: socket_block: fcntl: nonblock: Bad file descriptor SYSERR: Jul 22 19:21:30 :: SetBilling: cannot find login key 0 SYSERR: Jul 22 19:23:19 :: heart_idle: losing 31 seconds. (lag occured) SYSERR: Jul 22 19:33:43 :: hupsig: SIGHUP, SIGINT, SIGTERM signal has been received. shutting down. SYSERR: Jul 22 19:33:58 :: socket_bind: bind: Address already in use SYSERR: Jul 22 19:34:58 :: socket_connect: HOST localhost:15000, could not connect. SYSERR: Jul 22 19:34:58 :: socket_block: fcntl: nonblock: Bad file descriptor db Spoiler SYSERR: Jul 22 19:33:56 :: Start: TABLE_POSTFIX not configured use default SYSERR: Jul 22 19:33:56 :: DirectQuery: AsyncSQL:irectQuery : mysql_query error: Table './player/shop_item' is marked as crashed and last (automatic?) repair failed query: SELECT shop.vnum, shop.npc_vnum, shop_item.item_vnum, shop_item.count FROM shop LEFT JOIN shop_item ON shop.vnum = shop_item.shop_vnum ORDER BY shop.vnum, shop_item.item_vnum SYSERR: Jul 22 19:33:56 :: InitializeShopTable: InitializeShopTable : Table count is zero. SYSERR: Jul 22 19:33:56 :: InitializeTables: InitializeShopTable FAILED SYSERR: Jul 22 19:33:56 :: Initialize: Table Initialize FAILED Ich hoffe ihr könnt mir helfen.

« Meinugen gesucht! | Welche Files und welcher Client? »

Similar Threads
php mysql problem 04/25/2012 - Web Development - 8 Replies Hallo, ich habe ein kleines problem mit mysql. Ich möchte aus einer Datenbank von einem benutzernamen die id bekommen danach mit der id in einer anderen tabelle alle einträge auslesen und in einer zahl darstellen lassen doch leider kommt immer der fehler: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '-players WHERE playername=SuGGl LIMIT 1' at line 1 Hier ist der Code: <?php $user = $_SESSION;...
[PROBLEM]:[Root]:Mysql:[...]/tmp/mysql.sock 10/22/2011 - Metin2 Private Server - 3 Replies Hallo Community habe jetzt seit ein Paar Tagen einen Fehler Namens: failed, retrying in 5 secondsmysql_real_connect: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) Screen: http://img809.imageshack.us/img809/9805/helpg.png
[PHP/Mysql] Connection Problem/ OR problem 08/19/2011 - Web Development - 6 Replies Hey Epvpianer (:D) Ich habe mich entschlossen php zu lernen und bin jetzt bei dem Teil ->Mysql<- angekommen. Ich versuch jetzt eine Verbindung auf zu bauen und wenn es nicht klappt soll einer Fehler Meldung kommen. So sieht mein Code aus: <?php $verbindung = mysql_connect("localhost","Ecstasy_ x3","12345"); OR die ("Die Verbindung konnte nicht hergestellt werden"); mysql_select_db("links"); or die ("Falscher Datenbankname");
MySQL-Problem 07/13/2011 - Metin2 Private Server - 2 Replies Hi Leute Habe ein mächtiges Server problem. Und zwar: Bin gerade am MySQL installieren gewesen auf meinem Root, dann kam ne Warnung : Warning the Temperature is to high /65C. oder sowas. Habe Root auseinander genommen gekuckt ob alle Lüftungen laufen , alle laufen. Habe auch Motherboard angefasst um zu schauen ob es wirklick so ne Temperatur hat, nee hat es nicht ist noch ganz kalt. :confused: Wäre Froh um schnelle Antwort :) thx <3
Mysql Problem 05/26/2010 - Metin2 Private Server - 0 Replies Hallo eine frage was kann man dagegen machen das der mysql server nicht immer down fährt login is nun behoben aber nun schaltet mysql immer down das war schon seit anfang an so ??? MFG

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

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