error 017: undefined symbol "mysql_query"

error 017: undefined symbol "mysql_query" - 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: error 017: undefined symbol "mysql_query" (/showthread.php?tid=549643)

error 017: undefined symbol "mysql_query" - kbalor - 07.12.2014

i'm using blueg mysql r7, then after compiling iHouse v2 filtersript by Brandon_More it shows "error 017: undefined symbol "mysql_query"

Is there any way to fix it, to make it compatible with mysql r7? because if I tried to changing my mysql r7 to mysql r6 then after compiling my gamemode it shows hundreds of warnings.

EDIT: Did they change mysql_query to something?

EDIT2: I tried changing mysql_query to mysql_function_query but it shows "error 035: argument type mismatch (argument 1)"

Re: error 017: undefined symbol "mysql_query" - Abagail - 07.12.2014

It's easy to upgrade to r33+. Just use the a_mysql from r33 and show us the errors, and we'll be able to help you.

Re: error 017: undefined symbol "mysql_query" - Nightkill - 07.12.2014

Instead of mysql_query i use

Код:

mysql_format(mysql, sql, sizeof(sql), "SELECT * FROM yourtable");
mysql_tquery(mysql, sql, "", "");

Re: error 017: undefined symbol "mysql_query" - kbalor - 07.12.2014

Quote:

Originally Posted by Abagail

It's easy to upgrade to r33+. Just use the a_mysql from r33 and show us the errors, and we'll be able to help you.

Okay thanks, so after upgrading then compiling this errors shows below

Quote:

error 017: undefined symbol "mysql_debug" <= mysql_debug(1);
error 035: argument type mismatch (argument 1) <= all the mysql_query - 20+ error lines

Re: error 017: undefined symbol "mysql_query" - kbalor - 07.12.2014

Quote:

Originally Posted by Nightkill

Instead of mysql_query i use

Код:

mysql_format(mysql, sql, sizeof(sql), "SELECT * FROM yourtable");
mysql_tquery(mysql, sql, "", "");

which version of mysql you're using?

coz my gamemode is only compatible for mysql r7 if I upgraded to the latest version it shows hundreds of errors and the filterscript that I'am using is compatible with mysql r6.

Re: error 017: undefined symbol "mysql_query" - Nightkill - 07.12.2014

I'm using R39-2 which I think it's the latest.

Re: error 017: undefined symbol "mysql_query" - kbalor - 07.12.2014

Quote:

Originally Posted by Nightkill

I'm using R39-2 which I think it's the latest.

cool! I hope someone help me with this. I tried using R39-2 but it shows warning

Quote:

warning 206: redundant test: constant expression is non-zero
warning 215: expression has no effect

line:

Quote:

mysql_debug(1);

Re: error 017: undefined symbol "mysql_query" - Nightkill - 07.12.2014

On main() I have something like this for debug

Код:

mysql_log(LOG_ERROR | LOG_WARNING | LOG_DEBUG);
mysql = mysql_connect(host, user, db, pass);

so everytime I start the server a file named mysql_log.txt will be created and there I have the full debugging

Re : Re: error 017: undefined symbol "mysql_query" - Dutheil - 07.12.2014

Quote:

Originally Posted by Nightkill

Instead of mysql_query i use

Код:

mysql_format(mysql, sql, sizeof(sql), "SELECT * FROM yourtable");
mysql_tquery(mysql, sql, "", "");

just : mysql_tquery(mysql, sql);
will work