Register for your free account! | Forgot your password?

You last visited: Today at 02:33

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

Advertisement



SQL query failed?

Discussion on SQL query failed? within the Metin2 Private Server forum part of the Metin2 category.

Reply
 
Old   #1



 
Samael's Avatar
 
elite*gold: 17
Join Date: May 2014
Posts: 2,101
Received Thanks: 1,291
SQL query failed?

Quote:
SYSERR: Sep 29 20:39:05 :: ChildLoop: AsyncSQL: query failed: Out of range value for column 'y' at row 1 (query: INSERT DELAYED INTO log (type, time, who, x, y, what, how, hint, ip, vnum) VALUES('ITEM', NOW(), 0, 72, 4294967283, 30002934, 'SET_ATTR', '', '0.0.0.0', 299) errno: 1264)
SYSERR: Sep 29 20:39:06 :: ChildLoop: AsyncSQL: query failed: Out of range value for column 'y' at row 1 (query: INSERT DELAYED INTO log (type, time, who, x, y, what, how, hint, ip, vnum) VALUES('ITEM', NOW(), 1, 71, 4294967295, 30002934, 'SET_ATTR', '', '0.0.0.0', 299) errno: 1264)
SYSERR: Sep 29 20:39:06 :: ChildLoop: AsyncSQL: query failed: Out of range value for column 'y' at row 1 (query: INSERT DELAYED INTO log (type, time, who, x, y, what, how, hint, ip, vnum) VALUES('ITEM', NOW(), 1, 71, 4294967289, 30002934, 'SET_ATTR', '', '0.0.0.0', 299) errno: 1264)
SYSERR: Sep 29 20:39:07 :: ChildLoop: AsyncSQL: query failed: Out of range value for column 'y' at row 1 (query: INSERT DELAYED INTO log (type, time, who, x, y, what, how, hint, ip, vnum) VALUES('ITEM', NOW(), 0, 72, 4294967290, 30002934, 'SET_ATTR', '', '0.0.0.0', 299) errno: 1264)
SYSERR: Sep 29 20:39:08 :: ChildLoop: AsyncSQL: query failed: Out of range value for column 'y' at row 1 (query: INSERT DELAYED INTO log (type, time, who, x, y, what, how, hint, ip, vnum) VALUES('ITEM', NOW(), 1, 71, 4294967292, 30002934, 'SET_ATTR', '', '0.0.0.0', 299) errno: 1264)
SYSERR: Sep 29 20:39:09 :: ChildLoop: AsyncSQL: query failed: Out of range value for column 'y' at row 1 (query: INSERT DELAYED INTO log (type, time, who, x, y, what, how, hint, ip, vnum) VALUES('ITEM', NOW(), 0, 72, 4294967294, 30002934, 'SET_ATTR', '', '0.0.0.0', 299) errno: 1264)

Warum?... Ich könnte kotzen.. Hat jemand ne Lösung? Hab bereits auf 255 gestellt das max. aber ändert nichts..
Samael is offline  
Old 09/30/2014, 07:52   #2
 
elite*gold: 0
Join Date: Sep 2014
Posts: 10
Received Thanks: 1
Ist der Datentyp von y auch ein unsigned int oder unsigned long int (Max Wert 4'294'967'295)? Denn wenn nicht, dann handelt es sich wahrscheinlich um den Datentyp int bei dem der maximal Wert: 2'147'483'647 ist :P
Penk767 is offline  
Thanks
1 User
Reply

Tags
error, log, metin2, problem, query


Similar Threads Similar Threads
ChildLoop: AsyncSQL: query failed: Unknown column FIXX
08/29/2013 - Metin2 Private Server - 7 Replies
Heyho habe folgendes Problem, das meine ganze Syserr vollspamt. Über eine sinnvolle Antwort würde ich mich freuen und ihr euch über ein Thx wa ? :D SYSERR: Aug 29 15:22:35 :: ChildLoop: AsyncSQL: query failed: Unknown column 'ip' in 'field list' (query: INSERT DELAYED INTO log (type, time, who, x, y, what, how, hint, ip, vnum) VALUES('ITEM', NOW(), 2, 28785, 0, 10001712, 'SET_SOCKET', '', '', 71124) errno: 1054) Mir ist aufgefallen dass der Coden in Rot der Code für Weißen Löwen ist....
[HELP] query failed
08/30/2012 - Metin2 Private Server - 4 Replies
Hey @ all Ich habe folgenden Fehler in meiner Syserr gefunden: SYSERR: Aug 27 03:13:06 :: ChildLoop: AsyncSQL: query failed: DELAYED option not supported for table 'command_log' (query: INSERT DELAYED INTO command_log (userid, server, ip, port, username, command, date ) VALUES(57700, 999, 'xxx.xxx.xxx.xxx', 1, 'Coniesan', 'ma 101 20', NOW()) errno: 1616) Weiß eventuell jemand, wie man diesen Fehler weg bekommt??? Kind regards Coniesan
ChildLoop: AsyncSQL: query failed: Unknown column
05/29/2012 - Metin2 Private Server - 0 Replies
Hallo, wie fixxt man diesen error der DB? SYSERR: May 29 08:13:03 :: GetMoveMotionSpeed: cannot find motion (name GnomMinotaurus race 2604 mode 0) SYSERR: May 29 08:13:19 :: GetMoveMotionSpeed: cannot find motion (name GnomMinotaurus race 2604 mode 0) SYSERR: May 29 08:13:32 :: SpawnMob: SpawnMob: no mob data for vnum 10800 SYSERR: May 29 08:13:33 :: GetMoveMotionSpeed: cannot find motion (name GnomMinotaurus race 2604 mode 0)
[Suche]Query für "Alteklinge, Reichsklinge" &' Stichdolche NUR QUERY!
08/18/2010 - Metin2 Private Server - 1 Replies
Ich weiß ich werd nervig aber ich suche die Query's für Alteklinge, Reichsklinge &' Strichdolche Why? Naya, weil ich in der DB i-wie nur Drachenmaulglocke hab ... not more -.- Auf jeden Fall Icon's etc. etc. etc. hab ich ich brauche nur die Query's



All times are GMT +1. The time now is 02:33.


Powered by vBulletin®
Copyright ©2000 - 2025, 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 ©2025 elitepvpers All Rights Reserved.