Error Log!

kjy18

insertaste una qery etste una tabl mysql incorrecta a la version de tus files osea metiste qerys o tablas 2007 en files 2011

trata de implmentar qrys 2010

[http://foro.universojuegos.es/viewtopic.php?f=19&t=15027][0]">viewtopic.php?f=19&t=15027

[0]: <a href=

Shiki

Queria saber como solucionar este error.

SYSERR: Feb 1 02:01:48 :: 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(), 11568, 963527, 263918, 10058393, 'CHANGE_ATTRIBUTE', '150029957', 'xxx.xx.xxx.xxx', 71084) errno: 1054)
SYSERR: Feb 1 02:01:48 :: 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(), 0, 38, 18, 150010287, 'SET_ATTR', '', 'xxx.xx.xxx.xxx', 12529) errno: 1054)
SYSERR: Feb 1 02:01:48 :: 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, 10, 12, 150010287, 'SET_ATTR', '', xxx.xx.xxx.xxx', 12529) errno: 1054)

Me sale en el syserr y el syslog me sale repetidamente, hasta que al final e ch1 se cae.

¿Alguna solucion?

Shiki

Hice la guia pero la primera parte de poner

ALTER TABLE mob_proto
DROP COLUMN skill_level2
ALTER TABLE mob_proto
DROP COLUMN skill_vnum2
ALTER TABLE mob_proto
DROP COLUMN skill_level3
ALTER TABLE mob_proto
DROP COLUMN skill_vnum3
ALTER TABLE mob_proto
DROP COLUMN skill_level4
ALTER TABLE mob_proto
DROP COLUMN skill_vnum4

Me salta este error en el mysql

[SQL] ALTER TABLE mob_proto
DROP COLUMN skill_level2
ALTER TABLE mob_proto
DROP COLUMN skill_vnum2
ALTER TABLE mob_proto
DROP COLUMN skill_level3
ALTER TABLE mob_proto
DROP COLUMN skill_vnum3
ALTER TABLE mob_proto
DROP COLUMN skill_level4
ALTER TABLE mob_proto
DROP COLUMN skill_vnum4

[Err] 1064 - 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 'ALTER TABLE mob_proto
DROP COLUMN skill_vnum2
ALTER TABLE mob_proto
DROP COLU' at line 3

No puse eso primero pero ahora me lansa este otro error diferente

SYSERR: Feb 1 03:09:17 :: locale_find: LOCALE_ERROR: "¼Ó¼ºÀ» º¯°æÇÏ¿´½À´Ï´Ù.";
SYSERR: Feb 1 03:09:17 :: 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(), 0, 20, 6, 150010342, 'SET_ATTR', '', '', 14169) errno: 1054)
SYSERR: Feb 1 03:09:17 :: 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(), 1, 2, 1000, 150010342, 'SET_ATTR', '', '', 14169) errno: 1054)
SYSERR: Feb 1 03:09:17 :: 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, 25, 3