5 Errors die ich nicht weg bekomme

robbi2304 · 8. März 2017

Zitat von Slider

Kannst Du mal bitte erlaeutern, wieso das ein Fehler gewesen ist?

Das gab seine Log noch aus

[22:31:47 03/07/17] [ERROR] CMySQLQuery::Execute[] - (error #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 'WHERE `id` = '1'' at line 1 (Query: " WHERE `id` = '1'")

Von daher dachte ich mir einfach mal vielleicht klappt es wenn man die Abfrage etwas umschreibt,
Ich sehe nun auch kein Grund mehr warum er nicht speichern soll.
Nur frage ich mich wo du String abfragst

linux_ · 8. März 2017

Die Backticks sind in SQL kein Fehler. Die sagen nur aus, dass was da drinnen steht, nicht als SQL Keyword verstanden wird. Somit war das einfach korrekt. Die Variable `string` die er hat ist einfach leer wie man auch im Error sieht. Und das ' kannst Du Dir sparen bei `id` = weil Integer keine Anfuehrungszeichen benoetigen.

RedDragon28080 · 8. März 2017

das hat mir aber auch nicht geholfen habe immer noch das gleiche problem

Kaliber · 8. März 2017

Dann lass dir mal das ganze Query ausgeben und poste es mal hier (da wo du diesen Fehler bekommst)

RedDragon28080 · 8. März 2017

Zitat von Kaliber

Dann lass dir mal das ganze Query ausgeben und poste es mal hier (da wo du diesen Fehler bekommst)

hier bitte

CSS: Server_log

[12:14:00] params: 560 1
[12:14:00] faction0: 1
[12:14:00] Setze 1 auf -255
[12:14:00] Setze 2 auf -255
[12:14:00] Setze 3 auf -255
[12:14:00] Setze 4 auf -255
[12:14:00] f0 = 1
[12:14:00] f0 set 1
[12:14:00] f1 = -255
[12:14:00] f1 set -255
[12:14:00] f2 = -255
[12:14:00] f2 set -255
[12:14:00] f3 = -255
[12:14:00] f3 set -255
[12:14:00] f4 = -255
[12:14:00] f4 set -255
[12:14:00] Carid: 192
[12:14:00] pstring: LyL-PD- 1
[12:14:00] Fertig.
[12:14:03]  WHERE `ID` = '0'
[12:14:40] Admin RedDragon28080 hat den Spieler RedDragon28080 sein Level auf 5 gesetzt
[12:14:57] `fSperrpreis`='0'  WHERE ID = '0'
[12:15:04] Admin RedDragon28080 hat sich zu diese Koordinaten (X 1743.626464 ,Y -1903.989868 ,Z 33.556762) geportet
[12:15:59] `fSperrpreis`='0'  WHERE ID = '0'

Alles anzeigen

CSS: msql_log

[12:20:54 03/08/17] [DEBUG] mysql_pquery - connection: 1, query: "ALTER TABLE `FracVehicles` ADD `fCarid` varchar(11) NOT NULL DEF", callback: "(null)", format: "(null)"
[12:20:54 03/08/17] [DEBUG] mysql_pquery - connection: 1, query: "ALTER TABLE `FracVehicles` ADD `fVehid` varchar(11) NOT NULL DEF", callback: "(null)", format: "(null)"
[12:20:54 03/08/17] [DEBUG] mysql_pquery - connection: 1, query: "ALTER TABLE `FracVehicles` ADD `fPosX` float NOT NULL DEFAULT '0", callback: "(null)", format: "(null)"
[12:20:54 03/08/17] [DEBUG] mysql_pquery - connection: 1, query: "ALTER TABLE `FracVehicles` ADD `fPosY` float NOT NULL DEFAULT '0", callback: "(null)", format: "(null)"
[12:20:54 03/08/17] [DEBUG] mysql_pquery - connection: 1, query: "ALTER TABLE `FracVehicles` ADD `fPosZ` float NOT NULL DEFAULT '0", callback: "(null)", format: "(null)"
[12:20:54 03/08/17] [DEBUG] mysql_pquery - connection: 1, query: "ALTER TABLE `FracVehicles` ADD `fPosA` float NOT NULL DEFAULT '0", callback: "(null)", format: "(null)"
[12:20:54 03/08/17] [DEBUG] mysql_pquery - connection: 1, query: "ALTER TABLE `FracVehicles` ADD `fCol1` varchar(11) NOT NULL DEFA", callback: "(null)", format: "(null)"
[12:20:54 03/08/17] [DEBUG] mysql_pquery - connection: 1, query: "ALTER TABLE `FracVehicles` ADD `fCol2` varchar(11) NOT NULL DEFA", callback: "(null)", format: "(null)"
[12:20:54 03/08/17] [DEBUG] mysql_pquery - connection: 1, query: "ALTER TABLE `FracVehicles` ADD `fFaction1` varchar(11) NOT NULL ", callback: "(null)", format: "(null)"
[12:20:54 03/08/17] [DEBUG] mysql_pquery - connection: 1, query: "ALTER TABLE `FracVehicles` ADD `fFaction2` varchar(11) NOT NULL ", callback: "(null)", format: "(null)"
[12:20:54 03/08/17] [DEBUG] mysql_pquery - connection: 1, query: "ALTER TABLE `FracVehicles` ADD `fFaction3` varchar(11) NOT NULL ", callback: "(null)", format: "(null)"
[12:20:54 03/08/17] [DEBUG] mysql_pquery - connection: 1, query: "ALTER TABLE `FracVehicles` ADD `fFaction4` varchar(11) NOT NULL ", callback: "(null)", format: "(null)"
[12:20:54 03/08/17] [DEBUG] mysql_pquery - connection: 1, query: "ALTER TABLE `FracVehicles` ADD `fFaction5` varchar(11) NOT NULL ", callback: "(null)", format: "(null)"
[12:20:54 03/08/17] [DEBUG] mysql_pquery - connection: 1, query: "ALTER TABLE `FracVehicles` ADD `fSpoiler` varchar(11) NOT NULL D", callback: "(null)", format: "(null)"
[12:20:54 03/08/17] [DEBUG] mysql_pquery - connection: 1, query: "ALTER TABLE `FracVehicles` ADD `fHood` varchar(11) NOT NULL DEFA", callback: "(null)", format: "(null)"
[12:20:54 03/08/17] [DEBUG] mysql_pquery - connection: 1, query: "ALTER TABLE `FracVehicles` ADD `fRoof` varchar(11) NOT NULL DEFA", callback: "(null)", format: "(null)"
[12:20:54 03/08/17] [DEBUG] mysql_pquery - connection: 1, query: "ALTER TABLE `FracVehicles` ADD `fSideskirt` varchar(11) NOT NULL", callback: "(null)", format: "(null)"
[12:20:54 03/08/17] [DEBUG] mysql_pquery - connection: 1, query: "ALTER TABLE `FracVehicles` ADD `fLamps` varchar(11) NOT NULL DEF", callback: "(null)", format: "(null)"
[12:20:54 03/08/17] [DEBUG] mysql_pquery - connection: 1, query: "ALTER TABLE `FracVehicles` ADD `fNitro` varchar(11) NOT NULL DEF", callback: "(null)", format: "(null)"
[12:20:54 03/08/17] [DEBUG] mysql_pquery - connection: 1, query: "ALTER TABLE `FracVehicles` ADD `fExhaust` varchar(11) NOT NULL D", callback: "(null)", format: "(null)"
[12:20:54 03/08/17] [DEBUG] mysql_pquery - connection: 1, query: "ALTER TABLE `FracVehicles` ADD `fWheel` varchar(11) NOT NULL DEF", callback: "(null)", format: "(null)"
[12:20:54 03/08/17] [DEBUG] CMySQLQuery::Execute[] - starting query execution
[12:20:54 03/08/17] [DEBUG] mysql_pquery - connection: 1, query: "ALTER TABLE `FracVehicles` ADD `fStereo` varchar(11) NOT NULL DE", callback: "(null)", format: "(null)"
[12:20:54 03/08/17] [DEBUG] mysql_pquery - connection: 1, query: "ALTER TABLE `FracVehicles` ADD `fHydraulics` varchar(11) NOT NUL", callback: "(null)", format: "(null)"
[12:20:54 03/08/17] [DEBUG] mysql_pquery - connection: 1, query: "ALTER TABLE `FracVehicles` ADD `fFrontBumper` varchar(11) NOT NU", callback: "(null)", format: "(null)"
[12:20:54 03/08/17] [DEBUG] mysql_pquery - connection: 1, query: "ALTER TABLE `FracVehicles` ADD `fVent1` varchar(11) NOT NULL DEF", callback: "(null)", format: "(null)"
[12:20:54 03/08/17] [DEBUG] mysql_pquery - connection: 1, query: "ALTER TABLE `FracVehicles` ADD `fRearBumper` varchar(11) NOT NUL", callback: "(null)", format: "(null)"
[12:20:54 03/08/17] [DEBUG] mysql_pquery - connection: 1, query: "ALTER TABLE `FracVehicles` ADD `fVent2` varchar(11) NOT NULL DEF", callback: "(null)", format: "(null)"
[12:20:54 03/08/17] [DEBUG] mysql_pquery - connection: 1, query: "ALTER TABLE `FracVehicles` ADD `fPaintjob` varchar(11) NOT NULL ", callback: "(null)", format: "(null)"
[12:20:54 03/08/17] [DEBUG] mysql_pquery - connection: 1, query: "ALTER TABLE `FracVehicles` ADD `fPrice` varchar(11) NOT NULL DEF", callback: "(null)", format: "(null)"
[12:20:54 03/08/17] [DEBUG] mysql_pquery - connection: 1, query: "ALTER TABLE `FracVehicles` ADD `fTankart` varchar(11) NOT NULL D", callback: "(null)", format: "(null)"
[12:20:54 03/08/17] [ERROR] CMySQLQuery::Execute[] - (error #1060) Duplicate column name 'fCarid' (Query: "ALTER TABLE `FracVehicles` ADD `fCarid` varchar(11) NOT NULL DEFAULT '0'")
[12:20:54 03/08/17] [DEBUG] mysql_pquery - connection: 1, query: "ALTER TABLE `FracVehicles` ADD `fGesperrt` varchar(11) NOT NULL ", callback: "(null)", format: "(null)"
[12:20:54 03/08/17] [DEBUG] CMySQLQuery::Execute[] - error will be triggered in OnQueryError
[12:20:54 03/08/17] [DEBUG] CMySQLQuery::Execute[] - starting query execution
[12:20:54 03/08/17] [DEBUG] mysql_pquery - connection: 1, query: "ALTER TABLE `FracVehicles` ADD `fMotorschaden` varchar(11) NOT N", callback: "(null)", format: "(null)"
[12:20:54 03/08/17] [DEBUG] mysql_pquery - connection: 1, query: "ALTER TABLE `FracVehicles` ADD `fSperrpreis` varchar(11) NOT NUL", callback: "(null)", format: "(null)"
[12:20:54 03/08/17] [ERROR] CMySQLQuery::Execute[] - (error #1060) Duplicate column name 'fPosX' (Query: "ALTER TABLE `FracVehicles` ADD `fPosX` float NOT NULL DEFAULT '0.0'")
[12:20:54 03/08/17] [DEBUG] CMySQLQuery::Execute[] - error will be triggered in OnQueryError
[12:20:54 03/08/17] [DEBUG] CMySQLQuery::Execute[] - starting query execution
[12:20:54 03/08/17] [ERROR] CMySQLQuery::Execute[] - (error #1060) Duplicate column name 'fPosZ' (Query: "ALTER TABLE `FracVehicles` ADD `fPosZ` float NOT NULL DEFAULT '0.0'")
[12:20:54 03/08/17] [DEBUG] CMySQLQuery::Execute[] - error will be triggered in OnQueryError
[12:20:54 03/08/17] [DEBUG] CMySQLQuery::Execute[] - starting query execution
[12:20:54 03/08/17] [ERROR] CMySQLQuery::Execute[] - (error #1060) Duplicate column name 'fCol1' (Query: "ALTER TABLE `FracVehicles` ADD `fCol1` varchar(11) NOT NULL DEFAULT '0'")
[12:20:54 03/08/17] [DEBUG] CMySQLQuery::Execute[] - error will be triggered in OnQueryError
[12:20:54 03/08/17] [DEBUG] CMySQLQuery::Execute[] - starting query execution
[12:20:54 03/08/17] [ERROR] CMySQLQuery::Execute[] - (error #1060) Duplicate column name 'fFaction1' (Query: "ALTER TABLE `FracVehicles` ADD `fFaction1` varchar(11) NOT NULL DEFAULT '0'")
[12:20:54 03/08/17] [DEBUG] CMySQLQuery::Execute[] - error will be triggered in OnQueryError
[12:20:54 03/08/17] [DEBUG] CMySQLQuery::Execute[] - starting query execution
[12:20:54 03/08/17] [ERROR] CMySQLQuery::Execute[] - (error #1060) Duplicate column name 'fFaction3' (Query: "ALTER TABLE `FracVehicles` ADD `fFaction3` varchar(11) NOT NULL DEFAULT '0'")
[12:20:54 03/08/17] [DEBUG] CMySQLQuery::Execute[] - error will be triggered in OnQueryError
[12:20:54 03/08/17] [DEBUG] CMySQLQuery::Execute[] - starting query execution
[12:20:54 03/08/17] [ERROR] CMySQLQuery::Execute[] - (error #1060) Duplicate column name 'fFaction5' (Query: "ALTER TABLE `FracVehicles` ADD `fFaction5` varchar(11) NOT NULL DEFAULT '0'")
[12:20:54 03/08/17] [DEBUG] CMySQLQuery::Execute[] - error will be triggered in OnQueryError
[12:20:54 03/08/17] [DEBUG] CMySQLQuery::Execute[] - starting query execution
[12:20:54 03/08/17] [ERROR] CMySQLQuery::Execute[] - (error #1060) Duplicate column name 'fHood' (Query: "ALTER TABLE `FracVehicles` ADD `fHood` varchar(11) NOT NULL DEFAULT '0'")
[12:20:54 03/08/17] [DEBUG] CMySQLQuery::Execute[] - error will be triggered in OnQueryError
[12:20:54 03/08/17] [DEBUG] CMySQLQuery::Execute[] - starting query execution
[12:20:54 03/08/17] [ERROR] CMySQLQuery::Execute[] - (error #1060) Duplicate column name 'fSideskirt' (Query: "ALTER TABLE `FracVehicles` ADD `fSideskirt` varchar(11) NOT NULL DEFAULT '0'")
[12:20:54 03/08/17] [DEBUG] CMySQLQuery::Execute[] - error will be triggered in OnQueryError
[12:20:54 03/08/17] [DEBUG] CMySQLQuery::Execute[] - starting query execution
[12:20:54 03/08/17] [ERROR] CMySQLQuery::Execute[] - (error #1060) Duplicate column name 'fNitro' (Query: "ALTER TABLE `FracVehicles` ADD `fNitro` varchar(11) NOT NULL DEFAULT '0'")
[12:20:54 03/08/17] [DEBUG] CMySQLQuery::Execute[] - error will be triggered in OnQueryError
[12:20:54 03/08/17] [DEBUG] CMySQLQuery::Execute[] - starting query execution
[12:20:54 03/08/17] [ERROR] CMySQLQuery::Execute[] - (error #1060) Duplicate column name 'fWheel' (Query: "ALTER TABLE `FracVehicles` ADD `fWheel` varchar(11) NOT NULL DEFAULT '0'")
[12:20:54 03/08/17] [DEBUG] CMySQLQuery::Execute[] - error will be triggered in OnQueryError
[12:20:54 03/08/17] [DEBUG] CMySQLQuery::Execute[] - starting query execution
[12:20:54 03/08/17] [ERROR] CMySQLQuery::Execute[] - (error #1060) Duplicate column name 'fHydraulics' (Query: "ALTER TABLE `FracVehicles` ADD `fHydraulics` varchar(11) NOT NULL DEFAULT '0'")
[12:20:54 03/08/17] [DEBUG] CMySQLQuery::Execute[] - error will be triggered in OnQueryError
[12:20:54 03/08/17] [DEBUG] CMySQLQuery::Execute[] - starting query execution
[12:20:54 03/08/17] [ERROR] CMySQLQuery::Execute[] - (error #1060) Duplicate column name 'fVent1' (Query: "ALTER TABLE `FracVehicles` ADD `fVent1` varchar(11) NOT NULL DEFAULT '0'")
[12:20:54 03/08/17] [DEBUG] CMySQLQuery::Execute[] - error will be triggered in OnQueryError
[12:20:54 03/08/17] [DEBUG] CMySQLQuery::Execute[] - starting query execution
[12:20:54 03/08/17] [ERROR] CMySQLQuery::Execute[] - (error #1060) Duplicate column name 'fVent2' (Query: "ALTER TABLE `FracVehicles` ADD `fVent2` varchar(11) NOT NULL DEFAULT '0'")
[12:20:54 03/08/17] [DEBUG] CMySQLQuery::Execute[] - error will be triggered in OnQueryError
[12:20:54 03/08/17] [DEBUG] CMySQLQuery::Execute[] - starting query execution
[12:20:54 03/08/17] [DEBUG] CMySQLQuery::Execute[] - starting query execution
[12:20:54 03/08/17] [ERROR] CMySQLQuery::Execute[] - (error #1060) Duplicate column name 'fPrice' (Query: "ALTER TABLE `FracVehicles` ADD `fPrice` varchar(11) NOT NULL DEFAULT '0'")
[12:20:54 03/08/17] [DEBUG] CMySQLQuery::Execute[] - error will be triggered in OnQueryError
[12:20:54 03/08/17] [DEBUG] CMySQLQuery::Execute[] - starting query execution
[12:20:54 03/08/17] [ERROR] CMySQLQuery::Execute[] - (error #1060) Duplicate column name 'fVehid' (Query: "ALTER TABLE `FracVehicles` ADD `fVehid` varchar(11) NOT NULL DEFAULT '0'")
[12:20:54 03/08/17] [DEBUG] CMySQLQuery::Execute[] - error will be triggered in OnQueryError
[12:20:54 03/08/17] [DEBUG] CMySQLQuery::Execute[] - starting query execution
[12:20:54 03/08/17] [ERROR] CMySQLQuery::Execute[] - (error #1060) Duplicate column name 'fGesperrt' (Query: "ALTER TABLE `FracVehicles` ADD `fGesperrt` varchar(11) NOT NULL DEFAULT '0'")
[12:20:54 03/08/17] [DEBUG] CMySQLQuery::Execute[] - error will be triggered in OnQueryError
[12:20:54 03/08/17] [DEBUG] CMySQLQuery::Execute[] - starting query execution
[12:20:54 03/08/17] [ERROR] CMySQLQuery::Execute[] - (error #1060) Duplicate column name 'fPosY' (Query: "ALTER TABLE `FracVehicles` ADD `fPosY` float NOT NULL DEFAULT '0.0'")
[12:20:54 03/08/17] [DEBUG] CMySQLQuery::Execute[] - error will be triggered in OnQueryError
[12:20:54 03/08/17] [DEBUG] CMySQLQuery::Execute[] - starting query execution
[12:20:54 03/08/17] [ERROR] CMySQLQuery::Execute[] - (error #1060) Duplicate column name 'fPosA' (Query: "ALTER TABLE `FracVehicles` ADD `fPosA` float NOT NULL DEFAULT '0.0'")
[12:20:54 03/08/17] [DEBUG] CMySQLQuery::Execute[] - error will be triggered in OnQueryError
[12:20:54 03/08/17] [DEBUG] CMySQLQuery::Execute[] - starting query execution
[12:20:54 03/08/17] [ERROR] CMySQLQuery::Execute[] - (error #1060) Duplicate column name 'fSperrpreis' (Query: "ALTER TABLE `FracVehicles` ADD `fSperrpreis` varchar(11) NOT NULL DEFAULT '0'")
[12:20:54 03/08/17] [DEBUG] CMySQLQuery::Execute[] - error will be triggered in OnQueryError
[12:20:54 03/08/17] [ERROR] CMySQLQuery::Execute[] - (error #1060) Duplicate column name 'fCol2' (Query: "ALTER TABLE `FracVehicles` ADD `fCol2` varchar(11) NOT NULL DEFAULT '0'")
[12:20:54 03/08/17] [DEBUG] CMySQLQuery::Execute[] - error will be triggered in OnQueryError
[12:20:54 03/08/17] [DEBUG] CMySQLQuery::Execute[] - starting query execution
[12:20:54 03/08/17] [ERROR] CMySQLQuery::Execute[] - (error #1060) Duplicate column name 'fFaction2' (Query: "ALTER TABLE `FracVehicles` ADD `fFaction2` varchar(11) NOT NULL DEFAULT '0'")
[12:20:54 03/08/17] [DEBUG] CMySQLQuery::Execute[] - error will be triggered in OnQueryError
[12:20:54 03/08/17] [DEBUG] CMySQLQuery::Execute[] - starting query execution
[12:20:54 03/08/17] [ERROR] CMySQLQuery::Execute[] - (error #1060) Duplicate column name 'fFaction4' (Query: "ALTER TABLE `FracVehicles` ADD `fFaction4` varchar(11) NOT NULL DEFAULT '0'")
[12:20:54 03/08/17] [DEBUG] CMySQLQuery::Execute[] - error will be triggered in OnQueryError
[12:20:54 03/08/17] [DEBUG] CMySQLQuery::Execute[] - starting query execution
[12:20:54 03/08/17] [ERROR] CMySQLQuery::Execute[] - (error #1060) Duplicate column name 'fSpoiler' (Query: "ALTER TABLE `FracVehicles` ADD `fSpoiler` varchar(11) NOT NULL DEFAULT '0'")
[12:20:54 03/08/17] [DEBUG] CMySQLQuery::Execute[] - error will be triggered in OnQueryError
[12:20:54 03/08/17] [DEBUG] CMySQLQuery::Execute[] - starting query execution
[12:20:54 03/08/17] [ERROR] CMySQLQuery::Execute[] - (error #1060) Duplicate column name 'fRoof' (Query: "ALTER TABLE `FracVehicles` ADD `fRoof` varchar(11) NOT NULL DEFAULT '0'")
[12:20:54 03/08/17] [DEBUG] CMySQLQuery::Execute[] - error will be triggered in OnQueryError
[12:20:54 03/08/17] [DEBUG] CMySQLQuery::Execute[] - starting query execution
[12:20:54 03/08/17] [ERROR] CMySQLQuery::Execute[] - (error #1060) Duplicate column name 'fLamps' (Query: "ALTER TABLE `FracVehicles` ADD `fLamps` varchar(11) NOT NULL DEFAULT '0'")
[12:20:54 03/08/17] [DEBUG] CMySQLQuery::Execute[] - error will be triggered in OnQueryError
[12:20:54 03/08/17] [DEBUG] CMySQLQuery::Execute[] - starting query execution
[12:20:54 03/08/17] [ERROR] CMySQLQuery::Execute[] - (error #1060) Duplicate column name 'fExhaust' (Query: "ALTER TABLE `FracVehicles` ADD `fExhaust` varchar(11) NOT NULL DEFAULT '0'")
[12:20:54 03/08/17] [DEBUG] CMySQLQuery::Execute[] - error will be triggered in OnQueryError
[12:20:54 03/08/17] [DEBUG] CMySQLQuery::Execute[] - starting query execution
[12:20:54 03/08/17] [ERROR] CMySQLQuery::Execute[] - (error #1060) Duplicate column name 'fStereo' (Query: "ALTER TABLE `FracVehicles` ADD `fStereo` varchar(11) NOT NULL DEFAULT '0'")
[12:20:54 03/08/17] [DEBUG] CMySQLQuery::Execute[] - error will be triggered in OnQueryError
[12:20:54 03/08/17] [DEBUG] CMySQLQuery::Execute[] - starting query execution
[12:20:54 03/08/17] [ERROR] CMySQLQuery::Execute[] - (error #1060) Duplicate column name 'fFrontBumper' (Query: "ALTER TABLE `FracVehicles` ADD `fFrontBumper` varchar(11) NOT NULL DEFAULT '0'")
[12:20:54 03/08/17] [DEBUG] CMySQLQuery::Execute[] - error will be triggered in OnQueryError
[12:20:54 03/08/17] [DEBUG] CMySQLQuery::Execute[] - starting query execution
[12:20:54 03/08/17] [ERROR] CMySQLQuery::Execute[] - (error #1060) Duplicate column name 'fRearBumper' (Query: "ALTER TABLE `FracVehicles` ADD `fRearBumper` varchar(11) NOT NULL DEFAULT '0'")
[12:20:54 03/08/17] [DEBUG] CMySQLQuery::Execute[] - error will be triggered in OnQueryError
[12:20:54 03/08/17] [DEBUG] CMySQLQuery::Execute[] - starting query execution
[12:20:54 03/08/17] [ERROR] CMySQLQuery::Execute[] - (error #1060) Duplicate column name 'fPaintjob' (Query: "ALTER TABLE `FracVehicles` ADD `fPaintjob` varchar(11) NOT NULL DEFAULT '0'")
[12:20:54 03/08/17] [DEBUG] CMySQLQuery::Execute[] - error will be triggered in OnQueryError
[12:20:54 03/08/17] [DEBUG] CMySQLQuery::Execute[] - starting query execution
[12:20:54 03/08/17] [ERROR] CMySQLQuery::Execute[] - (error #1060) Duplicate column name 'fTankart' (Query: "ALTER TABLE `FracVehicles` ADD `fTankart` varchar(11) NOT NULL DEFAULT '0'")
[12:20:54 03/08/17] [DEBUG] CMySQLQuery::Execute[] - error will be triggered in OnQueryError
[12:20:54 03/08/17] [DEBUG] CMySQLQuery::Execute[] - starting query execution
[12:20:54 03/08/17] [ERROR] CMySQLQuery::Execute[] - (error #1060) Duplicate column name 'fMotorschaden' (Query: "ALTER TABLE `FracVehicles` ADD `fMotorschaden` varchar(11) NOT NULL DEFAULT '0'")
[12:20:54 03/08/17] [DEBUG] CMySQLQuery::Execute[] - error will be triggered in OnQueryError

Alles anzeigen

Jeffry · 8. März 2017

Zitat von RedDragon28080

und hier die Speicher Codes

Basierend auf diesem Post (vom Zitat ^ #12) musst du folgende Anpassung machen:
format(query, sizeof(query), "%s`fVehid`='%s', ", string, FactionCars[i][fVehid]);
zu:
format(query, sizeof(query), "%s`fVehid`='%s', ", query, FactionCars[i][fVehid]);

Bei allen Zeilen, in beiden Funktionen (string -> query).
Nehme ich auf meine Kappe, habe es selbst so gepostet. Ohne Compiler ist das nicht aufgefallen.

Alles was zwischen Post #12 und diesem Post gemacht wurde, bitte rückgängig machen und vergessen.

RedDragon28080 · 8. März 2017

es Speichert immer noch nicht ab das Fahrzeug steht immer noch da wo ich es erstellt habe dabei fahre ich es woanders hin und steige aus

Jeffry · 8. März 2017

Wie sieht dein Code zum Speichern jetzt aus, und was sagt der Log?

RedDragon28080 · 8. März 2017

hier die Codes

CSS: codes

public SaveAllFracVehs()
{
	//Deklaration neuer temporärer Variablen:
	new query[3048];


	//Schleife durch alle Fraktions-Fahrzeuge
	for(new i=0; i<MAX_FRAC_VEHICLES; i++)
	{
		//Wenn das Fahrzeug existiert
		if(FactionCars[i][fVehid] >= 400 && FactionCars[i][fVehid] <= 611)
		{
			//Wir fragen die Position des Fahrzeugs ab:
			GetVehiclePos(FactionCars[i][fCarid], FactionCars[i][fPos][0], FactionCars[i][fPos][1], FactionCars[i][fPos][2]);
			GetVehicleZAngle(FactionCars[i][fCarid], FactionCars[i][fPos][3]);


			//Und wir erstellen das Query:
			format(query, sizeof(query), "UPDATE `FracVehicles` SET");
			format(query, sizeof(query), "%s`fVehid`='%d', ", query, FactionCars[i][fVehid]);
			format(query, sizeof(query), "%s`fPosX`='%f', ",  query, FactionCars[i][fPos][0]);
			format(query, sizeof(query), "%s`fPosY`='%f', ",  query, FactionCars[i][fPos][1]);
			format(query, sizeof(query), "%s`fPosZ`='%f', ",  query, FactionCars[i][fPos][2]);
			format(query, sizeof(query), "%s`fPosA`='%f', ",  query, FactionCars[i][fPos][3]);
			format(query, sizeof(query), "%s`fCol1`='%d' ",  query, FactionCars[i][fCol][0]);
			format(query, sizeof(query), "%s`fCol2`='%d' ",  query, FactionCars[i][fCol][1]);
			format(query, sizeof(query), "%s`fFaction1`='%d' ",  query, FactionCars[i][fFaction][0]);
			format(query, sizeof(query), "%s`fFaction2`='%d' ",  query, FactionCars[i][fFaction][1]);
			format(query, sizeof(query), "%s`fFaction3`='%d' ",  query, FactionCars[i][fFaction][2]);
			format(query, sizeof(query), "%s`fFaction4`='%d' ",  query, FactionCars[i][fFaction][3]);
			format(query, sizeof(query), "%s`fFaction5`='%d' ",  query, FactionCars[i][fFaction][4]);
			format(query, sizeof(query), "%s`fSpoiler`='%d' ",  query, FactionCars[i][fTuning][0]);
			format(query, sizeof(query), "%s`fHood`='%d' ",  query, FactionCars[i][fTuning][1]);
			format(query, sizeof(query), "%s`fRoof`='%d' ",  query, FactionCars[i][fTuning][2]);
			format(query, sizeof(query), "%s`fSideskirt`='%d' ",  query, FactionCars[i][fTuning][3]);
			format(query, sizeof(query), "%s`fLamps`='%d' ",  query, FactionCars[i][fTuning][4]);
			format(query, sizeof(query), "%s`fNitro`='%d' ",  query, FactionCars[i][fTuning][5]);
			format(query, sizeof(query), "%s`fExhaust`='%d' ",  query, FactionCars[i][fTuning][6]);
			format(query, sizeof(query), "%s`fWheel`='%d' ",  query, FactionCars[i][fTuning][7]);
			format(query, sizeof(query), "%s`fStereo`='%d' ",  query, FactionCars[i][fTuning][8]);
			format(query, sizeof(query), "%s`fHydraulics`='%d' ",  query, FactionCars[i][fTuning][9]);
			format(query, sizeof(query), "%s`fFrontBumper`='%d' ",  query, FactionCars[i][fTuning][10]);
			format(query, sizeof(query), "%s`fVent1`='%d' ",  query, FactionCars[i][fTuning][11]);
			format(query, sizeof(query), "%s`fRearBumper`='%d' ",  query, FactionCars[i][fTuning][12]);
			format(query, sizeof(query), "%s`fVent2`='%d' ",  query, FactionCars[i][fTuning][13]);
			format(query, sizeof(query), "%s`fPaintjob`='%d' ",  query, FactionCars[i][fTuning][14]);
			format(query, sizeof(query), "%s`fPrice`='%d' ",  query, FactionCars[i][fPrice]);
			format(query, sizeof(query), "%s`fTankart`='%d' ",  query, FactionCars[i][fTankart]);
			format(query, sizeof(query), "%s`fGesperrt`='%d' ",  query, FactionCars[i][fGesperrt]);
			format(query, sizeof(query), "%s`fMotorschaden`='%d' ",  query, FactionCars[i][fMotorschaden]);
			format(query, sizeof(query), "%s`fSperrpreis`='%d' ",  query, FactionCars[i][fSperrpreis]);
			format(query, sizeof(query), "%s WHERE ID = '%d'", query, i);
			mysql_pquery(handle, query);
			printf("%s", query);
			mysql_log(LOG_ALL);
		}
	}
	return 1;
}


stock SaveFracVehCheck(vehicleid)
{
	//Deklaration neuer temporärer Variablen:
	new query[3048];


	//Schleife durch alle Fraktions-Fahrzeuge
	for(new i=0; i<MAX_FRAC_VEHICLES; i++)
	{
		//Wenn die vehicleid die gleiche ist, wie die des Fraktions-Fahrzeugs
		if(FactionCars[i][fCarid] == vehicleid)
		{
			//Wir fragen die Position des Fahrzeugs ab:
			GetVehiclePos(FactionCars[i][fCarid], FactionCars[i][fPos][0], FactionCars[i][fPos][1], FactionCars[i][fPos][2]);
			GetVehicleZAngle(FactionCars[i][fCarid], FactionCars[i][fPos][3]);


			//Und wir erstellen das Query:
			format(query, sizeof(query), "UPDATE `FracVehicles` SET");
			format(query, sizeof(query), "%s`fVehid`='%d', ", query, FactionCars[i][fVehid]);
			format(query, sizeof(query), "%s`fPosX`='%f', ",  query, FactionCars[i][fPos][0]);
			format(query, sizeof(query), "%s`fPosY`='%f', ",  query, FactionCars[i][fPos][1]);
			format(query, sizeof(query), "%s`fPosZ`='%f', ",  query, FactionCars[i][fPos][2]);
			format(query, sizeof(query), "%s`fPosA`='%f', ",  query, FactionCars[i][fPos][3]);
			format(query, sizeof(query), "%s`fCol1`='%d' ",  query, FactionCars[i][fCol][0]);
			format(query, sizeof(query), "%s`fCol2`='%d' ",  query, FactionCars[i][fCol][1]);
			format(query, sizeof(query), "%s`fFaction1`='%d' ",  query, FactionCars[i][fFaction][0]);
			format(query, sizeof(query), "%s`fFaction2`='%d' ",  query, FactionCars[i][fFaction][1]);
			format(query, sizeof(query), "%s`fFaction3`='%d' ",  query, FactionCars[i][fFaction][2]);
			format(query, sizeof(query), "%s`fFaction4`='%d' ",  query, FactionCars[i][fFaction][3]);
			format(query, sizeof(query), "%s`fFaction5`='%d' ",  query, FactionCars[i][fFaction][4]);
			format(query, sizeof(query), "%s`fSpoiler`='%d' ",  query, FactionCars[i][fTuning][0]);
			format(query, sizeof(query), "%s`fHood`='%d' ",  query, FactionCars[i][fTuning][1]);
			format(query, sizeof(query), "%s`fRoof`='%d' ",  query, FactionCars[i][fTuning][2]);
			format(query, sizeof(query), "%s`fSideskirt`='%d' ",  query, FactionCars[i][fTuning][3]);
			format(query, sizeof(query), "%s`fLamps`='%d' ",  query, FactionCars[i][fTuning][4]);
			format(query, sizeof(query), "%s`fNitro`='%d' ",  query, FactionCars[i][fTuning][5]);
			format(query, sizeof(query), "%s`fExhaust`='%d' ",  query, FactionCars[i][fTuning][6]);
			format(query, sizeof(query), "%s`fWheel`='%d' ",  query, FactionCars[i][fTuning][7]);
			format(query, sizeof(query), "%s`fStereo`='%d' ",  query, FactionCars[i][fTuning][8]);
			format(query, sizeof(query), "%s`fHydraulics`='%d' ",  query, FactionCars[i][fTuning][9]);
			format(query, sizeof(query), "%s`fFrontBumper`='%d' ",  query, FactionCars[i][fTuning][10]);
			format(query, sizeof(query), "%s`fVent1`='%d' ",  query, FactionCars[i][fTuning][11]);
			format(query, sizeof(query), "%s`fRearBumper`='%d' ",  query, FactionCars[i][fTuning][12]);
			format(query, sizeof(query), "%s`fVent2`='%d' ",  query, FactionCars[i][fTuning][13]);
			format(query, sizeof(query), "%s`fPaintjob`='%d' ",  query, FactionCars[i][fTuning][14]);
			format(query, sizeof(query), "%s`fPrice`='%d' ",  query, FactionCars[i][fPrice]);
			format(query, sizeof(query), "%s`fTankart`='%d' ",  query, FactionCars[i][fTankart]);
			format(query, sizeof(query), "%s`fGesperrt`='%d' ",  query, FactionCars[i][fGesperrt]);
			format(query, sizeof(query), "%s`fMotorschaden`='%d' ",  query, FactionCars[i][fMotorschaden]);
			format(query, sizeof(query), "%s`fSperrpreis`='%d' ",  query, FactionCars[i][fSperrpreis]);
			format(query, sizeof(query), "%s WHERE ID = '%d'", query, i);
			mysql_pquery(handle, query);
			printf("%s", query);
			mysql_log(LOG_ALL);
			return 1; //Es gibt ja keine zwei gleichen Fahrzeuge
		}
	}
	return 0; //Fahrzeug ist kein Fraktions-Fahrzeug
}

Alles anzeigen

_log´s

CSS: Server_log

[20:26:58] UPDATE `FracVehicles` SET`fVehid`='560', `fPosX`='1538.899291', `fPosY`='-1657.557739', `fPosZ`='13.236455', `fPosA`='358.811614', `fCol1`='-1' `fCol2`='-1' `fFaction1`='1' `fFaction2`='0' `fFaction3`='0' `fFaction4`='0' `fFaction5`='0' `fSpoiler`='1138' `fHood`='0' `fRoof`='0' `fSideskirt`='0' `fLamps`='0' `fNitro`='0' `fExhaust`='0' `fWheel`='0' `fStereo`='0' `fHydraulics`='0' `fFrontBumper`='0' `fVent1`='0' `fRearBumper`='0' `fVent2`='0' `fPaintjob`='0' `fPrice`='300000' `fTankart`='3' `fGesperrt`='0' `fMotorschaden`='0' `fSperrpreis`='0'  WHERE ID = '5'
[20:26:58] UPDATE `FracVehicles` SET`fVehid`='400', `fPosX`='1537.350219', `fPosY`='-1678.525512', `fPosZ`='13.567066', `fPosA`='76.766181', `fCol1`='-1' `fCol2`='-1' `fFaction1`='1' `fFaction2`='0' `fFaction3`='0' `fFaction4`='0' `fFaction5`='0' `fSpoiler`='0' `fHood`='0' `fRoof`='0' `fSideskirt`='0' `fLamps`='0' `fNitro`='0' `fExhaust`='0' `fWheel`='0' `fStereo`='0' `fHydraulics`='0' `fFrontBumper`='0' `fVent1`='0' `fRearBumper`='0' `fVent2`='0' `fPaintjob`='0' `fPrice`='0' `fTankart`='1' `fGesperrt`='0' `fMotorschaden`='0' `fSperrpreis`='0'  WHERE ID = '6'

CSS: msql_log

[20:29:59 03/08/17] [DEBUG] mysql_pquery - connection: 1, query: "ALTER TABLE `FracVehicles` ADD `fCarid` varchar(11) NOT NULL DEF", callback: "(null)", format: "(null)"
[20:29:59 03/08/17] [DEBUG] mysql_pquery - connection: 1, query: "ALTER TABLE `FracVehicles` ADD `fVehid` varchar(11) NOT NULL DEF", callback: "(null)", format: "(null)"
[20:29:59 03/08/17] [DEBUG] mysql_pquery - connection: 1, query: "ALTER TABLE `FracVehicles` ADD `fPosX` float NOT NULL DEFAULT '0", callback: "(null)", format: "(null)"
[20:29:59 03/08/17] [DEBUG] mysql_pquery - connection: 1, query: "ALTER TABLE `FracVehicles` ADD `fPosY` float NOT NULL DEFAULT '0", callback: "(null)", format: "(null)"
[20:29:59 03/08/17] [DEBUG] mysql_pquery - connection: 1, query: "ALTER TABLE `FracVehicles` ADD `fPosZ` float NOT NULL DEFAULT '0", callback: "(null)", format: "(null)"
[20:29:59 03/08/17] [DEBUG] mysql_pquery - connection: 1, query: "ALTER TABLE `FracVehicles` ADD `fPosA` float NOT NULL DEFAULT '0", callback: "(null)", format: "(null)"
[20:29:59 03/08/17] [DEBUG] mysql_pquery - connection: 1, query: "ALTER TABLE `FracVehicles` ADD `fCol1` varchar(11) NOT NULL DEFA", callback: "(null)", format: "(null)"
[20:29:59 03/08/17] [DEBUG] mysql_pquery - connection: 1, query: "ALTER TABLE `FracVehicles` ADD `fCol2` varchar(11) NOT NULL DEFA", callback: "(null)", format: "(null)"
[20:29:59 03/08/17] [DEBUG] mysql_pquery - connection: 1, query: "ALTER TABLE `FracVehicles` ADD `fFaction1` varchar(11) NOT NULL ", callback: "(null)", format: "(null)"
[20:29:59 03/08/17] [DEBUG] mysql_pquery - connection: 1, query: "ALTER TABLE `FracVehicles` ADD `fFaction2` varchar(11) NOT NULL ", callback: "(null)", format: "(null)"
[20:29:59 03/08/17] [DEBUG] mysql_pquery - connection: 1, query: "ALTER TABLE `FracVehicles` ADD `fFaction3` varchar(11) NOT NULL ", callback: "(null)", format: "(null)"
[20:29:59 03/08/17] [DEBUG] mysql_pquery - connection: 1, query: "ALTER TABLE `FracVehicles` ADD `fFaction4` varchar(11) NOT NULL ", callback: "(null)", format: "(null)"
[20:29:59 03/08/17] [DEBUG] mysql_pquery - connection: 1, query: "ALTER TABLE `FracVehicles` ADD `fFaction5` varchar(11) NOT NULL ", callback: "(null)", format: "(null)"
[20:29:59 03/08/17] [DEBUG] mysql_pquery - connection: 1, query: "ALTER TABLE `FracVehicles` ADD `fSpoiler` varchar(11) NOT NULL D", callback: "(null)", format: "(null)"
[20:29:59 03/08/17] [DEBUG] mysql_pquery - connection: 1, query: "ALTER TABLE `FracVehicles` ADD `fHood` varchar(11) NOT NULL DEFA", callback: "(null)", format: "(null)"
[20:29:59 03/08/17] [DEBUG] mysql_pquery - connection: 1, query: "ALTER TABLE `FracVehicles` ADD `fRoof` varchar(11) NOT NULL DEFA", callback: "(null)", format: "(null)"
[20:29:59 03/08/17] [DEBUG] mysql_pquery - connection: 1, query: "ALTER TABLE `FracVehicles` ADD `fSideskirt` varchar(11) NOT NULL", callback: "(null)", format: "(null)"
[20:29:59 03/08/17] [DEBUG] mysql_pquery - connection: 1, query: "ALTER TABLE `FracVehicles` ADD `fLamps` varchar(11) NOT NULL DEF", callback: "(null)", format: "(null)"
[20:29:59 03/08/17] [DEBUG] mysql_pquery - connection: 1, query: "ALTER TABLE `FracVehicles` ADD `fNitro` varchar(11) NOT NULL DEF", callback: "(null)", format: "(null)"
[20:29:59 03/08/17] [DEBUG] mysql_pquery - connection: 1, query: "ALTER TABLE `FracVehicles` ADD `fExhaust` varchar(11) NOT NULL D", callback: "(null)", format: "(null)"
[20:29:59 03/08/17] [DEBUG] mysql_pquery - connection: 1, query: "ALTER TABLE `FracVehicles` ADD `fWheel` varchar(11) NOT NULL DEF", callback: "(null)", format: "(null)"
[20:29:59 03/08/17] [DEBUG] mysql_pquery - connection: 1, query: "ALTER TABLE `FracVehicles` ADD `fStereo` varchar(11) NOT NULL DE", callback: "(null)", format: "(null)"
[20:29:59 03/08/17] [DEBUG] mysql_pquery - connection: 1, query: "ALTER TABLE `FracVehicles` ADD `fHydraulics` varchar(11) NOT NUL", callback: "(null)", format: "(null)"
[20:29:59 03/08/17] [DEBUG] mysql_pquery - connection: 1, query: "ALTER TABLE `FracVehicles` ADD `fFrontBumper` varchar(11) NOT NU", callback: "(null)", format: "(null)"
[20:29:59 03/08/17] [DEBUG] mysql_pquery - connection: 1, query: "ALTER TABLE `FracVehicles` ADD `fVent1` varchar(11) NOT NULL DEF", callback: "(null)", format: "(null)"
[20:29:59 03/08/17] [DEBUG] mysql_pquery - connection: 1, query: "ALTER TABLE `FracVehicles` ADD `fRearBumper` varchar(11) NOT NUL", callback: "(null)", format: "(null)"
[20:29:59 03/08/17] [DEBUG] mysql_pquery - connection: 1, query: "ALTER TABLE `FracVehicles` ADD `fVent2` varchar(11) NOT NULL DEF", callback: "(null)", format: "(null)"
[20:29:59 03/08/17] [DEBUG] mysql_pquery - connection: 1, query: "ALTER TABLE `FracVehicles` ADD `fPaintjob` varchar(11) NOT NULL ", callback: "(null)", format: "(null)"
[20:29:59 03/08/17] [DEBUG] mysql_pquery - connection: 1, query: "ALTER TABLE `FracVehicles` ADD `fPrice` varchar(11) NOT NULL DEF", callback: "(null)", format: "(null)"
[20:29:59 03/08/17] [DEBUG] mysql_pquery - connection: 1, query: "ALTER TABLE `FracVehicles` ADD `fTankart` varchar(11) NOT NULL D", callback: "(null)", format: "(null)"
[20:29:59 03/08/17] [DEBUG] mysql_pquery - connection: 1, query: "ALTER TABLE `FracVehicles` ADD `fGesperrt` varchar(11) NOT NULL ", callback: "(null)", format: "(null)"
[20:29:59 03/08/17] [DEBUG] mysql_pquery - connection: 1, query: "ALTER TABLE `FracVehicles` ADD `fMotorschaden` varchar(11) NOT N", callback: "(null)", format: "(null)"
[20:29:59 03/08/17] [DEBUG] mysql_pquery - connection: 1, query: "ALTER TABLE `FracVehicles` ADD `fSperrpreis` varchar(11) NOT NUL", callback: "(null)", format: "(null)"
[20:29:59 03/08/17] [DEBUG] CMySQLQuery::Execute[] - starting query execution
[20:29:59 03/08/17] [ERROR] CMySQLQuery::Execute[] - (error #1060) Duplicate column name 'fVehid' (Query: "ALTER TABLE `FracVehicles` ADD `fVehid` varchar(11) NOT NULL DEFAULT '0'")
[20:29:59 03/08/17] [DEBUG] CMySQLQuery::Execute[] - error will be triggered in OnQueryError
[20:29:59 03/08/17] [DEBUG] CMySQLQuery::Execute[] - starting query execution
[20:29:59 03/08/17] [ERROR] CMySQLQuery::Execute[] - (error #1060) Duplicate column name 'fPosY' (Query: "ALTER TABLE `FracVehicles` ADD `fPosY` float NOT NULL DEFAULT '0.0'")
[20:29:59 03/08/17] [DEBUG] CMySQLQuery::Execute[] - error will be triggered in OnQueryError
[20:29:59 03/08/17] [DEBUG] CMySQLQuery::Execute[] - starting query execution
[20:29:59 03/08/17] [ERROR] CMySQLQuery::Execute[] - (error #1060) Duplicate column name 'fPosA' (Query: "ALTER TABLE `FracVehicles` ADD `fPosA` float NOT NULL DEFAULT '0.0'")
[20:29:59 03/08/17] [DEBUG] CMySQLQuery::Execute[] - error will be triggered in OnQueryError
[20:29:59 03/08/17] [DEBUG] CMySQLQuery::Execute[] - starting query execution
[20:29:59 03/08/17] [ERROR] CMySQLQuery::Execute[] - (error #1060) Duplicate column name 'fCol2' (Query: "ALTER TABLE `FracVehicles` ADD `fCol2` varchar(11) NOT NULL DEFAULT '0'")
[20:29:59 03/08/17] [DEBUG] CMySQLQuery::Execute[] - error will be triggered in OnQueryError
[20:29:59 03/08/17] [DEBUG] CMySQLQuery::Execute[] - starting query execution
[20:29:59 03/08/17] [DEBUG] CMySQLQuery::Execute[] - starting query execution
[20:29:59 03/08/17] [ERROR] CMySQLQuery::Execute[] - (error #1060) Duplicate column name 'fCarid' (Query: "ALTER TABLE `FracVehicles` ADD `fCarid` varchar(11) NOT NULL DEFAULT '0'")
[20:29:59 03/08/17] [DEBUG] CMySQLQuery::Execute[] - error will be triggered in OnQueryError
[20:29:59 03/08/17] [DEBUG] CMySQLQuery::Execute[] - starting query execution
[20:29:59 03/08/17] [ERROR] CMySQLQuery::Execute[] - (error #1060) Duplicate column name 'fPosX' (Query: "ALTER TABLE `FracVehicles` ADD `fPosX` float NOT NULL DEFAULT '0.0'")
[20:29:59 03/08/17] [DEBUG] CMySQLQuery::Execute[] - error will be triggered in OnQueryError
[20:29:59 03/08/17] [DEBUG] CMySQLQuery::Execute[] - starting query execution
[20:29:59 03/08/17] [ERROR] CMySQLQuery::Execute[] - (error #1060) Duplicate column name 'fPosZ' (Query: "ALTER TABLE `FracVehicles` ADD `fPosZ` float NOT NULL DEFAULT '0.0'")
[20:29:59 03/08/17] [DEBUG] CMySQLQuery::Execute[] - error will be triggered in OnQueryError
[20:29:59 03/08/17] [DEBUG] CMySQLQuery::Execute[] - starting query execution
[20:29:59 03/08/17] [ERROR] CMySQLQuery::Execute[] - (error #1060) Duplicate column name 'fCol1' (Query: "ALTER TABLE `FracVehicles` ADD `fCol1` varchar(11) NOT NULL DEFAULT '0'")
[20:29:59 03/08/17] [DEBUG] CMySQLQuery::Execute[] - error will be triggered in OnQueryError
[20:29:59 03/08/17] [DEBUG] CMySQLQuery::Execute[] - starting query execution
[20:29:59 03/08/17] [ERROR] CMySQLQuery::Execute[] - (error #1060) Duplicate column name 'fFaction1' (Query: "ALTER TABLE `FracVehicles` ADD `fFaction1` varchar(11) NOT NULL DEFAULT '0'")
[20:29:59 03/08/17] [DEBUG] CMySQLQuery::Execute[] - error will be triggered in OnQueryError
[20:29:59 03/08/17] [DEBUG] CMySQLQuery::Execute[] - starting query execution
[20:29:59 03/08/17] [ERROR] CMySQLQuery::Execute[] - (error #1060) Duplicate column name 'fFaction2' (Query: "ALTER TABLE `FracVehicles` ADD `fFaction2` varchar(11) NOT NULL DEFAULT '0'")
[20:29:59 03/08/17] [DEBUG] CMySQLQuery::Execute[] - error will be triggered in OnQueryError
[20:29:59 03/08/17] [DEBUG] CMySQLQuery::Execute[] - starting query execution
[20:29:59 03/08/17] [ERROR] CMySQLQuery::Execute[] - (error #1060) Duplicate column name 'fFaction3' (Query: "ALTER TABLE `FracVehicles` ADD `fFaction3` varchar(11) NOT NULL DEFAULT '0'")
[20:29:59 03/08/17] [DEBUG] CMySQLQuery::Execute[] - error will be triggered in OnQueryError
[20:29:59 03/08/17] [DEBUG] CMySQLQuery::Execute[] - starting query execution
[20:29:59 03/08/17] [ERROR] CMySQLQuery::Execute[] - (error #1060) Duplicate column name 'fFaction4' (Query: "ALTER TABLE `FracVehicles` ADD `fFaction4` varchar(11) NOT NULL DEFAULT '0'")
[20:29:59 03/08/17] [DEBUG] CMySQLQuery::Execute[] - error will be triggered in OnQueryError
[20:29:59 03/08/17] [DEBUG] CMySQLQuery::Execute[] - starting query execution
[20:29:59 03/08/17] [ERROR] CMySQLQuery::Execute[] - (error #1060) Duplicate column name 'fFaction5' (Query: "ALTER TABLE `FracVehicles` ADD `fFaction5` varchar(11) NOT NULL DEFAULT '0'")
[20:29:59 03/08/17] [DEBUG] CMySQLQuery::Execute[] - error will be triggered in OnQueryError
[20:29:59 03/08/17] [DEBUG] CMySQLQuery::Execute[] - starting query execution
[20:29:59 03/08/17] [ERROR] CMySQLQuery::Execute[] - (error #1060) Duplicate column name 'fSpoiler' (Query: "ALTER TABLE `FracVehicles` ADD `fSpoiler` varchar(11) NOT NULL DEFAULT '0'")
[20:29:59 03/08/17] [DEBUG] CMySQLQuery::Execute[] - error will be triggered in OnQueryError
[20:29:59 03/08/17] [DEBUG] CMySQLQuery::Execute[] - starting query execution
[20:29:59 03/08/17] [ERROR] CMySQLQuery::Execute[] - (error #1060) Duplicate column name 'fHood' (Query: "ALTER TABLE `FracVehicles` ADD `fHood` varchar(11) NOT NULL DEFAULT '0'")
[20:29:59 03/08/17] [DEBUG] CMySQLQuery::Execute[] - error will be triggered in OnQueryError
[20:29:59 03/08/17] [DEBUG] CMySQLQuery::Execute[] - starting query execution
[20:29:59 03/08/17] [ERROR] CMySQLQuery::Execute[] - (error #1060) Duplicate column name 'fRoof' (Query: "ALTER TABLE `FracVehicles` ADD `fRoof` varchar(11) NOT NULL DEFAULT '0'")
[20:29:59 03/08/17] [DEBUG] CMySQLQuery::Execute[] - error will be triggered in OnQueryError
[20:29:59 03/08/17] [DEBUG] CMySQLQuery::Execute[] - starting query execution
[20:29:59 03/08/17] [ERROR] CMySQLQuery::Execute[] - (error #1060) Duplicate column name 'fSideskirt' (Query: "ALTER TABLE `FracVehicles` ADD `fSideskirt` varchar(11) NOT NULL DEFAULT '0'")
[20:29:59 03/08/17] [DEBUG] CMySQLQuery::Execute[] - error will be triggered in OnQueryError
[20:29:59 03/08/17] [DEBUG] CMySQLQuery::Execute[] - starting query execution
[20:29:59 03/08/17] [ERROR] CMySQLQuery::Execute[] - (error #1060) Duplicate column name 'fLamps' (Query: "ALTER TABLE `FracVehicles` ADD `fLamps` varchar(11) NOT NULL DEFAULT '0'")
[20:29:59 03/08/17] [DEBUG] CMySQLQuery::Execute[] - error will be triggered in OnQueryError
[20:29:59 03/08/17] [DEBUG] CMySQLQuery::Execute[] - starting query execution
[20:29:59 03/08/17] [ERROR] CMySQLQuery::Execute[] - (error #1060) Duplicate column name 'fNitro' (Query: "ALTER TABLE `FracVehicles` ADD `fNitro` varchar(11) NOT NULL DEFAULT '0'")
[20:29:59 03/08/17] [DEBUG] CMySQLQuery::Execute[] - error will be triggered in OnQueryError
[20:29:59 03/08/17] [DEBUG] CMySQLQuery::Execute[] - starting query execution
[20:29:59 03/08/17] [ERROR] CMySQLQuery::Execute[] - (error #1060) Duplicate column name 'fExhaust' (Query: "ALTER TABLE `FracVehicles` ADD `fExhaust` varchar(11) NOT NULL DEFAULT '0'")
[20:29:59 03/08/17] [DEBUG] CMySQLQuery::Execute[] - error will be triggered in OnQueryError
[20:29:59 03/08/17] [DEBUG] CMySQLQuery::Execute[] - starting query execution
[20:29:59 03/08/17] [ERROR] CMySQLQuery::Execute[] - (error #1060) Duplicate column name 'fWheel' (Query: "ALTER TABLE `FracVehicles` ADD `fWheel` varchar(11) NOT NULL DEFAULT '0'")
[20:29:59 03/08/17] [DEBUG] CMySQLQuery::Execute[] - error will be triggered in OnQueryError
[20:29:59 03/08/17] [DEBUG] CMySQLQuery::Execute[] - starting query execution
[20:29:59 03/08/17] [ERROR] CMySQLQuery::Execute[] - (error #1060) Duplicate column name 'fStereo' (Query: "ALTER TABLE `FracVehicles` ADD `fStereo` varchar(11) NOT NULL DEFAULT '0'")
[20:29:59 03/08/17] [DEBUG] CMySQLQuery::Execute[] - error will be triggered in OnQueryError
[20:29:59 03/08/17] [DEBUG] CMySQLQuery::Execute[] - starting query execution
[20:29:59 03/08/17] [ERROR] CMySQLQuery::Execute[] - (error #1060) Duplicate column name 'fHydraulics' (Query: "ALTER TABLE `FracVehicles` ADD `fHydraulics` varchar(11) NOT NULL DEFAULT '0'")
[20:29:59 03/08/17] [DEBUG] CMySQLQuery::Execute[] - error will be triggered in OnQueryError
[20:29:59 03/08/17] [DEBUG] CMySQLQuery::Execute[] - starting query execution
[20:29:59 03/08/17] [ERROR] CMySQLQuery::Execute[] - (error #1060) Duplicate column name 'fFrontBumper' (Query: "ALTER TABLE `FracVehicles` ADD `fFrontBumper` varchar(11) NOT NULL DEFAULT '0'")
[20:29:59 03/08/17] [DEBUG] CMySQLQuery::Execute[] - error will be triggered in OnQueryError
[20:29:59 03/08/17] [DEBUG] CMySQLQuery::Execute[] - starting query execution
[20:29:59 03/08/17] [ERROR] CMySQLQuery::Execute[] - (error #1060) Duplicate column name 'fVent1' (Query: "ALTER TABLE `FracVehicles` ADD `fVent1` varchar(11) NOT NULL DEFAULT '0'")
[20:29:59 03/08/17] [DEBUG] CMySQLQuery::Execute[] - error will be triggered in OnQueryError
[20:29:59 03/08/17] [DEBUG] CMySQLQuery::Execute[] - starting query execution
[20:29:59 03/08/17] [ERROR] CMySQLQuery::Execute[] - (error #1060) Duplicate column name 'fRearBumper' (Query: "ALTER TABLE `FracVehicles` ADD `fRearBumper` varchar(11) NOT NULL DEFAULT '0'")
[20:29:59 03/08/17] [DEBUG] CMySQLQuery::Execute[] - error will be triggered in OnQueryError
[20:29:59 03/08/17] [DEBUG] CMySQLQuery::Execute[] - starting query execution
[20:29:59 03/08/17] [ERROR] CMySQLQuery::Execute[] - (error #1060) Duplicate column name 'fVent2' (Query: "ALTER TABLE `FracVehicles` ADD `fVent2` varchar(11) NOT NULL DEFAULT '0'")
[20:29:59 03/08/17] [DEBUG] CMySQLQuery::Execute[] - error will be triggered in OnQueryError
[20:29:59 03/08/17] [DEBUG] CMySQLQuery::Execute[] - starting query execution
[20:29:59 03/08/17] [ERROR] CMySQLQuery::Execute[] - (error #1060) Duplicate column name 'fPaintjob' (Query: "ALTER TABLE `FracVehicles` ADD `fPaintjob` varchar(11) NOT NULL DEFAULT '0'")
[20:29:59 03/08/17] [DEBUG] CMySQLQuery::Execute[] - error will be triggered in OnQueryError
[20:29:59 03/08/17] [DEBUG] CMySQLQuery::Execute[] - starting query execution
[20:29:59 03/08/17] [ERROR] CMySQLQuery::Execute[] - (error #1060) Duplicate column name 'fPrice' (Query: "ALTER TABLE `FracVehicles` ADD `fPrice` varchar(11) NOT NULL DEFAULT '0'")
[20:29:59 03/08/17] [DEBUG] CMySQLQuery::Execute[] - error will be triggered in OnQueryError
[20:29:59 03/08/17] [DEBUG] CMySQLQuery::Execute[] - starting query execution
[20:29:59 03/08/17] [ERROR] CMySQLQuery::Execute[] - (error #1060) Duplicate column name 'fTankart' (Query: "ALTER TABLE `FracVehicles` ADD `fTankart` varchar(11) NOT NULL DEFAULT '0'")
[20:29:59 03/08/17] [DEBUG] CMySQLQuery::Execute[] - error will be triggered in OnQueryError
[20:29:59 03/08/17] [DEBUG] CMySQLQuery::Execute[] - starting query execution
[20:29:59 03/08/17] [ERROR] CMySQLQuery::Execute[] - (error #1060) Duplicate column name 'fGesperrt' (Query: "ALTER TABLE `FracVehicles` ADD `fGesperrt` varchar(11) NOT NULL DEFAULT '0'")
[20:29:59 03/08/17] [DEBUG] CMySQLQuery::Execute[] - error will be triggered in OnQueryError
[20:29:59 03/08/17] [DEBUG] CMySQLQuery::Execute[] - starting query execution
[20:29:59 03/08/17] [ERROR] CMySQLQuery::Execute[] - (error #1060) Duplicate column name 'fMotorschaden' (Query: "ALTER TABLE `FracVehicles` ADD `fMotorschaden` varchar(11) NOT NULL DEFAULT '0'")
[20:29:59 03/08/17] [DEBUG] CMySQLQuery::Execute[] - error will be triggered in OnQueryError
[20:29:59 03/08/17] [ERROR] CMySQLQuery::Execute[] - (error #1060) Duplicate column name 'fSperrpreis' (Query: "ALTER TABLE `FracVehicles` ADD `fSperrpreis` varchar(11) NOT NULL DEFAULT '0'")
[20:29:59 03/08/17] [DEBUG] CMySQLQuery::Execute[] - error will be triggered in OnQueryError

Alles anzeigen

vieleicht findest du den fehler warum es nicht Speichern will

Jeffry · 8. März 2017

Ab "fCol1" fehlen die Kommas am Ende.
Nur die letzte Zeile (fSperrpreis) darf kein Komma haben.

Zitat von RedDragon28080

[20:29:59 03/08/17] [DEBUG] mysql_pquery - connection: 1, query: "ALTER TABLE `FracVehicles` ADD `fCarid` varchar(11) NOT NULL DEF", callback: "(null)", format: "(null)"

Entferne diese Queries alle. Sonst bekommst du beim Server Start jedes Mal die Fehlermeldungen, weil die Spalten ja bereits existieren.
Wenn du Spalten hinzufügen willst, mache das in der Datenbank direkt, da dies ja nur ein einmaliger Vorgang ist.
Lediglich das CREATE TABLE IF NOT EXIST musst du anpassen, da dies die Tabelle komplett erstellt, wenn sie nicht existiert.

RedDragon28080 · 8. März 2017

Zitat von Jeffry

Entferne diese Queries alle. Sonst bekommst du beim Server Start jedes Mal die Fehlermeldungen, weil die Spalten ja bereits existieren.
Wenn du Spalten hinzufügen willst, mache das in der Datenbank direkt, da dies ja nur ein einmaliger Vorgang ist.
Lediglich das CREATE TABLE IF NOT EXIST musst du anpassen, da dies die Tabelle komplett erstellt, wenn sie nicht existiert.

ich klammer die aus wenn ich mal was in die Tabelle hinzufügen will zumbeispiel: carheal dann setzte ich es dort hinzu und klammer es wieder ein danach wird die wieder ausgeklammert habe es jetzt nur vergessen

Edit:

Also ich habe jetzt neues Prbleme:

-Speichern tut es jetzt aber laden tut er die Tuningteile nicht

Code

forward LoadFracVehicles_Data();
public LoadFracVehicles_Data()
{
	//Deklaration neuer temporärer Variablen:
	new rows, id, createdVehs;
	//Anzahl der gelesenen Datensätze abfragen:
	rows = cache_num_rows();
	//Schleife durch alle Datensätze:
	for(new i=0; i<rows; i++)
	{
		//Fahrzeug existiert in der Datenbank, wir laden die Daten jetzt aus dem Cache.
		id = cache_get_field_content_int(i, "ID");


		//Um Fehler bei der Verarbeitung zu vermeiden:
		if(id < 0 || id >= MAX_FRAC_VEHICLES) continue;
		print("LoadFracVehicles_Data 1");
		FactionCars[id][fCarid] = cache_get_field_content_int(i, "fCarid");
		FactionCars[id][fVehid] = cache_get_field_content_int(i, "fVehid");
		FactionCars[id][fPos][0] = cache_get_field_content_float(i, "fPosX");
		FactionCars[id][fPos][1] = cache_get_field_content_float(i, "fPosY");
		FactionCars[id][fPos][2] = cache_get_field_content_float(i, "fPosZ");
		FactionCars[id][fPos][3] = cache_get_field_content_float(i, "fPosA");
		FactionCars[id][fCol][0] = cache_get_field_content_int(i, "fCol1");
		FactionCars[id][fCol][1] = cache_get_field_content_int(i, "fCol2");
		FactionCars[id][fFaction][0] = cache_get_field_content_int(i, "fFaction1");
		FactionCars[id][fFaction][1] = cache_get_field_content_int(i, "fFaction2");
		FactionCars[id][fFaction][2] = cache_get_field_content_int(i, "fFaction3");
		FactionCars[id][fFaction][3] = cache_get_field_content_int(i, "fFaction4");
		FactionCars[id][fFaction][4] = cache_get_field_content_int(i, "fFaction5");
		FactionCars[id][fTuning][0] = cache_get_field_content_int(i, "fSpoiler");
		FactionCars[id][fTuning][1] = cache_get_field_content_int(i, "fHood");
		FactionCars[id][fTuning][2] = cache_get_field_content_int(i, "fRoof");
		FactionCars[id][fTuning][3] = cache_get_field_content_int(i, "fSideskirt");
		FactionCars[id][fTuning][4] = cache_get_field_content_int(i, "fLamps");
		FactionCars[id][fTuning][5] = cache_get_field_content_int(i, "fNitro");
		FactionCars[id][fTuning][6] = cache_get_field_content_int(i, "fExhaust");
		FactionCars[id][fTuning][7] = cache_get_field_content_int(i, "fWheel");
		FactionCars[id][fTuning][8] = cache_get_field_content_int(i, "fStereo");
		FactionCars[id][fTuning][9] = cache_get_field_content_int(i, "fHydraulics");
		FactionCars[id][fTuning][10] = cache_get_field_content_int(i, "fFrontBumper");
		FactionCars[id][fTuning][11] = cache_get_field_content_int(i, "fVent1");
		FactionCars[id][fTuning][12] = cache_get_field_content_int(i, "fRearBumper");
		FactionCars[id][fTuning][13] = cache_get_field_content_int(i, "fVent2");
		FactionCars[id][fTuning][14] = cache_get_field_content_int(i, "fPaintjob");
		FactionCars[id][fPrice] = cache_get_field_content_int(i, "fPrice");
		FactionCars[id][fTankart] = cache_get_field_content_int(i, "fTankart");
		FactionCars[id][fGesperrt] = cache_get_field_content_int(i, "fGesperrt");
		FactionCars[id][fMotorschaden] = cache_get_field_content_int(i, "fMotorschaden");
		FactionCars[id][fSperrpreis] = cache_get_field_content_int(i, "fSperrpreis");
		//Zur Sicherheit fragen wir hier nun ab, ob das angegebene Modell auch existiert,
		//sollte das nicht der Fall sein, dann wird das Fahrzeug nicht erstellt.
		print("LoadFracVehicles_Data 2");
		printf("Model-ID %d (ID: %d)", FactionCars[id][fVehid], id);
		if(FactionCars[id][fVehid] >= 400 && FactionCars[id][fVehid] <= 611)
		{
			//Nachdem das Fahrzeug geladen wurde, wird es erstellt.
  			FactionCars[id][fCarid] = CreateVehicle(FactionCars[id][fVehid],FactionCars[id][fPos][0],FactionCars[id][fPos][1],FactionCars[id][fPos][2],FactionCars[id][fPos][3],FactionCars[id][fCol][0],FactionCars[id][fCol][1],-1);
			new pstring[128];
			new randomplate = 1 + random(20);
			format(pstring,sizeof(pstring),"%s %d",Factions[FactionCars[id][fFaction][0]],randomplate);
			SetVehicleNumberPlate(FactionCars[id][fCarid], pstring);
		}
		else
		{
			//Falls eine nicht existierende Model-ID angegeben wurde, geben wir eine Information aus.
			printf("[Error] Model-ID %d existiert nicht (ID: %d).", FactionCars[id][fVehid], id);
		}


		//Zur Sicherheit fragen wir noch ab, ob das Fahrzeug-Limit noch nicht überschritten wurde.
		//Existiert ein Fahrzeug mit der höchsten ID, dann kann kein weiteres mehr erstellt werden.
		if(GetVehicleModel(MAX_VEHICLES-1) != 0) return print("Es können keine weiteren Fahrzeuge geladen werden, Limit (MAX_VEHICLES) erreicht.");


		//Zur weiteren Sicherheit prüfen wir noch, ob die maximale Anzahl an Fraktions-Fahrzeugen erreicht ist.
		createdVehs++;
		if(createdVehs == MAX_FRAC_VEHICLES) return print("Es können keine weiteren Fahrzeuge geladen werden, Limit (MAX_FRAC_VEHICLES) erreicht.");
	}
	return 1;
}

Alles anzeigen

**XeroX** · 8. März 2017

Du erstellst ja auch nur das Fahrzeug und nutzt AddVehicleComponent nicht.

5 Errors die ich nicht weg bekomme

breadfish.de 12. März 2022

Ähnliche Themen

GivePlayerWantedLevel frage

Errors in einem Befehl

Autohaus System Errors

|Hilfe| FraktionAutohaus MySQL

8 Errors

15 Errors, PAWN finden Plugins nicht...