[MYSQL] pRP Save Problem

Chilltime. · 24. Juni 2013

Moin

Ich möchte mit mein Kumpel über die Sommerferien samp zocken also über lan und dafür habe ich das pRP script genommen weil mir das am besten gefallen hat.

Mein Problem ist das dass die Ingame Sachen wie z.B. die Accounts nicht in der Datenbank gespeichert werden. Laut den Logs wurde eine erfolgreiche Verbindung mit der DB hergestellt.
ich weiß einfach nicht woran es liegen könnte

hoffe ihr könnt mir weiterhelfen

Raphael · 24. Juni 2013

mysql_debug(1) sollte dir Helfen unter OnGameModeInit

'VaniC<~ · 24. Juni 2013

und noch eins,

Chilltime hat den Server hochgefahren er kann joinen aber ich nicht da er bei mir als offline gezeigt wird, wie kann Mann nun den Server mit hamachi kompatibel machen?

mfg

Raphael · 24. Juni 2013

Hamashi Downloaden
Hamashi Installieren
Chilltime öffnet den Server
Du conntectest mit Chilltime's Hamashi IP : PORT
Und dann Sollte es gehen,

Ansonsten muss Chilltime einfach seine Port's Freigeben in seinem Router

Chilltime. · 24. Juni 2013

trotz debug klappts immernoch nicht genau das selbe problem

Raphael · 24. Juni 2013

Weisst du auch wofür Mysql_debug ist ?
Das ist keine Funktion damit es Laden / Saven tut, damit siehst du wo der Fehler liegt beim Saven

.SleY · 24. Juni 2013

Damit du conecten kannst, Stell die Firewall aus Geht bei mir auch nur so

Chilltime. · 24. Juni 2013

und wo kann ich die Fehler einlesen? in Serverlog ist nichts zu finden.

aber sehe grade in Mysql Log sind ein paar sachen.

Code

24/06/2013-13:26:08 | 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 'blacklist0,blacklistreason0,blacklist1,blacklistreason1,blacklist2,blacklistreas' at line 1,query=CREATE TABLE IF NOT EXISTS `YNL_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,PRIMARY KEY (`Name`))
24/06/2013-13:26:14 | errorid=1364,error=Field 'GangWarZoneAttacker' doesn't have a default value,query=INSERT INTO YNL_gangwar (GangZoneID,GangWarZoneOwner) VALUES ('0','0')
24/06/2013-13:26:14 | errorid=1364,error=Field 'GangWarZoneAttacker' doesn't have a default value,query=INSERT INTO YNL_gangwar (GangZoneID,GangWarZoneOwner) VALUES ('1','0')
24/06/2013-13:26:14 | errorid=1364,error=Field 'GangWarZoneAttacker' doesn't have a default value,query=INSERT INTO YNL_gangwar (GangZoneID,GangWarZoneOwner) VALUES ('2','0')
24/06/2013-13:26:14 | errorid=1364,error=Field 'GangWarZoneAttacker' doesn't have a default value,query=INSERT INTO YNL_gangwar (GangZoneID,GangWarZoneOwner) VALUES ('3','0')
24/06/2013-13:26:14 | errorid=1364,error=Field 'GangWarZoneAttacker' doesn't have a default value,query=INSERT INTO YNL_gangwar (GangZoneID,GangWarZoneOwner) VALUES ('4','0')
24/06/2013-13:26:14 | errorid=1364,error=Field 'GangWarZoneAttacker' doesn't have a default value,query=INSERT INTO YNL_gangwar (GangZoneID,GangWarZoneOwner) VALUES ('5','0')
24/06/2013-13:26:14 | errorid=1364,error=Field 'GangWarZoneAttacker' doesn't have a default value,query=INSERT INTO YNL_gangwar (GangZoneID,GangWarZoneOwner) VALUES ('6','0')
24/06/2013-13:26:14 | errorid=1364,error=Field 'GangWarZoneAttacker' doesn't have a default value,query=INSERT INTO YNL_gangwar (GangZoneID,GangWarZoneOwner) VALUES ('7','0')
24/06/2013-13:26:14 | errorid=1364,error=Field 'GangWarZoneAttacker' doesn't have a default value,query=INSERT INTO YNL_gangwar (GangZoneID,GangWarZoneOwner) VALUES ('8','0')
24/06/2013-13:26:14 | errorid=1364,error=Field 'GangWarZoneAttacker' doesn't have a default value,query=INSERT INTO YNL_gangwar (GangZoneID,GangWarZoneOwner) VALUES ('9','0')
24/06/2013-13:26:14 | errorid=1364,error=Field 'GangWarZoneAttacker' doesn't have a default value,query=INSERT INTO YNL_gangwar (GangZoneID,GangWarZoneOwner) VALUES ('10','0')
24/06/2013-13:26:14 | errorid=1364,error=Field 'GangWarZoneAttacker' doesn't have a default value,query=INSERT INTO YNL_gangwar (GangZoneID,GangWarZoneOwner) VALUES ('11','0')
24/06/2013-13:26:14 | errorid=1364,error=Field 'GangWarZoneAttacker' doesn't have a default value,query=INSERT INTO YNL_gangwar (GangZoneID,GangWarZoneOwner) VALUES ('12','0')
24/06/2013-13:26:14 | errorid=1364,error=Field 'GangWarZoneAttacker' doesn't have a default value,query=INSERT INTO YNL_gangwar (GangZoneID,GangWarZoneOwner) VALUES ('13','0')
24/06/2013-13:26:16 | errorid=1364,error=Field 'id' doesn't have a default value,query=INSERT INTO `YNL_stuff` (ADPreis,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,SAPDpay,FBIpay,SAFDpay,ARMYpay,OAMTpay,GOVpay,WorkLessMoney,BlitzerToleranz,Reichensteuer,JobSperreFree,AngelLicPrice,PersoLicPrice,WeapPrice,ParkPrice) VALUES ('250','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','NO-ONE','NO-ONE','NO-ONE','NO-
24/06/2013-13:26:16 | errorid=1364,error=Field 'GFFID' doesn't have a default value,query=INSERT INTO YNL_fraktion_verwaltung (fID,Geld,Opium,Ganja,Kokain,C4,Materials,WaffenPack,WaffenSlots,Heal,HealSlots,Armour,ArmourSlots,HaveVBInvite,VBFraktion,F0,F1,F2,F3,F4,F5,F6) VALUES ('0','500000','0','0','0','0','200000','1','50','1','50','1','50','0','0','R0','R1','R2','R3','R4','R5','R6')
24/06/2013-13:26:16 | errorid=1364,error=Field 'GFFID' doesn't have a default value,query=INSERT INTO YNL_fraktion_verwaltung (fID,Geld,Opium,Ganja,Kokain,C4,Materials,WaffenPack,WaffenSlots,Heal,HealSlots,Armour,ArmourSlots,HaveVBInvite,VBFraktion,F0,F1,F2,F3,F4,F5,F6) VALUES ('1','500000','0','0','0','0','200000','1','50','1','50','1','50','0','0','R0','R1','R2','R3','R4','R5','R6')
24/06/2013-13:26:16 | errorid=1364,error=Field 'GFFID' doesn't have a default value,query=INSERT INTO YNL_fraktion_verwaltung (fID,Geld,Opium,Ganja,Kokain,C4,Materials,WaffenPack,WaffenSlots,Heal,HealSlots,Armour,ArmourSlots,HaveVBInvite,VBFraktion,F0,F1,F2,F3,F4,F5,F6) VALUES ('2','500000','0','0','0','0','200000','1','50','1','50','1','50','0','0','R0','R1','R2','R3','R4','R5','R6')
24/06/2013-13:26:16 | errorid=1364,error=Field 'GFFID' doesn't have a default value,query=INSERT INTO YNL_fraktion_verwaltung (fID,Geld,Opium,Ganja,Kokain,C4,Materials,WaffenPack,WaffenSlots,Heal,HealSlots,Armour,ArmourSlots,HaveVBInvite,VBFraktion,F0,F1,F2,F3,F4,F5,F6) VALUES ('3','500000','0','0','0','0','200000','1','50','1','50','1','50','0','0','R0','R1','R2','R3','R4','R5','R6')
24/06/2013-13:26:16 | errorid=1364,error=Field 'GFFID' doesn't have a default value,query=INSERT INTO YNL_fraktion_verwaltung (fID,Geld,Opium,Ganja,Kokain,C4,Materials,WaffenPack,WaffenSlots,Heal,HealSlots,Armour,ArmourSlots,HaveVBInvite,VBFraktion,F0,F1,F2,F3,F4,F5,F6) VALUES ('4','500000','0','0','0','0','200000','1','50','1','50','1','50','0','0','R0','R1','R2','R3','R4','R5','R6')
24/06/2013-13:26:16 | errorid=1364,error=Field 'GFFID' doesn't have a default value,query=INSERT INTO YNL_fraktion_verwaltung (fID,Geld,Opium,Ganja,Kokain,C4,Materials,WaffenPack,WaffenSlots,Heal,HealSlots,Armour,ArmourSlots,HaveVBInvite,VBFraktion,F0,F1,F2,F3,F4,F5,F6) VALUES ('5','500000','0','0','0','0','200000','1','50','1','50','1','50','0','0','R0','R1','R2','R3','R4','R5','R6')
24/06/2013-13:26:16 | errorid=1364,error=Field 'GFFID' doesn't have a default value,query=INSERT INTO YNL_fraktion_verwaltung (fID,Geld,Opium,Ganja,Kokain,C4,Materials,WaffenPack,WaffenSlots,Heal,HealSlots,Armour,ArmourSlots,HaveVBInvite,VBFraktion,F0,F1,F2,F3,F4,F5,F6) VALUES ('6','500000','0','0','0','0','200000','1','50','1','50','1','50','0','0','R0','R1','R2','R3','R4','R5','R6')
24/06/2013-13:26:16 | errorid=1364,error=Field 'GFFID' doesn't have a default value,query=INSERT INTO YNL_fraktion_verwaltung (fID,Geld,Opium,Ganja,Kokain,C4,Materials,WaffenPack,WaffenSlots,Heal,HealSlots,Armour,ArmourSlots,HaveVBInvite,VBFraktion,F0,F1,F2,F3,F4,F5,F6) VALUES ('7','500000','0','0','0','0','200000','1','50','1','50','1','50','0','0','R0','R1','R2','R3','R4','R5','R6')
24/06/2013-13:26:16 | errorid=1364,error=Field 'GFFID' doesn't have a default value,query=INSERT INTO YNL_fraktion_verwaltung (fID,Geld,Opium,Ganja,Kokain,C4,Materials,WaffenPack,WaffenSlots,Heal,HealSlots,Armour,ArmourSlots,HaveVBInvite,VBFraktion,F0,F1,F2,F3,F4,F5,F6) VALUES ('8','500000','0','0','0','0','200000','1','50','1','50','1','50','0','0','R0','R1','R2','R3','R4','R5','R6')
24/06/2013-13:26:16 | errorid=1364,error=Field 'GFFID' doesn't have a default value,query=INSERT INTO YNL_fraktion_verwaltung (fID,Geld,Opium,Ganja,Kokain,C4,Materials,WaffenPack,WaffenSlots,Heal,HealSlots,Armour,ArmourSlots,HaveVBInvite,VBFraktion,F0,F1,F2,F3,F4,F5,F6) VALUES ('9','500000','0','0','0','0','200000','1','50','1','50','1','50','0','0','R0','R1','R2','R3','R4','R5','R6')
24/06/2013-13:26:16 | errorid=1364,error=Field 'GFFID' doesn't have a default value,query=INSERT INTO YNL_fraktion_verwaltung (fID,Geld,Opium,Ganja,Kokain,C4,Materials,WaffenPack,WaffenSlots,Heal,HealSlots,Armour,ArmourSlots,HaveVBInvite,VBFraktion,F0,F1,F2,F3,F4,F5,F6) VALUES ('10','500000','0','0','0','0','200000','1','50','1','50','1','50','0','0','R0','R1','R2','R3','R4','R5','R6')
24/06/2013-13:26:16 | errorid=1364,error=Field 'GFFID' doesn't have a default value,query=INSERT INTO YNL_fraktion_verwaltung (fID,Geld,Opium,Ganja,Kokain,C4,Materials,WaffenPack,WaffenSlots,Heal,HealSlots,Armour,ArmourSlots,HaveVBInvite,VBFraktion,F0,F1,F2,F3,F4,F5,F6) VALUES ('11','500000','0','0','0','0','200000','1','50','1','50','1','50','0','0','R0','R1','R2','R3','R4','R5','R6')
24/06/2013-13:26:16 | errorid=1364,error=Field 'GFFID' doesn't have a default value,query=INSERT INTO YNL_fraktion_verwaltung (fID,Geld,Opium,Ganja,Kokain,C4,Materials,WaffenPack,WaffenSlots,Heal,HealSlots,Armour,ArmourSlots,HaveVBInvite,VBFraktion,F0,F1,F2,F3,F4,F5,F6) VALUES ('12','500000','0','0','0','0','200000','1','50','1','50','1','50','0','0','R0','R1','R2','R3','R4','R5','R6')
24/06/2013-13:26:16 | errorid=1364,error=Field 'GFFID' doesn't have a default value,query=INSERT INTO YNL_fraktion_verwaltung (fID,Geld,Opium,Ganja,Kokain,C4,Materials,WaffenPack,WaffenSlots,Heal,HealSlots,Armour,ArmourSlots,HaveVBInvite,VBFraktion,F0,F1,F2,F3,F4,F5,F6) VALUES ('13','500000','0','0','0','0','200000','1','50','1','50','1','50','0','0','R0','R1','R2','R3','R4','R5','R6')
24/06/2013-13:26:16 | errorid=1364,error=Field 'GFFID' doesn't have a default value,query=INSERT INTO YNL_fraktion_verwaltung (fID,Geld,Opium,Ganja,Kokain,C4,Materials,WaffenPack,WaffenSlots,Heal,HealSlots,Armour,ArmourSlots,HaveVBInvite,VBFraktion,F0,F1,F2,F3,F4,F5,F6) VALUES ('14','500000','0','0','0','0','200000','1','50','1','50','1','50','0','0','R0','R1','R2','R3','R4','R5','R6')
24/06/2013-13:26:16 | errorid=1364,error=Field 'GFFID' doesn't have a default value,query=INSERT INTO YNL_fraktion_verwaltung (fID,Geld,Opium,Ganja,Kokain,C4,Materials,WaffenPack,WaffenSlots,Heal,HealSlots,Armour,ArmourSlots,HaveVBInvite,VBFraktion,F0,F1,F2,F3,F4,F5,F6) VALUES ('15','500000','0','0','0','0','200000','1','50','1','50','1','50','0','0','R0','R1','R2','R3','R4','R5','R6')
24/06/2013-13:26:16 | errorid=1364,error=Field 'GFFID' doesn't have a default value,query=INSERT INTO YNL_fraktion_verwaltung (fID,Geld,Opium,Ganja,Kokain,C4,Materials,WaffenPack,WaffenSlots,Heal,HealSlots,Armour,ArmourSlots,HaveVBInvite,VBFraktion,F0,F1,F2,F3,F4,F5,F6) VALUES ('16','500000','0','0','0','0','200000','1','50','1','50','1','50','0','0','R0','R1','R2','R3','R4','R5','R6')
24/06/2013-13:26:16 | errorid=1364,error=Field 'GFFID' doesn't have a default value,query=INSERT INTO YNL_fraktion_verwaltung (fID,Geld,Opium,Ganja,Kokain,C4,Materials,WaffenPack,WaffenSlots,Heal,HealSlots,Armour,ArmourSlots,HaveVBInvite,VBFraktion,F0,F1,F2,F3,F4,F5,F6) VALUES ('17','500000','0','0','0','0','200000','1','50','1','50','1','50','0','0','R0','R1','R2','R3','R4','R5','R6')

Alles anzeigen

//edit Firewall ist bereits aus.

breadfish.de 12. März 2022