PROBLEMĂ TIMP ÎNAPOI CARACTERE

anghel14 · 14 Dec 2020, 07:21

*Problemă/Întrebare:Salutare, întâmpin următoarea problemă: Timpul se dă înapoi la unele caractere, nu la toate. Practic dacă un jucător are 75, face 80, iese pentru 10 minute, îl dă 75 înapoi și în același loc de unde a pornit.
Tipologie server:-
*Resursă folosită:-
*ServerFiles utilizat:-
*Syserr:

Cod: Selectaţi tot

YSERR: Dec 14 01:11:39 :: 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, 550012198, 'SET_ATTR', '', '109.166.138.62', 180) errno: 1264)
SYSERR: Dec 14 01:11:39 :: ChildLoop: AsyncSQL: query failed: Data too long for column 'hint' at row 1 (query: INSERT DELAYED INTO log (type, time, who, x, y, what, how, hint, ip, vnum) VALUES('ITEM', NOW(), 3004, 958682, 268705, 8594, 'USE_ITEM', 'Vrajeste Obiectul 103', '91.228.37.49', 71084) errno: 1406)
SYSERR: Dec 14 01:11:39 :: ChildLoop: AsyncSQL: query failed: Data too long for column 'hint' at row 1 (query: INSERT DELAYED INTO log (type, time, who, x, y, what, how, hint, ip, vnum) VALUES('ITEM', NOW(), 3004, 958682, 268705, 8594, 'USE_ITEM', 'Vrajeste Obiectul 102', '91.228.37.49', 71084) errno: 1406)
SYSERR: Dec 14 01:11:40 :: ChildLoop: AsyncSQL: query failed: Data too long for column 'hint' at row 1 (query: INSERT DELAYED INTO log (type, time, who, x, y, what, how, hint, ip) VALUES('CHARACTER', NOW(), 3000, 958159, 268999, 0, 'LOGOUT', '82.77.94.198 1286402364 1 41 34724', '82.77.94.198') errno: 1406)
SYSERR: Dec 14 01:11:40 :: 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, 550011999, 'SET_ATTR', '', '109.166.138.62', 180) errno: 1264)
SYSERR: Dec 14 01:11:40 :: 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, 550012198, 'SET_ATTR', '', '109.166.138.62', 180) errno: 1264)
SYSERR: Dec 14 01:11:40 :: ChildLoop: AsyncSQL: query failed: Data too long for column 'hint' at row 1 (query: INSERT DELAYED INTO log (type, time, who, x, y, what, how, hint, ip, vnum) VALUES('ITEM', NOW(), 3004, 958682, 268705, 8594, 'USE_ITEM', 'Vrajeste Obiectul 101', '91.228.37.49', 71084) errno: 1406)
SYSERR: Dec 14 01:11:40 :: ChildLoop: AsyncSQL: query failed: Data too long for column 'hint' at row 1 (query: INSERT DELAYED INTO log (type, time, who, x, y, what, how, hint, ip, vnum) VALUES('ITEM', NOW(), 3004, 958682, 268705, 8594, 'USE_ITEM', 'Vrajeste Obiectul 100', '91.228.37.49', 71084) errno: 1406)
SYSERR: Dec 14 01:11:40 :: 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, 4294967291, 550012198, 'SET_ATTR', '', '109.166.138.62', 180) errno: 1264)
SYSERR: Dec 14 01:11:40 :: 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, 4294967293, 550010822, 'SET_ATTR', '', '109.166.138.62', 3169) errno: 1264)
SYSERR: Dec 14 01:11:41 :: 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, 550011999, 'SET_ATTR', '', '109.166.138.62', 180) errno: 1264)
SYSERR: Dec 14 01:11:41 :: 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, 4294967291, 550012198, 'SET_ATTR', '', '109.166.138.62', 180) errno: 1264)
SYSERR: Dec 14 01:11:41 :: 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, 550010822, 'SET_ATTR', '', '109.166.138.62', 3169) errno: 1264)
SYSERR: Dec 14 01:11:41 :: 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, 550011999, 'SET_ATTR', '', '109.166.138.62', 180) errno: 1264)
SYSERR: Dec 14 01:11:41 :: 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, 4294967293, 550010822, 'SET_ATTR', '', '109.166.138.62', 3169) errno: 1264)
SYSERR: Dec 14 01:11:41 :: 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, 550011999, 'SET_ATTR', '', '109.166.138.62', 180) errno: 1264)
SYSERR: Dec 14 01:11:42 :: 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, 550011999, 'SET_ATTR', '', '109.166.138.62', 180) errno: 1264)
SYSERR: Dec 14 01:11:42 :: ChildLoop: AsyncSQL: query failed: Data too long for column 'hint' at row 1 (query: INSERT DELAYED INTO log (type, time, who, x, y, what, how, hint, ip) VALUES('CHARACTER', NOW(), 3004, 958682, 268705, 0, 'LOGOUT', '91.228.37.49 1971091679 1 41 102689', '91.228.37.49') errno: 1406)
SYSERR: Dec 14 01:11:42 :: 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, 550011999, 'SET_ATTR', '', '109.166.138.62', 180) errno: 1264)
SYSERR: Dec 14 01:11:43 :: Process: SEQUENCE 389f6180 mismatch 0xaf != 0x64 header 254
SYSERR: Dec 14 01:11:43 :: Process: SEQUENCE_LOG [UNKNOWN]-------------
	[254 : 0xaf]

Poză:
*Detalii suplimentare: Se repetă aceeași eroare în tot sysseru.

Petrinel · 14 Dec 2020, 07:29

log navicat - Design Table -> Dai UTF-8 la hint. incearca asa sau sa fie pe varchar si la length sa aiba 20
sau la hint in loc de 20 incearca sa ii pui 40 sau 50.
si la coloana "y" dai la length 11 si sa fie pe int

Process: SEQUENCE 389f6180 mismatch 0xaf != 0x64 header 254 pentru asta:
sursa/dnd-fix-process-sequence-0x64-hea ... 67438.html

anghel14 · 14 Dec 2020, 07:36

La toate tabelele din log?

Petrinel · 14 Dec 2020, 07:37

anghel14 scrie: ↑14 Dec 2020, 07:36 La toate tabelele din log?

doar la log din tabela log.

anghel14 · 14 Dec 2020, 07:48

Ok, și să înțeleg că una din astea două o să rezolve problema pe care am menționat-o mai sus?

Petrinel · 14 Dec 2020, 07:50

anghel14 scrie: ↑14 Dec 2020, 07:48 Ok, și să înțeleg că una din astea două o să rezolve problema pe care am menționat-o mai sus?

Eu zic ca da, oricum am m-ai editat editat acolo la mine si ti-am mai pus niste variante , ar trebuie sa reusesti, revino cu edit.

anghel14 · 14 Dec 2020, 08:49

same sh1t..

Hunger · 14 Dec 2020, 09:10

Pune hint ca varbinary si length 80.

anghel14 · 14 Dec 2020, 09:37

Tot nu merge, acum e la toate caracterele..

Hunger · 14 Dec 2020, 09:47

anghel14 scrie: ↑14 Dec 2020, 09:37 Tot nu merge, acum e la toate caracterele..

Pune log

[ Postat de pe iPhone ] Imagine

PROBLEMĂ TIMP ÎNAPOI CARACTERE

Problemă: Se dă timpul înapoi.

problema cand merg ma da inapoi cu cativa metri

problema cand merg ma da inapoi cu cativa metri.

problema caractere

Cine este conectat