Fedor Posted July 21, 2015 Share Posted July 21, 2015 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. Quote Link to comment https://forums.phpfreaks.com/topic/297408-1064-i-dont-know-why/ Share on other sites More sharing options...
fastsol Posted July 21, 2015 Share Posted July 21, 2015 You're missing a , (comma) at the end of this line `Statistics` int(11) NOT NULL DEFAULT'[ [ ] ]' Quote Link to comment https://forums.phpfreaks.com/topic/297408-1064-i-dont-know-why/#findComment-1516999 Share on other sites More sharing options...
Fedor Posted July 21, 2015 Author Share Posted July 21, 2015 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 Quote Link to comment https://forums.phpfreaks.com/topic/297408-1064-i-dont-know-why/#findComment-1517003 Share on other sites More sharing options...
Ch0cu3r Posted July 21, 2015 Share Posted July 21, 2015 The error is trigger because of this '0|0|1338.2893066406|-1773.7534179688|13.552166938782|0' after `Spawnkoords` float NOT NULL What is that supposed to be? Quote Link to comment https://forums.phpfreaks.com/topic/297408-1064-i-dont-know-why/#findComment-1517010 Share on other sites More sharing options...
Fedor Posted July 21, 2015 Author Share Posted July 21, 2015 The are spawncords for a MTA. Quote Link to comment https://forums.phpfreaks.com/topic/297408-1064-i-dont-know-why/#findComment-1517012 Share on other sites More sharing options...
Ch0cu3r Posted July 21, 2015 Share Posted July 21, 2015 Is it the the default value? Then you need DEFAULT before it. Event then it work as you are using float datatype, prehaps you mean to use varchar datatype? Quote Link to comment https://forums.phpfreaks.com/topic/297408-1064-i-dont-know-why/#findComment-1517020 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.