• There is NO official Otland's Discord server and NO official Otland's server list. The Otland's Staff does not manage any Discord server or server list. Moderators or administrator of any Discord server or server lists have NO connection to the Otland's Staff. Do not get scammed!

Znote AAC create character problem

Benjamz93

New Member
Joined
Nov 5, 2019
Messages
10
Reaction score
4
Im getting this error when trying to create a chacater - unsure what ive done
Code:
string(748) "INSERT INTO `players`(`name`, `group_id`, `account_id`, `level`, `vocation`, `health`, `healthmax`, `experience`, `lookbody`, `lookfeet`, `lookhead`, `looklegs`, `looktype`, `lookaddons`, `maglevel`, `mana`, `manamax`, `manaspent`, `soul`, `town_id`, `posx`, `posy`, `posz`, `conditions`, `cap`, `sex`, `lastlogin`, `lastip`, `save`, `skull`, `skulltime`, `lastlogout`, `blessings`, `balance`, `skill_fist`, `skill_club`, `skill_sword`, `skill_axe`, `skill_dist`, `skill_shielding`, `skill_fishing`) VALUES ('Toby', '1', '1', '8', '1', '270', '270', '4200', '68', '76', '78', '58', '128', '0', '3', '520', '520', '0', '100', '1', '', '', '', '', '590', '1', '0', '167837953', '1', '0', '0', '0', '0', '0', '10', '10', '10', '10', '10', '15', '10');"
(query - SQL error)
Type: voidQuery (voidQuery is used for update, insert or delete from database)

Incorrect integer value: '' for column 'posx' at row 1


Thanks in advance
 
Ive made sure its correct and now its is this
Code:
string(751) "INSERT INTO `players`(`name`, `group_id`, `account_id`, `level`, `vocation`, `health`, `healthmax`, `experience`, `lookbody`, `lookfeet`, `lookhead`, `looklegs`, `looktype`, `lookaddons`, `maglevel`, `mana`, `manamax`, `manaspent`, `soul`, `town_id`, `posx`, `posy`, `posz`, `conditions`, `cap`, `sex`, `lastlogin`, `lastip`, `save`, `skull`, `skulltime`, `lastlogout`, `blessings`, `balance`, `skill_fist`, `skill_club`, `skill_sword`, `skill_axe`, `skill_dist`, `skill_shielding`, `skill_fishing`) VALUES ('Benjamx', '1', '1', '8', '1', '270', '270', '4200', '68', '76', '78', '58', '128', '0', '3', '520', '520', '0', '100', '1', '', '', '', '', '590', '1', '0', '167837953', '1', '0', '0', '0', '0', '0', '10', '10', '10', '10', '10', '15', '10');"
(query - SQL error)
Type: voidQuery (voidQuery is used for update, insert or delete from database)

Incorrect integer value: '' for column 'posx' at row 1
 
Back
Top