SA-MP Forums Archive
no active cache available - Printable Version

+- SA-MP Forums Archive (https://sampforum.blast.hk)
+-- Forum: SA-MP Scripting and Plugins (https://sampforum.blast.hk/forumdisplay.php?fid=8)
+--- Forum: Scripting Help (https://sampforum.blast.hk/forumdisplay.php?fid=12)
+--- Thread: no active cache available (/showthread.php?tid=507172)



no active cache available - S4t3K - 16.04.2014

Hi.

I've made my own registration system, but when I start the server and when someone registers, the player is automatically kicked.
And a file called mysql_log is created in my server folder.
The MySQL log tells me this :

Quote:
Originally Posted by mysql_log
[WARNING] cache_get_row_count - no active cache
[WARNING] cache_affected_rows - no active cache
[ERROR] CMySQLQuery::Execute[] - (error #1136) Column count doesn't match value count at row 1
When i process a query, i do like this :

PHP Code:

new query[512];
format(querysizeof(query), "SELECT * FROM `Joueurs` WHERE `pseudo` = '%s'"GetName(playerid));
mysql_tquery(handlequery); 
Then, I use cache_num_rows to chose which dialog must displays

PHP Code:

if(cache_num_rows() > 0)
{
   
ShowPlayerDialog(playeridD_LOGINDPSWlogin"Valider""");
   return 
1;
}
else
{
   
ShowPlayerDialog(playeridD_REGISTERDPSWregis"Valider""");
   return 
1;

What's wrong ? Or how must I set an active cache ?
I read the wiki about cache_set_active but I didn't understood at all.