MySQL Big problem pls
#1

Код:
[11:50:19] [INFO] Now logging: errors
[11:50:19] [ERROR] >> cache_get_row_float(...) - An error occured during the datatype conversion.
[11:50:19] [ERROR] >> cache_get_row_int(...) - An error occured during the datatype conversion.
[11:50:19] [ERROR] >> cache_get_row_int(...) - An error occured during the datatype conversion.
[11:50:19] [ERROR] >> cache_get_row_int(...) - An error occured during the datatype conversion.
[04:38:45] [INFO] Now logging: errors
[04:38:45] [ERROR] >> cache_get_row_float(...) - An error occured during the datatype conversion.
[04:38:46] [ERROR] >> cache_get_row_int(...) - An error occured during the datatype conversion.
[04:38:46] [ERROR] >> cache_get_row_int(...) - An error occured during the datatype conversion.
[04:38:46] [ERROR] >> cache_get_row_int(...) - An error occured during the datatype conversion.
[04:40:46] [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)
[04:41:09] [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)
[04:42:08] [INFO] Now logging: errors
[04:42:09] [ERROR] >> cache_get_row_float(...) - An error occured during the datatype conversion.
[04:42:09] [ERROR] >> cache_get_row_int(...) - An error occured during the datatype conversion.
[04:42:09] [ERROR] >> cache_get_row_int(...) - An error occured during the datatype conversion.
[04:42:09] [ERROR] >> cache_get_row_int(...) - An error occured during the datatype conversion.
Code:

Код HTML:
		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, "", "");
I can't save and load something like House's info "Like written something that can be use in 3DText by an admin and i can't save interior and exit position " and a part of Player Info, why?
Reply
#2

BUMP!!!
Reply
#3

BUMP!!!
Reply


Forum Jump:


Users browsing this thread: 1 Guest(s)