[BUG] Can’t Create Characters

[Shadows002]

Hi Community,



When creating a character im getting the error "Can't create character".

When creating a character the first time after a server reboot it works with no error. But if i want to create another character i get the error "Can't create character".

If i keep trying to create the same character with the same name, eventually it works.

It appears that in the Syslog when i get the error the HEADER_GD_PLAYER_CREATE is empty and when it succeeds its with a "PlayerCreate accountid".

This is Syslog from DB:

HEADER_GD_PLAYER_CREATE (handle: 7 length: 1883) // This is when it works.
Apr 7 14:05:20 :: PlayerCreate accountid 9 name Aghei level 1 gold 0, st 5 ht 3 job 2
Apr 7 14:05:20 :: 7 name Aghei job 2
Apr 7 14:05:20 :: END
Apr 7 14:05:22 :: [ 2450] return 0/0/0 async 0/0/0
Apr 7 14:05:26 :: HEADER_GD_PLAYER_CREATE (handle: 7 length: 1883) //This is the empty header when i get the error.
Apr 7 14:05:26 :: END
Apr 7 14:05:27 :: [ 2500] return 0/0/0 async 0/0/0
Apr 7 14:05:32 :: [ 2550] return 0/0/0 async 0/0/0
Apr 7 14:05:37 :: [ 2600] return 0/0/0 async 0/0/0
Apr 7 14:05:42 :: [ 2650] return 0/0/0 async 0/0/0
Apr 7 14:05:47 :: [ 2700] return 0/0/0 async 0/0/0
Apr 7 14:05:52 :: [ 2750] return 0/0/0 async 0/0/0
Apr 7 14:05:57 :: [ 2800] return 0/0/0 async 0/0/0
Apr 7 14:06:02 :: [ 2850] return 0/0/0 async 0/0/0
Apr 7 14:06:07 :: [ 2900] return 0/0/0 async 0/0/0
Apr 7 14:06:12 :: [ 2950] return 0/0/0 async 0/0/0
Apr 7 14:06:17 :: [ 3000] return 0/0/0 async 0/0/0
Apr 7 14:06:21 :: HEADER_GD_PLAYER_CREATE (handle: 7 length: 1883) // This is when it works just after the error.
Apr 7 14:06:21 :: PlayerCreate accountid 9 name Taker level 1 gold 0, st 5 ht 3 job 2
Apr 7 14:06:21 :: 7 name Taker job 2
Apr 7 14:06:21 :: END
Apr 7 14:06:22 :: [ 3050] return 0/0/0 async 0/0/0

In DB Syserr i only get this:

SYSERR: Apr 7 14:01:17 :: pid_init:
Start of pid: 851

SYSERR: Apr 7 14:01:17 :: Start: TABLE_POSTFIX not configured use default
SYSERR: Apr 7 14:01:18 :: DirectQuery: AsyncSQL:irectQuery : 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

Could someone please help and maybe tell me where to look or know the fix ?

[~RealBlade~]

Originally Posted by Shadows002

Hi Community,



When creating a character im getting the error "Can't create character".

When creating a character the first time after a server reboot it works with no error. But if i want to create another character i get the error "Can't create character".

If i keep trying to create the same character with the same name, eventually it works.

It appears that in the Syslog when i get the error the HEADER_GD_PLAYER_CREATE is empty and when it succeeds its with a "PlayerCreate accountid".

This is Syslog from DB:





In DB Syserr i only get this:







Could someone please help and maybe tell me where to look or know the fix ?

The table "money" in your player database seems to be broken or false configurated.

[Shadows002]

Originally Posted by ~RealBlade~

The table "money" in your player database seems to be broken or false configurated.

Thats from the monarch database. I dont think it affects character creating. And i fixed that but still same issue.