Fedor

Thanks, but the error is still there. btw. It's the same error. #1054 - Unknown column 'Spawnkoords' in 'field list' '@Barand' @Barand

userdata for a game. For the dates like gender.

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'

The are spawncords for a MTA.

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` float NOT NULL '0|0|1338.2893066406|-1773.7534179688|13.552166938782|0', `Skin` varchar(50) NOT NULL '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; Error: SQL-Command: 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` float NOT NULL '0|0|1338.2893066406|-1773.7534179688|13.552166938782|0', `Skin` varchar(50) NOT NULL '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 reported: #1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''0|0|1338.2893066406|-1773.7534179688|13.552166938782|0', `Skin` varchar(50) N' at line 9

The Error is under the tables. CREATE TABLE IF NOT EXISTS `joindata` ( `Username` varchar(50) NOT NULL, `Herkunft` text NOT NULL, `IP` text NOT NULL, `Serial` text NOT NULL, `Version` text NOT NULL, `Lastseen` text NOT NULL, `Timesjoined` varchar(50) NOT NULL DEFAULT 'none' ) ENGINE=MyISAM DEFAULT CHARSET=latin1; Above is right and works perfect. But the User Table don't work. CREATE TABLE IF NOT EXISTS `user` ( `id` smallint(6) NOT NULL AUTO_INCREMENT, `Name` varchar(30) NOT NULL, `E-Mail` text NOT NULL, `Password` text NOT NULL, `Salt` varchar(20) NOT NULL DEFAULT '0', `Serial` text NOT NULL, `Played_Time` double NOT NULL DEFAULT '0', `Last_IP` text NOT NULL, `Last_Logout` int(50) NOT NULL, `Last_Login` int(50) NOT NULL, `Register_Date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, `Geburtsdatum` text NOT NULL, `Verifikation` text NOT NULL, `Adminlevel` float NOT NULL DEFAULT '0', `Status` varchar(50) NOT NULL DEFAULT 'Obdachloser', `Available_Status` varchar(50) NOT NULL DEFAULT '[ { "Obdachloser": true } ]', `Bonuspoints` int(11) NOT NULL DEFAULT '0', `Achievements` int(50) NOT NULL DEFAULT '[ [ ] ]', `Statistics` int(11) NOT NULL DEFAULT'[ [ ] ]' PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ; SQL-Command: CREATE TABLE IF NOT EXISTS `user` ( `id` smallint(6) NOT NULL AUTO_INCREMENT, `Name` varchar(30) NOT NULL, `E-Mail` text NOT NULL, `Password` text NOT NULL, `Salt` varchar(20) NOT NULL DEFAULT '0', `Serial` text NOT NULL, `Played_Time` double NOT NULL DEFAULT '0', `Last_IP` text NOT NULL, `Last_Logout` int(50) NOT NULL, `Last_Login` int(50) NOT NULL, `Register_Date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, `Geburtsdatum` text NOT NULL, `Verifikation` text NOT NULL, `Adminlevel` float NOT NULL DEFAULT '0', `Status` varchar(50) NOT NULL DEFAULT 'Obdachloser', `Available_Status` varchar(50) NOT NULL DEFAULT '[ { "Obdachloser": true } ]', `Bonuspoints` int(11) NOT NULL DEFAULT '0', `Achievements` int(50) NOT NULL DEFAULT '[ [ ] ]', `Statistics` int(11) NOT NULL DEFAULT'[ [ ] ]' PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ; MySQL meldet: #1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '(`id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1' at line 21 Hope you can help me.