#1064 I don't know why.

[Fedor]

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.

 

[fastsol]

You're missing a , (comma) at the end of this line `Statistics` int(11) NOT NULL DEFAULT'[ [ ] ]'

[Fedor]

 

 

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 

 

[Ch0cu3r]

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?

[Fedor]

The are spawncords for a MTA.

[Ch0cu3r]

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?