Problem mit einer Datenbank

Wichtiger Hinweis: Bitte ändert nicht manuell die Schriftfarbe auf schwarz sondern belasst es bei der Standardeinstellung. Somit tragt ihr dazu bei dass euer Text auch bei Verwendung unseren dunklen Forenstils noch lesbar ist!

Tipp: Ihr wollt längere Codeausschnitte oder Logfiles bereitstellen? Benutzt unseren eigenen PasteBin-Dienst Link
  • Hallo Liebe Breadfish Community
    ich habe ein Problem mit der Datenbank das ich in deinem Thema mehr erklären möchte
    ich entschuldige mich jetzt schonmal für meine Rechtschreibung
    also ich habe einen SAMP Server bei SAMP4YOU und habe das SaN Script [MrM]
    und wollte die Datenbank Hochladen...
    doch dann Kommt dieser Fehler



    SQL-Befehl:


    INSERT INTO `kickbans` VALUES (13380,'10.10.2011','20:30:05',0,0,'[MrM]Philip','[MrM]Philip','nickchange'),(13381,'10.10.2011','20:34:38',2,0,'Tanner_Man','[MrM]Philip','cheater haben einen kliene'),(13382,'10.10.2011','20:36:39',0,0,'Huntii.[$]','[MrM]LoddY','spam'),(13383,'10.10.2011','20:36:48',0,0,'Swagen','DeMax','afk im report'),(13384,'10.10.2011','20:49:13',0,0,'HolzfellerBOB','[MrM]RakedePaule','PNS Spam'),(13385,'10.10.2011','20:51:01',0,0,'SechsenSchreiber','.Sm0ky','Dafür schreibt man keinen report'),(13386,'10.10.2011','20:56:36',1,2,'Brainwash','DeMax','sdm auf medic'),(13387,'10.10.2011','21:00:57',1,2,'Itz','DeMax','sdm auf beamte'),(13388,'10.10.2011','21:27:20',0,0,'Chris.[587]','Nina.','BL ausnutze i.a [MrM]NoLife'),(13389,'10.10.2011','21:40:17',1,48,'.Dimple','[MrM]RakedePaule','adacausnutze, beleidigung, nötigung, jobmissbrauch'),(13390,'10.10.2011','21:41:40',1,6,'Kartoffelbrei','[MrM]RakedePaule','nötigung, adacbedrohen'),(13391,'10.10.2011','21:56:58',2,0,'Corn[...]

    #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 ''Lass das SDM und geh mit dem Hund' at line 1



    [12:01:02] [MySQL] Error (3): Could not execute query. Table 'samp5059_MrM.user' doesn't exist.
    [12:01:10] [MySQL] Error (0): Failed to exeute query. Table 'samp5059_MrM.usercounts' doesn't exist.
    [12:01:10] [MySQL] Error (0): Function: mysql_store_result called when no prior successful query executed. Table 'samp5059_MrM.usercounts' doesn't exist.
    [12:01:10] [MySQL] Error (0): Function: mysql_num_rows called when no result stored. Table 'samp5059_MrM.usercounts' doesn't exist.
    [12:01:10] [MySQL] Error (0): Failed to exeute query. 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 'samp5059_MrM.usercounts' doesn't exist.", error id: 5, connection: 0.','1')' at line 1.
    [12:01:14] [MySQL] Error (0): Failed to exeute query. Table 'samp5059_MrM.waffensaves' doesn't exist.
    [12:01:14] [MySQL] Error (0): Function: mysql_store_result called when no prior successful query executed. Table 'samp5059_MrM.waffensaves' doesn't exist.
    [12:01:14] [MySQL] Error (0): Function: mysql_num_rows called when no result stored. Table 'samp5059_MrM.waffensaves' doesn't exist.
    [12:01:14] [MySQL] Error (0): Failed to exeute query. Table 'samp5059_MrM.waffensaves' doesn't exist.
    [12:01:14] [MySQL] Error (0): Failed to exeute query. Table 'samp5059_MrM.user' doesn't exist.
    [12:01:14] Autos löschen dauert 0ms
    [12:02:15] --- Server Shutting Down.
    [12:02:15] [MySQL] Error (0): Failed to exeute query. Table 'samp5059_MrM.usercounts' doesn't exist.
    [12:02:15] [MySQL] Error (0): Function: mysql_store_result called when no prior successful query executed. Table 'samp5059_MrM.usercounts' doesn't exist.
    [12:02:15] [MySQL] Error (0): Function: mysql_num_rows called when no result stored. Table 'samp5059_MrM.usercounts' doesn't exist.
    [12:02:15] [MySQL] Error (0): Failed to exeute query. 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 'samp5059_MrM.usercounts' doesn't exist.", error id: 5, connection: 0.','1')' at line 1.
    [12:02:15] [MySQL] Error (0): Failed to exeute query. Table 'samp5059_MrM.state' doesn't exist.
    [12:02:15] [MySQL] Error (0): Failed to exeute query. Table 'samp5059_MrM.state' doesn't exist.
    [12:02:15] [MySQL] Error (0): Failed to exeute query. Table 'samp5059_MrM.state' doesn't exist.
    [12:02:15] [MySQL] Error (0): Failed to exeute query. Table 'samp5059_MrM.state' doesn't exist.
    [12:02:15] [MySQL] Error (0): Failed to exeute query. Table 'samp5059_MrM.state' doesn't exist.
    [12:02:15] [MySQL] Error (0): Failed to exeute query. Table 'samp5059_MrM.state' doesn't exist.
    [12:02:15] [MySQL] Error (0): Failed to exeute query. Table 'samp5059_MrM.state' doesn't exist.
    [12:02:15] [MySQL] Error (0): Failed to exeute query. Table 'samp5059_MrM.state' doesn't exist.
    [12:02:15] [MySQL] Error (0): Failed to exeute query. Table 'samp5059_MrM.state' doesn't exist.
    [12:02:15] [MySQL] Error (0): Failed to exeute query. Table 'samp5059_MrM.usercounts' doesn't exist.
    [12:02:15] [MySQL] Error (0): Function: mysql_store_result called when no prior successful query executed. Table 'samp5059_MrM.usercounts' doesn't exist.
    [12:02:15] [MySQL] Error (0): Function: mysql_num_rows called when no result stored. Table 'samp5059_MrM.usercounts' doesn't exist.
    [12:02:15] [MySQL] Error (0): Failed to exeute query. 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 'samp5059_MrM.usercounts' doesn't exist.", error id: 5, connection: 0.','1')' at line 1.
    [12:02:16] [MySQL] Error (0): Failed to exeute query. Table 'samp5059_MrM.zeitung' doesn't exist.
    [12:02:16] [MySQL] Error (0): Failed to exeute query. Table 'samp5059_MrM.zeitung' doesn't exist.
    [12:02:16] [MySQL] Error (0): Failed to exeute query. Table 'samp5059_MrM.zeitung' doesn't exist.
    [12:02:16] [MySQL] Error (0): Failed to exeute query. Table 'samp5059_MrM.zeitung' doesn't exist.
    [12:02:16] [MySQL] Error (0): Failed to exeute query. Table 'samp5059_MrM.zeitung' doesn't exist.
    [12:02:16] [MySQL] Error (0): Failed to exeute query. Table 'samp5059_MrM.zeitung' doesn't exist.
    [12:02:16] [MySQL] Error (0): Failed to exeute query. Table 'samp5059_MrM.zeitung' doesn't exist.
    [12:02:16] [MySQL] Error (0): Failed to exeute query. Table 'samp5059_MrM.zeitung' doesn't exist.
    [12:02:16] [MySQL] Error (0): Failed to exeute query. Table 'samp5059_MrM.zeitung' doesn't exist.
    [12:02:16] [MySQL] Error (0): Failed to exeute query. Table 'samp5059_MrM.zeitung' doesn't exist.
    [12:02:16] [MySQL] Error (0): Failed to exeute query. Table 'samp5059_MrM.zeitung' doesn't exist.
    [12:02:16] [MySQL] Error (0): Failed to exeute query. Table 'samp5059_MrM.zeitung' doesn't exist.
    [12:02:16] [MySQL] Error (0): Failed to exeute query. Table 'samp5059_MrM.zeitung' doesn't exist.
    [12:02:16] [MySQL] Error (0): Failed to exeute query. Table 'samp5059_MrM.zeitung' doesn't exist.
    [12:02:16] [MySQL] Error (0): Failed to exeute query. Table 'samp5059_MrM.zeitung' doesn't exist.
    [12:02:16] [MySQL] Error (0): Failed to exeute query. Table 'samp5059_MrM.zeitung' doesn't exist.
    [12:02:16] [MySQL] Error (0): Failed to exeute query. Table 'samp5059_MrM.zeitung' doesn't exist.
    [12:02:16] [MySQL] Error (0): Failed to exeute query. Table 'samp5059_MrM.zeitung' doesn't exist.
    [12:02:16] [MySQL] Closed (0). Logging ended.
    [12:02:16] [MySQL] Closed (1). Logging ended.
    [12:02:16] [MySQL] Closed (2). Logging ended.
    [12:02:16] [MySQL] Closed (3). Logging ended.
    [12:02:16]
    ich habe auch schon von anderen Gehört das die User Tabelle nicht erstellt wird was auch stimmt sie wird nicht erstelltweshalb man sich inGame Auch nicht Registrieren kannich bitte die leute die Ahnung haben mich zu Kontaktieren egal ob im Beitrag oder per Privatnachricht sich zu meldendas wäre sehr nett
    Bzw. Per PN Können wir weiteres Besprechen


    Mit Freundlichen Grüßen
    die Datenbankdatei nennt sich --18.02.2013_18-06


    Würde auch eine Bezahlung geben bei Interesse

    2 Mal editiert, zuletzt von [sRP]Maxim ()

  • #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 ''Lass das SDM und geh mit dem Hund' at line 1

    Der fehler wird ausgelöst wenn jemand ingame das Zeichen " ' " schreibt, z.B.: "Na wie geht's?"
    Da musst du das bevor du es an den Mysql server schickst damit escapen http://wiki.sa-mp.com/wiki/MySQL/R33#mysql_escape_string