Accounts werden nicht gespeichert

Zitat von Slider

Was fuer ein System nutzt Du?

Versuch mal am Ende der Datei folgendes zu schreiben:

Code

sql_mode=NO_ENGINE_SUBSTITUTION

und restarte deinen MySQL Server. Vielleicht ueberschreibst Du ja dann den default mode. Kill dann den SA:MP Server Prozess, loesch die Log-Dateien, starte den SA:MP Server und poste die Ausgabe der mysql log.

Ich weiss nicht, woher Dein MySQL Server diese Konfiguration "STRICT_TRANS_TABLES" nimmt, unter openSUSE ist es jeden Falls vorkonfiguriert und man kann es einfach entfernen.

Alles anzeigen

[22:41:48] [ERROR] CMySQLQuery::Execute[()] - (error #1060) Duplicate column name 'Friedhof'
[22:41:48] [ERROR] CMySQLQuery::Execute[()] - (error #1060) Duplicate column name 'pMarried'
[22:41:48] [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 '' at line 1
[22:41:48] [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 'blacklistreason0,blacklist1,blacklistreason1,blacklist2,blacklistreason2,blackli' at line 1
[22:41:48] [ERROR] CMySQLQuery::Execute[OnQueryFinish(siii)] - (error #1146) Table 'samp.pRP_races' doesn't exist
[22:41:48] [ERROR] CMySQLQuery::Execute[()] - (error #1364) Field 'GangWarZoneAttacker' doesn't have a default value
[22:41:48] [ERROR] CMySQLQuery::Execute[()] - (error #1364) Field 'GangWarZoneAttacker' doesn't have a default value
[22:41:48] [ERROR] CMySQLQuery::Execute[()] - (error #1364) Field 'GangWarZoneAttacker' doesn't have a default value
[22:41:48] [ERROR] CMySQLQuery::Execute[()] - (error #1364) Field 'GangWarZoneAttacker' doesn't have a default value
[22:41:48] [ERROR] CMySQLQuery::Execute[()] - (error #1364) Field 'GangWarZoneAttacker' doesn't have a default value
[22:41:48] [ERROR] CMySQLQuery::Execute[()] - (error #1364) Field 'GangWarZoneAttacker' doesn't have a default value
[22:41:48] [ERROR] CMySQLQuery::Execute[()] - (error #1364) Field 'GangWarZoneAttacker' doesn't have a default value
[22:41:48] [ERROR] CMySQLQuery::Execute[()] - (error #1364) Field 'GangWarZoneAttacker' doesn't have a default value
[22:41:48] [ERROR] CMySQLQuery::Execute[()] - (error #1364) Field 'GangWarZoneAttacker' doesn't have a default value
[22:41:48] [ERROR] CMySQLQuery::Execute[()] - (error #1364) Field 'GangWarZoneAttacker' doesn't have a default value
[22:41:48] [ERROR] CMySQLQuery::Execute[()] - (error #1364) Field 'GangWarZoneAttacker' doesn't have a default value
[22:41:48] [ERROR] CMySQLQuery::Execute[()] - (error #1364) Field 'GangWarZoneAttacker' doesn't have a default value
[22:41:48] [ERROR] CMySQLQuery::Execute[()] - (error #1364) Field 'GangWarZoneAttacker' doesn't have a default value
[22:41:48] [ERROR] CMySQLQuery::Execute[()] - (error #1364) Field 'GangWarZoneAttacker' doesn't have a default value
[22:41:48] [ERROR] CMySQLQuery::Execute[()] - (error #1364) Field 'id' doesn't have a default value
[22:41:48] [ERROR] CMySQLQuery::Execute[()] - (error #1364) Field 'GFFID' doesn't have a default value
[22:41:48] [ERROR] CMySQLQuery::Execute[()] - (error #1364) Field 'GFFID' doesn't have a default value
[22:41:48] [ERROR] CMySQLQuery::Execute[()] - (error #1364) Field 'GFFID' doesn't have a default value
[22:41:48] [ERROR] CMySQLQuery::Execute[()] - (error #1364) Field 'GFFID' doesn't have a default value
[22:41:48] [ERROR] CMySQLQuery::Execute[()] - (error #1364) Field 'GFFID' doesn't have a default value
[22:41:48] [ERROR] CMySQLQuery::Execute[()] - (error #1364) Field 'GFFID' doesn't have a default value
[22:41:48] [ERROR] CMySQLQuery::Execute[()] - (error #1364) Field 'GFFID' doesn't have a default value
[22:41:48] [ERROR] CMySQLQuery::Execute[()] - (error #1364) Field 'GFFID' doesn't have a default value
[22:41:48] [ERROR] CMySQLQuery::Execute[()] - (error #1364) Field 'GFFID' doesn't have a default value
[22:41:48] [ERROR] CMySQLQuery::Execute[()] - (error #1364) Field 'GFFID' doesn't have a default value
[22:41:48] [ERROR] CMySQLQuery::Execute[()] - (error #1364) Field 'GFFID' doesn't have a default value
[22:41:48] [ERROR] CMySQLQuery::Execute[()] - (error #1364) Field 'GFFID' doesn't have a default value
[22:41:48] [ERROR] CMySQLQuery::Execute[()] - (error #1364) Field 'GFFID' doesn't have a default value
[22:41:48] [ERROR] CMySQLQuery::Execute[()] - (error #1364) Field 'GFFID' doesn't have a default value
[22:41:48] [ERROR] CMySQLQuery::Execute[()] - (error #1364) Field 'GFFID' doesn't have a default value
[22:41:48] [ERROR] CMySQLQuery::Execute[()] - (error #1364) Field 'GFFID' doesn't have a default value
[22:41:48] [ERROR] CMySQLQuery::Execute[()] - (error #1364) Field 'GFFID' doesn't have a default value
[22:41:48] [ERROR] CMySQLQuery::Execute[()] - (error #1364) Field 'GFFID' doesn't have a default value
[22:41:48] [ERROR] CMySQLQuery::Execute[()] - (error #1364) Field 'GFFID' doesn't have a default value

Zitat von Slider

@FloriDE ok naechster Versuch:

• Entferne wieder das aus der Config Datei was ich Dir eben gesagt habe
• Starte den MySQL Server neu
• Fuehre in deinem Script direkt nach der Verbindung zum MySQL Server einen SQL Befehl aus

Koennte z.B. so aussehen:

Code

mysql_tquery(mysql, "SET SESSION sql_mode = '';");

Musst Du halt ggf. anpassen je nachdem welches MySQL Plugin Du verwendest.

Wenn das nicht geht, dann versuche mal nur in deine MySQL Config

Code

sql_mode=

am Ende einzutragen und dann musst du wieder den MySQL Server neustarten.

Alles anzeigen

Du Gott, das mit dem Einfügen in die MySQL Config hat funktioniert Vielen Dank!