[TheBosss]

Hello,

I updated my server to BlueG's mysql plugin r38,and when i compiled my gamemode i've got these errors:

Код:

error 017: undefined symbol "mysql_free_result"
error 017: undefined symbol "mysql_free_result"
error 017: undefined symbol "mysql_store_result"
error 017: undefined symbol "mysql_num_rows"
error 017: undefined symbol "mysql_store_result"
error 017: undefined symbol "mysql_num_rows"

So..can you tell me with what functions are these functions replaced?

[Mattakil]

Is the #include below the <a_samp>?

[TheBosss]

Yes,it is!

[Mattakil]

show the code of the errors

[DobbysGamertag]

pawn Код:

mysql_free_result();
mysql_store_result();

Are depreciated in R38.

while,

pawn Код:

mysql_num_rows();

is now:

pawn Код:

cache_num_rows(connectionHandle = 1);

read a few pages back (from the last page) of the release topic you'll see this

Quote:

Originally Posted by maddinat0r They do since R7. You have to delete the cache manually though if you are using "cache_save" or "mysql_query". EDIT: Whoops, forgot that there were also uncached queries in R7. Results are cleared automatically since R21.

[AceFlyer]

[Tutorial] Using BlueG's MySQL plugin R7 (with cache)

this basically covers all the new additions to the plugins. since R7 the plugin supports only threaded queries.
and introduces cache.

[ryansheilds]

If the plugin is correct I sometimes found that this was a problem with not having a few DLL files in your folder. The way I fixed it was add the following files to your root folder:



And ofc make sure you have libmysql.dll

If this doesn't work your either have two different versions of mysql. So download the one you need, add them and recompile the script with them.

Hope I can help