Lua Tfs 0.2.3

[xTremoxx]

I when i create player in ACC Manager, say this, The Player Cannot be Saved, and in console give this error:

MySQL ERROR mysql_real_query: INSERT INTO `players` (`id`, `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`, `redskull`, `redskulltime`, `save`, `rank_id`, `guildnick`, `lastlogout`, `blessings`, `online`) VALUES (NULL, 'Fusao Hrk', 1, 662390, 8, 2, 185, 185, 4200, 68, 76, 78, 39, 128, 0, 0, 35, 35, 0, 100, 5, 0, 0, 0, 0, 435, 1, 0, 0, 0, 0, 1, 0, '', 0, 0, 0); Column 'id' cannot be null

I'm using my sql, can help me ? :thumbup:

 

[xTremoxx]

Please help, its very important.

 

[Don Daniello]

Execute in phpmyadmin:

ALTER TABLE `accounts` CHANGE `id` `id` INT( 11 ) NOT NULL AUTO_INCREMENT

 

[xTremoxx]

Don't work, more suggestions?

i think the error is on table 'player' in id player, because error in mysql say 'INSERT INTO `players`'

SS:

 

[xTremoxx]

BUMP, pleasee help ;/

 

[xTremoxx]

Solved !

 

[DedicatedOT]

i just made it default some random word like "a". What did you do to solve it?