Name for New Character Not Being Accepted

[DarkOne 12]

I'm testing out some server files and it all ready had a account on it with two Characters a GM and a low lvl. When I go and try to create a new character on the existing account or on a new account with any given name. The name/names are not being accepted. I have tried many combination but it will not accept any new names for Character creation. Any suggetions to the problem would be appreciated.

[testtesttest13 0]

Mysql / source-db .

[BeHappy4Ever 237]

Send me a private message to help you

[Deliris 401]

syserr db?

[DarkOne 12]

Here is my syserr file

SYSERR: Jul 11 03:26:16.741386 :: Process: FDWATCH: peer null in event: ident 20
SYSERR: Jul 11 03:26:18.331016 :: hupsig: SIGHUP, SIGINT, SIGTERM signal has been received. shutting down.
SYSERR: Jul 11 03:26:18.364040 :: pid_deinit: 
End of pid

SYSERR: Jul 11 03:28:30.110069 :: pid_init: 
Start of pid: 750

SYSERR: Jul 11 03:28:30.110669 :: Start: TABLE_POSTFIX not configured use default
SYSERR: Jul 11 03:28:30.745594 :: ChildLoop: AsyncSQL: query failed: Unknown column 'resist_claw' in 'field list' (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, resist_claw, 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 (34035, "???", "???", 1,
SYSERR: Jul 11 03:28:33.471393 :: DirectQuery: AsyncSQL::DirectQuery : mysql_query error: Column 'money' in field list is ambiguous
query: SELECT empire, pid, name, money, windate FROM monarch a, player b where a.pid=b.id

[Jodie 4]

The first error is saying that you don't have resist_claw column in your mob_proto.sql. It will be okay if you add that column in your mob_proto.sql. The second error is saying that there is a query problem about monarch.

- Jodie

[DarkOne 12]

Yeah I was just posting it for Wahmon....My main issues is with my first post...

[MichaelM 40]

5 hours ago, DarkOne said:

Here is my syserr file

SYSERR: Jul 11 03:26:16.741386 :: Process: FDWATCH: peer null in event: ident 20
SYSERR: Jul 11 03:26:18.331016 :: hupsig: SIGHUP, SIGINT, SIGTERM signal has been received. shutting down.
SYSERR: Jul 11 03:26:18.364040 :: pid_deinit: 
End of pid

SYSERR: Jul 11 03:28:30.110069 :: pid_init: 
Start of pid: 750

SYSERR: Jul 11 03:28:30.110669 :: Start: TABLE_POSTFIX not configured use default
SYSERR: Jul 11 03:28:30.745594 :: ChildLoop: AsyncSQL: query failed: Unknown column 'resist_claw' in 'field list' (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, resist_claw, 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 (34035, "???", "???", 1,
SYSERR: Jul 11 03:28:33.471393 :: DirectQuery: AsyncSQL::DirectQuery : mysql_query error: Column 'money' in field list is ambiguous
query: SELECT empire, pid, name, money, windate FROM monarch a, player b where a.pid=b.id

^{ALTER TABLE `mob_proto` ADD `resist_claw` INT(255) NOT NULL AFTER `resist_poison`;}

Note: The type for the column might be wrong.

The monarch error is thrown because the column named 'money' exists in both tables (monarch, player). I think you'll have to fix that query serverside to get rid of this error.

 

[DarkOne 12]

Also here is my syslog when creating a character. No matter what name I choose it will not accept it.

 

Jul 11 13:36:49.768025 :: PlayerCreate accountid 1 name jacobjohn level 1 gold 0, st 6 ht 4 job 0
SYSERR: Jul 11 13:36:49.768374 :: DirectQuery: AsyncSQL::DirectQuery : mysql_query error: Field 'money' doesn't have a default value
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, playtime, skill_level, quickslot) VALUES(0, 1, 'jacobjohn', 1, 6, 4, 3, 3, 0, 0, 0, 957079, 255057, 0, 760, 260, 0, 0, 0, 800, 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\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\
SYSERR: Jul 11 13:36:49.768593 :: __QUERY_PLAYER_CREATE: QUERY_ERROR: UPDATE player_index SET pid3=0 WHERE id=1
Jul 11 13:36:49.768759 :: END

[DarkOne 12]

I fixed the problem. I went into tables for player. Right clicked on player and selected Design Table and unchecked Not Null for money and that fixed the problem.

Thanks to all that tried to help......