[bibu]

I get this with the plugin:

L 01/14/2012 - 22:147: [Untitled.amxx] SQL error: near "auto_increment": syntax error L 01/14/2012 - 22:147: [Untitled.amxx] Error while creating steamid table. Pausing plugin.

PHP Code:

#define CREATE_TABLE_STEAMIDS        "CREATE TABLE IF NOT EXISTS steamids (steamid varchar(40) NOT NULL default '',  id int(11) NOT NULL auto_increment,  PRIMARY KEY  (id),  UNIQUE KEY STEAMID (steamid)) TYPE=MyISAM;"

bool:create_tables()
{
    new Sql:sql
    
    if (!connect(sql))
    {
        log_amx("[%s] Failed connecting to database. Pausing plugin.", PLUGINNAME)
        pause("ad")
        return false
    }

    new Result:result

    format(g_query, QSIZE, "%s", CREATE_TABLE_STEAMIDS)

    result = dbi_query(sql, g_query)

    if (result <= RESULT_FAILED && dbi_check_error(sql))
    {
        log_amx("Error while creating steamid table. Pausing plugin.")
        disconnect(sql)
        pause("ad")
        return false
    }
    
    jghg_free_result(result)

    format(g_query, QSIZE, "%s", CREATE_TABLE_NAMES)

    result = dbi_query(sql, g_query)

    if (result <= RESULT_FAILED && dbi_check_error(sql))
    {
        log_amx("Error while creating names table. Pausing plugin.")
        disconnect(sql)
        pause("ad")
        return false
    }
    
    jghg_free_result(result)

    disconnect(sql)

    return true
}

jghg_free_result(Result:result)
{
    if(result > RESULT_NONE)
    {
        dbi_free_result(result)
    }
}

dbi_check_error(&Sql:sql)
{
    new error[256] = ""
    dbi_error(sql, error, 255)
    
    if(error[0] && !equal(error, "Not an error"))
    {
        log_amx("SQL error: %s", error)

        return true
    }
    return false
}

disconnect(&Sql:sql)
{
    if(sql > SQL_FAILED)
    {
        dbi_close(sql)
        sql = SQL_FAILED
    }
} 


[Sylwester]

It should work fine with mysql. If you are trying to use it with sqlite, then you need to change query:

CREATE TABLE IF NOT EXISTS steamids (steamid varchar(40) UNIQUE NOT NULL, id INTEGER PRIMARY KEY AUTOINCREMENT);

[bibu]

Mhmm... very weird. I am running actually mysql, on a friend it runs perfect. However, it is a sign, I get the same for the other table now, would be really appreciated:

PHP Code:

"CREATE TABLE IF NOT EXISTS names (  timestamp int(10) unsigned NOT NULL default '0',  counter int(10) unsigned NOT NULL default '1',  id int(11) NOT NULL default '0',  name varchar(32) binary NOT NULL default '',  PRIMARY KEY  (id,name)) TYPE=MyISAM; " 


[Sylwester]

I just updated my mysql (v5.5.20) and now I get syntax error caused by "TYPE=MyISAM" (you can remove it). The rest of the query should work fine, so if you get syntax errors then maybe you are connecting to sqlite without even knowing about it...

[bibu]

CREATE TABLE IF NOT EXISTS names (  timestamp int(10) unsigned NOT NULL default '0',  counter int(10) unsigned NOT NULL default '1',  id int(11) NOT NULL default '0',  name varchar(32) binary NOT NULL default '',  PRIMARY KEY  (id,name))

I get this now:

SQL error: near "unsigned": syntax error

[Sylwester]

You get this error because your plugin is using sqlite, not mysql. This query will work with sqlite:

CREATE TABLE IF NOT EXISTS names (  timestamp integer unsigned NOT NULL default '0',  counter integer unsigned NOT NULL default '1',  id integer NOT NULL default '0',  name varchar(32) NOT NULL default '',  PRIMARY KEY  (id,name));

[bibu]

How can I change it to mysql then? I see there are no tables in the mysql server but the plugin however works now.