SA-MP Forums Archive
MySQL Bug ID 1064 - Printable Version

+- SA-MP Forums Archive (https://sampforum.blast.hk)
+-- Forum: SA-MP Scripting and Plugins (https://sampforum.blast.hk/forumdisplay.php?fid=8)
+--- Forum: Scripting Help (https://sampforum.blast.hk/forumdisplay.php?fid=12)
+--- Thread: MySQL Bug ID 1064 (/showthread.php?tid=508847)


MySQL Bug ID 1064 - Mavis100 - 24.04.2014

PHP код:
[12:25:48] [INFO] Now logging: errors
[12:25:48] [ERROR] >> cache_get_row_float(...) - An error occured during the datatype conversion.
[12:25:48] [ERROR] >> cache_get_row_int(...) - An error occured during the datatype conversion.
[12:25:48] [ERROR] >> cache_get_row_int(...) - An error occured during the datatype conversion.
[12:25:48] [ERROR] >> cache_get_row_int(...) - An error occured during the datatype conversion.
[12:25:48] [ERROR] >> cache_get_row_int(...) - An error occured during the datatype conversion.
[12:25:48] [ERROR] >> cache_get_row_int(...) - An error occured during the datatype conversion.
[12:25:48] [ERROR] >> cache_get_row_int(...) - An error occured during the datatype conversion.
[12:27:00] [ERROR] ProcessQueryThread() - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '`melee` = 0, `wep1`= 0, `wep2` = 0, `ammo1` = 0, `ammo2`= 0 WHERE `name` = 'Casp' at line 1 (error ID: 1064)
[12:31:55] [INFO] Now logging: errors
[12:31:55] [ERROR] >> cache_get_row_float(...) - An error occured during the datatype conversion.
[12:31:55] [ERROR] >> cache_get_row_float(...) - An error occured during the datatype conversion.
[12:31:55] [ERROR] >> cache_get_row_int(...) - An error occured during the datatype conversion.
[12:31:55] [ERROR] >> cache_get_row_int(...) - An error occured during the datatype conversion.
[12:31:55] [ERROR] >> cache_get_row_int(...) - An error occured during the datatype conversion.
[12:31:55] [ERROR] >> cache_get_row_int(...) - An error occured during the datatype conversion.
[12:31:55] [ERROR] >> cache_get_row_int(...) - An error occured during the datatype conversion.
[12:31:55] [ERROR] >> cache_get_row_int(...) - An error occured during the datatype conversion.
[12:32:56] [ERROR] ProcessQueryThread() - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '`melee` = 0, `wep1`= 0, `wep2` = 0, `ammo1` = 0, `ammo2`= 0 WHERE `name` = 'Casp' at line 1 (error ID: 1064) 
Pawn code:

Код:
		//=========================================================================================================
		format(query, sizeof(query), "UPDATE `users` SET `note3` = '%s', `note3s` = %d, `attributes` = '%s', `paycheck` = %d, `paycheckmoney` = %d, `chequecode` = %d, `chequeID` = %d, `Online` = %d WHERE `name` = '%s'",
		PlayerInfo[playerid][pNote3],
		PlayerInfo[playerid][pNote3s],
		PlayerInfo[playerid][pAttributes],
		PlayerInfo[playerid][pPayCheckMade],
		PlayerInfo[playerid][pPayCheckMoney],
		PlayerInfo[playerid][pChequeCode],
		PlayerInfo[playerid][pChequeID],
		PlayerInfo[playerid][pOnline],
		GetName(playerid));
		mysql_function_query(dbHandle, query, false, "", "");
		//=========================================================================================================
		format(query, sizeof(query), "UPDATE `users` SET `upgrade` = %d, `paydaytime` = %d, `spawnhealth` = %.1f, `cellphone` = %d, `number` = %d, `savings` = %d, `housekey` = %d, `bizkey` = %d, `veh1` = '%s', `veh2` = '%s', `veh3` = '%s' `melee` = %d, `wep1`= %d, `wep2` = %d, `ammo1` = %d, `ammo2`= %d WHERE `name` = '%s'",
		PlayerInfo[playerid][pUpgrade],
		PlayerInfo[playerid][pPayDayTime],
		PlayerInfo[playerid][pSHealth],
		PlayerInfo[playerid][pCellPhone],
		PlayerInfo[playerid][pNumber],
		PlayerInfo[playerid][pSavings],
		PlayerInfo[playerid][pHouseKey],
		PlayerInfo[playerid][pBizKey],
		PlayerVehicle[playerid][pVeh1],
		PlayerVehicle[playerid][pVeh2],
		PlayerVehicle[playerid][pVeh3],
		PlayerInfo[playerid][pMeleeWep],
		GetPrimaryWeapon(playerid),
		GetSecondaryWeapon(playerid),
		GetWeaponAmmo(playerid, PlayerInfo[playerid][pPerm1]),
		GetWeaponAmmo(playerid, PlayerInfo[playerid][pPerm2]),
		GetName(playerid));
		mysql_function_query(dbHandle, query, false, "", "");


Re: MySQL Bug ID 1064 - Mavis100 - 24.04.2014

[13:09:27] [INFO] Now logging: errors
[13:09:27] [ERROR] >> cache_get_row_float(...) - An error occured during the datatype conversion.
[13:09:27] [ERROR] >> cache_get_row_int(...) - An error occured during the datatype conversion.
[13:09:27] [ERROR] >> cache_get_row_int(...) - An error occured during the datatype conversion.
[13:09:27] [ERROR] >> cache_get_row_int(...) - An error occured during the datatype conversion.
[13:09:27] [ERROR] >> cache_get_row_int(...) - An error occured during the datatype conversion.
[13:09:27] [ERROR] >> cache_get_row_int(...) - An error occured during the datatype conversion.
[13:09:27] [ERROR] >> cache_get_row_int(...) - An error occured during the datatype conversion.
[13:09:27] [ERROR] >> cache_get_row_int(...) - An error occured during the datatype conversion.
[13:09:27] [ERROR] >> cache_get_row_int(...) - An error occured during the datatype conversion.
[13:09:27] [ERROR] >> cache_get_row_float(...) - An error occured during the datatype conversion.


When i added some table into my sql and i got this.