[caoraivoso3]

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

[Mellnik]

Quote:

Originally Posted by caoraivoso3 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

pawn Код:

cache_insert_id();

Read through the include

[Danny]

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.

[Mellnik]

Quote:

Originally Posted by Danny 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.

[Danny]

Quote:

Originally Posted by Mellnik Could you turn on mysql_log(LOG_ALL) and post the entire mysql_log.txt? It contains exact query execution times.

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.

[iLegendary]

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

[Konstantinos]

Quote:

Originally Posted by iLegendary 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

[iLegendary]

Quote:

Originally Posted by Konstantinos The plugin failed to load: http://forum.sa-mp.com/showpost.php?...postcount=4921

I've got already test, and doesn't work !

[The-Krew]

Quote:

Originally Posted by iLegendary 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

same error

[iLegendary]

Many people have this error and no solution given by the FAQ works..

[[Mr]Wallace]

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

Quote:

[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]

r39 inlude, r7 plugin, how the hell is that going to work?

go Github and check the latest release.

https://github.com/pBlueG/SA-MP-MySQL/releases

[S4t3K]

@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.

[iZN]

Quote:

Originally Posted by S4t3K @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.

wat?

Quote:

Originally Posted by [Mr]Wallace 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

Don't you see your mistake there?

[maddinat0r]

Quote:

Originally Posted by iLegendary Many people have this error and no solution given by the FAQ works..

Many people (in our case exactly 2) also underestimate the solution with redistributables and don't install them or just place some .dll's randomly downloaded from some shady dll-sites and place them somewhere to make things work.
So if you really correctly installed those 3 x86 (32 bit) redistributables and it still don't works, make sure that

• your Windows is up2date
• you are using the correct libmysql.dll
• you never "installed" (placed manually) some .dll's you downloaded from the internet

Which version of Windows are you using btw?

Quote:

Originally Posted by S4t3K @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.

This is the only solution. Do you really think you can't compile a script with a higher-version include and run that script with a lower-version plugin? Well of course you can do that, just like MrWallace.

[iLegendary]

Window 7 Family Prenium SP1 (x64)

[Pupak]

Suggestion for future version:

pawn Код:

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,_}:...);

That functions would read queries from the file and then fire it. It's scriptable of course, but currently I have to buffer every statement (query) in the file and then fire it one by one. Plus, you can dynamically allocate and release the memory where the query is stored in the plugin. I'm currently using it to set up the database if tables aren't created already.

It's nothing important, but if you run out of ideas, why not?

[maddinat0r]

Quote:

Originally Posted by iLegendary Window 7 Family Prenium SP1 (x64)

And you are sure you followed all points I mentioned? I honestly can't see any other reason apart from wrong dll-management and missing redistributables. You could also try starting the server in compatibility mode with administrator rights.

Quote:

Originally Posted by Pupak Suggestion for future version: pawn Код: 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,_}:...); That functions would read queries from the file and then fire it. It's scriptable of course, but currently I have to buffer every statement (query) in the file and then fire it one by one. Plus, you can dynamically allocate and release the memory where the query is stored in the plugin. I'm currently using it to set up the database if tables aren't created already. It's nothing important, but if you run out of ideas, why not?

I'll think about it, but it's a nice idea (so it's likely that I will implement this in R40).

[iLegendary]

Ok, i fixed problem : i reinstall my window 7, i fixed mscvp100 and other, and i reinstall one per one redistributables

[Danny]

I'm sorry for 'bumping' my question, but can anybody help me out with this? I'm kinda on a schedule.

Quote:

Originally Posted by Danny 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.

Quote:

Originally Posted by Danny 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.

In the meantime I've been able again to reproduce the hang-issues. With some optimisations (replacing cache_get_row by cache_get_row_int/float in some places) I succeeded in reducing the hang time from > 100 to 81 seconds. But the issue hasn't been solved yet: I never had issues like this with the old plugin.