(Resolvido)Field 'comment' doesn't have a default value - ZnoteAcc

[MarcosAlcantara 0]

string(754) "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 ('Pandemon', '1', '2', '8', '1', '185', '185', '4200', '68', '76', '78', '58', '128', '0', '0', '40', '40', '0', '100', '1', '5', '5', '2', '', '470', '1', '0', '2130706433', '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

 

 

[Pedro. 537]

  Em 10/01/2019 em 00:41, MarcosAlcantara disse:

string(754) "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 ('Pandemon', '1', '2', '8', '1', '185', '185', '4200', '68', '76', '78', '58', '128', '0', '0', '40', '40', '0', '100', '1', '5', '5', '2', '', '470', '1', '0', '2130706433', '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

  

 

 

Expand   Mostrar mais  

Vá para a tabela Players e defina o campo de comentário como anulável e defina o valor padrão como null .
 

Editado Janeiro 10, 2019 por Yinz (veja o histórico de edições)