[StrickenKid]

Btw, can a mod please change the topic name to: "[REL] SA:MP MySQL Plugin 2.1.1 - Released (1/25/2011)"

Thanks.

[PeteShag]

Quote:

Fixed bug that caused the server to crash when mysql_close was called with multiple connections.

Oh yeah....

Thanks for the update.

[Deji]

Could support for packed strings be added?

[Raimis_R]

Why i have this error [MySQL] Error (0): Function: mysql_connect failed, mysql was not initialized on this handle.

[selEcT]

Is there a possibility to make an inner join statement (p.e. SELECT * FROM blabla INNER JOIN blabla2 ON balabla.ID = blabla2.ID) and read out the fields of the two tables (a whole load function)? Is this more confortable and optimized?

[Dj_maryo1993]

A problem here too .
[17:14:26] [MySQL] Error (0): Function: mysql_connect failed, mysql was not initialized on this handle.

[Fro1sha]

mysql_close don't close handle.

Quote:

[Thu Feb 10 22:47:46 2011] Connected (0) to *** @ 127.0.0.1 via TCP/IP. [Thu Feb 10 22:47:46 2011] MySQL Server Version 5.1.40-community. [Thu Feb 10 22:54:35 2011] MySQL closed. Logging ended. [Thu Feb 10 22:54:47 2011] Connected (1) to *** @ 127.0.0.1 via TCP/IP. [Thu Feb 10 22:54:47 2011] MySQL Server Version 5.1.40-community. [Thu Feb 10 22:57:21 2011] MySQL closed. Logging ended. [Thu Feb 10 22:57:33 2011] Connected (2) to *** @ 127.0.0.1 via TCP/IP. [Thu Feb 10 22:57:33 2011] MySQL Server Version 5.1.40-community. [Thu Feb 10 22:57:38 2011] MySQL closed. Logging ended. [Thu Feb 10 22:57:50 2011] Connected (3) to *** @ 127.0.0.1 via TCP/IP. [Thu Feb 10 22:57:50 2011] MySQL Server Version 5.1.40-community.

And server crash...

[n8]

^^ to many noobs with too many problems :-p
StrickenKid your work rocks its fucking awsomme!!!
and it makes controlling so easy thx for this plugin

Live from fucking switzerland
Grezz Nate

[n8]

i read a little bit of your problems

heer is a little tutorial it works first time:

ON TOP OF SCRIPT
#include <mysql>

#define SQL_HOST "127.0.0.1"
#define SQL_DB "*******"
#define SQL_USER "root"
#define SQL_PASS "*******"

new MySQL:connection;

AND ON GAME / FILTER SCRIPT INIT

connection = mysql_init(LOG_ONLY_ERRORS, 1);
mysql_connect(SQL_HOST, SQL_USER, SQL_PASS, SQL_DB, connection, 1);

if this not work you have not a sql server running. Download XAMPP for Fuck Windows to test.

Grezz Nate

[StrickenKid]

Quote:

Originally Posted by Fro1sha mysql_close don't close handle. And server crash...

Build 157 - Fixed.

[Burridge]

Quote:

Originally Posted by StrickenKid Build 157 - Fixed.

Your Linux Static link doesn't work.

[StrickenKid]

Whoops, had the file named linux_satic_2.1.1.tar.gz by mistake

Fixed now :P

[Redirect Left]

I keep getting this error when trying to do something regarding MySQL:

Error (0): Failed to exeute query. Commands out of sync; you can't run this command now.

Any tips?

[xxmitsu]

That could be caused because you're not freeing the result before storing it again.

You should use mysql_free_result afer each mysql_store_result.

[Burridge]

Quote:

Originally Posted by StrickenKid Whoops, had the file named linux_satic_2.1.1.tar.gz by mistake

Thanks.

[JulianM]

That's funny ...
Sometimes the links works and somtimes you'll be redirected to the parked domain, strange.

I've got now all files, but StrickenKid should check this problem with the host^^

[kLx]

Waddup!

So, I have this problem here.
When I use mysql_real_escape_string on strings, where first letter is unicode (ą č ę ė į š ų ū ž), the whole script gets messed up, check this out.

Код:

[17:48:20] --- BEFORE ESCAPE ---
[17:48:20] name  -> Čiulpk
[17:48:20] rank1 -> neivesta
[17:48:20] rank2 -> neivesta
[17:48:20] rank3 -> neivesta
[17:48:20] rank4 -> neivesta
[17:48:20] rank5 -> neivesta
[17:48:20] rank6 -> neivesta
[17:48:20] 

--- AFTER ESCAPE ---
[17:48:20] name  -> ˙˙˙Č
[17:48:20] rank1 -> neivesta
[17:48:20] rank2 -> neivesta
[17:48:20] rank3 -> neivesta
[17:48:20] rank4 -> neivesta
[17:48:20] rank5 -> neivesta
[17:48:20] rank6 -> neivesta

I think it's somehow related to charsets, are there any fixes, or it's inside the plugin?

[RingoRus]

After several restarts the server I get an error:
[MySQL] Error: Max connections (4) reached, could not connect.

How to do that did not open more than one connection after restarts?
(mysql_connect() and mysql_close() called in OnGameModeInit and OnGameModeExit respectively)

P.S. Sorry if there are errors in the post, the English do not know much

[Akmet]

there are some solutions
exit the server and restart it then(no gmx)

or u change the source and set it up to an maximal 10 connections or something else


but i think, the best solution would be that the amount of maximal connections is just the count of actual connections.
for example:
i have two connections in my gm, a fs with one connection.
now i want to reload my filterscript 2 or 3 times. after the first reloading the server exits, because it reached 4 connections, but i only have actual 3 connections
is that probalby Incognito?

[Sheeba]

Thanks everyone.I need it.I'm coding a role play panel and I use MySQL and PHP.My game mode is connected to MySQL server.I research mysql plugins for Linux and I found it.