My column doesn't work?

[Fedor]

I don't know why, I hope you can help me.

 

CREATE TABLE IF NOT EXISTS `userdata` (

  `Name` text NOT NULL,

  `Inventory` text NOT NULL,

  `Phonenumber` text NOT NULL,

  `Geld` int(30) NOT NULL DEFAULT '250',

  `Bankgeld` int(50) NOT NULL DEFAULT '500',

  `Fraktion` double NOT NULL DEFAULT '0',

  `Rank` double NOT NULL DEFAULT '0',

  `Spawnkoords` varchar(50) NOT NULL DEFAULT '0|0|1338.2893066406|-1773.7534179688|13.552166938782|0',

  `Skin` varchar(50) NOT NULL DEFAULT '137',

  `Geschlecht` text NOT NULL,

  `Jailzeit` double NOT NULL DEFAULT '0',

  `Wanteds` varchar(50) NOT NULL DEFAULT '0',

  `ActiveQuests` text NOT NULL,

  `FinishedQuests` text NOT NULL

) ENGINE=MyISAM DEFAULT CHARSET=latin1;

 

 

MySQL Error:

INSERT INTO userdata (`Name`, `Inventory`, `Phonenumber`, `Geld`, `Bankgeld`, `Fraktion`, `Rank`, `Spawnkoords`, `Skin`, `Geschlecht`, `Jailtime`, `Wanteds`, `ActiveQuests`, `FinishedQuests`) VALUES
('', (SELECT MAX(ID) FROM `Inventory`), '', '250', '500', '0', '0', '0|0|1338.2893066406|-1773.7534179688|13.552166938782|0', '137', '', '0', '0', '[ [ ] ]', '[ [ ] ]');

 

MySQL reported: 

#1054 - Unknown column 'Spawnkoords' in 'field list' 

[requinix]

What does SHOW CREATE TABLE userdata say?

[Fedor]

userdata for a game.

 

For the dates like gender.

[Barand]

Strange, it should be "jailtime" giving that error. You have "jailzeit" in the table.

[Fedor]

Strange, it should be "jailtime" giving that error. You have "jailzeit" in the table.

Thanks, but the error is still there.

btw. It's the same error.

 

#1054 - Unknown column 'Spawnkoords' in 'field list' 

 

'@Barand'

@Barand

Edited July 22, 2015 by Fedor

[requinix]

I'll try again:

 

What is the output of the query

SHOW CREATE TABLE userdata