SA-MP Forums

Go Back   SA-MP Forums > SA-MP Scripting and Plugins > Plugin Development

Reply
 
Thread Tools Display Modes
Old 16/05/2010, 07:20 PM   #351
Coicatak
Huge Clucker
 
Join Date: Nov 2008
Posts: 318
Reputation: 0
Default Re: [REL] SA:MP MySQL Plugin 1.2.1 - New Update Released

Quote:
Originally Posted by BlueRey
Quote:
[14:32:59] Server Plugins
[14:32:59] --------------
[14:32:59] Loading plugin: streamer.so
[14:32:59]
*** Streamer Plugin v2.3.7 by Incognito loaded ***

[14:32:59] Loaded.
[14:32:59] Loading plugin: mysql.so
[14:32:59] Failed (/usr/lib/libstdc++.so.6: version `GLIBCXX_3.4.9' not found (required by plugins/mysql.so))
[14:32:59] Loaded 1 plugins.
Re-download, you may don't have the last version of the plugin. Also make sure you have the right include and compiled your script at least once with it.
Coicatak is offline   Reply With Quote
Old 22/05/2010, 06:08 PM   #352
DowNlOaD_
Big Clucker
 
Join Date: Aug 2009
Posts: 57
Reputation: 0
Default Re: [REL] SA:MP MySQL Plugin 1.2.1 - New Update Released

Code:
mysql_query_array(string, 1, {playerid, inputtext}, con);
what's wrong with this code?
DowNlOaD_ is offline   Reply With Quote
Old 23/05/2010, 04:31 AM   #353
Carlton
Gangsta
 
Carlton's Avatar
 
Join Date: Mar 2010
Posts: 687
Reputation: 4
Default Re: [REL] SA:MP MySQL Plugin 1.2.1 - New Update Released

Quote:
Originally Posted by DowNlOaD_
Code:
mysql_query_array(string, 1, {playerid, inputtext}, con);
what's wrong with this code?
Remove string from the code, the parameters don't match.
OnMysqlQueryArray(resultid, extravars[], MySQL:connection)
Carlton is offline   Reply With Quote
Old 23/05/2010, 07:03 PM   #354
StrickenKid
Gangsta
 
Join Date: Feb 2009
Posts: 762
Reputation: 44
Default Re: [REL] SA:MP MySQL Plugin 1.2.1 - New Update Released

Quote:
Originally Posted by Carlton
Quote:
Originally Posted by DowNlOaD_
Code:
mysql_query_array(string, 1, {playerid, inputtext}, con);
what's wrong with this code?
Remove string from the code, the parameters don't match.
OnMysqlQueryArray(resultid, extravars[], MySQL:connection)
You've got the function parameters mixed up with the callback parameters.

Quote:
Originally Posted by DowNlOaD_
Code:
mysql_query_array(string, 1, {playerid, inputtext}, con);
what's wrong with this code?
I'm guessing inputtext is a string, therefore is your problem. You cannot pass multi-dimensional arrays, you can only pass a single dimensional array.
StrickenKid is offline   Reply With Quote
Old 24/05/2010, 05:05 PM   #355
kacperoo
Big Clucker
 
Join Date: Mar 2009
Posts: 55
Reputation: 0
Default Re: [REL] SA:MP MySQL Plugin 1.2.1 - New Update Released

Hm, how about UPDATE and INSERT INTO queries?

I have smth like this:

pawn Code:
mysql_query("UPDATE `something` SET `sth` = '10' WHERE `blahblah` = '1'", QUERY_SAVEINTERIOR);

But I don't reffer QUERY_SAVEINTERIOR at OnMysqlQuery callback.

Will this be multithreaded?
kacperoo is offline   Reply With Quote
Old 24/05/2010, 08:06 PM   #356
Balon
Big Clucker
 
Join Date: Oct 2007
Posts: 108
Reputation: 2
Default Re: [REL] SA:MP MySQL Plugin 1.2.1 - New Update Released

Quote:
Will this be multithreaded?
Sure.
Balon is offline   Reply With Quote
Old 25/05/2010, 12:43 AM   #357
BlueRey
Big Clucker
 
BlueRey's Avatar
 
Join Date: Mar 2009
Location: Israel
Posts: 114
Reputation: 10
Default Re: [REL] SA:MP MySQL Plugin 1.2.1 - New Update Released

Quote:
Originally Posted by Coicatak
Quote:
Originally Posted by BlueRey
Quote:
[14:32:59] Server Plugins
[14:32:59] --------------
[14:32:59] Loading plugin: streamer.so
[14:32:59]
*** Streamer Plugin v2.3.7 by Incognito loaded ***

[14:32:59] Loaded.
[14:32:59] Loading plugin: mysql.so
[14:32:59] Failed (/usr/lib/libstdc++.so.6: version `GLIBCXX_3.4.9' not found (required by plugins/mysql.so))
[14:32:59] Loaded 1 plugins.
Re-download, you may don't have the last version of the plugin. Also make sure you have the right include and compiled your script at least once with it.
same fucking problem!
Quote:
----------
Loaded log file: "server_log.txt".
----------

SA-MP Dedicated Server
----------------------
v0.3a R6, (C)2005-2010 SA-MP Team

[03:45:42]
[03:45:42] Server Plugins
[03:45:42] --------------
[03:45:42] Loading plugin: streamer.so
[03:45:42]
*** Streamer Plugin v2.3.7 by Incognito loaded ***

[03:45:42] Loaded.
[03:45:42] Loading plugin: mysql.so
[03:45:42] Failed (/usr/lib/libstdc++.so.6: version `GLIBCXX_3.4.9' not found (required by plugins/mysql.so))
[03:45:42] Loaded 1 plugins.

[03:45:43]
[03:45:43] Filter Scripts
[03:45:43] ---------------
[03:45:43] Loading filter script 'rcon-cmds.amx'...
[03:45:43] Loaded 1 filter scripts.

[03:45:43] Script[gamemodes/test.amx]: Run time error 19: "File or function is not found"
[03:45:43] Number of vehicle models: 0
BlueRey is offline   Reply With Quote
Old 26/05/2010, 11:03 PM   #358
nemesis-
Huge Clucker
 
Join Date: Sep 2009
Location: USA
Posts: 231
Reputation: 65
Default Re: [REL] SA:MP MySQL Plugin 1.2.1 - New Update Released

Ethan,

Have you had a chance to look into the issue Dave (dchidell) contacted you about a few weeks back? We had to fall back to GStylez plugin due to this.

On another note - it seems your plugin and GStylez utilize the exact same method for multithreading of queries. In very rare scenarios an insert query will fail to exit your while() loop which locks up the plugin and pegs the SA:MP server executable at 100% CPU. We were only able to solve this problem by yanking the guts of the multithreading capabilities of your plugins and recompiling. We log at a fairly infrequent level (INSERTs occur every few seconds - or more based on player activity).
nemesis- is offline   Reply With Quote
Old 28/05/2010, 02:39 AM   #359
BlueRey
Big Clucker
 
BlueRey's Avatar
 
Join Date: Mar 2009
Location: Israel
Posts: 114
Reputation: 10
Default Re: [REL] SA:MP MySQL Plugin 1.2.1 - New Update Released

Quote:
Originally Posted by BlueRey
Quote:
Originally Posted by Coicatak
Quote:
Originally Posted by BlueRey
Quote:
[14:32:59] Server Plugins
[14:32:59] --------------
[14:32:59] Loading plugin: streamer.so
[14:32:59]
*** Streamer Plugin v2.3.7 by Incognito loaded ***

[14:32:59] Loaded.
[14:32:59] Loading plugin: mysql.so
[14:32:59] Failed (/usr/lib/libstdc++.so.6: version `GLIBCXX_3.4.9' not found (required by plugins/mysql.so))
[14:32:59] Loaded 1 plugins.

Re-download, you may don't have the last version of the plugin. Also make sure you have the right include and compiled your script at least once with it.
same fucking problem!
Quote:
----------
Loaded log file: "server_log.txt".
----------

SA-MP Dedicated Server
----------------------
v0.3a R6, (C)2005-2010 SA-MP Team

[03:45:42]
[03:45:42] Server Plugins
[03:45:42] --------------
[03:45:42] Loading plugin: streamer.so
[03:45:42]
*** Streamer Plugin v2.3.7 by Incognito loaded ***

[03:45:42] Loaded.
[03:45:42] Loading plugin: mysql.so
[03:45:42] Failed (/usr/lib/libstdc++.so.6: version `GLIBCXX_3.4.9' not found (required by plugins/mysql.so))
[03:45:42] Loaded 1 plugins.

[03:45:43]
[03:45:43] Filter Scripts
[03:45:43] ---------------
[03:45:43] Loading filter script 'rcon-cmds.amx'...
[03:45:43] Loaded 1 filter scripts.

[03:45:43] Script[gamemodes/test.amx]: Run time error 19: "File or function is not found"
[03:45:43] Number of vehicle models: 0
BlueRey is offline   Reply With Quote
Old 28/05/2010, 05:58 PM   #360
StrickenKid
Gangsta
 
Join Date: Feb 2009
Posts: 762
Reputation: 44
Default Re: [REL] SA:MP MySQL Plugin 1.2.1 - New Update Released

Quote:
Originally Posted by nemesis99
Ethan,

Have you had a chance to look into the issue Dave (dchidell) contacted you about a few weeks back? We had to fall back to GStylez plugin due to this.

On another note - it seems your plugin and GStylez utilize the exact same method for multithreading of queries. In very rare scenarios an insert query will fail to exit your while() loop which locks up the plugin and pegs the SA:MP server executable at 100% CPU. We were only able to solve this problem by yanking the guts of the multithreading capabilities of your plugins and recompiling. We log at a fairly infrequent level (INSERTs occur every few seconds - or more based on player activity).
Thanks, I'll look into it. I have final exams next week so I wont be able to work on it for a couple days.
StrickenKid 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
[Plugin] [REL] MySQL Plugin (Now on github!) BlueG Plugin Development 6158 11/04/2020 08:51 AM
Best MySQL Plugin? Antonio [G-RP] Help Archive 3 10/01/2011 01:31 AM
Best MySQL plugin? DRIFT_HUNTER Help Archive 2 07/12/2010 03:43 PM
Which MySQL plugin? Whois. Help Archive 0 07/04/2010 11:55 AM
Mysql Plugin Help Jbosh123 Help Archive 0 04/09/2009 11:35 AM


All times are GMT. The time now is 02:25 PM.


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