Error mysql

[Voller.]

Salut ma puteti ajuta cu aceasta eroare: asta imi apare in mysql_log doar eroare asta tot sunt bune.

cache_get_field_content_int ERROR invalid datatype

Asta le da crash la playeri si ma enerveaza ff tare

Multumesc!

 

[WopsS]

Si ce linia ai cu cache_get_field_content_int?

[Voller.]

Pai sunt o gramada ... in gm dar una cred ca nu e buna ca altfel nu mergea deloc.

[Voller.]

In callback "LoadHouses"

Time Function Status Message In callback "LoadProps" In callback "LoadVehicles" In callback "LoadDuels" In callback "LoadServerConfiguration" In callback "LoadGangs" In callback "LoadTeritories" In callback "LoadGangCPS" In callback "call_LoadRaceNames" In callback "BanListCheck" In callback "LoginPlayerAccount" In callback "LoadPlayerAKA" In callback "LoadPersonalVehicleInfo" 01:59:00 cache_get_field_content_int ERROR invalid datatype In callback "BanListCheck" In callback "LoginPlayerAccount" In callback "LoadPlayerAKA" In callback "LoadClanDetails" In callback "BanListCheck" In callback "LoginPlayerAccount" In callback "LoadPlayerAKA" In callback "LoadPersonalVehicleInfo" 01:59:34 cache_get_field_content_int ERROR invalid datatype In callback "BanListCheck" In callback "LoginPlayerAccount" In callback "LoadPlayerAKA" In callback "LoadClanDetails" In callback "BanListCheck" In callback "LoginPlayerAccount" In callback "LoadPlayerAKA" In callback "LoadClanDetails" In callback "BanListCheck" In callback "LoginPlayerAccount" In callback "LoadPlayerAKA" In callback "OnAccountCreated" In callback "CreateClan" In callback "OnClanCreated"

 

 

asta e in mysql_log

Edited August 31, 2014 by valentin12

[Voller.]

SQL_Function CheckClanMembers( playerid )
{
    new
        clanname[ 128 ]
    ;

    cache_get_field_content( 0, "name", clanname, g_Handle );

    if ( cache_get_field_content_int( 0, "members", g_Handle ) <= 0 )
    {
        format( gsString, 144, "- The Clan {00FF00}%s {FFF1AF}- has been destroyed. Reason: {FF0000}No more players in.", clanname );
        SendClientMessageToAll( COLOR_SPECIAL, gsString );

        format( gsQuery, 128, "DELETE FROM `Clans` WHERE `id` = %d", PlayerInfo[ playerid ][ ID ] );
        mysql_function_query( g_Handle, gsQuery, false, "", "" );

        SetPlayerHealth( playerid, 0 );
        ResetPlayerWeapons( playerid );
        SetPlayerSkin( playerid, 217 );
        PlayerInfo[ playerid ][ ID ]         = 0;
        PlayerInfo[ playerid ][ rank ]         = 0;
        PlayerInfo[ playerid ][ skin ]         = 0;
        PlayerInfo[ playerid ][ spawnX ]     = 0.0;
        PlayerInfo[ playerid ][ spawnY ]     = 0.0;
        PlayerInfo[ playerid ][ spawnZ ]     = 0.0;
        PlayerInfo[ playerid ][ spawnA ]     = 0.0;
        PlayerInfo[ playerid ][ Weap1 ]     = 0;
        PlayerInfo[ playerid ][ Weap2 ]     = 0;
        PlayerInfo[ playerid ][ Weap3 ]     = 0;
        PlayerInfo[ playerid ][ Weap4 ]     = 0;
        PlayerInfo[ playerid ][ Weap5 ]     = 0;
        PlayerInfo[ playerid ][ Weap6 ]     = 0;
        PlayerInfo[ playerid ][ clan_H ]       = 0;
        PlayerInfo[ playerid ][ clan_M ]       = 0;
        PlayerInfo[ playerid ][ clan_S ]       = 0;
        format( PlayerInfo[ playerid ][ Clan ], 25, "None" );
    }
    else
    {
        foreach(new i: Player)
            if ( PlayerInfo[ i ][ ID ] == PlayerInfo[ playerid ][ ID ] )
                FormatMSG( i, COLOR_YELLOW, "Clan Info: {FFF1AF}Member {FF0000}%s{FFF1AF} left the clan.", PlayerName( playerid ) );

        SetPlayerHealth( playerid, 0 );
        ResetPlayerWeapons( playerid );
        SetPlayerSkin( playerid, 217 );
        PlayerInfo[ playerid ][ ID ]         = 0;
        PlayerInfo[ playerid ][ rank ]         = 0;
        PlayerInfo[ playerid ][ skin ]         = 0;
        PlayerInfo[ playerid ][ spawnX ]     = 0.0;
        PlayerInfo[ playerid ][ spawnY ]     = 0.0;
        PlayerInfo[ playerid ][ spawnZ ]     = 0.0;
        PlayerInfo[ playerid ][ spawnA ]     = 0.0;
        PlayerInfo[ playerid ][ Weap1 ]     = 0;
        PlayerInfo[ playerid ][ Weap2 ]     = 0;
        PlayerInfo[ playerid ][ Weap3 ]     = 0;
        PlayerInfo[ playerid ][ Weap4 ]     = 0;
        PlayerInfo[ playerid ][ Weap5 ]     = 0;
        PlayerInfo[ playerid ][ Weap6 ]     = 0;
        PlayerInfo[ playerid ][ clan_H ]       = 0;
        PlayerInfo[ playerid ][ clan_M ]       = 0;
        PlayerInfo[ playerid ][ clan_S ]       = 0;
        format( PlayerInfo[ playerid ][ Clan ], 25, "None" );
    }
    return ( 1 );
}

[Dany_Diaz]

Problema este in felul urmator cred ca ai incercat sa schimbi versiunea de mysql si nu ai schimbato corect.

P.S. Nu stiu daca tu esti scripterul sau este altcineva, dar dupa erorile primite cred ca cauza de mai sus este de vina.

[Voller.]

Nu am incercat sa schimb... gm-ul il am de la un prieten..asa l-am primit si vreau sa rezolv eroarea am playeri 20  pe urma la ceva timp ma  trezesc cu 4 playeri :| le da crash.

[Dany_Diaz]

In aces caz, intreabal pe prietenul tau ce are serverul pentru ca doar el stie ce a facut.

P.S Asa se intampla daca nu stii nimic la un gamemode dar deschizi cu el servere.

[Voller.]

Trb e ca nici el nu stie...( sa faca eroarea asta

[Voller.]

Inca o eroare : (((

CMySQLResult::GetRowDataByName() ERROR invalid row index ('0')

la playeri le da last connection .

Edited August 31, 2014 by valentin12