[GameMode] Next Generation Roleplay

Just saying, are you even reading the logs... You installed MySQL but you haven't even configured the username and password so it's still not fixed.

Quote:

[09:44:20] [MySQL] (Main Pipelines) Connecting to 127.0.0.1...
[09:44:20] [MySQL] (MainPipeline) Fatal Error! Could not connect to MySQL: Host 127.0.0.1 - DB: ngrp2 - User: root
[09:44:20] [MySQL] Note: Make sure that you have provided the correct connection credentials.
[09:44:20] [MySQL] Error number: 2013

You will also need to import the SQL data into that database, which if you haven't done this already, I would suggest on starting with a less complicated script...
Reply

Quote:
Originally Posted by Sew_Sumi
View Post
Just saying, are you even reading the logs... You installed MySQL but you haven't even configured the username and password so it's still not fixed.



You will also need to import the SQL data into that database, which if you haven't done this already, I would suggest on starting with a less complicated script...
I admire your patience to respond to this still.. You're right btw, people should learn how to use certain plugins/includes (or scripting in general) before they even try to touch a 'complicated' script like this.
Reply

Quote:
Originally Posted by Sew_Sumi
Посмотреть сообщение
Just saying, are you even reading the logs... You installed MySQL but you haven't even configured the username and password so it's still not fixed.



You will also need to import the SQL data into that database, which if you haven't done this already, I would suggest on starting with a less complicated script...
server work but i get
Код:
SA-MP Dedicated Server
----------------------
v0.3.7-R2, ©2005-2015 SA-MP Team

[17:07:03] 
[17:07:03] Server Plugins
[17:07:03] --------------
[17:07:03]  Loading plugin: crashdetect
[17:07:03]   CrashDetect v4.16 is OK.
[17:07:03]   Loaded.
[17:07:03]  Loading plugin: streamer
[17:07:03] 

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

[17:07:03]   Loaded.
[17:07:03]  Loading plugin: mysql
[17:07:03]  >> plugin.mysql: R41-2 successfully loaded.
[17:07:03]   Loaded.
[17:07:03]  Loading plugin: sscanf
[17:07:03] 

[17:07:03]  ===============================

[17:07:03]       sscanf plugin loaded.     

[17:07:03]          Version:  2.8.2        

[17:07:03]    © 2012 Alex "******" Cole  

[17:07:03]  ===============================

[17:07:03]   Loaded.
[17:07:03]  Loading plugin: whirlpool
[17:07:03]  
[17:07:03]  ==================
[17:07:03]  
[17:07:03]   Whirlpool loaded
[17:07:03]  
[17:07:03]  ==================
[17:07:03]  
[17:07:03]   Loaded.
[17:07:03]  Loading plugin: irc
[17:07:03] 

*** IRC Plugin v1.4.6 by Incognito loaded ***

[17:07:03]   Loaded.
[17:07:03]  Loading plugin: gvar
[17:07:03] 

*** GVar Plugin v1.3 by Incognito loaded ***

[17:07:03]   Loaded.
[17:07:03]  Loaded 7 plugins.

[17:07:03] 
[17:07:03] Ban list
[17:07:03] --------
[17:07:03]  Loaded: samp.ban
[17:07:03] 
[17:07:03] 
[17:07:03] Filterscripts
[17:07:03] ---------------
[17:07:03]   Loading filterscript 'FurnitureSystem.amx'...
[17:07:07]   Loading filterscript 'server.amx'...
[17:07:08]   Loaded 2 filterscripts.

[17:07:09]  
[17:07:09]  
[17:07:09]  
[17:07:09]  ======================================= 
[17:07:09]  |                                     | 
[17:07:09]  |        YSI version 3.09.0684        | 
[17:07:09]  |        By Alex "******" Cole        | 
[17:07:09]  |                                     | 
[17:07:09]  ======================================= 
[17:07:09]  
[17:07:09]  
[17:07:09]  
[17:07:10] [Streamer] Loading Dynamic Areas...
[17:07:10] [Streamer] Loading Dynamic Buttons...
[17:07:10] [Streamer] Dynamic Buttons has been loaded.
[17:07:10] [Streamer] Loading Dynamic Objects...
[17:07:10] [Streamer] Dynamic Objects has been loaded.
[17:07:10] [Streamer] Loading Dynamic Pickups...
[17:07:10] [Streamer] Dynamic Pickups have been loaded.
[17:07:10] [Streamer] Loading 3D Text Labels...
[17:07:10] [Streamer] Dynamic 3D Text Labels has been loaded.
[17:07:10] [Streamer] Loading Dynamic Static Vehicles...
[17:07:10] [Streamer] Dynamic Static Vehicles have been loaded.
[17:07:10] Preparing the gamemode, please wait...
[17:07:10] [MySQL] (Main Pipelines) Connecting to 127.0.0.1...
[17:07:10] [MySQL] (MainPipeline) Connection successful toward MySQL Database Server!
[17:07:10] [Dynamic Giftbox] Loading the Dynamic Giftbox...
[17:07:10] [LoadHouses] Loading data from database...
[17:07:10] [LoadDynamicDoors] Loading data from database...
[17:07:10] [LoadDynamicMapIcons] Loading data from database...
[17:07:10] [LoadMailboxes] Loading data from database...
[17:07:10] [LoadBusinesses] Loading data from database...
[17:07:10] [LoadAuctions] Loading data from database...
[17:07:10] [LoadTxtLabels] Loading data from database...
[17:07:10] [SpeedCameras] Loading data from database...
[17:07:10] [LoadPayNSprays] Loading data from database...
[17:07:10] [LoadArrestPoints] Loading data from database...
[17:07:10] [LoadImpoundPoints] Loading data from database...
[17:07:10] [LoadRelayForLifeTeams] Loading data from database...
[17:07:10] [LoadGarages] Loading data from database...
[17:07:10] [LoadCrimes] Loading Crimes...
[17:07:10] [LoadBusinessSales] Loading data from database...
[17:07:10] [LoadPaintballArenas] Loading Paintball Arenas from the database, please wait...
[17:07:10] [LoadEventPoints] 0 event points loaded.
[17:07:10] [LoadGates] Loading data from database...
[17:07:10] [Dynamic Points] Loading Dynamic Points from the database, please wait...
[17:07:10] [Turf Wars] Loading turfs from the database, please wait...
[17:07:10] [LoadPlants] Loading data from database...
[17:07:10] [LoadElevatorStuff] 20 floors loaded.
[17:07:10] [LoadHelp] Loading data from database...
[17:07:10] [MiscLoad] Misc Loaded
[17:07:10] Resetting news...
[17:07:10] Resetting default server variables..
[17:07:10] Adjusted the server time...
[17:07:10] [LoadParkingMeters] Loading data from database...
[17:07:10] [Streamer] ATM Points Loaded
[17:07:10] [Streamer] Bank System Loaded
[17:07:10] [Pay Phones] Loading pay phones from database...
[17:07:10] [Textdraws] Loading Textdraws...
[17:07:10] [Textdraws] Loaded textdraws.
[17:07:10] [Dynamic Groups] Loading Dynamic Groups...
[17:07:10] [Dynamic Groups] Loading Dynamic Groups Vehicles...
[17:07:10] [Dynamic Crate Boxes] Loading Dynamic Crate Boxes from the database, please wait...
[17:07:10] [Dynamic Crate Facility] Loading Dynamic Crate Facilities from the database, please wait...
[17:07:10] [LoadDynamicCrateVehicles] Loading data from database...
[17:07:10] [Dynamic Jobs Names] Loading Dynamic Job names from the database, please wait...
[17:07:10] [Dynamic Jobs] Loading Dynamic Jobs from the database, please wait...
[17:07:10] 
-------------------------------------------
[17:07:10] Next Generation Roleplay

[17:07:10] Copyright © Next Generation Gaming, LLC (2010-2014)
[17:07:10] All Rights Reserved
[17:07:10] -------------------------------------------

[17:07:10] Successfully initiated the gamemode...
[17:07:10] Number of vehicle models: 33
[17:07:10] [Dynamic Giftbox] Successfully loaded the dynamic giftbox.
[17:07:10] [LoadHouses] Failed to load any houses.
[17:07:10] [LoadDynamicDoors] Failed to load any doors.
[17:07:10] [LoadDynamicMapIcons] Failed to load any map icons.
[17:07:10] [LoadMailboxes] Failed to load any mailboxes.
[17:07:10] [LoadBusinesses] Failed to load any businesses.
[17:07:10] [SpeedCameras] No Speed Cameras loaded.
[17:07:10] [LoadRelayForLifeTeams] Failed to load any teams.
[17:07:10] [LoadGarages] Failed to load any garages.
[17:07:10] [LoadCrimes] Crime Data Loaded.
[17:07:10] [LOADSALEDATA] Inserted new row into `sales`
[17:07:11] [LoadPaintBallArenas] No Paintball Arenas have been loaded.
[17:07:11] [Dynamic Points] 20 dynamic points has been loaded.
[17:07:11] [LoadTurfWars] Failed to load any turfs.
[17:07:11] [LoadPlants] Error: Failed to load any plants!
[17:07:11] [LoadHelp] 2 help entries rehashed/loaded.
[17:07:11] [Parking Meters] No parking meters loaded.
[17:07:11] [Gov Weapon Prices] Loaded 47 Weapons
[17:07:11] [Metal Detectors] Successfully loaded 4 metal detectors
[17:07:11] [MySQL] Query Error - (ErrorID: 1146)
[17:07:11] [MySQL] Check mysql_log.txt to review the query that threw the error.
[17:07:11] Dumping query from 2018/2/1 (17:7:11)

Description: Table 'nrp.payphones' doesn't exist (index 0). Query:


[17:07:11] SELECT * FROM `payphones`
[17:07:11] [Dynamic Crate Boxes] There are no dynamic crate boxes to load.
[17:07:11] [Dynamic Crate Facility] 10 dynamic Crate Facilities have been loaded.
[17:07:11] [LoadDynamicCrateVehicles] No dynamic crate vehicles have been loaded.
[17:07:11] [Dynamic Job Names] 24 dynamic job names have been loaded.
[17:07:11] [Dynamic Job Points] No dynamic job points has been loaded.
[17:07:11] [Gang Tags] There are no gang tags in the database.
[17:07:11] [MySQL] Query Error - (ErrorID: 1146)
[17:07:11] [MySQL] Check mysql_log.txt to review the query that threw the error.
[17:07:11] Dumping query from 2018/2/1 (17:7:11)

Description: Table 'nrp.furniturecatalog' doesn't exist (index 0). Query:


[17:07:11] SELECT * FROM `furniturecatalog`
[17:07:11] TotalSold0: 0 | AmountMade0: 0
[17:07:11] TotalSold1: 0 | AmountMade1: 0
[17:07:11] TotalSold2: 0 | AmountMade2: 0
[17:07:11] TotalSold3: 0 | AmountMade3: 0
[17:07:11] TotalSold4: 0 | AmountMade4: 0
[17:07:11] TotalSold5: 0 | AmountMade5: 0
[17:07:11] TotalSold6: 0 | AmountMade6: 0
[17:07:11] TotalSold7: 0 | AmountMade7: 0
[17:07:11] TotalSold8: 0 | AmountMade8: 0
[17:07:11] TotalSold9: 0 | AmountMade9: 0
[17:07:11] TotalSold10: 0 | AmountMade10: 0
[17:07:11] TotalSold11: 0 | AmountMade11: 0
[17:07:11] TotalSold12: 0 | AmountMade12: 0
[17:07:11] TotalSold13: 0 | AmountMade13: 0
[17:07:11] TotalSold14: 0 | AmountMade14: 0
[17:07:11] TotalSold15: 0 | AmountMade15: 0
[17:07:11] TotalSold16: 0 | AmountMade16: 0
[17:07:11] TotalSold17: 0 | AmountMade17: 0
[17:07:11] TotalSold18: 0 | AmountMade18: 0
[17:07:11] TotalSold19: 0 | AmountMade19: 0
[17:07:11] TotalSold20: 0 | AmountMade20: 0
[17:07:11] TotalSold21: 0 | AmountMade21: 0
[17:07:11] TotalSold22: 0 | AmountMade22: 0
[17:07:11] TotalSold23: 0 | AmountMade23: 0
[17:07:11] TotalSold24: 0 | AmountMade24: 0
[17:07:11] TotalSold25: 0 | AmountMade25: 0
[17:07:11] TotalSold26: 0 | AmountMade26: 0
[17:07:11] TotalSold27: 0 | AmountMade27: 0
[17:07:11] TotalSold28: 0 | AmountMade28: 0
[17:07:11] TotalSold29: 0 | AmountMade29: 0
[17:07:11] TotalSold30: 0 | AmountMade30: 0
[17:07:11] TotalSold31: 0 | AmountMade31: 0
[17:07:11] TotalSold32: 0 | AmountMade32: 0
[17:07:11] TotalSold33: 0 | AmountMade33: 0
[17:07:11] TotalSold34: 0 | AmountMade34: 0
[17:07:11] TotalSold35: 0 | AmountMade35: 0
[17:07:11] TotalSold36: 0 | AmountMade36: 0
[17:07:11] TotalSold37: 0 | AmountMade37: 0
[17:07:11] TotalSold38: 0 | AmountMade38: 0
[17:07:11] TotalSold39: 0 | AmountMade39: 0
[17:07:11] TotalSold40: 0 | AmountMade40: 0
[17:07:11] TotalSold41: 0 | AmountMade41: 0
[17:07:11] TotalSold42: 0 | AmountMade42: 0
[17:07:11] TotalSold43: 0 | AmountMade43: 0
[17:07:11] TotalSoldMicro0: 0 | AmountMadeMicro0: 0
[17:07:11] TotalSoldMicro1: 0 | AmountMadeMicro1: 0
[17:07:11] TotalSoldMicro2: 0 | AmountMadeMicro2: 0
[17:07:11] TotalSoldMicro3: 0 | AmountMadeMicro3: 0
[17:07:11] TotalSoldMicro4: 0 | AmountMadeMicro4: 0
[17:07:11] TotalSoldMicro5: 0 | AmountMadeMicro5: 0
[17:07:11] TotalSoldMicro6: 0 | AmountMadeMicro6: 0
[17:07:11] TotalSoldMicro7: 0 | AmountMadeMicro7: 0
[17:07:11] TotalSoldMicro8: 0 | AmountMadeMicro8: 0
[17:07:11] TotalSoldMicro9: 0 | AmountMadeMicro9: 0
[17:07:11] TotalSoldMicro10: 0 | AmountMadeMicro10: 0
[17:07:11] TotalSoldMicro11: 0 | AmountMadeMicro11: 0
[17:07:11] TotalSoldMicro12: 0 | AmountMadeMicro12: 0
[17:07:11] TotalSoldMicro13: 0 | AmountMadeMicro13: 0
[17:07:11] TotalSoldMicro14: 0 | AmountMadeMicro14: 0
[17:07:11] TotalSoldMicro15: 0 | AmountMadeMicro15: 0
[17:07:11] TotalSoldMicro16: 0 | AmountMadeMicro16: 0
[17:07:11] TotalSoldMicro17: 0 | AmountMadeMicro17: 0
[17:07:11] TotalSoldMicro18: 0 | AmountMadeMicro18: 0
[17:07:11] TotalSoldMicro19: 0 | AmountMadeMicro19: 0
[17:16:00] [connection] 127.0.0.1:50057 requests connection cookie.
[17:16:01] [connection] incoming connection: 127.0.0.1:50057 id: 0
[17:16:01] [join] Blom_Mandi has joined the server (0:127.0.0.1)
[17:16:01] [PlayerName] Formatted Blom_Mandi to the correct RP-format standards.
[17:16:26] Blom Mandi has logged in.
[17:16:27] [MySQL] Query Error - (ErrorID: 1054)
[17:16:27] [MySQL] Check mysql_log.txt to review the query that threw the error.
[17:16:27] Dumping query from 2018/2/1 (17:16:27)

Description: Unknown column 'Subject' in 'field list' (index 0). Query:


[17:16:27] SELECT `id`, `Subject` FROM `bugs` WHERE `status` = 6 AND `Userid` = 1000519030
[17:21:31] [part] Blom_Mandi has left the server (0:1)
[17:21:31] [MySQL] Query Error - (ErrorID: 1054)
[17:21:31] [MySQL] Check mysql_log.txt to review the query that threw the error.
[17:21:31] Dumping query from 2018/2/1 (17:21:31)

Description: Unknown column 'DrugSmuggler' in 'field list' (index 0). Query:


[17:21:31] UPDATE `accounts` SET `IP`='127.0.0.1',`Registered`=1,`ConnectedTime`=0,`Sex`=2,`BirthDate`='1926-04-09',`Band`=0,`PermBand`=0,`Warnings`=0,`Disabled`=0,`Level`=1,`AdminLevel`=0,`SeniorModerator`=0,`Helper`=0,`DonateRank`=0,`Respect`=0,`Money`=50000,`Bank`=20000,`pHealth`='100.00',`pArmor`='0.00',`pSHealth`='0.00',`Int`=0,`VirtualWorld`=0,`Model`=91,`BanAppealer`=0,`PR`=0,`HR`=0,`AP`=0,`Security`=0,`ShopTech`=0,`FactionModerator`=0,`GangModerator`=0,`Undercover`=0,`TogReports`=0,`Radio`=0,`RadioFreq`=0,`UpgradePoints`=0,`Origin`=0,`Muted`=0,`Crimes`=0,`Accent`=14,`CHits`=0,`FHits`=0,`Arrested`=0,`Phonebook`=0,`LottoNr`=0,`Fishes`=0,`BiggestFish`=0,`Job`=0,`Job2`=0,`Job3`=0,`Paycheck`=281,`HeadValue`=0,`JailTime`=0,`WRestricted`=0,`Materials`=0,`Crates`=0,`Nation`=0,`Leader`=-1,`Member`=-1,`Division`=-1,`Badge`='None',`Rank`=255,`DetSkill`=0,`SexSkill`=0,`BoxSkill`=0,`LawSkill`=0,`MechSkill`=0,`TruckSkill`=0,`DrugSmuggler`=0,`ArmsSkill`=0,`FishSkill`=0,`CheckCash`=0,`Checks`=0,`BoatLic`=0,`FlyLic`=0,`GunLic`=
[17:21:31] 0,`FishLic`=1,`FishSkill`=0,`FightingStyle`=0,`PhoneNr`=0,`Apartment`=-1,`Apartment2`=-1,`Apartment3`=-1,`Renting`=-1,`CarLic`=0,`DrugsTime`=0,`LawyerTime`=0,`LawyerFreeTime`=0,`MechTime`=0,`SexTime`=0,`PayDay`=281,`PayDayHad`=0,`CDPlayer`=0,`Dice`=0,`Spraycan`=0,`Rope`=0,`Rags`=0,`Cigars`=0,`Sprunk`=0,`Bombs`=0,`Wins`=0,`Loses`=0,`Tutorial`=-1,`OnDuty`=0,`Hospital`=0,`MarriedID`=-1,`ContractBy`='',`ContractDetail`='',`WantedLevel`=0,`Insurance`=0,`911Muted`=0,`NewMuted`=0,`NewMutedTotal`=0,`AdMuted`=0,`AdMutedTotal`=0,`HelpMute`=0,`ReportMuted`=0,`ReportMutedTotal`=0,`ReportMutedTime`=0,`DMRMuted`=0,`VIPMuted`=0,`VIPMutedTime`=0,`GiftTime`=0,`AdvisorDutyHours`=0,`AcceptedHelp`=0,`AcceptReport`=0,`TrashReport`=0,`GangWarn`=0,`CSFBanned`=0,`VIPInviteDay`=0,`TempVIP`=0,`BuddyInvite`=0,`Tokens`=0,`PTokens`=0,`TriageTime`=0 WHERE `id`=1000519030
[17:21:31] [MySQL] Query Error - (ErrorID: 1054)
[17:21:31] [MySQL] Check mysql_log.txt to review the query that threw the error.
[17:21:31] Dumping query from 2018/2/1 (17:21:31)

Description: Unknown column 'Wallpaper' in 'field list' (index 0). Query:


[17:21:31] UPDATE `accounts` SET `PrisonedBy`='Nobody',`PrisonReason`='None',`TaxiLicense`=0,`TicketTime`=0,`Screwdriver`=0,`Smslog`=0,`Speedo`=0,`Wristwatch`=0,`Surveillance`=0,`Tire`=0,`Firstaid`=0,`Rccam`=0,`Receiver`=0,`GPS`=0,`Sweep`=0,`SweepLeft`=0,`Bugged`=-1,`pWExists`=0,`pWSeeds`=0,`Warrants`='',`JudgeJailTime`=0,`JudgeJailType`=0,`BeingSentenced`=0,`ProbationTime`=0,`DMKills`=0,`OrderConfirmed`=0,`FreezeHouse`=0,`FreezeCar`=0,`Firework`=0,`Boombox`=0,`Hydration`=100,`DoubleEXP`=0,`EXPToken`=0,`RacePlayerLaps`=0,`Ringtone`=0,`Wallpaper`=0,`Order`=0,`CallsAccepted`=0,`PatientsDelivered`=0,`LiveBanned`=0,`FreezeBank`=0,`VIPM`=0,`VIPMO`=0,`VIPExpire`=0,`GVip`=0,`Watchdog`=0,`VIPSold`=0,`GoldBoxTokens`=0,`DrawChance`=0,`RewardHours`='0.00',`CarsRestricted`=0,`LastCarWarning`=0,`CarWarns`=0,`Flagged`=0,`Paper`=0,`MailEnabled`=1,`Mailbox`=0,`Business`=-1,`BusinessRank`=-1,`TreasureSkill`=0,`MetalDetector`=0,`HelpedBefore`=0,`Trickortreat`=0,`LastCharmReceived`=0,`RHMutes`=0,`RHMuteTime`=0,`GiftCode`=0,`Table`=0,`Opi
[17:21:31] umSeeds`=0,`RawOpium`=0,`Syringe`=0,`Skins`=0,`Fitness`=0,`HealthCare`=0,`ReceivedCredits`=0,`RimMod`=0,`Tazer`=0,`Cuff`=0,`CarVoucher`=0,`ReferredBy`='Nobody',`PendingRefReward`=0,`Refers`=0,`Famed`=0,`FamedMuted`=0,`DefendTime`=0,`PVIPVoucher`=0,`VehicleSlot`=0,`ToySlot`=0,`RFLTeam`=-1,`RFLTeamL`=-1,`VehVoucher`=0,`SVIPVoucher`=0,`GVIPVoucher`=0,`GiftVoucher`=0,`FallIntoFun`=0,`HungerVoucher`=0,`BoughtCure`=0,`Vials`=0,`AdvertVoucher`=0,`ShopCounter`=0,`ShopNotice`=0,`SVIPExVoucher`=0,`GVIPExVoucher`=0,`VIPSellable`=0,`ReceivedPrize`=0,`VIPSpawn`=0,`FreeAdsDay`=0,`FreeAdsLeft`=0,`BuddyInvites`=0,`ReceivedBGift`=0,`pVIPJob`=1,`LastBirthday`=0,`AccountRestricted`=0,`Watchlist`=0,`WatchlistTime`=0,`Backpack`=0,`BEquipped`=0,`BStoredH`=-1,`BStoredV`=0,`PrisonCredits`=0,`PrisonMaterials`=0,`PrisonWineTime`=0,`PrisonCell`=0 WHERE `id`=1000519030
[17:21:31] [MySQL] Query Error - (ErrorID: 1054)
[17:21:31] [MySQL] Check mysql_log.txt to review the query that threw the error.
[17:21:31] Dumping query from 2018/2/1 (17:21:31)

Description: Unknown column 'PrisonSoap' in 'field list' (index 0). Query:


[17:21:31] UPDATE `accounts` SET `PrisonSoap`=0,`PrisonSugar`=0,`PrisonBread`=0,`PrisonShank`=0,`PrisonShankOut`=0,`ShankUsages`=0,`PrisonWine`=0,`PrisonMWine`=0,`PrisonChisel`=0,`PrisonCellChisel`=0,`FishingSkill`=0,`FishWeight`=0,`GarbageSkill`=0,`Pot`=0,`Crack`=0,`Meth`=0,`Ecstasy`=0,`Heroin`=0,`CopKit`=0,`Hitman`=-1,`HitmanLeader`=0,`HitmanBlacklisted`=0,`BlacklistReason`='',`BItem0`=0,`BItem1`=0,`BItem2`=0,`BItem3`=0,`BItem4`=0,`BItem5`=0,`BItem6`=0,`BItem7`=0,`BItem8`=0,`BItem9`=0,`BItem10`=0,`BItem11`=0,`BDrug0`=0,`BDrug1`=0,`BDrug2`=0,`BDrug3`=0,`BDrug4`=0,`Gun0`=0,`Gun1`=0,`Gun2`=0,`Gun3`=0,`Gun4`=0,`Gun5`=0,`Gun6`=0,`Gun7`=0,`Gun8`=0,`Gun9`=0,`Gun10`=0,`Gun11`=0,`BRTimeout`=0,`pDigCooldown`=0,`ToolBox`=0,`CrowBar`=0,`CarLockPickSkill`=0,`LockPickVehCount`=0,`LockPickTime`=0,`SEC`=0,`BM`=0,`ASM`=0,`Isolated`=0,`WantedJailTime`=0,`WantedJailFine`=0,`NextNameChange`=0,`pExamineDesc`='',`FavStation`='',`pDedicatedPlayer`=0,`pDedicatedEnabled`=0,`pDedicatedMuted`=0,`pDedicatedWarn`=0,`mInventory`='0|0|0|0|0|0|0|0|
[17:21:31] 0|0|0|0|0|0|0|0|0|0|0|0',`mPurchaseCounts`='0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0',`mCooldowns`='0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0',`mBoost`='0|0',`mShopNotice`='0|0',`zFuelCan`=0,`bTicket`=0,`JailedInfo`='0|0|0|0|0',`JailedWeapons`='0|0|0|0|0|0|0|0|0|0|0|0',`ChatTog0`=0,`ChatTog1`=0,`ChatTog2`=0,`ChatTog3`=0,`ChatTog4`=0,`ChatTog5`=0,`ChatTog6`=0,`ChatTog7`=0,`ChatTog8`=0,`ChatTog9`=0,`ChatTog10`=0,`ChatTog11`=0,`ChatTog12`=0,`ChatTog13`=0,`ChatTog14`=0,`ChatTog15`=0,`ChatTog16`=0,`ChatTog17`=0,`ChatTog18`=0,`ChatTog19`=0,`ChatTog20`=0,`ChatTog21`=0,`ChatTog22`=0,`ChatTog23`=0,`pVIPMod`=0,`pEventTokens`=0,`VIPGunsCount`=0,`pBailPrice`=0,`pLastPoll`=0,`PollKeyA`='Invalid Key',`PollKeyB`='Invalid Key',`PollKeyC`='Invalid Key',`FurnitureSlots`=0,`StaffBanned`=0,`DedicatedDaymarker`='',`DedicatedTimestamp`='',`DedicatedHours`=0 WHERE `id`=1000519030
[17:21:31] [MySQL] Query Error - (ErrorID: 1054)
[17:21:31] [MySQL] Check mysql_log.txt to review the query that threw the error.
[17:21:31] Dumping query from 2018/2/1 (17:21:31)

Description: Unknown column 'WalkStyle' in 'field list' (index 0). Query:


[17:21:31] UPDATE `accounts` SET `WalkStyle`=0,`FlagCredits`=0,`FlagClaimed`=0 WHERE id=1000519030
need db ssql
Reply

Quote:
Originally Posted by langit
Посмотреть сообщение
server work but i get
Код:
SA-MP Dedicated Server
----------------------
v0.3.7-R2, ©2005-2015 SA-MP Team

[17:07:03] 
[17:07:03] Server Plugins
[17:07:03] --------------
[17:07:03]  Loading plugin: crashdetect
[17:07:03]   CrashDetect v4.16 is OK.
[17:07:03]   Loaded.
[17:07:03]  Loading plugin: streamer
[17:07:03] 

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

[17:07:03]   Loaded.
[17:07:03]  Loading plugin: mysql
[17:07:03]  >> plugin.mysql: R41-2 successfully loaded.
[17:07:03]   Loaded.
[17:07:03]  Loading plugin: sscanf
[17:07:03] 

[17:07:03]  ===============================

[17:07:03]       sscanf plugin loaded.     

[17:07:03]          Version:  2.8.2        

[17:07:03]    © 2012 Alex "******" Cole  

[17:07:03]  ===============================

[17:07:03]   Loaded.
[17:07:03]  Loading plugin: whirlpool
[17:07:03]  
[17:07:03]  ==================
[17:07:03]  
[17:07:03]   Whirlpool loaded
[17:07:03]  
[17:07:03]  ==================
[17:07:03]  
[17:07:03]   Loaded.
[17:07:03]  Loading plugin: irc
[17:07:03] 

*** IRC Plugin v1.4.6 by Incognito loaded ***

[17:07:03]   Loaded.
[17:07:03]  Loading plugin: gvar
[17:07:03] 

*** GVar Plugin v1.3 by Incognito loaded ***

[17:07:03]   Loaded.
[17:07:03]  Loaded 7 plugins.

[17:07:03] 
[17:07:03] Ban list
[17:07:03] --------
[17:07:03]  Loaded: samp.ban
[17:07:03] 
[17:07:03] 
[17:07:03] Filterscripts
[17:07:03] ---------------
[17:07:03]   Loading filterscript 'FurnitureSystem.amx'...
[17:07:07]   Loading filterscript 'server.amx'...
[17:07:08]   Loaded 2 filterscripts.

[17:07:09]  
[17:07:09]  
[17:07:09]  
[17:07:09]  ======================================= 
[17:07:09]  |                                     | 
[17:07:09]  |        YSI version 3.09.0684        | 
[17:07:09]  |        By Alex "******" Cole        | 
[17:07:09]  |                                     | 
[17:07:09]  ======================================= 
[17:07:09]  
[17:07:09]  
[17:07:09]  
[17:07:10] [Streamer] Loading Dynamic Areas...
[17:07:10] [Streamer] Loading Dynamic Buttons...
[17:07:10] [Streamer] Dynamic Buttons has been loaded.
[17:07:10] [Streamer] Loading Dynamic Objects...
[17:07:10] [Streamer] Dynamic Objects has been loaded.
[17:07:10] [Streamer] Loading Dynamic Pickups...
[17:07:10] [Streamer] Dynamic Pickups have been loaded.
[17:07:10] [Streamer] Loading 3D Text Labels...
[17:07:10] [Streamer] Dynamic 3D Text Labels has been loaded.
[17:07:10] [Streamer] Loading Dynamic Static Vehicles...
[17:07:10] [Streamer] Dynamic Static Vehicles have been loaded.
[17:07:10] Preparing the gamemode, please wait...
[17:07:10] [MySQL] (Main Pipelines) Connecting to 127.0.0.1...
[17:07:10] [MySQL] (MainPipeline) Connection successful toward MySQL Database Server!
[17:07:10] [Dynamic Giftbox] Loading the Dynamic Giftbox...
[17:07:10] [LoadHouses] Loading data from database...
[17:07:10] [LoadDynamicDoors] Loading data from database...
[17:07:10] [LoadDynamicMapIcons] Loading data from database...
[17:07:10] [LoadMailboxes] Loading data from database...
[17:07:10] [LoadBusinesses] Loading data from database...
[17:07:10] [LoadAuctions] Loading data from database...
[17:07:10] [LoadTxtLabels] Loading data from database...
[17:07:10] [SpeedCameras] Loading data from database...
[17:07:10] [LoadPayNSprays] Loading data from database...
[17:07:10] [LoadArrestPoints] Loading data from database...
[17:07:10] [LoadImpoundPoints] Loading data from database...
[17:07:10] [LoadRelayForLifeTeams] Loading data from database...
[17:07:10] [LoadGarages] Loading data from database...
[17:07:10] [LoadCrimes] Loading Crimes...
[17:07:10] [LoadBusinessSales] Loading data from database...
[17:07:10] [LoadPaintballArenas] Loading Paintball Arenas from the database, please wait...
[17:07:10] [LoadEventPoints] 0 event points loaded.
[17:07:10] [LoadGates] Loading data from database...
[17:07:10] [Dynamic Points] Loading Dynamic Points from the database, please wait...
[17:07:10] [Turf Wars] Loading turfs from the database, please wait...
[17:07:10] [LoadPlants] Loading data from database...
[17:07:10] [LoadElevatorStuff] 20 floors loaded.
[17:07:10] [LoadHelp] Loading data from database...
[17:07:10] [MiscLoad] Misc Loaded
[17:07:10] Resetting news...
[17:07:10] Resetting default server variables..
[17:07:10] Adjusted the server time...
[17:07:10] [LoadParkingMeters] Loading data from database...
[17:07:10] [Streamer] ATM Points Loaded
[17:07:10] [Streamer] Bank System Loaded
[17:07:10] [Pay Phones] Loading pay phones from database...
[17:07:10] [Textdraws] Loading Textdraws...
[17:07:10] [Textdraws] Loaded textdraws.
[17:07:10] [Dynamic Groups] Loading Dynamic Groups...
[17:07:10] [Dynamic Groups] Loading Dynamic Groups Vehicles...
[17:07:10] [Dynamic Crate Boxes] Loading Dynamic Crate Boxes from the database, please wait...
[17:07:10] [Dynamic Crate Facility] Loading Dynamic Crate Facilities from the database, please wait...
[17:07:10] [LoadDynamicCrateVehicles] Loading data from database...
[17:07:10] [Dynamic Jobs Names] Loading Dynamic Job names from the database, please wait...
[17:07:10] [Dynamic Jobs] Loading Dynamic Jobs from the database, please wait...
[17:07:10] 
-------------------------------------------
[17:07:10] Next Generation Roleplay

[17:07:10] Copyright © Next Generation Gaming, LLC (2010-2014)
[17:07:10] All Rights Reserved
[17:07:10] -------------------------------------------

[17:07:10] Successfully initiated the gamemode...
[17:07:10] Number of vehicle models: 33
[17:07:10] [Dynamic Giftbox] Successfully loaded the dynamic giftbox.
[17:07:10] [LoadHouses] Failed to load any houses.
[17:07:10] [LoadDynamicDoors] Failed to load any doors.
[17:07:10] [LoadDynamicMapIcons] Failed to load any map icons.
[17:07:10] [LoadMailboxes] Failed to load any mailboxes.
[17:07:10] [LoadBusinesses] Failed to load any businesses.
[17:07:10] [SpeedCameras] No Speed Cameras loaded.
[17:07:10] [LoadRelayForLifeTeams] Failed to load any teams.
[17:07:10] [LoadGarages] Failed to load any garages.
[17:07:10] [LoadCrimes] Crime Data Loaded.
[17:07:10] [LOADSALEDATA] Inserted new row into `sales`
[17:07:11] [LoadPaintBallArenas] No Paintball Arenas have been loaded.
[17:07:11] [Dynamic Points] 20 dynamic points has been loaded.
[17:07:11] [LoadTurfWars] Failed to load any turfs.
[17:07:11] [LoadPlants] Error: Failed to load any plants!
[17:07:11] [LoadHelp] 2 help entries rehashed/loaded.
[17:07:11] [Parking Meters] No parking meters loaded.
[17:07:11] [Gov Weapon Prices] Loaded 47 Weapons
[17:07:11] [Metal Detectors] Successfully loaded 4 metal detectors
[17:07:11] [MySQL] Query Error - (ErrorID: 1146)
[17:07:11] [MySQL] Check mysql_log.txt to review the query that threw the error.
[17:07:11] Dumping query from 2018/2/1 (17:7:11)

Description: Table 'nrp.payphones' doesn't exist (index 0). Query:


[17:07:11] SELECT * FROM `payphones`
[17:07:11] [Dynamic Crate Boxes] There are no dynamic crate boxes to load.
[17:07:11] [Dynamic Crate Facility] 10 dynamic Crate Facilities have been loaded.
[17:07:11] [LoadDynamicCrateVehicles] No dynamic crate vehicles have been loaded.
[17:07:11] [Dynamic Job Names] 24 dynamic job names have been loaded.
[17:07:11] [Dynamic Job Points] No dynamic job points has been loaded.
[17:07:11] [Gang Tags] There are no gang tags in the database.
[17:07:11] [MySQL] Query Error - (ErrorID: 1146)
[17:07:11] [MySQL] Check mysql_log.txt to review the query that threw the error.
[17:07:11] Dumping query from 2018/2/1 (17:7:11)

Description: Table 'nrp.furniturecatalog' doesn't exist (index 0). Query:


[17:07:11] SELECT * FROM `furniturecatalog`
[17:07:11] TotalSold0: 0 | AmountMade0: 0
[17:07:11] TotalSold1: 0 | AmountMade1: 0
[17:07:11] TotalSold2: 0 | AmountMade2: 0
[17:07:11] TotalSold3: 0 | AmountMade3: 0
[17:07:11] TotalSold4: 0 | AmountMade4: 0
[17:07:11] TotalSold5: 0 | AmountMade5: 0
[17:07:11] TotalSold6: 0 | AmountMade6: 0
[17:07:11] TotalSold7: 0 | AmountMade7: 0
[17:07:11] TotalSold8: 0 | AmountMade8: 0
[17:07:11] TotalSold9: 0 | AmountMade9: 0
[17:07:11] TotalSold10: 0 | AmountMade10: 0
[17:07:11] TotalSold11: 0 | AmountMade11: 0
[17:07:11] TotalSold12: 0 | AmountMade12: 0
[17:07:11] TotalSold13: 0 | AmountMade13: 0
[17:07:11] TotalSold14: 0 | AmountMade14: 0
[17:07:11] TotalSold15: 0 | AmountMade15: 0
[17:07:11] TotalSold16: 0 | AmountMade16: 0
[17:07:11] TotalSold17: 0 | AmountMade17: 0
[17:07:11] TotalSold18: 0 | AmountMade18: 0
[17:07:11] TotalSold19: 0 | AmountMade19: 0
[17:07:11] TotalSold20: 0 | AmountMade20: 0
[17:07:11] TotalSold21: 0 | AmountMade21: 0
[17:07:11] TotalSold22: 0 | AmountMade22: 0
[17:07:11] TotalSold23: 0 | AmountMade23: 0
[17:07:11] TotalSold24: 0 | AmountMade24: 0
[17:07:11] TotalSold25: 0 | AmountMade25: 0
[17:07:11] TotalSold26: 0 | AmountMade26: 0
[17:07:11] TotalSold27: 0 | AmountMade27: 0
[17:07:11] TotalSold28: 0 | AmountMade28: 0
[17:07:11] TotalSold29: 0 | AmountMade29: 0
[17:07:11] TotalSold30: 0 | AmountMade30: 0
[17:07:11] TotalSold31: 0 | AmountMade31: 0
[17:07:11] TotalSold32: 0 | AmountMade32: 0
[17:07:11] TotalSold33: 0 | AmountMade33: 0
[17:07:11] TotalSold34: 0 | AmountMade34: 0
[17:07:11] TotalSold35: 0 | AmountMade35: 0
[17:07:11] TotalSold36: 0 | AmountMade36: 0
[17:07:11] TotalSold37: 0 | AmountMade37: 0
[17:07:11] TotalSold38: 0 | AmountMade38: 0
[17:07:11] TotalSold39: 0 | AmountMade39: 0
[17:07:11] TotalSold40: 0 | AmountMade40: 0
[17:07:11] TotalSold41: 0 | AmountMade41: 0
[17:07:11] TotalSold42: 0 | AmountMade42: 0
[17:07:11] TotalSold43: 0 | AmountMade43: 0
[17:07:11] TotalSoldMicro0: 0 | AmountMadeMicro0: 0
[17:07:11] TotalSoldMicro1: 0 | AmountMadeMicro1: 0
[17:07:11] TotalSoldMicro2: 0 | AmountMadeMicro2: 0
[17:07:11] TotalSoldMicro3: 0 | AmountMadeMicro3: 0
[17:07:11] TotalSoldMicro4: 0 | AmountMadeMicro4: 0
[17:07:11] TotalSoldMicro5: 0 | AmountMadeMicro5: 0
[17:07:11] TotalSoldMicro6: 0 | AmountMadeMicro6: 0
[17:07:11] TotalSoldMicro7: 0 | AmountMadeMicro7: 0
[17:07:11] TotalSoldMicro8: 0 | AmountMadeMicro8: 0
[17:07:11] TotalSoldMicro9: 0 | AmountMadeMicro9: 0
[17:07:11] TotalSoldMicro10: 0 | AmountMadeMicro10: 0
[17:07:11] TotalSoldMicro11: 0 | AmountMadeMicro11: 0
[17:07:11] TotalSoldMicro12: 0 | AmountMadeMicro12: 0
[17:07:11] TotalSoldMicro13: 0 | AmountMadeMicro13: 0
[17:07:11] TotalSoldMicro14: 0 | AmountMadeMicro14: 0
[17:07:11] TotalSoldMicro15: 0 | AmountMadeMicro15: 0
[17:07:11] TotalSoldMicro16: 0 | AmountMadeMicro16: 0
[17:07:11] TotalSoldMicro17: 0 | AmountMadeMicro17: 0
[17:07:11] TotalSoldMicro18: 0 | AmountMadeMicro18: 0
[17:07:11] TotalSoldMicro19: 0 | AmountMadeMicro19: 0
[17:16:00] [connection] 127.0.0.1:50057 requests connection cookie.
[17:16:01] [connection] incoming connection: 127.0.0.1:50057 id: 0
[17:16:01] [join] Blom_Mandi has joined the server (0:127.0.0.1)
[17:16:01] [PlayerName] Formatted Blom_Mandi to the correct RP-format standards.
[17:16:26] Blom Mandi has logged in.
[17:16:27] [MySQL] Query Error - (ErrorID: 1054)
[17:16:27] [MySQL] Check mysql_log.txt to review the query that threw the error.
[17:16:27] Dumping query from 2018/2/1 (17:16:27)

Description: Unknown column 'Subject' in 'field list' (index 0). Query:


[17:16:27] SELECT `id`, `Subject` FROM `bugs` WHERE `status` = 6 AND `Userid` = 1000519030
[17:21:31] [part] Blom_Mandi has left the server (0:1)
[17:21:31] [MySQL] Query Error - (ErrorID: 1054)
[17:21:31] [MySQL] Check mysql_log.txt to review the query that threw the error.
[17:21:31] Dumping query from 2018/2/1 (17:21:31)

Description: Unknown column 'DrugSmuggler' in 'field list' (index 0). Query:


[17:21:31] UPDATE `accounts` SET `IP`='127.0.0.1',`Registered`=1,`ConnectedTime`=0,`Sex`=2,`BirthDate`='1926-04-09',`Band`=0,`PermBand`=0,`Warnings`=0,`Disabled`=0,`Level`=1,`AdminLevel`=0,`SeniorModerator`=0,`Helper`=0,`DonateRank`=0,`Respect`=0,`Money`=50000,`Bank`=20000,`pHealth`='100.00',`pArmor`='0.00',`pSHealth`='0.00',`Int`=0,`VirtualWorld`=0,`Model`=91,`BanAppealer`=0,`PR`=0,`HR`=0,`AP`=0,`Security`=0,`ShopTech`=0,`FactionModerator`=0,`GangModerator`=0,`Undercover`=0,`TogReports`=0,`Radio`=0,`RadioFreq`=0,`UpgradePoints`=0,`Origin`=0,`Muted`=0,`Crimes`=0,`Accent`=14,`CHits`=0,`FHits`=0,`Arrested`=0,`Phonebook`=0,`LottoNr`=0,`Fishes`=0,`BiggestFish`=0,`Job`=0,`Job2`=0,`Job3`=0,`Paycheck`=281,`HeadValue`=0,`JailTime`=0,`WRestricted`=0,`Materials`=0,`Crates`=0,`Nation`=0,`Leader`=-1,`Member`=-1,`Division`=-1,`Badge`='None',`Rank`=255,`DetSkill`=0,`SexSkill`=0,`BoxSkill`=0,`LawSkill`=0,`MechSkill`=0,`TruckSkill`=0,`DrugSmuggler`=0,`ArmsSkill`=0,`FishSkill`=0,`CheckCash`=0,`Checks`=0,`BoatLic`=0,`FlyLic`=0,`GunLic`=
[17:21:31] 0,`FishLic`=1,`FishSkill`=0,`FightingStyle`=0,`PhoneNr`=0,`Apartment`=-1,`Apartment2`=-1,`Apartment3`=-1,`Renting`=-1,`CarLic`=0,`DrugsTime`=0,`LawyerTime`=0,`LawyerFreeTime`=0,`MechTime`=0,`SexTime`=0,`PayDay`=281,`PayDayHad`=0,`CDPlayer`=0,`Dice`=0,`Spraycan`=0,`Rope`=0,`Rags`=0,`Cigars`=0,`Sprunk`=0,`Bombs`=0,`Wins`=0,`Loses`=0,`Tutorial`=-1,`OnDuty`=0,`Hospital`=0,`MarriedID`=-1,`ContractBy`='',`ContractDetail`='',`WantedLevel`=0,`Insurance`=0,`911Muted`=0,`NewMuted`=0,`NewMutedTotal`=0,`AdMuted`=0,`AdMutedTotal`=0,`HelpMute`=0,`ReportMuted`=0,`ReportMutedTotal`=0,`ReportMutedTime`=0,`DMRMuted`=0,`VIPMuted`=0,`VIPMutedTime`=0,`GiftTime`=0,`AdvisorDutyHours`=0,`AcceptedHelp`=0,`AcceptReport`=0,`TrashReport`=0,`GangWarn`=0,`CSFBanned`=0,`VIPInviteDay`=0,`TempVIP`=0,`BuddyInvite`=0,`Tokens`=0,`PTokens`=0,`TriageTime`=0 WHERE `id`=1000519030
[17:21:31] [MySQL] Query Error - (ErrorID: 1054)
[17:21:31] [MySQL] Check mysql_log.txt to review the query that threw the error.
[17:21:31] Dumping query from 2018/2/1 (17:21:31)

Description: Unknown column 'Wallpaper' in 'field list' (index 0). Query:


[17:21:31] UPDATE `accounts` SET `PrisonedBy`='Nobody',`PrisonReason`='None',`TaxiLicense`=0,`TicketTime`=0,`Screwdriver`=0,`Smslog`=0,`Speedo`=0,`Wristwatch`=0,`Surveillance`=0,`Tire`=0,`Firstaid`=0,`Rccam`=0,`Receiver`=0,`GPS`=0,`Sweep`=0,`SweepLeft`=0,`Bugged`=-1,`pWExists`=0,`pWSeeds`=0,`Warrants`='',`JudgeJailTime`=0,`JudgeJailType`=0,`BeingSentenced`=0,`ProbationTime`=0,`DMKills`=0,`OrderConfirmed`=0,`FreezeHouse`=0,`FreezeCar`=0,`Firework`=0,`Boombox`=0,`Hydration`=100,`DoubleEXP`=0,`EXPToken`=0,`RacePlayerLaps`=0,`Ringtone`=0,`Wallpaper`=0,`Order`=0,`CallsAccepted`=0,`PatientsDelivered`=0,`LiveBanned`=0,`FreezeBank`=0,`VIPM`=0,`VIPMO`=0,`VIPExpire`=0,`GVip`=0,`Watchdog`=0,`VIPSold`=0,`GoldBoxTokens`=0,`DrawChance`=0,`RewardHours`='0.00',`CarsRestricted`=0,`LastCarWarning`=0,`CarWarns`=0,`Flagged`=0,`Paper`=0,`MailEnabled`=1,`Mailbox`=0,`Business`=-1,`BusinessRank`=-1,`TreasureSkill`=0,`MetalDetector`=0,`HelpedBefore`=0,`Trickortreat`=0,`LastCharmReceived`=0,`RHMutes`=0,`RHMuteTime`=0,`GiftCode`=0,`Table`=0,`Opi
[17:21:31] umSeeds`=0,`RawOpium`=0,`Syringe`=0,`Skins`=0,`Fitness`=0,`HealthCare`=0,`ReceivedCredits`=0,`RimMod`=0,`Tazer`=0,`Cuff`=0,`CarVoucher`=0,`ReferredBy`='Nobody',`PendingRefReward`=0,`Refers`=0,`Famed`=0,`FamedMuted`=0,`DefendTime`=0,`PVIPVoucher`=0,`VehicleSlot`=0,`ToySlot`=0,`RFLTeam`=-1,`RFLTeamL`=-1,`VehVoucher`=0,`SVIPVoucher`=0,`GVIPVoucher`=0,`GiftVoucher`=0,`FallIntoFun`=0,`HungerVoucher`=0,`BoughtCure`=0,`Vials`=0,`AdvertVoucher`=0,`ShopCounter`=0,`ShopNotice`=0,`SVIPExVoucher`=0,`GVIPExVoucher`=0,`VIPSellable`=0,`ReceivedPrize`=0,`VIPSpawn`=0,`FreeAdsDay`=0,`FreeAdsLeft`=0,`BuddyInvites`=0,`ReceivedBGift`=0,`pVIPJob`=1,`LastBirthday`=0,`AccountRestricted`=0,`Watchlist`=0,`WatchlistTime`=0,`Backpack`=0,`BEquipped`=0,`BStoredH`=-1,`BStoredV`=0,`PrisonCredits`=0,`PrisonMaterials`=0,`PrisonWineTime`=0,`PrisonCell`=0 WHERE `id`=1000519030
[17:21:31] [MySQL] Query Error - (ErrorID: 1054)
[17:21:31] [MySQL] Check mysql_log.txt to review the query that threw the error.
[17:21:31] Dumping query from 2018/2/1 (17:21:31)

Description: Unknown column 'PrisonSoap' in 'field list' (index 0). Query:


[17:21:31] UPDATE `accounts` SET `PrisonSoap`=0,`PrisonSugar`=0,`PrisonBread`=0,`PrisonShank`=0,`PrisonShankOut`=0,`ShankUsages`=0,`PrisonWine`=0,`PrisonMWine`=0,`PrisonChisel`=0,`PrisonCellChisel`=0,`FishingSkill`=0,`FishWeight`=0,`GarbageSkill`=0,`Pot`=0,`Crack`=0,`Meth`=0,`Ecstasy`=0,`Heroin`=0,`CopKit`=0,`Hitman`=-1,`HitmanLeader`=0,`HitmanBlacklisted`=0,`BlacklistReason`='',`BItem0`=0,`BItem1`=0,`BItem2`=0,`BItem3`=0,`BItem4`=0,`BItem5`=0,`BItem6`=0,`BItem7`=0,`BItem8`=0,`BItem9`=0,`BItem10`=0,`BItem11`=0,`BDrug0`=0,`BDrug1`=0,`BDrug2`=0,`BDrug3`=0,`BDrug4`=0,`Gun0`=0,`Gun1`=0,`Gun2`=0,`Gun3`=0,`Gun4`=0,`Gun5`=0,`Gun6`=0,`Gun7`=0,`Gun8`=0,`Gun9`=0,`Gun10`=0,`Gun11`=0,`BRTimeout`=0,`pDigCooldown`=0,`ToolBox`=0,`CrowBar`=0,`CarLockPickSkill`=0,`LockPickVehCount`=0,`LockPickTime`=0,`SEC`=0,`BM`=0,`ASM`=0,`Isolated`=0,`WantedJailTime`=0,`WantedJailFine`=0,`NextNameChange`=0,`pExamineDesc`='',`FavStation`='',`pDedicatedPlayer`=0,`pDedicatedEnabled`=0,`pDedicatedMuted`=0,`pDedicatedWarn`=0,`mInventory`='0|0|0|0|0|0|0|0|
[17:21:31] 0|0|0|0|0|0|0|0|0|0|0|0',`mPurchaseCounts`='0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0',`mCooldowns`='0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0',`mBoost`='0|0',`mShopNotice`='0|0',`zFuelCan`=0,`bTicket`=0,`JailedInfo`='0|0|0|0|0',`JailedWeapons`='0|0|0|0|0|0|0|0|0|0|0|0',`ChatTog0`=0,`ChatTog1`=0,`ChatTog2`=0,`ChatTog3`=0,`ChatTog4`=0,`ChatTog5`=0,`ChatTog6`=0,`ChatTog7`=0,`ChatTog8`=0,`ChatTog9`=0,`ChatTog10`=0,`ChatTog11`=0,`ChatTog12`=0,`ChatTog13`=0,`ChatTog14`=0,`ChatTog15`=0,`ChatTog16`=0,`ChatTog17`=0,`ChatTog18`=0,`ChatTog19`=0,`ChatTog20`=0,`ChatTog21`=0,`ChatTog22`=0,`ChatTog23`=0,`pVIPMod`=0,`pEventTokens`=0,`VIPGunsCount`=0,`pBailPrice`=0,`pLastPoll`=0,`PollKeyA`='Invalid Key',`PollKeyB`='Invalid Key',`PollKeyC`='Invalid Key',`FurnitureSlots`=0,`StaffBanned`=0,`DedicatedDaymarker`='',`DedicatedTimestamp`='',`DedicatedHours`=0 WHERE `id`=1000519030
[17:21:31] [MySQL] Query Error - (ErrorID: 1054)
[17:21:31] [MySQL] Check mysql_log.txt to review the query that threw the error.
[17:21:31] Dumping query from 2018/2/1 (17:21:31)

Description: Unknown column 'WalkStyle' in 'field list' (index 0). Query:


[17:21:31] UPDATE `accounts` SET `WalkStyle`=0,`FlagCredits`=0,`FlagClaimed`=0 WHERE id=1000519030
need db ssql
import the database files to your database
Reply

i have already done. total 247 table
Reply

Quote:
Originally Posted by langit
Посмотреть сообщение
i have already done. total 247 table
Obviously either you've imported them incorrectly, or you've missed some. The logs state quite clearly that there are missing tables.
Reply

This released gamemode is obviously filled with bugs from mysql to scriptings. Don't give us crap.
Reply

Quote:
Originally Posted by JulianWilliams
Посмотреть сообщение
This released gamemode is obviously filled with bugs from mysql to scriptings. Don't give us crap.
Amen to that my brother, missing alot of tables too.
Reply

My cousin was an Administrator/Head Administrator in ngg before.
he's called Sonny_Smith or something like this i don't remember, btw, he stopped playing samp but i'll tell him about this and the death of NGG
Reply

Quote:
Originally Posted by JulianWilliams
Посмотреть сообщение
This released gamemode is obviously filled with bugs from mysql to scriptings. Don't give us crap.
Considering what I said is fact, that those tables that the person is missing, are actually in the SQL files, there's quite possibly a problem with the person who is importing it.

People who don't know what they are doing, generally don't stop and think, instead post on the forums and try every single thing that's EASY to fix it, and then don't have 'time' to do what's recommended...


Just look at the responses... When people are told to start over, no-one ever does. Best thing in MANY instances is to clear it all out and START OVER.
Reply

Screenshots?! :/
Reply

I get this error https://i.hizliresim.com/0EDaqo.jpg
Reply

Quote:
Originally Posted by lostmode
Посмотреть сообщение
You need to install OpenSSL. A simple ****** of that error gave that answer.
Reply

Quote:
Originally Posted by Sew_Sumi
Посмотреть сообщение
You need to install OpenSSL. A simple ****** of that error gave that answer.
where can i install this
Reply

https://www.openssl.org/
Reply

Quote:
Originally Posted by Sew_Sumi
Посмотреть сообщение
ı'm not usinh linux
Reply

Noice Release, I downloaded and tried and what? I got hell problems xDDD, The worst script ever, nvm fam.
Reply

Quote:
Originally Posted by lostmode
Посмотреть сообщение
ı'm not usinh linux
If you looked through the site, you'll find windows versions... Read more.
Reply

Why the fuck is this script hella bugged, hella more then SARP's v3.3 script version OMG lmao
Reply

If people are getting it working, then obviously you've got a problem with your skills.
Reply


Forum Jump:


Users browsing this thread: 3 Guest(s)