"No me deja crear un pj"

[Migxelito]

Eh buscado en varios foros este error el cual lo encuentro raro y nunca me habia pasado, vi varias soluciones como por ejemplo:

reparar las tablas y luego optimizarlas tanto las de player como las de account, tambien fui a design table de player y borre 3 field que decian borrar "facebook y 2 con nombres extraños". 

Otras dicen borrar banword "esa igual la hice", pero ninguna dio resultado, en sysser no me muestra nada extraño y ya la verdad nose que mas hacer. 

Si alguien me puede ayudar se los agradeceria. 

Gracias de antemano.

[TuMAMAmEToca]

Que error te da en sysser

[Migxelito]

hace 2 horas, RobertSV dijo:

Que error te da en sysser

SYSERR: Jul 14 08:12:31 :: ChildLoop: AsyncSQL::ChildLoop : mysql_query error: Out of range value for column 'time' at row 1:
query: INSERT INTO bootlog (time, hostname, channel) VALUES(NOW(), 'core1', 1)

eso me sale en ch1

[Break]

hace 2 horas, Migxelito dijo:

SYSERR: Jul 14 08:12:31 :: ChildLoop: AsyncSQL::ChildLoop : mysql_query error: Out of range value for column 'time' at row 1:
query: INSERT INTO bootlog (time, hostname, channel) VALUES(NOW(), 'core1', 1)

eso me sale en ch1

Ese error no es el motivo de que no te deje registrar pjs.

 

Registra un pj, y mira el sysser de la db.

 

Un saludo

[Migxelito]

hace 17 minutos, Break dijo:

Ese error no es el motivo de que no te deje registrar pjs.

 

Registra un pj, y mira el sysser de la db.

 

Un saludo

En la db me tira error de mob proto te lo mando al tiro.

Quote

SYSERR: Jul 14 11:11:58 :: ChildLoop: AsyncSQL: query failed: Field 'resist_claw' doesn't have a default value (query: replace into mob_proto  (vnum, name, locale_name, type, rank, battle_type, level, size, ai_flag, setRaceFlag, setImmuneFlag, on_click, empire, drop_item, resurrection_vnum, folder, st, dx, ht, iq, damage_min, damage_max, max_hp, regen_cycle, regen_percent, exp, gold_min, gold_max, def, attack_speed, move_speed, aggressive_hp_pct, aggressive_sight, attack_range, polymorph_item, enchant_curse, enchant_slow, enchant_poison, enchant_stun, enchant_critical, enchant_penetrate, resist_sword, resist_twohand, resist_dagger, resist_bell, resist_fan, resist_bow, resist_fire, resist_elect, resist_magic, resist_wind, resist_poison, dam_multiply, summon, drain_sp, skill_vnum0, skill_level0, skill_vnum1, skill_level1, skill_vnum2, skill_level2, skill_vnum3, skill_level3, skill_vnum4, skill_level4, sp_berserk, sp_stoneskin, sp_godspeed, sp_deathblow, sp_revive) values (34114, "ÇÒ·ÎÀ©°­½Ã(¹«¼Ó¼º)", "Genç Jia
SYSERR: Jul 14 11:11:58 :: ChildLoop: AsyncSQL: query failed: Field 'resist_claw' doesn't have a default value (query: replace into mob_proto  (vnum, name, locale_name, type, rank, battle_type, level, size, ai_flag, setRaceFlag, setImmuneFlag, on_click, empire, drop_item, resurrection_vnum, folder, st, dx, ht, iq, damage_min, damage_max, max_hp, regen_cycle, regen_percent, exp, gold_min, gold_max, def, attack_speed, move_speed, aggressive_hp_pct, aggressive_sight, attack_range, polymorph_item, enchant_curse, enchant_slow, enchant_poison, enchant_stun, enchant_critical, enchant_penetrate, resist_sword, resist_twohand, resist_dagger, resist_bell, resist_fan, resist_bow, resist_fire, resist_elect, resist_magic, resist_wind, resist_poison, dam_multiply, summon, drain_sp, skill_vnum0, skill_level0, skill_vnum1, skill_level1, skill_vnum2, skill_level2, skill_vnum3, skill_level3, skill_vnum4, skill_level4, sp_berserk, sp_stoneskin, sp_godspeed, sp_deathblow, sp_revive) values (34115, "°íºí¸°1", "Kýrmýzý Elf", 1, 5,
SYSERR: Jul 14 11:11:58 :: ChildLoop: AsyncSQL: query failed: Field 'resist_claw' doesn't have a default value (query: replace into mob_proto  (vnum, name, locale_name, type, rank, battle_type, level, size, ai_flag, setRaceFlag, setImmuneFlag, on_click, empire, drop_item, resurrection_vnum, folder, st, dx, ht, iq, damage_min, damage_max, max_hp, regen_cycle, regen_percent, exp, gold_min, gold_max, def, attack_speed, move_speed, aggressive_hp_pct, aggressive_sight, attack_range, polymorph_item, enchant_curse, enchant_slow, enchant_poison, enchant_stun, enchant_critical, enchant_penetrate, resist_sword, resist_twohand, resist_dagger, resist_bell, resist_fan, resist_bow, resist_fire, resist_elect, resist_magic, resist_wind, resist_poison, dam_multiply, summon, drain_sp, skill_vnum0, skill_level0, skill_vnum1, skill_level1, skill_vnum2, skill_level2, skill_vnum3, skill_level3, skill_vnum4, skill_level4, sp_berserk, sp_stoneskin, sp_godspeed, sp_deathblow, sp_revive) values (34116, "°íºí¸°2", "Yeþil Elf", 1, 5, 0
SYSERR: Jul 14 11:11:58 :: ChildLoop: AsyncSQL: query failed: Field 'resist_claw' doesn't have a default value (query: replace into mob_proto  (vnum, name, locale_name, type, rank, battle_type, level, size, ai_flag, setRaceFlag, setImmuneFlag, on_click, empire, drop_item, resurrection_vnum, folder, st, dx, ht, iq, damage_min, damage_max, max_hp, regen_cycle, regen_percent, exp, gold_min, gold_max, def, attack_speed, move_speed, aggressive_hp_pct, aggressive_sight, attack_range, polymorph_item, enchant_curse, enchant_slow, enchant_poison, enchant_stun, enchant_critical, enchant_penetrate, resist_sword, resist_twohand, resist_dagger, resist_bell, resist_fan, resist_bow, resist_fire, resist_elect, resist_magic, resist_wind, resist_poison, dam_multiply, summon, drain_sp, skill_vnum0, skill_level0, skill_vnum1, skill_level1, skill_vnum2, skill_level2, skill_vnum3, skill_level3, skill_vnum4, skill_level4, sp_berserk, sp_stoneskin, sp_godspeed, sp_deathblow, sp_revive) values (34117, "°íºí¸°(¹«¼Ó¼º)", "Kýrmýzý Elf"
SYSERR: Jul 14 11:11:58 :: ChildLoop: AsyncSQL: query failed: Field 'resist_claw' doesn't have a default value (query: replace into mob_proto  (vnum, name, locale_name, type, rank, battle_type, level, size, ai_flag, setRaceFlag, setImmuneFlag, on_click, empire, drop_item, resurrection_vnum, folder, st, dx, ht, iq, damage_min, damage_max, max_hp, regen_cycle, regen_percent, exp, gold_min, gold_max, def, attack_speed, move_speed, aggressive_hp_pct, aggressive_sight, attack_range, polymorph_item, enchant_curse, enchant_slow, enchant_poison, enchant_stun, enchant_critical, enchant_penetrate, resist_sword, resist_twohand, resist_dagger, resist_bell, resist_fan, resist_bow, resist_fire, resist_elect, resist_magic, resist_wind, resist_poison, dam_multiply, summon, drain_sp, skill_vnum0, skill_level0, skill_vnum1, skill_level1, skill_vnum2, skill_level2, skill_vnum3, skill_level3, skill_vnum4, skill_level4, sp_berserk, sp_stoneskin, sp_godspeed, sp_deathblow, sp_revive) values (34118, "ºÎÈ°ÀýÅä³¢(W)", "Donni", 1, 5,
SYSERR: Jul 14 11:11:58 :: ChildLoop: AsyncSQL: query failed: Field 'resist_claw' doesn't have a default value (query: replace into mob_proto  (vnum, name, locale_name, type, rank, battle_type, level, size, ai_flag, setRaceFlag, setImmuneFlag, on_click, empire, drop_item, resurrection_vnum, folder, st, dx, ht, iq, damage_min, damage_max, max_hp, regen_cycle, regen_percent, exp, gold_min, gold_max, def, attack_speed, move_speed, aggressive_hp_pct, aggressive_sight, attack_range, polymorph_item, enchant_curse, enchant_slow, enchant_poison, enchant_stun, enchant_critical, enchant_penetrate, resist_sword, resist_twohand, resist_dagger, resist_bell, resist_fan, resist_bow, resist_fire, resist_elect, resist_magic, resist_wind, resist_poison, dam_multiply, summon, drain_sp, skill_vnum0, skill_level0, skill_vnum1, skill_level1, skill_vnum2, skill_level2, skill_vnum3, skill_level3, skill_vnum4, skill_level4, sp_berserk, sp_stoneskin, sp_godspeed, sp_deathblow, sp_revive) values (34119, "ºÎÈ°ÀýÅä³¢(G)", "Frank", 1, 5,
SYSERR: Jul 14 11:11:58 :: socket_bind: bind: Address already in use
SYSERR: Jul 14 11:11:58 :: pid_deinit: 
End of pid

 

[Dilong]

Haz lo mismo lo del default value con el mob proto

[Migxelito]

hace 1 hora, Dilong dijo:

Haz lo mismo lo del default value con el mob proto

Si bro gracias al fin pude eliminar todo del mob proto en el sysser y asi poder ver al fin el error que se genera al crear pj mira:

Quote

SYSERR: Jul 14 14:28:23 :: DirectQuery: AsyncSQL::DirectQuery : mysql_query error: Data too long for column 'quickslot' at row 1
query: INSERT INTO player  (id, account_id, name, level, st, ht, dx, iq, job, voice, dir, x, y, z, hp, mp, random_hp, random_sp, stat_point, stamina, part_base, part_main, part_hair, part_acce, gold, cheque, playtime, skill_level, quickslot, newquickslot) VALUES(0, 63376, '4641', 1, 5, 3, 3, 5, 6, 0, 0, 957128, 255002, 0, 770, 300,0, 0, 0, 800, 0, 0, 0, 0, 0, 0, 675637920, 0, '\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0
SYSERR: Jul 14 14:28:23 :: __QUERY_PLAYER_CREATE: QUERY_ERROR: UPDATE player_index  SET pid1=0 WHERE id=63376
 

Sabrias que puede ser?

[Dilong]

Cambia el tipo de quickslot a tinyblob o bigint

[Break]

hace 23 horas, Dilong dijo:

Cambia el tipo de quickslot a tinyblob o bigint

No le puedes cambiar el tipo de una celda, ya que no es lo mismo almacenar un string, que un char. (Es un ejemplo)

La solución es cambiar la extensión de la celda, ya que el error le decía, que el dato era demasiado grande para almacenarse en la celda, por lo que, en vez de poner tinyblob, es poner MEDIUMBLOB, que es mas extenso.

PD: Se lo he solucionado por anydesk.

 

Un saludo.

[Migxelito]

hace 1 minuto, Break dijo:

No le puedes cambiar el tipo de una celda, ya que no es lo mismo almacenar un string, que un char. (Es un ejemplo)

La solución es cambiar la extensión de la celda, ya que el error le decía, que el dato era demasiado grande para almacenarse en la celda, por lo que, en vez de poner tinyblob, es poner MEDIUMBLOB, que es mas extenso.

 

PD: Se lo he solucionado por anydesk.

 

Un saludo.

Eres una maquina tio! Xd