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 ?
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:
Quote:
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:
Quote:
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::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
Could someone please help and maybe tell me where to look or know the fix ?
