[help] mysql error
#1

[09:33:07] MySQL Error! msg: "Could not execute query. 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 'Key='1',Level='=',AdminLevel='',DonateRank='',Upg radePoints='',ConnectedTime='',' at line 1.", error id: 1064, connection handle: 0.
[09:33:08] MySQL Error (0): Could not execute query. 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 'Key='1',Level='=',AdminLevel='',DonateRank='',Upg radePoints='',ConnectedTime='',' at line 1.
[09:33:08] MySQL Error! msg: "Could not execute query. 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 'Key='1',Level='=',AdminLevel='',DonateRank='',Upg radePoints='',ConnectedTime='',' at line 1.", error id: 1064, connection handle: 0.

runserver

file log

helpme
Reply
#2

helpme plz
Reply
#3

PLease post the mysql code.
Reply
#4

CREATE TABLE `players` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`Name` varchar(50) COLLATE latin1_general_ci NOT NULL,
`Password` varchar(50) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
`Level` int(11) NOT NULL DEFAULT '1',
`AdminLevel` int(11) NOT NULL DEFAULT '0',
`DonateRank` int(11) NOT NULL DEFAULT '0',
`UpgradePoints` int(11) NOT NULL DEFAULT '0',
`ConnectedTime` int(11) NOT NULL DEFAULT '0',
`Registered` int(11) NOT NULL DEFAULT '0',
`Sex` int(11) NOT NULL DEFAULT '1',
`Age` int(11) NOT NULL DEFAULT '0',
`Origin` int(11) NOT NULL DEFAULT '255',
`CK` int(11) NOT NULL DEFAULT '0',
`Muted` int(11) NOT NULL DEFAULT '0',
`Respect` int(11) NOT NULL DEFAULT '0',
`Money` bigint(20) NOT NULL DEFAULT '1000',
`Bank` int(11) NOT NULL DEFAULT '5000',
`Crimes` int(11) NOT NULL DEFAULT '0',
`Kills` int(11) NOT NULL DEFAULT '0',
`Deaths` int(11) NOT NULL DEFAULT '0',
`Arrested` int(11) NOT NULL DEFAULT '0',
`WantedDeaths` int(11) NOT NULL DEFAULT '0',
`WantedLevel` int(11) NOT NULL DEFAULT '0',
`Phonebook` int(11) NOT NULL DEFAULT '0',
`LottoNr` int(11) NOT NULL DEFAULT '0',
`Fishes` int(11) NOT NULL DEFAULT '0',
`BiggestFish` int(11) NOT NULL DEFAULT '0',
`Job` int(11) NOT NULL DEFAULT '0',
`Paycheck` int(11) NOT NULL DEFAULT '0',
`HeadValue` int(11) NOT NULL DEFAULT '0',
`Jailed` int(11) NOT NULL DEFAULT '0',
`JailTime` int(11) NOT NULL DEFAULT '0',
`Materials` int(11) NOT NULL DEFAULT '0',
`Drugs` int(11) NOT NULL DEFAULT '0',
`Leader` int(11) NOT NULL DEFAULT '0',
`Member` int(11) NOT NULL DEFAULT '0',
`FMember` int(11) NOT NULL DEFAULT '255',
`Rank` int(11) NOT NULL DEFAULT '0',
`Chara` int(11) NOT NULL DEFAULT '0',
`ContractTime` int(11) NOT NULL DEFAULT '0',
`DetSkill` int(11) NOT NULL DEFAULT '0',
`SexSkill` int(11) NOT NULL DEFAULT '0',
`BoxSkill` int(11) NOT NULL DEFAULT '0',
`LawSkill` int(11) NOT NULL DEFAULT '0',
`MechSkill` int(11) NOT NULL DEFAULT '0',
`JackSkill` int(11) NOT NULL DEFAULT '0',
`CarSkill` int(11) NOT NULL DEFAULT '0',
`NewsSkill` int(11) NOT NULL DEFAULT '0',
`DrugsSkill` int(11) NOT NULL DEFAULT '0',
`CookSkill` int(11) NOT NULL DEFAULT '0',
`FishSkill` int(11) NOT NULL DEFAULT '0',
`pSHealth` varchar(16) COLLATE latin1_general_ci NOT NULL DEFAULT '50.0',
`pHealth` varchar(16) COLLATE latin1_general_ci NOT NULL DEFAULT '50.0',
`Inte` int(11) NOT NULL DEFAULT '0',
`Local` int(11) NOT NULL DEFAULT '255',
`Team` int(11) NOT NULL DEFAULT '3',
`Model` int(11) NOT NULL DEFAULT '264',
`PhoneNr` int(11) NOT NULL DEFAULT '0',
`House` int(11) NOT NULL DEFAULT '255',
`Bizz` int(11) NOT NULL DEFAULT '255',
`Pos_x` float NOT NULL DEFAULT '1766.35',
`Pos_y` float NOT NULL DEFAULT '-1361.74',
`Pos_z` float NOT NULL DEFAULT '15.7578',
`CarLic` int(11) NOT NULL DEFAULT '0',
`FlyLic` int(11) NOT NULL DEFAULT '0',
`BoatLic` int(11) NOT NULL DEFAULT '0',
`FishLic` int(11) NOT NULL DEFAULT '0',
`GunLic` int(11) NOT NULL DEFAULT '0',
`Gun1` int(11) NOT NULL DEFAULT '0',
`Gun2` int(11) NOT NULL DEFAULT '0',
`Gun3` int(11) NOT NULL DEFAULT '0',
`Gun4` int(11) NOT NULL DEFAULT '0',
`Ammo1` int(11) NOT NULL DEFAULT '0',
`Ammo2` int(11) NOT NULL DEFAULT '0',
`Ammo3` int(11) NOT NULL DEFAULT '0',
`Ammo4` int(11) NOT NULL DEFAULT '0',
`CarTime` int(11) NOT NULL DEFAULT '0',
`PayDay` int(11) NOT NULL DEFAULT '0',
`PayDayHad` int(11) NOT NULL DEFAULT '0',
`CDPlayer` int(11) NOT NULL DEFAULT '0',
`Wins` int(11) NOT NULL DEFAULT '0',
`Loses` int(11) NOT NULL DEFAULT '0',
`AlcoholPerk` int(11) NOT NULL DEFAULT '0',
`DrugPerk` int(11) NOT NULL DEFAULT '0',
`MiserPerk` int(11) NOT NULL DEFAULT '0',
`PainPerk` int(11) NOT NULL DEFAULT '0',
`TraderPerk` int(11) NOT NULL DEFAULT '0',
`Tutorial` int(11) NOT NULL DEFAULT '0',
`Mission` int(11) NOT NULL DEFAULT '0',
`Warnings` int(11) NOT NULL DEFAULT '0',
`Banned` int(11) NOT NULL DEFAULT '0',
`Adjustable` int(11) NOT NULL DEFAULT '0',
`Fuel` int(11) NOT NULL DEFAULT '0',
`Married` int(11) NOT NULL DEFAULT '0',
`MarriedTo` varchar(50) COLLATE latin1_general_ci NOT NULL DEFAULT 'No-one',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=8 ;
Reply


Forum Jump:


Users browsing this thread: 1 Guest(s)