[The_Gangstas]

add this before mysql_connect

pawn Код:

mysql_init(LOG_ALL, 1);

[Forairan]

Quote:

Originally Posted by The_Gangstas add this before mysql_connect pawn Код: mysql_init(LOG_ALL, 1);

Same error.

Код:

[Sat Dec 18 19:49:06 2010] -------------------------
[Sat Dec 18 19:49:06 2010]      Logging Started
[Sat Dec 18 19:49:06 2010] -------------------------
[Sat Dec 18 19:49:06 2010] Function: mysql_init executed with result: "0".
[Sat Dec 18 19:49:06 2010] Error (1): Function: mysql_connect failed, mysql was not initialized on this handle.

[Momo5000]

Quote:

Originally Posted by The_Gangstas try removing sendclient message and format and use printf scm and format will slow it down even more, printf will slow it down by about 1ms, just minus the 1ms

nvm.... i fixed it... the build-in sqlite function from samp sux...

this plugin is much better...

it took me 31ms to save 500 Accounts in loop (20 Columns) its better then before, 10 Accounts take up 1ms to save lol...

but thanks for the help...

[X35B]

It's a nice plugin.

[JernejL]

Quote:

Originally Posted by StrickenKid Nice ideas Jay_, I will definitely look into having custom query callbacks, doing it this way will be much easier than having all threaded queries sent to one callback.

BlueG's plugin had this for months now.. nice stealing ideas going on..

* JernejL runs away with a big loot of sarcasm

[Jay_]

Quote:

Originally Posted by JernejL BlueG's plugin had this for months now.. nice stealing ideas going on.. * Jay_ runs away with a big loot of sarcasm

His is very limited and doesn't support custom parameters making it practically pointless.

[StrickenKid]

Its funny how you people still accuse us of stealing ideas when thats exactly what you're doing...
Example: If I recall, my plugin had the error callback first.

[thimo]

Could anyone help me? i get the libmysqlclient_r.so.16 error im using serverffs and i dont know how to fix it cause everything is different on there. someone pls pm me or answer me in forum

[The_Gangstas]

Quote:

Originally Posted by thimo Could anyone help me? i get the libmysqlclient_r.so.16 error im using serverffs and i dont know how to fix it cause everything is different on there. someone pls pm me or answer me in forum

already msged woet about it, "ServerFFS" are not gonna update it.

as said by woet.. there not gonna update any major system files for a (forgot the word...) samp

[papagei9]

That's special with the libmysqlclient_r.so.16... i don't know how to fix that on my Linux Debian Lenny 64bit Rootserver.
Can anyone help me?

[StrickenKid]

Use the update I posted a few posts back.

[Redgie]

Quote:

[MySQL] Error (0): Function: mysql_fetch_field failed, no field data.

Just had this crash my server

You mentioned a while back that this was something you hadn't bug tested, you then fixed it and released it, another person posted saying they had the same problem. On the other hand, I know this can be caused by not freeing the result. Is there anyway of knowing what caused it?

[Luis-]

Quote:

Originally Posted by Redgie Just had this crash my server You mentioned a while back that this was something you hadn't bug tested, you then fixed it and released it, another person posted saying they had the same problem. On the other hand, I know this can be caused by not freeing the result. Is there anyway of knowing what caused it?

I do hope it is a fixable cause.

[ihatetn931]

lol, Hey redgie.

So, everytime i /gmx my server it crashes. This is with the latest windows version. Sup with that?

[Burridge]

Quote:

Originally Posted by ihatetn931 lol, Hey redgie. So, everytime i /gmx my server it crashes. This is with the latest windows version. Sup with that?

Are you sure it's this plugin causing it?

[Luka P.]

If somebody doesn't know: If you use only one connection to MySQL server, you don't have to make a new variable to hold the connection. You can simply connect this way:

pawn Код:

mysql_connect("hostname", "user", "password", "database", mysql_init(_, _));

And disconnect like this:

pawn Код:

mysql_close(_);

[ihatetn931]

Quote:

Originally Posted by Burridge Are you sure it's this plugin causing it?

It didn't start happing till i updated to the latest plugin

[ihatetn931]

Sorry about the double post, When you put mysql_close(); in OnGameModeExit() it crashes on /gmx.

Is this a bug?

pawn Код:

public OnGameModeExit()
{
    for(new i = 0; i < MAX_PLAYERS; i++) 
    {
    OnplayerSqlUpdate(i);
    }
    KillTimer(gate1);
    KillTimer(website);
    KillTimer(synchup);
    KillTimer(weathercheck);
    KillTimer(timeud);
    KillTimer(upss);
    KillTimer(jailtimer);
    KillTimer(checktralier);
    KillTimer(gpsgps);
    KillTimer(changeinterior);
    KillTimer(checkrock);
    KillTimer(playinghours);
    KillTimer(playingdays);
    KillTimer(playingmins);
    KillTimer(batterytimer);
    KillTimer(custompickupsupdate);
    KillTimer(accounts);
    KillTimer(autoweather);
//    mysql_close(); //i commented it cause it was crashing on /gmx
    GameModeExit();
    return 1;
}

[selEcT]

Where can I download the libmysqlclient_r.so.16?

edit: i found it.

[StrickenKid]

For the people who were not able to use the plugin on a hosted server because you didn't have access to compile a threadsafe mysql build (libmysqlclient_r.so.x), I've compiled a statically linked build, I posted it in a reply a couple pages back last week, I've put it on the main thread now.

On another note, I'm sorry that I haven't been able to update the plugin, or address any issues with the plugin. I've just moved to another state and I don't have my linux machines unboxed and running yet.