SA-MP Forums

Go Back   SA-MP Forums > SA-MP Scripting and Plugins > Scripting Help

Reply
 
Thread Tools Display Modes
Old 12/06/2018, 06:53 PM   #1
Stefand
Gangsta
 
Stefand's Avatar
 
Join Date: Sep 2011
Location: The Netherlands
Posts: 779
Reputation: 27
Default Proper MYSQL Errors in console.

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:
Code:
[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:
Code:
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.
__________________


Scripter & Mapper
_______________________
Stefand is offline   Reply With Quote
Old 12/06/2018, 06:58 PM   #2
CodeStyle175
Banned
 
Join Date: Apr 2014
Posts: 481
Reputation: 35
Default Re: Proper MYSQL Errors in console.

your gamemode uses old mysql
CodeStyle175 is offline   Reply With Quote
Old 12/06/2018, 07:00 PM   #3
Stefand
Gangsta
 
Stefand's Avatar
 
Join Date: Sep 2011
Location: The Netherlands
Posts: 779
Reputation: 27
Default Re: Proper MYSQL Errors in console.

Quote:
Originally Posted by CodeStyle175 View Post
your gamemode uses old mysql
Very helpful def rep+. Yes I know that but Strickenkid's stable and has all functions I need.
__________________


Scripter & Mapper
_______________________
Stefand is offline   Reply With Quote
Old 13/06/2018, 02:57 AM   #4
Slawi
Big Clucker
 
Join Date: Dec 2013
Posts: 47
Reputation: 1
Default Re: Proper MYSQL Errors in console.

what plugin version are you using ?
Slawi is offline   Reply With Quote
Old 13/06/2018, 07:31 PM   #5
Stefand
Gangsta
 
Stefand's Avatar
 
Join Date: Sep 2011
Location: The Netherlands
Posts: 779
Reputation: 27
Default Re: Proper MYSQL Errors in console.

SA:MP MySQL Plugin v2.1.1 Loaded.
__________________


Scripter & Mapper
_______________________
Stefand is offline   Reply With Quote
Reply

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
[MySQL] Proper way to do player statistics? Type-R Scripting Help 7 09/02/2017 05:09 PM
[MYSQL] proper way to do multi-table query??Rep+ iLuXing Scripting Help 4 01/03/2016 05:31 AM
Console gives me errors James Coral Scripting Help 3 30/03/2013 03:09 AM
Console errors :/ Elysian` Scripting Help 2 13/11/2012 04:19 PM
MySQL Console errors BleverCastard Scripting Help 1 03/06/2012 12:44 AM


All times are GMT. The time now is 05:32 AM.


Powered by vBulletin® Version 3.8.6
Copyright ©2000 - 2018, Jelsoft Enterprises Ltd.