MySQL [INFO] Now logging: errors

MySQL [INFO] Now logging: errors - 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 [INFO] Now logging: errors (/showthread.php?tid=509003)

MySQL [INFO] Now logging: errors - Mavis100 - 24.04.2014

[07:55:39] [INFO] Now logging: errors

What is this?

Re: MySQL [INFO] Now logging: errors - Mattakil - 24.04.2014

That would be a plugin in your script that is checking for any issues, it will report them..Most likely CrashDetect or something similar, nothing to worry about

Re: MySQL [INFO] Now logging: errors - Mavis100 - 24.04.2014

Quote:

Originally Posted by Mattakil

That would be a plugin in your script that is checking for any issues, it will report them..Most likely CrashDetect or something similar, nothing to worry about

I got this

[07:58:57] [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)
[07:59: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)

Код:

		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 [INFO] Now logging: errors - Mattakil - 25.04.2014

pawn Код:

format(query, sizeof(query), "UPDATE `users` SET `upgrade` = %d, `paydaytime` = %d, `spawnhealth` = %.1f, `cellphone` = %d, `number` = %d, `savings` = %d, `housekey` = %d, `bizkey` = %d, `veh1` = %d, `veh2` = %d, `veh3` = %d `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, "", "");

Try that, the vehicles were set to a string, I assume they should be set to a int, for the vehicleid

Re: MySQL [INFO] Now logging: errors - Mavis100 - 25.04.2014

Quote:

Originally Posted by Mattakil

pawn Код:

format(query, sizeof(query), "UPDATE `users` SET `upgrade` = %d, `paydaytime` = %d, `spawnhealth` = %.1f, `cellphone` = %d, `number` = %d, `savings` = %d, `housekey` = %d, `bizkey` = %d, `veh1` = %d, `veh2` = %d, `veh3` = %d `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, "", "");

Try that, the vehicles were set to a string, I assume they should be set to a int, for the vehicleid

Thank you, i'll try