AAC Database error.

[enanthenone]

Type: voidQuery (voidQuery is used for update, insert or delete from database)

Field 'comment' doesn't have a default value

When i try to create new character.

 

[Leo32]

Go to the Players table and set the Comment field to be nullable and set the default value to null.

 

[enanthenone]

still.

Register Account
string(161) "INSERT INTO `accounts` (`name`, `password`, `email`, `creation`) VALUES ('123123', '28d16dc8da5f078058bbd7183043bbefb2fa3229', '[email protected]', '1495667156')"
(query - SQL error)
Type: voidQuery (voidQuery is used for update, insert or delete from database)

Field 'vote' doesn't have a default value

 

[Raggaer]

This problem has been answered million times. You are missing columns (or have bad table configuration, in this case) on your database table. Make sure to run the required SQL statements for the AAC you are using (or plugin) and this will be fixed

ALERT TABLE accounts ALTER COLUMN vote SET DEFAULT '';

I dont know if vote is numeric or not. If vote is numeric just change '' for 0

 

[Leo32]

still.

Register Account
string(161) "INSERT INTO `accounts` (`name`, `password`, `email`, `creation`) VALUES ('123123', '28d16dc8da5f078058bbd7183043bbefb2fa3229', '[email protected]', '1495667156')"
(query - SQL error)
Type: voidQuery (voidQuery is used for update, insert or delete from database)

Field 'vote' doesn't have a default value

Go to the Accounts table and set the vote field to be nullable and set the default value to null.

Are you connecting the dots yet? bud?

 

[enanthenone]

grrr still i cant fix it.

Create Character
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 ('Dsads', '1', '1', '8', '1', '185', '185', '4200', '68', '76', '78', '58', '128', '0', '0', '40', '40', '0', '100', '2', '5', '5', '2', '', '470', '1', '0', '1508237659', '1', '0', '0', '0', '0', '0', '10', '10', '10', '10', '10', '10', '10');"
(query - SQL error)
Type: voidQuery (voidQuery is used for update, insert or delete from database)

Field 'comment' doesn't have a default value

i trying with clear tfs 1.2 database and clear znote sql and i have same problem.
But if i use old database from my server ( tfs 1,2 sql + znote tables with accounts) then i have problem only when i try to create "holy monk" fifth proffesion from me serv. sorry for my english im drunk now and i forgot words

 

[Leo32]

Go to the Players table and set the comment field to be nullable and set the default value to null.

I can do this all day, mate.

 

[Hitman94]

not work Imgur

 

[Infernum]

not work Imgur

change type to VARCHAR

 

[Hitman94]

not working

string(750) "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`, `rank_id`, `guildnick`, `lastlogout`, `blessings`, `direction`, `loss_experience`, `loss_mana`, `loss_skills`, `premend`, `online`, `balance`) VALUES ('Jkjkj', '1', '11', '8', '1', '185', '185', '4200', '68', '76', '78', '58', '128', '0', '0', '40', '40', '0', '100', '1', '5', '5', '2', '', '470', '1', '0', '780550762', '1', '0', '0', '0', '', '0', '0', '0', '10', '10', '10', '0', '0', '0');" 
(query - SQL error) 
Type: voidQuery (voidQuery is used for update, insert or delete from database)

Field 'auction_balance' doesn't have a default value

 

[Webtimize]

ALTER TABLE `players` CHANGE `auction_balance` `auction_balance` INT(11) NULL DEFAULT NULL;

 

[Hitman94]

thanks i no have so much tables i database next
error

Field 'nick_verify' doesn't have a default value

im add

ALTER TABLE `players` CHANGE `created` `created` INT(11) NULL DEFAULT NULL;

error

Field 'nick_verify' doesn't have a default value

this command not works

ALTER TABLE `players` CHANGE `nick_verify` `nick_verify` INT(11) NULL DEFAULT NULL;