Accounts werden nicht gespeichert

  • Server
  • Linux

Diese Seite verwendet Cookies. Durch die Nutzung unserer Seite erklären Sie sich damit einverstanden, dass wir Cookies setzen. Weitere Informationen

  • Slider schrieb:

    Was fuer ein System nutzt Du?

    Versuch mal am Ende der Datei folgendes zu schreiben:

    Quellcode

    1. 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.

    PAWN-Quellcode

    1. [22:41:48] [ERROR] CMySQLQuery::Execute[()] - (error #1060) Duplicate column name 'Friedhof'
    2. [22:41:48] [ERROR] CMySQLQuery::Execute[()] - (error #1060) Duplicate column name 'pMarried'
    3. [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
    4. [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
    5. [22:41:48] [ERROR] CMySQLQuery::Execute[OnQueryFinish(siii)] - (error #1146) Table 'samp.pRP_races' doesn't exist
    6. [22:41:48] [ERROR] CMySQLQuery::Execute[()] - (error #1364) Field 'GangWarZoneAttacker' doesn't have a default value
    7. [22:41:48] [ERROR] CMySQLQuery::Execute[()] - (error #1364) Field 'GangWarZoneAttacker' doesn't have a default value
    8. [22:41:48] [ERROR] CMySQLQuery::Execute[()] - (error #1364) Field 'GangWarZoneAttacker' doesn't have a default value
    9. [22:41:48] [ERROR] CMySQLQuery::Execute[()] - (error #1364) Field 'GangWarZoneAttacker' doesn't have a default value
    10. [22:41:48] [ERROR] CMySQLQuery::Execute[()] - (error #1364) Field 'GangWarZoneAttacker' doesn't have a default value
    11. [22:41:48] [ERROR] CMySQLQuery::Execute[()] - (error #1364) Field 'GangWarZoneAttacker' doesn't have a default value
    12. [22:41:48] [ERROR] CMySQLQuery::Execute[()] - (error #1364) Field 'GangWarZoneAttacker' doesn't have a default value
    13. [22:41:48] [ERROR] CMySQLQuery::Execute[()] - (error #1364) Field 'GangWarZoneAttacker' doesn't have a default value
    14. [22:41:48] [ERROR] CMySQLQuery::Execute[()] - (error #1364) Field 'GangWarZoneAttacker' doesn't have a default value
    15. [22:41:48] [ERROR] CMySQLQuery::Execute[()] - (error #1364) Field 'GangWarZoneAttacker' doesn't have a default value
    16. [22:41:48] [ERROR] CMySQLQuery::Execute[()] - (error #1364) Field 'GangWarZoneAttacker' doesn't have a default value
    17. [22:41:48] [ERROR] CMySQLQuery::Execute[()] - (error #1364) Field 'GangWarZoneAttacker' doesn't have a default value
    18. [22:41:48] [ERROR] CMySQLQuery::Execute[()] - (error #1364) Field 'GangWarZoneAttacker' doesn't have a default value
    19. [22:41:48] [ERROR] CMySQLQuery::Execute[()] - (error #1364) Field 'GangWarZoneAttacker' doesn't have a default value
    20. [22:41:48] [ERROR] CMySQLQuery::Execute[()] - (error #1364) Field 'id' doesn't have a default value
    21. [22:41:48] [ERROR] CMySQLQuery::Execute[()] - (error #1364) Field 'GFFID' doesn't have a default value
    22. [22:41:48] [ERROR] CMySQLQuery::Execute[()] - (error #1364) Field 'GFFID' doesn't have a default value
    23. [22:41:48] [ERROR] CMySQLQuery::Execute[()] - (error #1364) Field 'GFFID' doesn't have a default value
    24. [22:41:48] [ERROR] CMySQLQuery::Execute[()] - (error #1364) Field 'GFFID' doesn't have a default value
    25. [22:41:48] [ERROR] CMySQLQuery::Execute[()] - (error #1364) Field 'GFFID' doesn't have a default value
    26. [22:41:48] [ERROR] CMySQLQuery::Execute[()] - (error #1364) Field 'GFFID' doesn't have a default value
    27. [22:41:48] [ERROR] CMySQLQuery::Execute[()] - (error #1364) Field 'GFFID' doesn't have a default value
    28. [22:41:48] [ERROR] CMySQLQuery::Execute[()] - (error #1364) Field 'GFFID' doesn't have a default value
    29. [22:41:48] [ERROR] CMySQLQuery::Execute[()] - (error #1364) Field 'GFFID' doesn't have a default value
    30. [22:41:48] [ERROR] CMySQLQuery::Execute[()] - (error #1364) Field 'GFFID' doesn't have a default value
    31. [22:41:48] [ERROR] CMySQLQuery::Execute[()] - (error #1364) Field 'GFFID' doesn't have a default value
    32. [22:41:48] [ERROR] CMySQLQuery::Execute[()] - (error #1364) Field 'GFFID' doesn't have a default value
    33. [22:41:48] [ERROR] CMySQLQuery::Execute[()] - (error #1364) Field 'GFFID' doesn't have a default value
    34. [22:41:48] [ERROR] CMySQLQuery::Execute[()] - (error #1364) Field 'GFFID' doesn't have a default value
    35. [22:41:48] [ERROR] CMySQLQuery::Execute[()] - (error #1364) Field 'GFFID' doesn't have a default value
    36. [22:41:48] [ERROR] CMySQLQuery::Execute[()] - (error #1364) Field 'GFFID' doesn't have a default value
    37. [22:41:48] [ERROR] CMySQLQuery::Execute[()] - (error #1364) Field 'GFFID' doesn't have a default value
    38. [22:41:48] [ERROR] CMySQLQuery::Execute[()] - (error #1364) Field 'GFFID' doesn't have a default value
    39. [22:41:48] [ERROR] CMySQLQuery::Execute[()] - (error #1364) Field 'GFFID' doesn't have a default value
    Alles anzeigen
  • @FloriDE ok naechster Versuch:
    1. Entferne wieder das aus der Config Datei was ich Dir eben gesagt habe
    2. Starte den MySQL Server neu
    3. Fuehre in deinem Script direkt nach der Verbindung zum MySQL Server einen SQL Befehl aus
    Koennte z.B. so aussehen:

    PAWN-Quellcode

    1. 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

    Quellcode

    1. sql_mode=

    am Ende einzutragen und dann musst du wieder den MySQL Server neustarten.
    city-of-sa.de - Roleplay Projekt - Release: 2018
    samp-models.net - SA:MP Model Hoster
  • Slider schrieb:

    @FloriDE ok naechster Versuch:
    1. Entferne wieder das aus der Config Datei was ich Dir eben gesagt habe
    2. Starte den MySQL Server neu
    3. Fuehre in deinem Script direkt nach der Verbindung zum MySQL Server einen SQL Befehl aus
    Koennte z.B. so aussehen:

    PAWN-Quellcode

    1. 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

    Quellcode

    1. sql_mode=
    am Ende einzutragen und dann musst du wieder den MySQL Server neustarten.
    Du Gott, das mit dem Einfügen in die MySQL Config hat funktioniert Vielen Dank!