[SpeeDeeR]

PHP Code:

#define TABLE_NAME "Statics"
#define KEY_TODAYVISITS "Today_Visits"
#define KEY_MOSTVISITS "Most_Visits"
#define KEY_TOTALVISITS "Total_Visits"
#define KEY_UPTIME "Total_Uptime"
#define KEY_KILLS "Kills"
#define KEY_DEATHS "Deaths"

/*<snippet>*/
formatex(query, 255, "UPDATE %s SET %s = '%d', %s = '%s', %s = '%i', %s = '%i', %s = '%i', %s = '%i');",\
    TABLE_NAME,\
    KEY_TODAYVISITS, str_to_num(szToday),\
    KEY_MOSTVISITS, szMost,\
    KEY_TOTALVISITS, TotalVisits,\
    KEY_UPTIME, Total_Time,\
    KEY_KILLS, Total_Kills,\
    KEY_DEATHS, Total_Deaths
    );
    
    SQL_ThreadQuery(g_sql_tuple, "QueryWriteData", query);
/*</snippet>*/
public QueryWriteData(failstate, Handle:query, error[], errcode, data[], datasize, Float:queuetime)
{
    if( failstate == TQUERY_CONNECT_FAILED )
    {
        set_fail_state("Could not connect to database.");
    }
    else if( failstate == TQUERY_QUERY_FAILED )
    {
        set_fail_state("Query failed.");
    }
    else if( errcode )
    {
        log_amx("Error on query: %s", error);
    }
} 


[AMXX] Plugin says: Query failed.
Run time error 1: forced exit 
[AMXX] [0] QueryWriteData (line 189)

Am new to SQL and I can't find the error.


EDIT: Just saw the bracket.

[meTaLiCroSS]

"UPDATE %s SET %s = '%d', %s = '%s', %s = '%i', %s = '%i', %s = '%i', %s = '%i');"