search

pBlueG / SA-MP-MySQL

MySQL plugin for San Andreas Multiplayer
BSD 3-Clause "New" or "Revised" License
196 stars 80 forks source link

Bug mysql_log #224

Closed bobitza closed 4 years ago

bobitza commented 4 years ago

i set the mysql_log, i use r41-4 version but he put debug on and in log which is huge it say :

[10:01:04] [INFO] changed log level from 'warning, error' to 'debug, info, warning'

new MySQLOpt: option_id = mysql_init_options();
    mysql_log(ERROR | WARNING | INFO);
    mysql_set_option(option_id, AUTO_RECONNECT, true); // We will set that option to automatically reconnect on timeouts.

    Database = mysql_connect(sqlhost, sqluser, sqlpass, sqldb, option_id); // Setting up the "Database" handle on the given MySQL details above.
maddinat0r commented 4 years ago

Are you calling mysql_log in any other place? Make sure you're using the correct MySQL include (open it in your editor and make sure it says MySQL plugin R41-4). Also make sure you're properly recompiling it and not using an old AMX file by accident.

bobitza commented 4 years ago

Everything is checked,

But i noticed this is happened when i changed gamemode all functions, i putt it outside of gamemode in include, and function with connect is called in ongamemodeinit, I tried to put manually mysql_log in gamemodeinit to force but it's the same problem...

bobitza commented 4 years ago

Its bug if i put mysql_log(); with error | warning | info it's create big log and first line stat with

[10:37:08] [INFO] changed log level from 'warning, error' to 'debug, info, warning'

if i comment that line mysql_log(ERROR | WARNING | INFO); Its start normally with error|warning

bobitza commented 4 years ago

This is a_mysql.inc

` /**

if defined mysql_included

#endinput

endif

define mysql_included

/**

define ER_DBACCESS_DENIED_ERROR 1044

define ER_ACCESS_DENIED_ERROR 1045

define ER_UNKNOWN_TABLE 1109

define ER_SYNTAX_ERROR 1149

define CR_SERVER_GONE_ERROR 2006

define CR_SERVER_LOST 2013

define CR_COMMAND_OUT_OF_SYNC 2014

define CR_SERVER_LOST_EXTENDED 2055

if !defined E_LOGLEVEL

enum E_LOGLEVEL { NONE = 0, ERROR = 1, WARNING = 2, INFO = 4, DEBUG = 8,

ALL = ERROR | WARNING | INFO | DEBUG

};

endif

enum E_ORM_ERROR { ERROR_INVALID, ERROR_OK, ERROR_NO_DATA };

enum E_MYSQL_GLOBAL_OPTION { DUPLICATE_CONNECTIONS, DUPLICATE_CONNECTION_WARNING };

enum E_MYSQL_OPTION { AUTO_RECONNECT, MULTI_STATEMENTS, POOL_SIZE, SERVER_PORT, SSL_ENABLE, SSL_KEY_FILE, SSL_CERT_FILE, SSL_CA_FILE, SSL_CA_PATH, SSL_CIPHER };

enum E_MYSQL_FIELD_TYPE { MYSQL_TYPE_INVALID = -1, MYSQL_TYPE_DECIMAL = 0, MYSQL_TYPE_TINY, MYSQL_TYPE_SHORT, MYSQL_TYPE_LONG, MYSQL_TYPE_FLOAT, MYSQL_TYPE_DOUBLE, MYSQL_TYPE_NULL, MYSQL_TYPE_TIMESTAMP, MYSQL_TYPE_LONGLONG, MYSQL_TYPE_INT24, MYSQL_TYPE_DATE, MYSQL_TYPE_TIME, MYSQL_TYPE_DATETIME, MYSQL_TYPE_YEAR, MYSQL_TYPE_NEWDATE, MYSQL_TYPE_VARCHAR, MYSQL_TYPE_BIT, MYSQL_TYPE_TIMESTAMP2, MYSQL_TYPE_DATETIME2, MYSQL_TYPE_TIME2, MYSQL_TYPE_JSON = 245, MYSQL_TYPE_NEWDECIMAL = 246, MYSQL_TYPE_ENUM = 247, MYSQL_TYPE_SET = 248, MYSQL_TYPE_TINY_BLOB = 249, MYSQL_TYPE_MEDIUM_BLOB = 250, MYSQL_TYPE_LONG_BLOB = 251, MYSQL_TYPE_BLOB = 252, MYSQL_TYPE_VAR_STRING = 253, MYSQL_TYPE_STRING = 254, MYSQL_TYPE_GEOMETRY = 255 };

enum E_MYSQL_EXECTIME_UNIT { MILLISECONDS, MICROSECONDS };

define MYSQL_DEFAULT_HANDLE MySQL:1

define MYSQL_INVALID_HANDLE MySQL:0

define MYSQL_INVALID_CACHE Cache:0

define MYSQL_INVALID_ORM ORM:0

// ORM functions native ORM:orm_create(const table[], MySQL:handle = MYSQL_DEFAULT_HANDLE); native orm_destroy(ORM:id);

native E_ORM_ERROR:orm_errno(ORM:id);

native orm_apply_cache(ORM:id, row_idx, result_idx = 0);

native ormselect(ORM:id, const callback[] = "", const format[] = "", {Float, }:...); native ormupdate(ORM:id, const callback[] = "", const format[] = "", {Float, }:...); native orminsert(ORM:id, const callback[] = "", const format[] = "", {Float, }:...); native ormdelete(ORM:id, const callback[] = "", const format[] = "", {Float, }:...);

native ormload(ORM:id, const callback[] = "", const format[] = "", {Float, }:...) = orm_select; native ormsave(ORM:id, const callback[] = "", const format[] = "", {Float, }:...);

native orm_addvar_int(ORM:id, &var, const columnname[]); native orm_addvar_float(ORM:id, &Float:var, const columnname[]); native orm_addvar_string(ORM:id, var[], var_maxlen, const columnname[]);

native orm_clear_vars(ORM:id); native orm_delvar(ORM:id, const columnname[]); native orm_setkey(ORM:id, const columnname[]);

// MySQL functions native mysql_log(E_LOGLEVEL:loglevel = ERROR | WARNING); native MySQL:mysql_connect(const host[], const user[], const password[], const database[], MySQLOpt:option_id = MySQLOpt:0); native MySQL:mysql_connect_file(const file_name[] = "mysql.ini"); native mysql_close(MySQL:handle = MYSQL_DEFAULT_HANDLE);

native mysql_unprocessed_queries(MySQL:handle = MYSQL_DEFAULT_HANDLE); native mysql_global_options(E_MYSQL_GLOBAL_OPTION:type, value);

native MySQLOpt:mysql_init_options(); native mysql_set_option(MySQLOpt:option_id, E_MYSQL_OPTION:type, ...);

native mysqlpquery(MySQL:handle, const query[], const callback[] = "", const format[] = "", {Float,}:...); native mysqltquery(MySQL:handle, const query[], const callback[] = "", const format[] = "", {Float,}:...); native Cache:mysql_query(MySQL:handle, const query[], bool:use_cache = true); native mysql_query_file(MySQL:handle, const file_path[]);

native mysql_errno(MySQL:handle = MYSQL_DEFAULT_HANDLE); native mysql_escape_string(const source[], destination[], max_len = sizeof(destination), MySQL:handle = MYSQL_DEFAULT_HANDLE); native mysql_format(MySQL:handle, output[], maxlen, const format[], {Float,}:...); native mysql_set_charset(const charset[], MySQL:handle = MYSQL_DEFAULT_HANDLE); native mysql_get_charset(destination[], max_len = sizeof(destination), MySQL:handle = MYSQL_DEFAULT_HANDLE); native mysql_stat(destination[], max_len = sizeof(destination), MySQL:handle = MYSQL_DEFAULT_HANDLE);

// Cache functions native cache_get_row_count(&destination); native cache_get_field_count(&destination); native cache_get_result_count(&destination); native cache_get_field_name(field_index, destination[], max_len = sizeof(destination)); native E_MYSQL_FIELD_TYPE:cache_get_field_type(field_index); native cache_set_result(result_index);

stock cache_num_rows() { new row_count; cache_get_row_count(row_count); return row_count; } stock cache_num_fields() { new field_count; cache_get_field_count(field_count); return field_count; } stock cache_num_results() { new result_count; cache_get_result_count(result_count); return result_count; }

// overload macros for cache_get_value natives

define cache_getvalue(%1) (:MSCGV0:MSCGV1:MSCGV2:cache_get_ovrld_value(%1))

define MSCGV0:MSCGV1:MSCGV2:cache_get_ovrld_value(%1,"%2",%3) cache_get_value_name(%1,#%2,%3)

define MSCGV1:MSCGV2:cache_get_ovrld_value(%1,%8string%9:%2,%3) cache_get_value_name(%1,%2,%3)

define MSCGV2:cache_get_ovrld_value(%1,%2,%3) cache_get_value_index(%1,%2,%3)

define cache_get_valueint(%1) (:MSCGVI0:MSCGVI1:MSCGVI2:cache_get_value_int_ovrld(%1))

define MSCGVI0:MSCGVI1:MSCGVI2:cache_get_value_int_ovrld(%1,"%2",%3) cache_get_value_name_int(%1,#%2,%3)

define MSCGVI1:MSCGVI2:cache_get_value_int_ovrld(%1,%8string%9:%2,%3) cache_get_value_name_int(%1,%2,%3)

define MSCGVI2:cache_get_value_int_ovrld(%1,%2,%3) cache_get_value_index_int(%1,%2,%3)

define cache_get_valuefloat(%1) (:MSCGVF0:MSCGVF1:MSCGVF2:cache_get_value_float_ovrld(%1))

define MSCGVF0:MSCGVF1:MSCGVF2:cache_get_value_float_ovrld(%1,"%2",%3) cache_get_value_name_float(%1,#%2,%3)

define MSCGVF1:MSCGVF2:cache_get_value_float_ovrld(%1,%8string%9:%2,%3) cache_get_value_name_float(%1,%2,%3)

define MSCGVF2:cache_get_value_float_ovrld(%1,%2,%3) cache_get_value_index_float(%1,%2,%3)

define cache_get_value_bool(%1) cache_get_value_int(%1)

define cache_is_valuenull(%1) (:MSCIVN0:MSCIVN1:MSCIVN2:cache_is_value_null_ovrld(%1))

define MSCIVN0:MSCIVN1:MSCIVN2:cache_is_value_null_ovrld(%1,"%2",%3) cache_is_value_name_null(%1,#%2,%3)

define MSCIVN1:MSCIVN2:cache_is_value_null_ovrld(%1,%8string%9:%2,%3) cache_is_value_name_null(%1,%2,%3)

define MSCIVN2:cache_is_value_null_ovrld(%1,%2,%3) cache_is_value_index_null(%1,%2,%3)

native cache_get_value_index(row_idx, column_idx, destination[], max_len = sizeof(destination)); native cache_get_value_index_int(row_idx, column_idx, &destination); native cache_get_value_index_float(row_idx, column_idx, &Float:destination); / native cache_get_value_index_bool(row_idx, column_idx, &bool:destination); / stock cache_get_value_index_bool(row_idx, column_idx, &bool:destination) { return cache_get_value_index_int(row_idx, columnidx, :destination); } native cache_is_value_index_null(row_idx, column_idx, &bool:destination);

native cache_get_value_name(row_idx, const column_name[], destination[], max_len = sizeof(destination)); native cache_get_value_name_int(row_idx, const column_name[], &destination); native cache_get_value_name_float(row_idx, const column_name[], &Float:destination); / native cache_get_value_name_bool(row_idx, const column_name[], &bool:destination); / stock cache_get_value_name_bool(row_idx, const column_name[], &bool:destination) { return cache_get_value_name_int(row_idx, columnname, :destination); } native cache_is_value_name_null(row_idx, const column_name[], &bool:destination);

native Cache:cache_save(); native cache_delete(Cache:cache_id); native cache_set_active(Cache:cache_id); native cache_unset_active(); native bool:cache_is_any_active(); native bool:cache_is_valid(Cache:cache_id);

native cache_affected_rows(); native cache_insert_id(); native cache_warning_count();

native cache_get_query_exec_time(E_MYSQL_EXECTIME_UNIT:unit = MICROSECONDS); native cache_get_query_string(destination[], max_len = sizeof(destination));

// Forward declarations forward OnQueryError(errorid, const error[], const callback[], const query[], MySQL:handle);

`

maddinat0r commented 4 years ago

It's not a bug. I'll quote myself here:

Make sure you're using the correct MySQL include (open it in your editor and make sure it says MySQL plugin R41-4).

bobitza commented 4 years ago

My mistake, sorry, it was for R40