[BFBombi]

Hello, i have a problem, but can't resolve it.

public OnPluginStart()
{
	...
	SQL_TConnect(GotDatabase, "vote_vs");
}

public GotDatabase(Handle:owner, Handle:hndl, const String:error[], any:data)
{
	if (hndl == INVALID_HANDLE)
    {
        SetFailState("Error connecting to database. %s", error);
    } else {
        Database = hndl;
    }
}  

public OnMapStart()
{
	g_VoteNum = 0;
	s_VoteNumFirst = 0;
	s_VoteNumSecond = 0;
	
	s_VoteNameFirst = "";
	s_VoteNameSecond = "";
	
	new String:query[255];
    Format(query, sizeof(query), "SELECT * FROM vote ORDER BY id DESC LIMIT 1");
    new Handle:query_r = SQL_Query(Database, query);
	
	if(SQL_FetchRow(query_r) == false) {
		PrintToServer("[Votes] Can't fetch row.");
	} else {
	    PrintToServer("[Votes] Fetched row");
        g_VoteNum = SQL_FetchInt(query_r, 0);
		s_VoteNumFirst = SQL_FetchInt(query_r, 1);
		s_VoteNumSecond = SQL_FetchInt(query_r, 2);
		SQL_FetchString(query_r, 3, s_VoteNameFirst, 256);
		SQL_FetchString(query_r, 4, s_VoteNameSecond, 256);
		
    }
	
    CloseHandle(query_r);
}

It give me an error

Native "SQL_Query" reported: Invalid  database Handle 0 (error: 4)

Database setting is all okey!

[necavi]

First: Use threaded queries, and second: you're not allowing enough time to connect to the database, most likely.

[BFBombi]

Originally Posted by necavi second: you're not allowing enough time to connect to the database, most likely.

How i can fix it ?

[necavi]

Put your query in the callback for TConnecting to the database, right under your Database = hndl line.

[BFBombi]

Thaks!