Započeo Am1L
•23. Okt. 2021.• ZaključanoNE CUVAJU MI BEZINSKE PUMPE U MYSQL
399
pregleda
2
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
23. Okt. 2021.
Problem(error/warning): Necuva mi pumpe koje priram u databazu
Deo skripte:
Debug iz server_log(ukoliko je u pitanju crashanje servera - crashdetect log):
Deo skripte:
protected mSQL_CreateFuelStation( createID )
{
static q;
mysql_format( mSQL, q, sizeof( q ),
"INSERT INTO `fuel_stations` ( fsBussinesID, fsFuelPrice, fsPos1, fsPos2, fsPos3 ) \
VALUES( '%d', '%d', '%d', '%d', '%d', '%f', '%f', '%f' )",
FuelStation[ createID ][ fsBussinesID ], FuelStation[ createID ][ fsFuelPrice ], FuelStation[ createID ][ fsPos ][ 0 ], FuelStation[ createID ][ fsPos ][ 1 ], FuelStation[ createID ][ fsPos ][ 2 ] );
mysql_tquery( mSQL, q, "OnFuelStationCreated", "i", createID );
return(true);
}
protected OnFuelStationCreated( createID )
{
FuelStation[ createID ][ fsSQLID ] = cache_insert_id();
return(true);
}Debug iz server_log(ukoliko je u pitanju crashanje servera - crashdetect log):
[11:20:02 10/22/21] mysql_format - no value for specifier "%f" available
[11:20:02 10/22/21] mysql_format - no value for specifier "%f" available
[11:20:02 10/22/21] mysql_format - no value for specifier "%f" available
[11:20:02 10/22/21] CMySQLQuery::Execute - (error #1136) Column count doesn't match value count at row 1 (Query: "INSERT INTO `fuel_stations` ( fsBussinesID, fsFuelPrice, fsPos1, fsPos2, fsPos3 ) VALUES( '7', '2', '1148904002', '-999769157', '1110002024', '', '', '' )")Kingpin
Balkan SA:MP
SA-MP Doprinos
Balkan SA:MP
SA-MP DoprinosNovi Član
241 / 250 XP
Početnik(0)
1,344
Postovi:
96
Teme:
Pridružio se:Jun 2012
23. Okt. 2021.
Imas imenovnih 5 polja, a unosis 8 vrijednosti
Probaj ovako
Probaj ovako
"INSERT INTO `fuel_stations` ( fsBussinesID, fsFuelPrice, fsPos1, fsPos2, fsPos3 ) \
VALUES( `%d`, `%d`, `%f`, `%f`, `%f`)"Morate biti prijavljeni da biste odgovorili na ovu temu.
Prijava