PDA

View Full Version : MySQL database problem


darkowner
14/06/2015, 05:31 PM
Hello SA:MP forum, I have a problem with my mysql database, which is not saving anything, I registered my account in-game, then I check the database and nothing there.

I look in server log and I saw these things:

[19:25:54] Error ID: 1054
Error: Unknown column 'RLSClan' in 'field list'
Callback: OnAccountCreated
Query: INSERT INTO `Accounts` (`ID`, `Name`, `Password`, `IP`, `E-Mail`, `LoggedIn`, `RegisterDate`, `LastOn`, `Level`, `VIP`, `Cash`, `Score`, `Coins`, `Credits`, `Headshots`, `Kills`, `Deaths`, `Hours`, `Minutes`, `Seconds`, `BestKillings`, `KillingSpree`, `FavSkin`, `UseSkin`, `House`, `Property`, `Description1`, `Description2`, `Description3`, `Positive`, `Negative`, `ClanID`, `ClanRank`, `ClanPoints`, `ClanKills`, `ClanDeaths`, `Kicks`, `Bans`, `Jails`, `Warns`, `ClearChats`, `ReactionTest`, `MathTest`, `Mutes`, `Jailed`, `JailTime`, `Frozen`, `FreezeTime`, `Muted`, `MuteTime`, `RaceScore`, `StuntScore`, `DriftScore`, `GangID`, `GangRank`, `GangSkin`, `GangKills`, `GangDeaths`, `GangWarns`, `GangCaptures`, `GangPoints`, `Ignores`, `LottoNumber`, `C4`, `StatsNote`, `VIPTime`, `FreeVIP`, `TempVIP`, `RLSClan`, `RLSRank`, `AdmWarns`, `VIPWarns`, `KickW`) VALUES (0, 'LordH3ll', '0762996674', '82.137.10.16', 'changeme@etrion.ro', '1', '14/06/2015', '14/06/2015', '0', '0', '25000', '100', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '217', '1', '0', '0', ' ', ' ', ' ', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '00:00', '0', '00:00', '0', '00:00', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0/0/0/0', '0', '0', '0', '0', '1', '0', '0', '0', '0', '0', '0')
[19:25:54] ================================================== ==
[19:27:59] [part] LordH3ll has left the server (1:1)
[19:27:59] ================================================== ==
[19:27:59] Error ID: 1054
Error: Unknown column 'RLSClan' in 'field list'
Callback:
Query: UPDATE `Accounts` SET `LoggedIn` = 0, `LastOn` = '14/06/2015', `Level` = '0', `VIP` = '0', `Cash` = '25000', `Score` = '100', Coins = '0', `Credits` = '0', `Headshots` = '0', `Kills` = '0', `Deaths` = '0', `Hours` = '0', `Minutes` = '2', `Seconds` = '14', `BestKillings` = '0', `KillingSpree` = '0', `FavSkin` = '0', `UseSkin` = '0', `House` = '0', `Property` = '0', `Description1` = '', `Description2` = '', `Description3` = '', `Positive` = '0', `Negative` = '0', `ClanID` = '0', `ClanRank` = '0', `ClanPoints` = '0', `ClanKills` = '0', `ClanDeaths` = '0', `Kicks` = '0', `Bans` = '0', `Jails` = '0', `Warns` = '0', `ClearChats` = '0', `ReactionTest` = '0', `MathTest` = '0', `Mutes` = '0', `Jailed` = '0', `JailTime` = '0:0', `Frozen` = '0', `FreezeTime` = '0:0', `Muted` = '0', `MuteTime` = '0:0', `RaceScore` = '0', `StuntScore` = '0', `DriftScore` = '0', `Ignores` = '0/0/0/0', `AdmWarns` = '0', `VIPWarns` = '0', `KickW` = '0', `LottoNumber` = '0', `C4` = '0', `StatsNote` = '0', `FreeVIP` = '1', `TempVIP` = '0', `RLSClan` = '0', `RLSRank` = '0', `GangID` = '0', `GangRank` = '0', `GangSkin` = '0', `GangKills` = '0', `GangDeaths` = '0', `GangWarns` = '0', `GangCaptures` = '0', `GangPoints` = '0' WHERE `ID` = '0'
[19:27:59] ================================================== ==

Everything is well configured in the gamemode.
PS:My server is hosted.

ball
14/06/2015, 05:57 PM
You don't have column 'RLSClan' in table Accounts - simply add this column or remove it from gamemode if you don't know what it is.

darkowner
14/06/2015, 06:06 PM
You don't have column 'RLSClan' in table Accounts - simply add this column or remove it from gamemode if you don't know what it is.

Done,thank you.