Hallo Leute, ich brauche eure Hilfe. Es handelt sich um einen MySQL Fehler auf dem PR Script.
Sobald ich den Server starte, bekomme ich folgende Fehler:
26/07/2013-01:33:39 | errorid=1060,error=Duplicate column name 'Friedhof',query=ALTER TABLE prp_account_main ADD COLUMN (`Friedhof` int(2) NOT NULL,`FriedhofZeit` int(4) NOT NULL,`ImKnast` int(2) NOT NULL,`KnastZeit` int(4) NOT NULL,`KnastKaution` int(2) NOT NULL,`Muted` int(2) NOT NULL,`MuteZeit` int(4) NOT NULL,`ImPrison` int(2) NOT NULL,`PrisonCheckPointsAbgelaufen` int(6) NOT NULL,`PrisonCheckPointsGegeben` int(6) NOT NULL,`Morde` int(4) NOT NULL,`Tode` int(4) NOT NULL,`SkinID` int(3) NOT NULL,`FraktionSkinID` int(3) NOT NULL,`PaintBallKills` int(10) NOT NULL,`PaintBallTode` int(10) NOT NULL,`PaintBallRang` int(3) NOT NULL,`PaintBallBesuche` int(8) NOT NULL,`AngenommeneReports` int(6) NOT NULL,`KopfGeld` int(10) NOT NULL,`Bankkonto` int(2) NOT NULL,`pArmyPlaneOrder` int(2) NOT NULL,`pArmyHeliOrder` int(2) NOT NULL,`pArmyWaffenOrder` int(2) NOT NULL,`LevelUPKosten` int(10) NOT NULL,`RespectForLevelUp` int
26/07/2013-01:33:39 | errorid=1060,error=Duplicate column name 'pMarried',query=ALTER TABLE prp_account_main ADD COLUMN (`pMarried` varchar(24) NOT NULL,`pBuyClothes` int(6) NOT NULL,`pIll` int(10) NOT NULL,`pConterminatedTime` int(10) NOT NULL,`pBitchSkill` int(10) NOT NULL,`pBitchFuckCount` int(10) NOT NULL,`pMedicHealplayerSkill` int(10) NOT NULL,`pMedicHealCount` int(10) NOT NULL)
26/07/2013-01:33:39 | errorid=1064,error=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 '' at line 1,query=CREATE TABLE IF NOT EXISTS `prp_races` (`race` varchar(32) NOT NULL,`fID` int(3) NOT NULL, `rmode` int(3) NOT NULL,`X1` float(10,4) NOT NULL,`Y1` float(10,4) NOT NULL,`Z1` float(10,4) NOT NULL,`CP_TYP1` int(3) NOT NULL,`CP_SIZE1` float (10,4) NOT NULL,`X2` float(10,4) NOT NULL,`Y2` float(10,4) NOT NULL,`Z2` float(10,4) NOT NULL,`CP_TYP2` int(3) NOT NULL,`CP_SIZE2` float (10,4) NOT NULL,`X3` float(10,4) NOT NULL,`Y3` float(10,4) NOT NULL,`Z3` float(10,4) NOT NULL,`CP_TYP3` int(3) NOT NULL,`CP_SIZE3` float (10,4) NOT NULL,`X4` float(10,4) NOT NULL,`Y4` float(10,4) NOT NULL,`Z4` float(10,4) NOT NULL,`CP_TYP4` int(3) NOT NULL,`CP_SIZE4` float (10,4) NOT NULL,`X5` float(10,4) NOT NULL,`Y5` float(10,4) NOT NULL,`Z5` float(
26/07/2013-01:33:39 | errorid=1064,error=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 'blacklistreason0,blacklist1,blacklistreason1,blacklist2,blacklistreason2,blackli' at line 1,query=CREATE TABLE IF NOT EXISTS `prp_account_blacklist` (`Name` varchar(24) NOT NULL,blacklist0,blacklistreason0,blacklist1,blacklistreason1,blacklist2,blacklistreason2,blacklist3,blacklistreason3,blacklist4,blacklistreason4,blacklist5,blacklistreason5,blacklist6,blacklistreason6,blacklist7,blacklistreason7,blacklist8,blacklistreason8,blacklist9,blacklistreason9,blacklist10,blacklistreason10,blacklist11,blacklistreason11,blacklist12,blacklistreason12,blacklist13,blacklistreason13,blacklist14,blacklistreason14,blacklist15,blacklistreason15,blacklist16,blacklistreason16,blacklist17,blacklistreason17,blacklist18,blacklistreason18,PRIMARY KEY (`Nam
26/07/2013-01:33:39 | errorid=1146,error=Table 'plrp.prp_gutscheine' doesn't exist,query=SELECT * FROM prp_gutscheine
26/07/2013-01:33:39 | errorid=1054,error=Unknown column 'wHackPrice' in 'field list',query=INSERT INTO `prp_stuff` (ADPreis,PlayerRekord,Lottojackpot,RentVehsPreis,TerrorSpawn,Lohnsteuer,Kirchensteuer,Mwst,Grundsteuer,OamtStandGebuer,Solidsteuer,PreisLicCar,PreisLicBike,PreisLicRoller,PreisLicPlane,PreisLicHeli,PreisLicBoat,TerrorContractRang,FMeldePreis,NewspaperPreis,NewspaperText1,NewspaperText2,NewspaperText3,NewspaperText4,NewspaperText5,NewspaperText6,NewspaperText7,NewspaperText8,NewsPaperRealeased,NewsPaperLager1,NewsPaperLager2,EisenLagger1,EisenLagger2,Kartfahrer1,KartTime1,FreemanPrice,wHackPrice,SAPDpay,FBIpay,SAFDpay,ARMYpay,OAMTpay,GOVpay,WorkLessMoney,BlitzerToleranz,Reichensteuer,JobSperreFree,AngelLicPrice,PersoLicPrice,WeapPrice,ParkPrice) VALUES ('250','0','100000','50','0','2.2','1.4','19','2.6','150','1.2','1350','2000','500','10000','6750','4500','2','100','5','NO-ONE','NO-ONE','NO-ONE'
26/07/2013-01:33:39 | errorid=1060,error=Duplicate column name 'Friedhof',query=ALTER TABLE prp_account_main ADD COLUMN (`Friedhof` int(2) NOT NULL,`FriedhofZeit` int(4) NOT NULL,`ImKnast` int(2) NOT NULL,`KnastZeit` int(4) NOT NULL,`KnastKaution` int(2) NOT NULL,`Muted` int(2) NOT NULL,`MuteZeit` int(4) NOT NULL,`ImPrison` int(2) NOT NULL,`PrisonCheckPointsAbgelaufen` int(6) NOT NULL,`PrisonCheckPointsGegeben` int(6) NOT NULL,`Morde` int(4) NOT NULL,`Tode` int(4) NOT NULL,`SkinID` int(3) NOT NULL,`FraktionSkinID` int(3) NOT NULL,`PaintBallKills` int(10) NOT NULL,`PaintBallTode` int(10) NOT NULL,`PaintBallRang` int(3) NOT NULL,`PaintBallBesuche` int(8) NOT NULL,`AngenommeneReports` int(6) NOT NULL,`KopfGeld` int(10) NOT NULL,`Bankkonto` int(2) NOT NULL,`pArmyPlaneOrder` int(2) NOT NULL,`pArmyHeliOrder` int(2) NOT NULL,`pArmyWaffenOrder` int(2) NOT NULL,`LevelUPKosten` int(10) NOT NULL,`RespectForLevelUp` int
26/07/2013-01:33:39 | errorid=1060,error=Duplicate column name 'pMarried',query=ALTER TABLE prp_account_main ADD COLUMN (`pMarried` varchar(24) NOT NULL,`pBuyClothes` int(6) NOT NULL,`pIll` int(10) NOT NULL,`pConterminatedTime` int(10) NOT NULL,`pBitchSkill` int(10) NOT NULL,`pBitchFuckCount` int(10) NOT NULL,`pMedicHealplayerSkill` int(10) NOT NULL,`pMedicHealCount` int(10) NOT NULL)
26/07/2013-01:33:39 | errorid=1064,error=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 '' at line 1,query=CREATE TABLE IF NOT EXISTS `prp_races` (`race` varchar(32) NOT NULL,`fID` int(3) NOT NULL, `rmode` int(3) NOT NULL,`X1` float(10,4) NOT NULL,`Y1` float(10,4) NOT NULL,`Z1` float(10,4) NOT NULL,`CP_TYP1` int(3) NOT NULL,`CP_SIZE1` float (10,4) NOT NULL,`X2` float(10,4) NOT NULL,`Y2` float(10,4) NOT NULL,`Z2` float(10,4) NOT NULL,`CP_TYP2` int(3) NOT NULL,`CP_SIZE2` float (10,4) NOT NULL,`X3` float(10,4) NOT NULL,`Y3` float(10,4) NOT NULL,`Z3` float(10,4) NOT NULL,`CP_TYP3` int(3) NOT NULL,`CP_SIZE3` float (10,4) NOT NULL,`X4` float(10,4) NOT NULL,`Y4` float(10,4) NOT NULL,`Z4` float(10,4) NOT NULL,`CP_TYP4` int(3) NOT NULL,`CP_SIZE4` float (10,4) NOT NULL,`X5` float(10,4) NOT NULL,`Y5` float(10,4) NOT NULL,`Z5` float(
26/07/2013-01:33:39 | errorid=1064,error=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 'blacklistreason0,blacklist1,blacklistreason1,blacklist2,blacklistreason2,blackli' at line 1,query=CREATE TABLE IF NOT EXISTS `prp_account_blacklist` (`Name` varchar(24) NOT NULL,blacklist0,blacklistreason0,blacklist1,blacklistreason1,blacklist2,blacklistreason2,blacklist3,blacklistreason3,blacklist4,blacklistreason4,blacklist5,blacklistreason5,blacklist6,blacklistreason6,blacklist7,blacklistreason7,blacklist8,blacklistreason8,blacklist9,blacklistreason9,blacklist10,blacklistreason10,blacklist11,blacklistreason11,blacklist12,blacklistreason12,blacklist13,blacklistreason13,blacklist14,blacklistreason14,blacklist15,blacklistreason15,blacklist16,blacklistreason16,blacklist17,blacklistreason17,blacklist18,blacklistreason18,PRIMARY KEY (`Nam
Die Datenbanken werden automatisch erstellt außer die "prp_races". Wenn ich sie aber manuell erstelle und Werte hinein schreibe werden diese im Script ausgelesen.
Ich kann vom Script aus nur keine Werte einfügen, z.B. Rennen erstellen.
Weiß jemand wie ich vorgehen muss? Danke im Voraus