Mysql hiba! S.O.S.

Indította kicsiasdvagyok, 2017-08-15, 22:15:27

2017-08-15, 22:15:27 Utolsó szerkesztés: 2017-08-15, 23:38:44 Szerző: kicsiasdvagyok
Sziasztok!
Ezt miért írja,és hogyan tudnám javítani? Megköszönném a segítséget.
SYSERR: Aug 15 18:53:41.350236 :: 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, 10031097, 'SET_ATTR', '', 'IP', 10156) errno: 1264)
SYSERR: Aug 15 18:53:41.351451 :: 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, 10031095, 'SET_ATTR', '', 'IP', 10156) errno: 1264)
SYSERR: Aug 15 18:53:41.352471 :: 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, 4294967294, 10031096, 'SET_ATTR', '', 'IP', 10156) errno: 1264)
SYSERR: Aug 15 18:53:41.353558 :: 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, 4294967292, 10031103, 'SET_ATTR', '', 'IP', 10156) errno: 1264)
SYSERR: Aug 15 18:53:41.356935 :: 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, 10031094, 'SET_ATTR', '', 'IP', 10156) errno: 1264)
SYSERR: Aug 15 18:53:41.358152 :: 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, 4294967290, 10031100, 'SET_ATTR', '', 'IP', 10156) errno: 1264)
SYSERR: Aug 15 18:53:41.360389 :: 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, 4294967295, 10164089, 'SET_ATTR', '', 'IP', 10076) errno: 1264)
SYSERR: Aug 15 18:53:41.361782 :: 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, 4294967288, 10138388, 'SET_ATTR', '', 'IP', 10250) errno: 1264)
SYSERR: Aug 15 18:53:41.363985 :: 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, 4294967294, 10138386, 'SET_ATTR', '', 'IP', 10250) errno: 1264)
SYSERR: Aug 15 18:53:41.364314 :: 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, 4294967292, 10138381, 'SET_ATTR', '', 'IP', 10250) errno: 1264)
SYSERR: Aug 15 18:53:41.365336 :: 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, 4294967286, 10138533, 'SET_ATTR', '', 'IP', 10250) errno: 1264)
SYSERR: Aug 15 18:53:41.366354 :: 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, 4294967287, 10051349, 'SET_ATTR', '', 'IP', 12142) errno: 1264)
SYSERR: Aug 15 18:53:41.367919 :: 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, 4294967293, 10048473, 'SET_ATTR', '', 'IP', 12114) errno: 1264)
SYSERR: Aug 15 18:53:41.372298 :: 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, 4294967288, 10165078, 'SET_ATTR', '', 'IP', 12111) errno: 1264)
SYSERR: Aug 15 18:53:41.382698 :: number_ex: number(): first argument is bigger than second argument 5800 -> 0, char_skill.cpp 1040
SYSERR: Aug 15 18:53:41.382756 :: number_ex: number(): first argument is bigger than second argument 5800 -> 0, char_skill.cpp 1040


+ van egy olyan hibám, h eltünik a szint kezdéskor ha resizek, gondolom köze van hozzá. hogyan tudnám javítani?  Kérdéseket láttam ilyeneket de konkrét megoldást nem

2017-09-03, 10:56:59 #1 Utolsó szerkesztés: 2017-09-03, 11:11:37 Szerző: TrueLev
IdézOut of range value for column 'y'

https://translate.google.hu/#en/hu/out%20of%20range

[spoiler]Tehát az érték nem fér ki az oszlopba, navicat -> player jobb klikk design table, és az y oszlopot tedd bigint-re, hosszúságát meg pl 20-ra. Ajánlatos megtenni a x, illetve az exit_x, exit_y oszloppal.
Amúgy nagy koordin van a map szerintem, bár ha ezt megcsinálod lehet nem okoz több gondot.[/spoiler]