#[MySql Issue] Data suddenly stopped saving

14 messages · Page 1 of 1 (latest)

warm whale
#

mysql log would be useful

rocky lotus
# 
[21:42:32 08/19/24] [ERROR] CMySQLQuery::Execute[] - (error #1054) Unknown column 'bkSkills' in 'field list' (Query: "UPDATE `playersdata` SET `LastSeen` = UNIX_TIMESTAMP(), `IP` = '165.51.10.241', `AutoLogin` = 0, `Level` = 0, `Money` = 880, `RWC` = 0, `Kills` = 2,`Deaths` = 2, `Suicides` = 0, `Hours` = 0, `Minutes` = 8, `Seconds` = 50, `Marijuana` = 0, `Seeds` = 0, `Cocaine` = 0, `Premium` = 0, `PremiumExpires` = 0, `FightStyle` = 4,`xLevel` = 1, `XP` = 0, `Muted` = 0, `Hitman` = 0, `gSkills` = 4, `bSkills` = 0, `vSkills` = 0, `aSkills` = 4, `bkSkills` = 0, `mSkills` = 0, `rSkills` = 0, `dSkills` = 0,`tSkills` = 6, `ruSkills` = 0, `PlayerTeam` = 255, `MoneyBags` = 0, `Skin` = 0, `PosX` = 1288.319, `PosY` = 338.662, `PosZ` = 19.505, `Interior` = 0, `Health` = 100.0, `Armour` = 0.0, `Jetpack` = 0,`JetpackExpire` = 0, `Friends` = 1, `Vehicles` = 0, `InHouse` = -1, `PlayerColor` = '0xFFFFFFFF', `TextColor` = 'FFFFFF', `MapHide` = 0  WHERE `ID` = 123")
[21:42:32 08/19/24] [DEBUG] CMySQLQuery::Execute[] - error will be triggered in OnQueryError
warm whale
#

I doubt that it "suddenly" broke. Either it didn't work right from the beginning, or you changed something and now it's broken

rocky lotus
#

i'll not check DMs.

#

and it truly says "Unknown column 'bkSkills' in 'field list'"

warm whale
#

There are 80 errors in the span of 5 minutes

rocky lotus
#

Just read.

warm whale
#

(X) Doubt

rocky lotus
#

[21:37:50 08/19/24] [ERROR] CMySQLQuery::Execute[GiveHouseKeys] - (error #1146) Table 'n57yyyhsv3.HouseKeys' doesn't exist (Query: "SELECT * FROM `HouseKeys` WHERE `Player` = 'Usman_Khan'")
[21:39:01 08/19/24] [ERROR] CMySQLQuery::Execute[GiveHouseKeys] - (error #1146) Table 'n57yyyhsv3.HouseKeys' doesn't exist (Query: "SELECT * FROM `HouseKeys` WHERE `Player` = 'Beamon'")

#

Uhh

#

just change for [ERROR]

#

and modify ur mysql_log for mysql_log(ERROR)

#

remove the debug

rocky lotus
#

You can read right? the errors are in your face