hi all, i am changing my gamemode to the new system orm( i guess it is faster) but when i put the new version i see that this function
mysql_insert_id() doesn't exists. We have something similar? it gets the AUTO_INCREMENT id |
cache_insert_id();
Hi, it's me again. After my update to R39-2 I noticed another problem: the plugin's performance on startup is very bad from localhost. Loading 66 rows with cache takes up to 12 seconds. This is the same for the other loading processes. My server even hangs because of it, going from OnPlayerConnect to OnPlayerRequestClass takes 102 (!!!) seconds. It worked like a charm before, when I was using R17.
I'm pretty sure I'm doing something wrong here. My OS is Windows 7 32-bit, I'm only using threaded queries (pqueries) in my script. |
Could you turn on mysql_log(LOG_ALL) and post the entire mysql_log.txt? It contains exact query execution times.
|
---------- Loaded log file: "server_log.txt". ---------- SA-MP Dedicated Server ---------------------- v0.3z-R3, ©2005-2014 SA-MP Team [18:37:34] filterscripts = "" (string) [18:37:34] [18:37:34] Server Plugins [18:37:34] -------------- [18:37:34] Loading plugin: streamer [18:37:34] *** Streamer Plugin v2.7.2 by Incognito loaded *** [18:37:34] Loaded. [18:37:34] Loading plugin: Whirlpool [18:37:34] [18:37:34] ================== [18:37:34] [18:37:34] Whirlpool loaded [18:37:34] [18:37:34] ================== [18:37:34] [18:37:34] Loaded. [18:37:34] Loading plugin: sscanf [18:37:34] [18:37:34] =============================== [18:37:34] sscanf plugin loaded. [18:37:34] Version: 2.8.1 [18:37:34] © 2012 Alex "******" Cole [18:37:34] =============================== [18:37:34] Loaded. [18:37:34] Loading plugin: mysql [18:37:34] Failed. [18:37:34] Loading plugin: nativechecker [18:37:34] Loaded. [18:37:34] Loaded 4 plugins. [18:37:34] [18:37:34] Filterscripts [18:37:34] --------------- [18:37:34] Loaded 0 filterscripts. [18:37:34] Error: Function not registered: 'mysql_log' [18:37:34] Error: Function not registered: 'mysql_connect' [18:37:34] Error: Function not registered: 'mysql_errno' [18:37:34] Error: Function not registered: 'mysql_tquery' [18:37:34] Error: Function not registered: 'mysql_format' [18:37:34] Error: Function not registered: 'cache_get_field_content_int' [18:37:34] Error: Function not registered: 'cache_get_field_content_float' [18:37:34] Error: Function not registered: 'cache_get_data' [18:37:34] Error: Function not registered: 'cache_get_field_content' [18:37:34] Error: Function not registered: 'cache_get_row_count' [18:37:34] Script[gamemodes/gamemode.amx]: Run time error 19: "File or function is not found" [18:37:34] Number of vehicle models: 0
i have errors:
Код:
---------- Loaded log file: "server_log.txt". ---------- SA-MP Dedicated Server ---------------------- v0.3z-R3, ©2005-2014 SA-MP Team [18:37:34] filterscripts = "" (string) [18:37:34] [18:37:34] Server Plugins [18:37:34] -------------- [18:37:34] Loading plugin: streamer [18:37:34] *** Streamer Plugin v2.7.2 by Incognito loaded *** [18:37:34] Loaded. [18:37:34] Loading plugin: Whirlpool [18:37:34] [18:37:34] ================== [18:37:34] [18:37:34] Whirlpool loaded [18:37:34] [18:37:34] ================== [18:37:34] [18:37:34] Loaded. [18:37:34] Loading plugin: sscanf [18:37:34] [18:37:34] =============================== [18:37:34] sscanf plugin loaded. [18:37:34] Version: 2.8.1 [18:37:34] © 2012 Alex "******" Cole [18:37:34] =============================== [18:37:34] Loaded. [18:37:34] Loading plugin: mysql [18:37:34] Failed. [18:37:34] Loading plugin: nativechecker [18:37:34] Loaded. [18:37:34] Loaded 4 plugins. [18:37:34] [18:37:34] Filterscripts [18:37:34] --------------- [18:37:34] Loaded 0 filterscripts. [18:37:34] Error: Function not registered: 'mysql_log' [18:37:34] Error: Function not registered: 'mysql_connect' [18:37:34] Error: Function not registered: 'mysql_errno' [18:37:34] Error: Function not registered: 'mysql_tquery' [18:37:34] Error: Function not registered: 'mysql_format' [18:37:34] Error: Function not registered: 'cache_get_field_content_int' [18:37:34] Error: Function not registered: 'cache_get_field_content_float' [18:37:34] Error: Function not registered: 'cache_get_data' [18:37:34] Error: Function not registered: 'cache_get_field_content' [18:37:34] Error: Function not registered: 'cache_get_row_count' [18:37:34] Script[gamemodes/gamemode.amx]: Run time error 19: "File or function is not found" [18:37:34] Number of vehicle models: 0 |
The plugin failed to load: http://forum.sa-mp.com/showpost.php?...postcount=4921
|
i have errors:
Код:
---------- Loaded log file: "server_log.txt". ---------- SA-MP Dedicated Server ---------------------- v0.3z-R3, ©2005-2014 SA-MP Team [18:37:34] filterscripts = "" (string) [18:37:34] [18:37:34] Server Plugins [18:37:34] -------------- [18:37:34] Loading plugin: streamer [18:37:34] *** Streamer Plugin v2.7.2 by Incognito loaded *** [18:37:34] Loaded. [18:37:34] Loading plugin: Whirlpool [18:37:34] [18:37:34] ================== [18:37:34] [18:37:34] Whirlpool loaded [18:37:34] [18:37:34] ================== [18:37:34] [18:37:34] Loaded. [18:37:34] Loading plugin: sscanf [18:37:34] [18:37:34] =============================== [18:37:34] sscanf plugin loaded. [18:37:34] Version: 2.8.1 [18:37:34] © 2012 Alex "******" Cole [18:37:34] =============================== [18:37:34] Loaded. [18:37:34] Loading plugin: mysql [18:37:34] Failed. [18:37:34] Loading plugin: nativechecker [18:37:34] Loaded. [18:37:34] Loaded 4 plugins. [18:37:34] [18:37:34] Filterscripts [18:37:34] --------------- [18:37:34] Loaded 0 filterscripts. [18:37:34] Error: Function not registered: 'mysql_log' [18:37:34] Error: Function not registered: 'mysql_connect' [18:37:34] Error: Function not registered: 'mysql_errno' [18:37:34] Error: Function not registered: 'mysql_tquery' [18:37:34] Error: Function not registered: 'mysql_format' [18:37:34] Error: Function not registered: 'cache_get_field_content_int' [18:37:34] Error: Function not registered: 'cache_get_field_content_float' [18:37:34] Error: Function not registered: 'cache_get_data' [18:37:34] Error: Function not registered: 'cache_get_field_content' [18:37:34] Error: Function not registered: 'cache_get_row_count' [18:37:34] Script[gamemodes/gamemode.amx]: Run time error 19: "File or function is not found" [18:37:34] Number of vehicle models: 0 |
[13:21:08] Server Plugins [13:21:08] -------------- [13:21:08] Loading plugin: mysql.dll [13:21:08] > MySQL plugin R7 successfully loaded. [13:21:08] Loaded. [13:21:08] Loading plugin: nativechecker [13:21:08] Loaded. [13:21:08] Loaded 2 plugins. [13:21:08] [13:21:08] Filterscripts [13:21:08] --------------- [13:21:08] Loaded 0 filterscripts. [13:21:08] Error: Function not registered: 'mysql_tquery' [13:21:08] Error: Function not registered: 'cache_insert_id' [13:21:08] Error: Function not registered: 'cache_get_row_int' [13:21:08] Error: Function not registered: 'cache_affected_rows' [13:21:08] Error: Function not registered: 'cache_get_row_float' [13:21:08] Error: Function not registered: 'cache_get_field_content_int' [13:21:08] Error: Function not registered: 'mysql_log' [13:21:08] Script[gamemodes/wallace.amx]: Run time error 19: "File or function is not found" [13:21:08] Number of vehicle models: 0 [13:21:21] --- Server Shutting Down. [13:21:21] |
@Patrick_ : This is not an acceptable solution.
I mean, if he hadn't have the good include version, this would be a compiler error message, and thus not a run time error message. |
I have the same problem but my plugin (mysql.dll) is loaded .
i have the last a_mysql (R39-2) include and mysql R7 plugin |
Many people have this error and no solution given by the FAQ works..
|
@Patrick_ : This is not an acceptable solution.
I mean, if he hadn't have the good include version, this would be a compiler error message, and thus not a run time error message. |
native mysql_query_file(connectionHandle, file[], callback[] = "", format[] = "", {Float,_}:...);
native mysql_tquery_file(connectionHandle, file[], callback[] = "", format[] = "", {Float,_}:...);
native mysql_pquery_file(connectionHandle, file[], callback[] = "", format[] = "", {Float,_}:...);
Suggestion for future version:
pawn Код:
It's nothing important, but if you run out of ideas, why not? ![]() |
Hi, it's me again. After my update to R39-2 I noticed another problem: the plugin's performance on startup is very bad from localhost. Loading 66 rows with cache takes up to 12 seconds. This is the same for the other loading processes. My server even hangs because of it, going from OnPlayerConnect to OnPlayerRequestClass takes 102 (!!!) seconds. It worked like a charm before, when I was using R17.
I'm pretty sure I'm doing something wrong here. My OS is Windows 7 32-bit, I'm only using threaded queries (pqueries) in my script. |
Sure, here you go: http://tny.cz/f9a692ad
Amount of rows: http://puu.sh/a2fNj/ade97206a3.png Unfortunately this isn't the log which caused a 102-second server hang. I deleted that one accidentally. But still you can see here loading takes up to one and a half minute. I have never experience that with the old plugin version and I read some replies of people toying with huge amounts of data to test the plugin, and they were all able to get a much better load time out of it. The hang appears to be random: this afternoon I could reproduce it ~10 times, but when I tried it an hour or so ago I couldn't after 5 attempts. EDIT: The 230-sized table in the puush link is one we don't use, sorry for including it on the screenshot. |