Proper MYSQL Errors in console.

Proper MYSQL Errors in console. - 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: Proper MYSQL Errors in console. (/showthread.php?tid=655082)

Proper MYSQL Errors in console. - Stefand - 12.06.2018

Hello,

So I don't know what changed but 2 years ago when I used Strickenskid and had the MYSQLerror public it showed the query where the error occurred in.

Now 2 years later, it does this:

Код:

[MySQL] Error (0): Failed to exeute query. Unknown column '' in 'order clause'.
[MySQL] Error (0): Function: mysql_store_result called when no prior successful query executed. Unknown column '' in 'order clause'.
[MySQL] Error (0): Function: mysql_num_rows called when no result stored. Unknown column '' in 'order clause'.
[MySQL] Error (0): Function: mysql_num_rows called when no result stored. Unknown column '' in 'order clause'.
[MySQL] Error (0): Failed to exeute query. Unknown column '' in 'order clause'.
[MySQL] Error (0): Function: mysql_store_result called when no prior successful query executed. Unknown column '' in 'order clause'.
[MySQL] Error (0): Function: mysql_num_rows called when no result stored. Unknown column '' in 'order clause'.
[MySQL] Error (0): Function: mysql_num_rows called when no result stored. Unknown column '' in 'order clause'.
[MySQL] Error (0): Failed to exeute query. Unknown column '' in 'order clause'.
[MySQL] Error (0): Function: mysql_store_result called when no prior successful query executed. Unknown column '' in 'order clause'.
[MySQL] Error (0): Function: mysql_num_rows called when no result stored. Unknown column '' in 'order clause'.
[MySQL] Error (0): Function: mysql_num_rows called when no result stored. Unknown column '' in 'order clause'.

I used:

Код:

public OnMysqlError(error[], errorid, MySQL:handle)
{
	printf("Error: %s | Query: %s", errorid, error);
	return 1;
}

In the past but this does not work anymore either, it only adds "Query:" infront of the error.

Re: Proper MYSQL Errors in console. - CodeStyle175 - 12.06.2018

your gamemode uses old mysql

Re: Proper MYSQL Errors in console. - Stefand - 12.06.2018

Quote:

Originally Posted by CodeStyle175

your gamemode uses old mysql

Very helpful def rep+. Yes I know that but Strickenkid's stable and has all functions I need.

Re: Proper MYSQL Errors in console. - Slawi - 13.06.2018

what plugin version are you using ?

Re: Proper MYSQL Errors in console. - Stefand - 13.06.2018

SA:MP MySQL Plugin v2.1.1 Loaded.