Which MySQL plugin shall i use to fix these errors?

Which MySQL plugin shall i use to fix these errors? - 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: Which MySQL plugin shall i use to fix these errors? (/showthread.php?tid=536272)

Which MySQL plugin shall i use to fix these errors? - TonyNames - 08.09.2014

Код:

[18:16:54] [debug] Run time error 19: "File or function is not found"
[18:16:54] [debug]  mysql_debug
[18:16:54] [debug]  mysql_function_query
[18:16:54] [debug]  cache_get_data
[18:16:54] [debug]  cache_get_row
[18:16:54] [debug]  cache_get_row_int
[18:16:54] [debug]  cache_get_row_float
[18:16:54] [debug] Run time error 19: "File or function is not found"
[18:16:54] [debug]  mysql_debug
[18:16:54] [debug]  mysql_function_query
[18:16:54] [debug]  cache_get_data
[18:16:54] [debug]  cache_get_row
[18:16:54] [debug]  cache_get_row_int
[18:16:54] [debug]  cache_get_row_float

Re: Which MySQL plugin shall i use to fix these errors? - Sawalha - 08.09.2014

R39-2 Version (Newest one)

Re: Which MySQL plugin shall i use to fix these errors? - TonyNames - 08.09.2014

i get these errors

Код:

C:\Users\Jakken Koppen\Desktop\RoleplayRoleplay\hrp\gamemodes\rprp.pwn(920) : warning 206: redundant test: constant expression is non-zero
C:\Users\Jakken Koppen\Desktop\RoleplayRoleplay\hrp\gamemodes\rprp.pwn(920) : warning 215: expression has no effect
C:\Users\Jakken Koppen\Desktop\RoleplayRoleplay\hrp\gamemodes\rprp.pwn(921) : error 017: undefined symbol "mysql_ping"
C:\Users\Jakken Koppen\Desktop\RoleplayRoleplay\hrp\gamemodes\rprp.pwn(1113) : warning 217: loose indentation
C:\Users\Jakken Koppen\Desktop\RoleplayRoleplay\hrp\gamemodes\rprp.pwn(12686) : error 017: undefined symbol "mysql_insert_id"
C:\Users\Jakken Koppen\Desktop\RoleplayRoleplay\hrp\gamemodes\rprp.pwn(14496) : error 017: undefined symbol "mysql_insert_id"
C:\Users\Jakken Koppen\Desktop\RoleplayRoleplay\hrp\gamemodes\rprp.pwn(14502) : error 017: undefined symbol "mysql_insert_id"
C:\Users\Jakken Koppen\Desktop\RoleplayRoleplay\hrp\gamemodes\rprp.pwn(14508) : error 017: undefined symbol "mysql_insert_id"
C:\Users\Jakken Koppen\Desktop\RoleplayRoleplay\hrp\gamemodes\rprp.pwn(14514) : error 017: undefined symbol "mysql_insert_id"
C:\Users\Jakken Koppen\Desktop\RoleplayRoleplay\hrp\gamemodes\rprp.pwn(14520) : error 017: undefined symbol "mysql_insert_id"
C:\Users\Jakken Koppen\Desktop\RoleplayRoleplay\hrp\gamemodes\rprp.pwn(14526) : error 017: undefined symbol "mysql_insert_id"
C:\Users\Jakken Koppen\Desktop\RoleplayRoleplay\hrp\gamemodes\rprp.pwn(14532) : error 017: undefined symbol "mysql_insert_id"
C:\Users\Jakken Koppen\Desktop\RoleplayRoleplay\hrp\gamemodes\rprp.pwn(14538) : error 017: undefined symbol "mysql_insert_id"
C:\Users\Jakken Koppen\Desktop\RoleplayRoleplay\hrp\gamemodes\rprp.pwn(14544) : error 017: undefined symbol "mysql_insert_id"
C:\Users\Jakken Koppen\Desktop\RoleplayRoleplay\hrp\gamemodes\rprp.pwn(14550) : error 017: undefined symbol "mysql_insert_id"
C:\Users\Jakken Koppen\Desktop\RoleplayRoleplay\hrp\gamemodes\rprp.pwn(14556) : error 017: undefined symbol "mysql_insert_id"
C:\Users\Jakken Koppen\Desktop\RoleplayRoleplay\hrp\gamemodes\rprp.pwn(14562) : error 017: undefined symbol "mysql_insert_id"
C:\Users\Jakken Koppen\Desktop\RoleplayRoleplay\hrp\gamemodes\rprp.pwn(14568) : error 017: undefined symbol "mysql_insert_id"
C:\Users\Jakken Koppen\Desktop\RoleplayRoleplay\hrp\gamemodes\rprp.pwn(14574) : error 017: undefined symbol "mysql_insert_id"
C:\Users\Jakken Koppen\Desktop\RoleplayRoleplay\hrp\gamemodes\rprp.pwn(14580) : error 017: undefined symbol "mysql_insert_id"
C:\Users\Jakken Koppen\Desktop\RoleplayRoleplay\hrp\gamemodes\rprp.pwn(14586) : error 017: undefined symbol "mysql_insert_id"
C:\Users\Jakken Koppen\Desktop\RoleplayRoleplay\hrp\gamemodes\rprp.pwn(14592) : error 017: undefined symbol "mysql_insert_id"
C:\Users\Jakken Koppen\Desktop\RoleplayRoleplay\hrp\gamemodes\rprp.pwn(14598) : error 017: undefined symbol "mysql_insert_id"
C:\Users\Jakken Koppen\Desktop\RoleplayRoleplay\hrp\gamemodes\rprp.pwn(14604) : error 017: undefined symbol "mysql_insert_id"
C:\Users\Jakken Koppen\Desktop\RoleplayRoleplay\hrp\gamemodes\rprp.pwn(14610) : error 017: undefined symbol "mysql_insert_id"
C:\Users\Jakken Koppen\Desktop\RoleplayRoleplay\hrp\gamemodes\rprp.pwn(16470) : error 017: undefined symbol "mysql_insert_id"
C:\Users\Jakken Koppen\Desktop\RoleplayRoleplay\hrp\gamemodes\rprp.pwn(16509) : error 017: undefined symbol "mysql_insert_id"
C:\Users\Jakken Koppen\Desktop\RoleplayRoleplay\hrp\gamemodes\rprp.pwn(16558) : error 017: undefined symbol "mysql_insert_id"
C:\Users\Jakken Koppen\Desktop\RoleplayRoleplay\hrp\gamemodes\rprp.pwn(17133) : error 017: undefined symbol "mysql_insert_id"

Compilation aborted.Pawn compiler 3.2.3664	 	 	Copyright © 1997-2006, ITB CompuPhase


26 Errors.

Re: Which MySQL plugin shall i use to fix these errors? - dusk - 08.09.2014

Show us the 920th line.

mysql_ping doesn't exist anymore. The plugin will try to auto-reconnect to the database.

Use cache_insert_id instead of mysql_insert_id.

Re: Which MySQL plugin shall i use to fix these errors? - TonyNames - 08.09.2014

Line 920

Код:

	mysql_debug(1);

Line 921

Код:

	if(mysql_ping() == -1)

The whole line

Код:

stock ConnectMySQL()
{
	dbHandle = mysql_connect(SQL_HOST, SQL_USER, SQL_DB, SQL_PASS);
	mysql_debug(1);
	if(mysql_ping() == -1)
	{
	    printf("Failed to connect to MySQL !");
	} else {
		printf("Connected to MySQL !");
	}
	return 1;
}

And the new errors

Код:

C:\Users\Jakken Koppen\Desktop\RoleplayRoleplay\hrp\gamemodes\rprp.pwn(920) : warning 206: redundant test: constant expression is non-zero
C:\Users\Jakken Koppen\Desktop\RoleplayRoleplay\hrp\gamemodes\rprp.pwn(920) : warning 215: expression has no effect
C:\Users\Jakken Koppen\Desktop\RoleplayRoleplay\hrp\gamemodes\rprp.pwn(921) : error 017: undefined symbol "mysql_ping"
C:\Users\Jakken Koppen\Desktop\RoleplayRoleplay\hrp\gamemodes\rprp.pwn(1113) : warning 217: loose indentation
C:\Users\Jakken Koppen\Desktop\RoleplayRoleplay\hrp\gamemodes\rprp.pwn(28381) : warning 217: loose indentation
C:\Users\Jakken Koppen\Desktop\RoleplayRoleplay\hrp\gamemodes\rprp.pwn(29970) : warning 217: loose indentation
C:\Users\Jakken Koppen\Desktop\RoleplayRoleplay\hrp\gamemodes\rprp.pwn(35072) : warning 203: symbol is never used: "SprayInfo"
Pawn compiler 3.2.3664	 	 	Copyright © 1997-2006, ITB CompuPhase


1 Error.

Re: Which MySQL plugin shall i use to fix these errors? - dusk - 08.09.2014

Change mysql_debug(1); to mysql_log();

pawn Код:

stock ConnectMySQL()
{
    dbHandle = mysql_connect(SQL_HOST, SQL_USER, SQL_DB, SQL_PASS);
    mysql_log();
    if(dbHandle)
    {
        printf("Failed to connect to MySQL !");
    } else {
        printf("Connected to MySQL !");
    }
    return 1;
}

mysql_connect will return a valid connection handle which is represented by a number, or 0 if the connection isn't successful.

loose indentation warnings mean that the code is not evenly indented.

Re: Which MySQL plugin shall i use to fix these errors? - TonyNames - 08.09.2014

How come i get those warnings?

Код:

C:\Users\Jakken Koppen\Desktop\RoleplayRoleplay\hrp\gamemodes\rprp.pwn(920) : warning 206: redundant test: constant expression is non-zero
C:\Users\Jakken Koppen\Desktop\RoleplayRoleplay\hrp\gamemodes\rprp.pwn(920) : warning 215: expression has no effect

Re: Which MySQL plugin shall i use to fix these errors? - dusk - 08.09.2014

I edited the code in my last post. You probably copied it all. I forgot to change mysql_debug to mysql_log in it.

Re: Which MySQL plugin shall i use to fix these errors? - Sawalha - 09.09.2014

Mm.. mysql_debug isn't exist in R39-2 anymore, Use mysql_log now for debugging file.

pawn Код:

//Ex
mysql_log(LOG_ALL);

Re: Which MySQL plugin shall i use to fix these errors? - Vince - 09.09.2014

Quote:

Originally Posted by TonyNames

How come i get those warnings?

Код:

C:\Users\Jakken Koppen\Desktop\RoleplayRoleplay\hrp\gamemodes\rprp.pwn(920) : warning 206: redundant test: constant expression is non-zero
C:\Users\Jakken Koppen\Desktop\RoleplayRoleplay\hrp\gamemodes\rprp.pwn(920) : warning 215: expression has no effect

That means you're (probably indirectly) doing something like

pawn Код:

if(1 == 1)

Which is always true ("non-zero") and thus redundant. Probably hidden in the form of:

pawn Код:

#define ENABLE_SOME_FEATURE 1
if(ENABLE_SOME_FEATURE == 1)
{

}

In which case you should use directives instead (the lines starting with #).

pawn Код:

#if ENABLE_SOME_FEATURE == 1
// code
#endif