SA-MP Forums Archive
MYSQL Warning - Printable Version

+- SA-MP Forums Archive (https://sampforum.blast.hk)
+-- Forum: SA-MP Scripting and Plugins (https://sampforum.blast.hk/forumdisplay.php?fid=8)
+--- Forum: Scripting Help (https://sampforum.blast.hk/forumdisplay.php?fid=12)
+--- Thread: MYSQL Warning (/showthread.php?tid=540455)



MYSQL Warning - trapstar2020 - 04.10.2014

It successfully loads but doesn't successfully save

[19:22:41] [DEBUG] cache_get_row_count - connection: 1
[19:22:41] [WARNING] cache_get_row_count - no active cache

pawn Код:
public OnDoorSave()
{
    new saved = 0;
    if(cache_num_rows())
    {
        for(new dd = 0; dd <cache_num_rows(); dd++)
        {
                     new query[500];

                     mysql_format(mysql, query, sizeof(query), "UPDATE `dynamicdoors` SET `Created`=%d, `Owner`=%s, `Name`=%s, `Password`=%s, `PassSwitch`=%s, WHERE `ID`=%d", \
                     DynamicDoor[dd][ddCreated], DynamicDoor[dd][ddOwner], DynamicDoor[dd][ddName], DynamicDoor[dd][ddPassword], DynamicDoor[dd][ddPasswordSwitch], DynamicDoor[dd][ddID]);
                     mysql_tquery(mysql, query, "", "");

                     mysql_format(mysql, query, sizeof(query), "UPDATE `dynamicdoors` SET `Entry_X`=%f, `Entry_Y`=%f, `Entry_Z`=%f, `Entry_Y`=%f,`Entry_VW`=%d, `Entry_Int`=%d, WHERE `ID`=%d", \
                     DynamicDoor[dd][ddEnt][0], DynamicDoor[dd][ddEnt][1], DynamicDoor[dd][ddEnt][2], DynamicDoor[dd][ddEnt][3], DynamicDoor[dd][ddEntVW], DynamicDoor[dd][ddEntInt], DynamicDoor[dd][ddID]);
                     mysql_tquery(mysql, query, "", "");

                     mysql_format(mysql, query, sizeof(query), "UPDATE `dynamicdoors` SET `Ex_X`=%f, `Ex_Y`=%f, `Ex_Z`=%f, `Ex_Y`=%A,`Ex_VW`=%d, `Ex_Int`=%d, WHERE `ID`=%d", \
                     DynamicDoor[dd][ddEx][0], DynamicDoor[dd][ddEx][1], DynamicDoor[dd][ddEx][2], DynamicDoor[dd][ddEx][3], DynamicDoor[dd][ddExVW], DynamicDoor[dd][ddExInt], DynamicDoor[dd][ddID]);
                     mysql_tquery(mysql, query, "", "");
                     saved++;
        }

    }
    printf("Doors Saved: %d", saved);
    return 1;
}



Re: MYSQL Warning - SaintMikey - 04.10.2014

Download some other MySQL Plugins aswell, for example: mysql_static, and Mysql_5.5, It should work perfectly, with the normal mysql.so or .dll included aswell, and remember, all of them, works together, so nothing to worry about, It worked for me, on SCRP.


Re: MYSQL Warning - trapstar2020 - 04.10.2014

I'm using BlueG r33+.... I suck @ ORM so i'm trying to switch it up