mysql error

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
    Ich habe das IR script und habe versucht es mit der localen datenbank zu verbinden.
    Jedoch kommt es mir so vor als würde es nicht gehen..
    Die Acc werden nicht gespeichert die Fraktionsfahrzeuge und Gangfight gebiete ebenfalls nicht.
    Mein nechster versuch war ein neues inc.
    aber ich bekomme diese errors
    :C:\Users\mave\Desktop\Neuer Ordner (10)\Inter Roleplay Script by Darius und Acer\gamemodes\IR.pwn.pwn(6511) : warning 213: tag mismatch
    C:\Users\mave\Desktop\Neuer Ordner (10)\Inter Roleplay Script by Darius und Acer\gamemodes\IR.pwn.pwn(9202) : warning 213: tag mismatch
    C:\Users\mave\Desktop\Neuer Ordner (10)\Inter Roleplay Script by Darius und Acer\gamemodes\IR.pwn.pwn(16689) : error 017: undefined symbol "mysql_query"
    C:\Users\mave\Desktop\Neuer Ordner (10)\Inter Roleplay Script by Darius und Acer\gamemodes\IR.pwn.pwn(17397) : error 037: invalid string (possibly non-terminated string)
    C:\Users\mave\Desktop\Neuer Ordner (10)\Inter Roleplay Script by Darius und Acer\gamemodes\IR.pwn.pwn(17397) : error 017: undefined symbol "users"
    C:\Users\mave\Desktop\Neuer Ordner (10)\Inter Roleplay Script by Darius und Acer\gamemodes\IR.pwn.pwn(17397) : error 017: undefined symbol "s"
    C:\Users\mave\Desktop\Neuer Ordner (10)\Inter Roleplay Script by Darius und Acer\gamemodes\IR.pwn.pwn(17397) : fatal error 107: too many error messages on one line


    Compilation aborted.Pawn compiler 3.2.3664 Copyright (c) 1997-2006, ITB CompuPhase



    5 Errors.




    GetPlayerName(playerid, sendername, sizeof(sendername)); //Wir Speichern den Namen des Spielers in der Variable [i]SpielerInfo[playerid][pName][/i]
    if(IsPlayerConnected(playerid) && !IsPlayerNPC(playerid))//Wir fragen ab ob der angegebene Spieler auch Online ist, und kein NPC ist (nur zur sicherhheit)
    {
    format(string, sizeof(string),"SELECT * FROM `users` WHERE `Name` = '%s'", sendername);
    /hier/ mysql_query(string);//wir holen uns alles aus der tabelle "tabelle_mit_den_haeusern"
    mysql_store_result();//speichern dann das ergebniss
    new val[ 256 ];
    while(mysql_fetch_row_format(string,"|"))
    {
    self_mysql_get_field("Level", val); PlayerInfo[playerid][pLevel] = strval( val );
    self_mysql_get_field("AdminLevel", val); PlayerInfo[playerid][pAdmin] = strval( val );



    strcat(endstring, var, sizeof(endstring));
    self_mysql_query(endstring);


    new string[128];
    //#else
    /hier/ format(string, sizeof(string), "users/%s.ini, playername);
    new File: hFile = fopen(string, io_write);
    if (hFile)
    {
    //new var[32];
    format(var, 32, "Key=%s\n", PlayerInfo[playerid][pKey]);fwrite(hFile, var);
    format(var, 32, "Level=%d\n",PlayerInfo[playerid][pLevel]);fwrite(hFile, var); :huh:

  • ok danke das war dan mein Fehler...
    aber nun das C:\Users\mave\Desktop\Neuer Ordner (10)\Inter Roleplay Script by Darius und Acer\gamemodes\IR.pwn.pwn(6511) : warning 213: tag mismatch
    C:\Users\mave\Desktop\Neuer Ordner (10)\Inter Roleplay Script by Darius und Acer\gamemodes\IR.pwn.pwn(9202) : warning 213: tag mismatch
    C:\Users\mave\Desktop\Neuer Ordner (10)\Inter Roleplay Script by Darius und Acer\gamemodes\IR.pwn.pwn(16689) : error 017: undefined symbol "mysql_query"
    C:\Users\mave\Desktop\Neuer Ordner (10)\Inter Roleplay Script by Darius und Acer\gamemodes\IR.pwn.pwn(17701) : warning 203: symbol is never used: "logtext"
    C:\Users\mave\Desktop\Neuer Ordner (10)\Inter Roleplay Script by Darius und Acer\gamemodes\IR.pwn.pwn(17701) : warning 203: symbol is never used: "log"
    C:\Users\mave\Desktop\Neuer Ordner (10)\Inter Roleplay Script by Darius und Acer\gamemodes\IR.pwn.pwn(26144) : warning 213: tag mismatch
    C:\Users\mave\Desktop\Neuer Ordner (10)\Inter Roleplay Script by Darius und Acer\gamemodes\IR.pwn.pwn(53588) : error 017: undefined symbol "mysql_query"
    C:\Users\mave\Desktop\Neuer Ordner (10)\Inter Roleplay Script by Darius und Acer\gamemodes\IR.pwn.pwn(55357) : error 017: undefined symbol "mysql_query"
    C:\Users\mave\Desktop\Neuer Ordner (10)\Inter Roleplay Script by Darius und Acer\gamemodes\IR.pwn.pwn(56042) : error 017: undefined symbol "mysql_query"
    C:\Users\mave\Desktop\Neuer Ordner (10)\Inter Roleplay Script by Darius und Acer\gamemodes\IR.pwn.pwn(56051) : error 017: undefined symbol "mysql_query"
    C:\Users\mave\Desktop\Neuer Ordner (10)\Inter Roleplay Script by Darius und Acer\gamemodes\IR.pwn.pwn(56060) : error 017: undefined symbol "mysql_query"
    C:\Users\mave\Desktop\Neuer Ordner (10)\Inter Roleplay Script by Darius und Acer\gamemodes\IR.pwn.pwn(56072) : error 017: undefined symbol "mysql_query"
    C:\Users\mave\Desktop\Neuer Ordner (10)\Inter Roleplay Script by Darius und Acer\gamemodes\IR.pwn.pwn(56074) : error 017: undefined symbol "mysql_fetch_int"
    C:\Users\mave\Desktop\Neuer Ordner (10)\Inter Roleplay Script by Darius und Acer\gamemodes\IR.pwn.pwn(56085) : error 017: undefined symbol "mysql_query"
    C:\Users\mave\Desktop\Neuer Ordner (10)\Inter Roleplay Script by Darius und Acer\gamemodes\IR.pwn.pwn(56087) : error 017: undefined symbol "mysql_fetch_int"
    Pawn compiler 3.2.3664 Copyright (c) 1997-2006, ITB CompuPhase



    10 Errors.




    vllt hilft das ja ...der in. inhalt:
    /**
    * MySQL plugin R7
    * Copyright (c) 2008-2011, BlueG
    */


    #if defined mysql_included
    #endinput
    #endif
    #define mysql_included


    /**
    * Common error codes
    *
    * Client: http://dev.mysql.com/doc/refman/5.0/en/error-messages-client.html
    * Server: http://dev.mysql.com/doc/refman/5.0/en/error-messages-server.html
    *
    */


    #define ER_DBACCESS_DENIED_ERROR 1044
    #define ER_ACCESS_DENIED_ERROR 1045
    #define ER_UNKNOWN_TABLE 1109
    #define ER_SYNTAX_ERROR 1149
    #define CR_SERVER_GONE_ERROR 2006
    #define CR_SERVER_LOST 2013
    #define CR_COMMAND_OUT_OF_SYNC 2014
    #define CR_SERVER_LOST_EXTENDED 2055


    // Native functions


    #define mysql_fetch_row(%1) mysql_fetch_row_format(%1,"|")
    #define mysql_next_row() mysql_retrieve_row()
    #define mysql_get_field(%1,%2) mysql_fetch_field_row(%2,%1)


    #define mysql_query_callback(%1,%2,%3,%4,%5) \
    mysql_function_query(%5, %2, false, %3, "siii", %2, %1, %4, %5)


    #define mysql_query(%1,%2,%3,%4) \
    mysql_function_query(%4, %1, false, "OnQueryFinish", "siii", %1, %2, %3, %4)



    native mysql_affected_rows(connectionHandle = 1);
    native mysql_close(connectionHandle = 1);
    native mysql_connect(const host[], const user[], const database[], const password[], port = 3306);
    native mysql_data_seek(offset, connectionHandle = 1);
    native mysql_debug(enable = 1);
    native mysql_errno(connectionHandle = 1);
    native mysql_fetch_field(number, dest[], connectionHandle = 1);
    native mysql_fetch_field_row(string[], const fieldname[], connectionHandle = 1);
    native mysql_fetch_row_format(string[], const delimiter[] = "|", connectionHandle = 1);
    native mysql_format(connectionHandle, output[], format[], {Float,_}:...);
    native mysql_field_count(connectionHandle = 1);
    native mysql_free_result(connectionHandle = 1);
    native mysql_get_charset(destination[], connectionHandle = 1);
    native mysql_insert_id(connectionHandle = 1);
    native mysql_num_rows(connectionHandle = 1);
    native mysql_num_fields(connectionHandle = 1);
    native mysql_ping(connectionHandle = 1);
    native mysql_real_escape_string(const source[], destination[], connectionHandle = 1);
    native mysql_reconnect(connectionHandle = 1);
    native mysql_reload(connectionHandle = 1);
    native mysql_retrieve_row(connectionHandle = 1);
    native mysql_set_charset(charset[], connectionHandle = 1);
    native mysql_stat(const destination[], connectionHandle = 1);
    native mysql_store_result(connectionHandle = 1);
    native mysql_warning_count(connectionHandle = 1);


    // Cache functions


    native mysql_function_query(connectionHandle, query[], bool:cache, callback[], format[], {Float,_}:...);
    native cache_get_row(row, idx, dest[], connectionHandle = 1);
    native cache_get_field(field_index, dest[], connectionHandle = 1);
    native cache_get_data(&num_rows, &num_fields, connectionHandle = 1);
    native cache_get_field_content(row, const field_name[], dest[], connectionHandle = 1);
    native enable_mutex(bool:enable);


    // forward declarations


    forward OnQueryError(errorid, error[], callback[], query[], connectionHandle);

  • /**
    * MySQL plugin R7
    * Copyright (c) 2008-2011, BlueG
    */


    #if defined mysql_included
    #endinput
    #endif
    #define mysql_included


    /**
    * Common error codes
    *
    * Client: http://dev.mysql.com/doc/refman/5.0/en/error-messages-client.html
    * Server: http://dev.mysql.com/doc/refman/5.0/en/error-messages-server.html
    *
    */


    #define ER_DBACCESS_DENIED_ERROR 1044
    #define ER_ACCESS_DENIED_ERROR 1045
    #define ER_UNKNOWN_TABLE 1109
    #define ER_SYNTAX_ERROR 1149
    #define CR_SERVER_GONE_ERROR 2006
    #define CR_SERVER_LOST 2013
    #define CR_COMMAND_OUT_OF_SYNC 2014
    #define CR_SERVER_LOST_EXTENDED 2055


    // Native functions


    #define mysql_fetch_row(%1) mysql_fetch_row_format(%1,"|")
    #define mysql_next_row() mysql_retrieve_row()
    #define mysql_get_field(%1,%2) mysql_fetch_field_row(%2,%1)


    #define mysql_query_callback(%1,%2,%3,%4,%5) \
    mysql_function_query(%5, %2, false, %3, "siii", %2, %1, %4, %5)


    #define mysql_query(%1,%2,%3,%4) \
    mysql_function_query(%4, %1, false, "OnQueryFinish", "siii", %1, %2, %3, %4)



    native mysql_affected_rows(connectionHandle = 1);
    native mysql_close(connectionHandle = 1);
    native mysql_connect(const host[], const user[], const database[], const password[], port = 3306);
    native mysql_data_seek(offset, connectionHandle = 1);
    native mysql_debug(enable = 1);
    native mysql_errno(connectionHandle = 1);
    native mysql_fetch_field(number, dest[], connectionHandle = 1);
    native mysql_fetch_field_row(string[], const fieldname[], connectionHandle = 1);
    native mysql_fetch_row_format(string[], const delimiter[] = "|", connectionHandle = 1);
    native mysql_format(connectionHandle, output[], format[], {Float,_}:...);
    native mysql_field_count(connectionHandle = 1);
    native mysql_free_result(connectionHandle = 1);
    native mysql_get_charset(destination[], connectionHandle = 1);
    native mysql_insert_id(connectionHandle = 1);
    native mysql_num_rows(connectionHandle = 1);
    native mysql_num_fields(connectionHandle = 1);
    native mysql_ping(connectionHandle = 1);
    native mysql_real_escape_string(const source[], destination[], connectionHandle = 1);
    native mysql_reconnect(connectionHandle = 1);
    native mysql_reload(connectionHandle = 1);
    native mysql_retrieve_row(connectionHandle = 1);
    native mysql_set_charset(charset[], connectionHandle = 1);
    native mysql_stat(const destination[], connectionHandle = 1);
    native mysql_store_result(connectionHandle = 1);
    native mysql_warning_count(connectionHandle = 1);


    // Cache functions


    native mysql_function_query(connectionHandle, query[], bool:cache, callback[], format[], {Float,_}:...);
    native cache_get_row(row, idx, dest[], connectionHandle = 1);
    native cache_get_field(field_index, dest[], connectionHandle = 1);
    native cache_get_data(&num_rows, &num_fields, connectionHandle = 1);
    native cache_get_field_content(row, const field_name[], dest[], connectionHandle = 1);
    native enable_mutex(bool:enable);


    // forward declarations


    forward OnQueryError(errorid, error[], callback[], query[], connectionHandle);