MYSQL ERROR


Započeo Am1L, Oktobar 19, 2021, 12:15:12 POSLE PODNE

prethodna tema - sledeća tema

0 članova i 1 gost pregledaju ovu temu.

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[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);
}

Debug iz server_log(ukoliko je u pitanju crashanje servera - crashdetect log):
[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")
Poslednja Izmena: Oktobar 20, 2021, 23:56:49 POSLE PODNE od M Ө M Σ N Z I

Nedostaje ti u tabeli xTogStats colum samo ti kaze unkown columm
Vandals Project OGC
[size=11.25pt]Vandals Project OGC[/size][/font]
[/color]

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.
Upwork Skills
Back-end:
• PHP Frameworks (Laravel, Symfony,Codeigniter)
• Python/Django
• Node.js

Front-end:
• HTML
• CSS pre-processing (SASS, LESS)
• Javascript (JQuery, Ajax, Vue, Angular, React, etc.)
• Bootstrap

CMS
• Wordpress (Woocommerce)
• Shopify, Magento