MYSQL ERROR

Započeo Am1L
pre 4 godine
419
pregleda
4
postova
Am1L
Street Runner
pre 4 godine
Problem(error/warning):  Kad pokrenem mod i ucem u samp ne izbacuje mi dialog, evo imate dole mysql_log
Deo skripte:
protected CheckPlayerAccount( playerid )
{
    new rows, fields;
    cache_get_data( rows, fields, mSQL );

    if( !rows )
{
        if( !IsValidRoleplayName( ImeIgraca( playerid ) ) )
{
SendClientMessage( playerid, CRVENA, "#NON-RP NICKNAME: {FFFFFF}Dobili ste kick zbog krivo formatiranog imena." );
SendClientMessage( playerid, CRVENA, "#NON-RP NICKNAME: {FFFFFF}Vase ime mora biti u formatu {FA5555}'Ime_Prezime'." );
defer KickIgraca(playerid);
return 1;
}

    if( ServerInfo[ Registracija ] == false )
{
SendClientMessage( playerid, CRVENA, "#REGISTER: {FFFFFF}REGISTRACIJA JE TRENUTNO ONEMOGUCENA." );
SendClientMessage( playerid, CRVENA, "#REGISTER: {FFFFFF}JV - ADMIN TEAM." );
defer KickIgraca(playerid);
            return 1;
    }

    Register(playerid);
    }
    else
{
        cache_get_field_content( 0, "password", PlayerInfo[ playerid ][ xLozinka ], mSQL, 150 );
PlayerInfo[ playerid ][ xRegistrovan ] = cache_get_field_content_int( 0, "registered" );
PlayerInfo[ playerid ][ xID ] = cache_get_field_content_int( 0, "user_id" );
PlayerInfo[ playerid ][ xLevel ] = cache_get_field_content_int( 0, "level" );
PlayerInfo[ playerid ][ xRespekt ] = cache_get_field_content_int( 0, "exp" );
PlayerInfo[ playerid ][ xOnlineSati ] = cache_get_field_content_int( 0, "xOnlineSati" );
PlayerInfo[ playerid ][ xDrzava ] = cache_get_field_content_int( 0, "country" );
PlayerInfo[ playerid ][ xNovac ] = cache_get_field_content_int( 0, "money" );
PlayerInfo[ playerid ][ xBRacun ] = cache_get_field_content_int( 0, "xBRacun" );
PlayerInfo[ playerid ][ xPosao ] = cache_get_field_content_int( 0, "job_id" );
PlayerInfo[ playerid ][ xUgovor ] = cache_get_field_content_int( 0, "contract" );
PlayerInfo[ playerid ][ xSkin ] = cache_get_field_content_int( 0, "skin_id" );
PlayerInfo[ playerid ][ xWarn ] = cache_get_field_content_int( 0, "warn" );
PlayerInfo[ playerid ][ xAdmin ] = cache_get_field_content_int( 0, "admin_lvl" );
PlayerInfo[ playerid ][ xHelper ] = cache_get_field_content_int( 0, "helper_level" );
PlayerInfo[ playerid ][ xTestAdmin ] = cache_get_field_content_int( 0, "xTestAdmin" );
PlayerInfo[ playerid ][ xVIPLevel ] = cache_get_field_content_int( 0, "vip_level" );
PlayerInfo[ playerid ][ xVPoen ] = cache_get_field_content_int( 0, "v_poen" );
PlayerInfo[ playerid ][ xVCoin ] = cache_get_field_content_int( 0, "xVCoin" );
PlayerInfo[ playerid ][ xTogStats ] = bool:cache_get_field_content_int( 0, "xTogStats" );

        if( PlayerInfo[ playerid ][ xRegistrovan ] == 1 )
{
            new query;
mysql_format( mSQL, query, sizeof(query), "SELECT * FROM `banned` WHERE `user_id` = '%d' LIMIT 1", PlayerInfo[ playerid ][ xID ] );
mysql_pquery( mSQL, query, "CheckPlayerBan", "i", playerid );
}
else
{
    if( ServerInfo[ Registracija ] == false )
{
        SendClientMessage( playerid, CRVENA, "#REGISTER: {FFFFFF}REGISTRACIJA JE TRENUTNO ONEMOGUCENA." );
SendClientMessage( playerid, CRVENA, "#REGISTER: {FFFFFF}JV - ADMIN TEAM." );
        defer KickIgraca(playerid);
        return 1;
    }

Register(playerid);
}
    }
return(true);
}

Debug iz server_log(ukoliko je u pitanju crashanje servera - crashdetect log):
 CMySQLQuery::Execute - (error #1054) Unknown column 'xTogStats' in 'field list' (Query: "SELECT `registered`, `password`, `user_id`, `level`, `exp`, `xOnlineSati`, `country`, `money`, `xBRacun`, `job_id`, `contract`, `skin_id`, `warn`, `admin_lvl`, `helper_level`, `xTestAdmin`, `vip_level`, `v_poen`, `xVCoin`, `xTogStats` FROM `users` WHERE `p_name` = 'Amil_Vetar' LIMIT 1")
David||BM
Made Man
pre 4 godine
Nedostaje ti u tabeli xTogStats colum samo ti kaze unkown columm
Raskiselišelitiseopanci
Enforcer
pre 4 godine
1. u tabeli nedostaje kolona

2. Ako naziv kolone u TABELI CREATE i UPDATE nisu isti. U slučajevima, oni mogu izgledati isto, ali možda postoje znakovi koji se ne mogu isprintati ili imaju Unicode znakove koji izgledaju isto, ali zapravo su različite kodne tačke.
Am1L
Street Runner
pre 4 godine
Hvala svima rjesio sam

Morate biti prijavljeni da biste odgovorili na ovu temu.

Prijava