Započeo Am1L
•19. Okt. 2021.MYSQL ERROR
507
pregleda
4
postova
Street Runner
Balkan SA:MP
SA-MP Doprinos
Balkan SA:MP
SA-MP DoprinosNovi Član
90 / 100 XP
Početnik(0)
12
Postovi:
7
Teme:
Pridružio se:Avg. 2021
19. Okt. 2021.
Problem(error/warning): Kad pokrenem mod i ucem u samp ne izbacuje mi dialog, evo imate dole mysql_log
Deo skripte:
Debug iz server_log(ukoliko je u pitanju crashanje servera - crashdetect 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")Made Man
Balkan SA:MP
SA-MP Doprinos
Balkan SA:MP
SA-MP DoprinosNovi Član
137 / 250 XP
Početnik(0)
387
Postovi:
39
Teme:
Pridružio se:Feb. 2016
Enforcer
Balkan SA:MP
SA-MP Doprinos
Balkan SA:MP
SA-MP DoprinosNovi Član
25 / 100 XP
Početnik(0)
315
Postovi:
0
Teme:
Pridružio se:Jun 2021
19. Okt. 2021.
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.
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.
Morate biti prijavljeni da biste odgovorili na ovu temu.
Prijava