MYSQL Warning
#1

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;
}
Reply
#2

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.
Reply
#3

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


Forum Jump:


Users browsing this thread: 1 Guest(s)