[GuskiS]

L 02/22/2015 - 23:07:23: Info (map "cs_italy_mini") (file "addons/amxmodx/logs/error_20150222.log")
L 02/22/2015 - 23:07:23: [AMXX] Plugin ("ttt_antiretry_system.amxx") is setting itself as failed.
L 02/22/2015 - 23:07:23: [AMXX] Plugin says: unable to open database file
L 02/22/2015 - 23:07:23: [AMXX] Run time error 1 (plugin "ttt_antiretry_system.amxx") - forced exit

Build ID: 4616:5a7752a

I'm having issues with MySQL module using sqlite. It happens randomly, every couple of maps. What is the problem?
Code(1 mysql, 2 sqlite):

PHP Code:

public MySQL_Init()
{
    new cvar = get_pcvar_num(cvar_stats);
    if(cvar == 1)
    {
        new host[64], user[33], pass[32], db[32];
        get_cvar_string("amx_sql_host", host, charsmax(host));
        get_cvar_string("amx_sql_user", user, charsmax(user));
        get_cvar_string("amx_sql_pass", pass, charsmax(pass));
        get_cvar_string("amx_sql_db", db, charsmax(db));
        g_pSqlTuple = SQL_MakeDbTuple(host, user, pass, db);
    }
    else if(cvar == 2)
    {
        SQL_SetAffinity("sqlite");
        g_pSqlTuple = SQL_MakeDbTuple("localhost", "root", "", "ttt_db");

    }
    else set_fail_state("[TTT] CVAR set wrongly, plugin turning off!");

    new error[128];
    new code, Handle:connection = SQL_Connect(g_pSqlTuple, code, error, charsmax(error));
    if(connection == Empty_Handle)
        set_fail_state(error);

    new Handle:queries;
    if(cvar == 1)
    {
        queries = SQL_PrepareQuery(connection, 
            "CREATE TABLE IF NOT EXISTS ttt_stats(\
                id int unsigned NOT NULL AUTO_INCREMENT, \
                player_name varchar(40) UNIQUE NOT NULL default '', \
                gwk int(10), \
                kills_i int(10), \
                kills_d int(10), \
                kills_t int(10), \
                rdm int(10), \
                innocent int(15), \
                detective int(10), \
                traitor int(10), \
                bomb_planted int(10), \
                bomb_exploded int(10), \
                bomb_defused int(10), \
                total_points int(32), \
                PRIMARY KEY (id)\
            );"
        );
    }
    else if(cvar == 2)
    {
        queries = SQL_PrepareQuery(connection, 
            "CREATE TABLE IF NOT EXISTS ttt_stats(\
                id INTEGER PRIMARY KEY, \
                player_name CHAR(40) UNIQUE NOT NULL default '', \
                gwk INTEGER, \
                kills_i INTEGER, \
                kills_d INTEGER, \
                kills_t INTEGER, \
                rdm INTEGER, \
                innocent INTEGER, \
                detective INTEGER, \
                traitor INTEGER, \
                bomb_planted INTEGER, \
                bomb_exploded INTEGER, \
                bomb_defused INTEGER, \
                total_points INTEGER\
            );"
        );
    }

    if(!SQL_Execute(queries))
    {
        SQL_QueryError(queries, error, charsmax(error));
        set_fail_state(error);
    }

    SQL_FreeHandle(queries);
    SQL_FreeHandle(connection); 
} 


[Arkshine]

Do you have SELinux enabled? if so, disable it.

[GuskiS]

After doing little research on SELinux, I think I'm not using it. I have Ubuntu 14.04.1. While searching about SELinux, found out that default protection in Ubuntu is AppArmor, but after finding commands, it showed that apparmor module is not loaded.

[GuskiS]

So?

[Arkshine]

So, it could sound like a permission issue too.

[GuskiS]

What kind of permissions are you reffering to?

[Arkshine]

I'm not sure, like the user/group you're using for HLDS doesn't have the access to write in the directory where the database is. It's likely a permission issue. You should check it (/tmp too in case).