[REL]SAMP-MySQL v0.15 - SAMP 0.3 supported!!! corrected version uploaded...

[SoeH]

I've tested my function with your old version but, i get the same problem as before

Related : http://forum.sa-mp.com/index.php?topic=23931.msg787099#msg787099

I cannot use my function twice 
Server crash at

Code:

samp_mysql_fetch_row(ligne_brute);
samp_mysql_get_field(info, ligne_resultat);

Like the others one ...

I have this problem...
I'm using this function and my server crash.

What can i do?

[MenaceX^]

I've tested my function with your old version but, i get the same problem as before

Related : http://forum.sa-mp.com/index.php?topic=23931.msg787099#msg787099

I cannot use my function twice 
Server crash at

Code:

samp_mysql_fetch_row(ligne_brute);
samp_mysql_get_field(info, ligne_resultat);

Like the others one ...

I have this problem...
I'm using this function and my server crash.

What can i do?

Can't you read? This plugin is bugged..

[SoeH]

Yes, I can.

[REL]SAMP-MySQL v0.15 - SAMP 0.3 supported!!! corrected version uploaded...

Are there any plugin developer that can resolve this problem?
More people use this plugin, but also when you have more variables there are a crash probability, i think that it is fixable...

EDIT: (I talk about Windows v.)

[SE7ENGX]

I've been playing with this for the last couple days but it seems the plugin crashes my server. Windows Server 2003, and also tried on XP SP3. I have mysql knowledge but apparently there wasn't anything that went wrong. SAMP Server simply just closed after a successful connection and query attempt. MySQL 5.1, apache... any ideas?

[Joe Staff]

I've been playing with this for the last couple days but it seems the plugin crashes my server. Windows Server 2003, and also tried on XP SP3. I have mysql knowledge but apparently there wasn't anything that went wrong. SAMP Server simply just closed after a successful connection and query attempt. MySQL 5.1, apache... any ideas?

Make sure you're using mysql_store_result();

[mprofitt]

I've been playing with this for the last couple days but it seems the plugin crashes my server. Windows Server 2003, and also tried on XP SP3. I have mysql knowledge but apparently there wasn't anything that went wrong. SAMP Server simply just closed after a successful connection and query attempt. MySQL 5.1, apache... any ideas?

Make sure you're using mysql_store_result();

I am crashing as well.
Yes I am using mysql_store_result();

[Redgie]

Quick Question, here is some code I use, cut down and simplified

Code:

while (idx < sizeof(HouseInfo))
{
    new query[128],result[256],loop[256];
    new poop = 1;
    format(query,sizeof(query),"SELECT * FROM Houses WHERE ID = '%d'",idx);
    samp_mysql_query(query);
    samp_mysql_store_result();
    samp_mysql_fetch_row(result);
    if(samp_mysql_num_rows() == 1)
    {
        samp_mysql_strtok(loop, "|", result);
        while(samp_mysql_strtok(loop, "|", ""))
        {
            //Do stuff
            poop++;
        }
        idx++;
    }
}

My question is, because "idx++;" is only called "if(samp_mysql_num_rows() == 1)", will the loop continue endlessly once "samp_mysql_num_rows() != 1" because "idx++;" is never being used?

[MenaceX^]

Quick Question, here is some code I use, cut down and simplified

Code:

while (idx < sizeof(HouseInfo))
{
    new query[128],result[256],loop[256];
    new poop = 1;
    format(query,sizeof(query),"SELECT * FROM Houses WHERE ID = '%d'",idx);
    samp_mysql_query(query);
    samp_mysql_store_result();
    samp_mysql_fetch_row(result);
    if(samp_mysql_num_rows() == 1)
    {
        samp_mysql_strtok(loop, "|", result);
        while(samp_mysql_strtok(loop, "|", ""))
        {
            //Do stuff
            poop++;
        }
        idx++;
    }
}

My question is, because "idx++;" is only called "if(samp_mysql_num_rows() == 1)", will the loop continue endlessly once "samp_mysql_num_rows() != 1" because "idx++;" is never being used?

I suppose you forgot samp_mysql_fetch_row, and I'd rather do this that way:

PAWN Code:

while(samp_mysql_fetch_row(resultline))
{
    // the strtok stuff.
}

[Redgie]

I suppose you forgot samp_mysql_fetch_row, and I'd rather do this that way:

PAWN Code:

while(samp_mysql_fetch_row(resultline))
{
    // the strtok stuff.
}

I didn't forget it, it is in there, I basically used the default query system back when I knew nothing about MySQL, and now I'm looking for reasons for heavy resource usage and am assuming a loop is going on longer than it should be, I'm going to log them to try to determine a cause but doesn't hurt to improve the coding too.

So the code you posted replaces the 3 MySQL lines:

PAWN Code:

samp_mysql_query(query);
samp_mysql_store_result();
samp_mysql_fetch_row(result);

right?

[SoeH]

[17:34:01] Error in mysql_query: Commands out of sync; you can't run this command now

What is this?

[Imran]

is this plugin bugged or...?

[MenaceX^]

Both plugins are bugged..

[PawnNewCommer]

So already there is a decision with server crash? 

[Hypar]

So what is this plugin for? There are already build in sql features in sa-mp.. Also, isn't there an include instead of a plugin? My host doesnt allow me to dump all those files in the root..

[MenaceX^]

So what is this plugin for? There are already build in sql features in sa-mp.. Also, isn't there an include instead of a plugin? My host doesnt allow me to dump all those files in the root..

The include is SQLite, this is not.