Jump to content
  • 0

Problema accounts baza de date

[K]Punker.

Asked by [K]Punker.,

 Share

Question

[K]Punker. Enthusiast

[K]Punker.

Posted
Posted

Salut. Dupa cum spune si titlul , nu se salveaza conturile in baza de date. Serverul este SSR V9 . Imi da o eroare Error: Unknown column 'Bussines' in 'field list' dar nu stiu cum sa o rezolv 

logs  

----------
Loaded log file: "server_log.txt".
----------

SA-MP Dedicated Server
----------------------
v0.3.7-R2, (C)2005-2015 SA-MP Team

[09:38:54] password = ""  (string)
[09:38:54] 
[09:38:54] Server Plugins
[09:38:54] --------------
[09:38:54]  Loading plugin: streamer.so
[09:38:54] 

*** Streamer Plugin v2.7.5.2 by Incognito loaded ***

[09:38:54]   Loaded.
[09:38:54]  Loading plugin: mysql_static.so
[09:38:55]  >> plugin.mysql: R39-2 successfully loaded.
[09:38:55]   Loaded.
[09:38:55]  Loading plugin: sscanf.so
[09:38:55] 

[09:38:55]  ===============================

[09:38:55]       sscanf plugin loaded.     

[09:38:55]          Version:  2.8.1        

[09:38:55]    (c) 2012 Alex "Y_Less" Cole  

[09:38:55]  ===============================

[09:38:55]   Loaded.
[09:38:55]  Loaded 3 plugins.

[09:38:55] 
[09:38:55] Ban list
[09:38:55] --------
[09:38:55]  Loaded: samp.ban
[09:38:55] 
[09:38:55] 
[09:38:55] Filterscripts
[09:38:55] ---------------
[09:38:55]   Loading filterscript 'UltraHost.amx'...
[09:38:55]   Loading filterscript 'streamermaps.amx'...
[09:38:57]   Loading filterscript 'PersonalCars.amx'...
[09:38:57]   Loading filterscript 'gangtxd.amx'...
[09:38:57]  - Gang Zone Editor v1.0b by Lorenc_ Loaded!
[09:38:57]   Loading filterscript 'TD_Editor.amx'...
[09:38:57]   Loading filterscript 'streamergangs.amx'...
[09:38:58]   Loaded 6 filterscripts.

[09:38:58] 30138 - Objects.
[09:38:58] 
MySQL: Connection to '127.0.0.1' established.
[09:38:58] MySQL: Database 'port_2503' selected.

[09:38:58] Number of vehicle models: 65
[09:38:59] 
Loaded 7 Gangs.
[09:38:59] Loaded 7 Gang Teritories.
[09:38:59] Loaded 7 Gang Checkpoints.
[09:38:59] Loaded 97 Properties.
[09:38:59] Loaded 1133 Houses.
[09:41:46] [connection] 178.203.234.88:3501 requests connection cookie.
[09:41:47] [connection] incoming connection: 178.203.234.88:3501 id: 0
[09:41:51] [join] [K]Shadow. has joined the server (0:178.203.234.88)
[09:42:05] ====================================================
[09:42:05] Error ID: 1054
Error: Unknown column 'Bussines' in 'field list'
Callback: OnAccountCreated
Query: INSERT INTO `Accounts` (`ID`, `Name`, `Password`, `IP`, `E-Mail`, `LoggedIn`, `RegisterDate`, `LastOn`, `Level`, `VIP`, `Cash`, `Score`, `Coins`, `Credits`, `Kills`, `Deaths`, `Hours`, `Minutes`, `Seconds`, `BestKillings`, `KillingSpree`, `FavSkin`, `UseSkin`, `House`, `Bussines`, `Description1`, `Description2`, `Description3`, `Positive`, `Negative`, `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`, `RGSClan`, `RGSRank`, `AdmWarns`, `VIPWarns`, `KickW`) VALUES (0, '[K]Shadow.', 'mafiotu', '178.203.234.88', 'changeme', '1', '11/02/2017', '11/02/2017', '0', '15', '25000', '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', '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')
[09:42:05] ====================================================
[09:42:07] ====================================================
[09:42:07] Error ID: 1054
Error: Unknown column 'Bussines' in 'field list'
Callback: 
Query: UPDATE `Accounts` SET `LoggedIn` = 0, `LastOn` = '11/02/2017', `Level` = '0', `VIP` = '0', `Cash` = '25000', `Score` = '15', Coins = '0', `Credits` = '0', `Kills` = '0', `Deaths` = '0', `Hours` = '0', `Minutes` = '0', `Seconds` = '16', `BestKillings` = '0', `KillingSpree` = '0', `FavSkin` = '0', `UseSkin` = '0', `House` = '0', `Bussines` = '0', `Description1` = '', `Description2` = '', `Description3` = '', `Positive` = '0', `Negative` = '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', `RGSClan` = '0', `RGSRank` = '0', `GangID` = '0', `GangRank` = '0', `GangSkin` = '0', `GangKills` = '0', `GangDeaths` = '0', `GangWarns` = '0', `GangCaptures` = '0', `GangPoints` = '0' WHERE `ID` = '0'
[09:42:07] ====================================================
[09:42:37] [chat] [[K]Shadow.]: 
[09:42:44] [chat] [[K]Shadow.]: 
[09:44:26] RCON (In-Game): Player #0 ([K]Shadow.) has logged in.
[09:47:43] [part] [K]Shadow. has left the server (0:1)
[09:47:43] ====================================================
[09:47:43] Error ID: 1054
Error: Unknown column 'Bussines' in 'field list'
Callback: 
Query: UPDATE `Accounts` SET `LoggedIn` = 0, `LastOn` = '11/02/2017', `Level` = '0', `VIP` = '0', `Cash` = '25000', `Score` = '15', Coins = '1661992960', `Credits` = '0', `Kills` = '1410065408', `Deaths` = '0', `Hours` = '1000', `Minutes` = '5', `Seconds` = '52', `BestKillings` = '0', `KillingSpree` = '0', `FavSkin` = '0', `UseSkin` = '0', `House` = '0', `Bussines` = '0', `Description1` = '', `Description2` = '', `Description3` = '', `Positive` = '276447232', `Negative` = '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` = '1316134912', `StuntScore` = '1316134912', `DriftScore` = '1316134912', `Ignores` = '0/0/0/0', `AdmWarns` = '0', `VIPWarns` = '0', `KickW` = '0', `LottoNumber` = '0', `C4` = '0', `StatsNote` = '6', `FreeVIP` = '1', `TempVIP` = '0', `RGSClan` = '0', `RGSRank` = '0', `GangID` = '0', `GangRank` = '0', `GangSkin` = '0', `GangKills` = '0', `GangDeaths` = '0', `GangWarns` = '0', `GangCaptures` = '0', `GangPoints` = '0' WHERE `ID` = '0'
[09:47:43] ====================================================

 

Link to comment
Share on other sites

9 answers to this question

Recommended Posts

  • 0
Mister Veteran

Mister

Posted
Posted

Verifica in baza de date daca ai tabelul 

Bussines

si daca da vezi sa nu se numseasca defapt

Busines pentru ca in gm este alt nume si nu il recunoaste cand se executa instructiunea mysql

  

    __  ____      __           
   /  |/  (_)____/ /____  _____
  / /|_/ / / ___/ __/ _ \/ ___/
 / /  / / (__  ) /_/  __/ /    
/_/  /_/_/____/\__/\___/_/     
SERVICII SCRIPTING DE CALITATE
Pagina     Scripting     pawn
Link to comment
Share on other sites
  • 0
Daedric-Fox Mentor

Daedric-Fox

Posted
Posted
Chiar acum, TinKode_ a spus:

Nu am nici un Bussines 

 

Asta si problema, trebuie sa-l adaugi.

**********************************

Servicii Scripting de calitate:

*********************************

Future Project: ExpertGame

*********************************

Link to comment
Share on other sites
  • 0
Daedric-Fox Mentor

Daedric-Fox

Posted
Posted
Chiar acum, TinKode_ a spus:

Si cum fac asta ? ai un tutorial ceva ? plss help

Adaugi acea coloana in acel tabel, chiar e asa de greu?

**********************************

Servicii Scripting de calitate:

*********************************

Future Project: ExpertGame

*********************************

Link to comment
Share on other sites
  • 0
Mister Veteran

Mister

Posted
Posted
6 minutes ago, TinKode_ said:

Am facut asta si acuma nu mai merge srv ii Unknown

poti da click pe tabelul AKAs sa vedem poate acela este tabelul business iar cel care a facut gmul a schimbat numele ca sa intimpini tu probleme

  

    __  ____      __           
   /  |/  (_)____/ /____  _____
  / /|_/ / / ___/ __/ _ \/ ___/
 / /  / / (__  ) /_/  __/ /    
/_/  /_/_/____/\__/\___/_/     
SERVICII SCRIPTING DE CALITATE
Pagina     Scripting     pawn
Link to comment
Share on other sites
  • 0
[K]Punker. Enthusiast

[K]Punker.

Posted
  • Author
Posted
1 oră în urmă, Mister a spus:

poti da click pe tabelul AKAs sa vedem poate acela este tabelul business iar cel care a facut gmul a schimbat numele ca sa intimpini tu probleme

Am dat si daca adaug Bussines ii unknown plsss help. Am cautat si in celelalte si alea par in regula

Link to comment
Share on other sites
Guest
This topic is now closed to further replies.
 Share
Go to question listing
×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue. For more details you can also review our Terms of Use and Privacy Policy.