You last visited: Today at 05:36
Advertisement
Mysql Problem
Discussion on Mysql Problem within the Metin2 Private Server forum part of the Metin2 category.
07/22/2012, 20:33
#1
elite*gold: 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
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
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
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.
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 05:37 .