Fedor Posted July 22, 2015 Share Posted July 22, 2015 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' Quote Link to comment https://forums.phpfreaks.com/topic/297429-my-column-doesnt-work/ Share on other sites More sharing options...
requinix Posted July 22, 2015 Share Posted July 22, 2015 What does SHOW CREATE TABLE userdata say? Quote Link to comment https://forums.phpfreaks.com/topic/297429-my-column-doesnt-work/#findComment-1517101 Share on other sites More sharing options...
Fedor Posted July 22, 2015 Author Share Posted July 22, 2015 userdata for a game. For the dates like gender. Quote Link to comment https://forums.phpfreaks.com/topic/297429-my-column-doesnt-work/#findComment-1517103 Share on other sites More sharing options...
Barand Posted July 22, 2015 Share Posted July 22, 2015 Strange, it should be "jailtime" giving that error. You have "jailzeit" in the table. Quote Link to comment https://forums.phpfreaks.com/topic/297429-my-column-doesnt-work/#findComment-1517105 Share on other sites More sharing options...
Fedor Posted July 22, 2015 Author Share Posted July 22, 2015 (edited) 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 Quote Link to comment https://forums.phpfreaks.com/topic/297429-my-column-doesnt-work/#findComment-1517107 Share on other sites More sharing options...
requinix Posted July 22, 2015 Share Posted July 22, 2015 I'll try again: What is the output of the query SHOW CREATE TABLE userdata Quote Link to comment https://forums.phpfreaks.com/topic/297429-my-column-doesnt-work/#findComment-1517108 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.