MYSQL ERROR

[Am1L]

Problem(error/warning):  Kad pokrenem mod i ucem u samp ne izbacuje mi dialog, evo imate dole mysql_log
Deo skripte: [pawn]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[128];
         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);
}[/pawn]
Debug iz server_log(ukoliko je u pitanju crashanje servera - crashdetect log):

Kod [Izaberi] Proširi

[ERROR] CMySQLQuery::Execute[CheckPlayerAccount] - (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")

[Skorpija_026]

Nedostaje ti u tabeli xTogStats colum samo ti kaze unkown columm

[№Grella]

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]

Hvala svima rjesio sam