SA-MP Forums

Go Back   SA-MP Forums > SA-MP Scripting and Plugins > Gamemode Scripts

Reply
 
Thread Tools Display Modes
Old 01/02/2018, 02:30 AM   #131
langit
Big Clucker
 
Join Date: Dec 2015
Posts: 51
Reputation: 0
Default Re: Next Generation Roleplay

after config mysql. same
Code:
v0.3.7-R2, (C)2005-2015 SA-MP Team

[09:44:01] 
[09:44:01] Server Plugins
[09:44:01] --------------
[09:44:01]  Loading plugin: crashdetect
[09:44:01]   CrashDetect v4.16 is OK.
[09:44:01]   Loaded.
[09:44:01]  Loading plugin: streamer
[09:44:01] 

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

[09:44:01]   Loaded.
[09:44:01]  Loading plugin: mysql
[09:44:01]  >> plugin.mysql: R41-3 successfully loaded.
[09:44:01]   Loaded.
[09:44:01]  Loading plugin: sscanf
[09:44:01] 

[09:44:01]  ===============================

[09:44:01]       sscanf plugin loaded.     

[09:44:01]          Version:  2.8.2        

[09:44:01]    (c) 2012 Alex "Y_Less" Cole  

[09:44:01]  ===============================

[09:44:01]   Loaded.
[09:44:01]  Loading plugin: whirlpool
[09:44:01]  
[09:44:01]  ==================
[09:44:01]  
[09:44:01]   Whirlpool loaded
[09:44:01]  
[09:44:01]  ==================
[09:44:01]  
[09:44:01]   Loaded.
[09:44:01]  Loading plugin: irc
[09:44:01] 

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

[09:44:01]   Loaded.
[09:44:01]  Loading plugin: gvar
[09:44:01] 

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

[09:44:01]   Loaded.
[09:44:01]  Loaded 7 plugins.

[09:44:01] 
[09:44:01] Filterscripts
[09:44:01] ---------------
[09:44:01]   Loading filterscript 'FurnitureSystem.amx'...
[09:44:12]   Loading filterscript 'server.amx'...
[09:44:13]   Loaded 2 filterscripts.

[09:44:15]  
[09:44:15]  
[09:44:15]  
[09:44:15]  ======================================= 
[09:44:15]  |                                     | 
[09:44:15]  |        YSI version 3.09.0684        | 
[09:44:15]  |        By Alex "Y_Less" Cole        | 
[09:44:15]  |                                     | 
[09:44:15]  ======================================= 
[09:44:15]  
[09:44:15]  
[09:44:15]  
[09:44:15] [Streamer] Loading Dynamic Areas...
[09:44:15] [Streamer] Loading Dynamic Buttons...
[09:44:15] [Streamer] Dynamic Buttons has been loaded.
[09:44:15] [Streamer] Loading Dynamic Objects...
[09:44:15] [Streamer] Dynamic Objects has been loaded.
[09:44:15] [Streamer] Loading Dynamic Pickups...
[09:44:15] [Streamer] Dynamic Pickups have been loaded.
[09:44:15] [Streamer] Loading 3D Text Labels...
[09:44:15] [Streamer] Dynamic 3D Text Labels has been loaded.
[09:44:15] [Streamer] Loading Dynamic Static Vehicles...
[09:44:15] [Streamer] Dynamic Static Vehicles have been loaded.
[09:44:15] Preparing the gamemode, please wait...
[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
[09:44:20] [Dynamic Giftbox] Loading the Dynamic Giftbox...
[09:44:20] [LoadHouses] Loading data from database...
[09:44:20] [LoadDynamicDoors] Loading data from database...
[09:44:20] [LoadDynamicMapIcons] Loading data from database...
[09:44:20] [LoadMailboxes] Loading data from database...
[09:44:20] [LoadBusinesses] Loading data from database...
[09:44:20] [LoadAuctions] Loading data from database...
[09:44:20] [LoadTxtLabels] Loading data from database...
[09:44:20] [SpeedCameras] Loading data from database...
[09:44:20] [LoadPayNSprays] Loading data from database...
[09:44:20] [LoadArrestPoints] Loading data from database...
[09:44:20] [LoadImpoundPoints] Loading data from database...
[09:44:20] [LoadRelayForLifeTeams] Loading data from database...
[09:44:20] [LoadGarages] Loading data from database...
[09:44:20] [LoadCrimes] Loading Crimes...
[09:44:20] [LoadBusinessSales] Loading data from database...
[09:44:20] [LoadPaintballArenas] Loading Paintball Arenas from the database, please wait...
[09:44:20] [LoadEventPoints] 0 event points loaded.
[09:44:20] [LoadGates] Loading data from database...
[09:44:20] [Dynamic Points] Loading Dynamic Points from the database, please wait...
[09:44:20] [Turf Wars] Loading turfs from the database, please wait...
[09:44:20] [LoadPlants] Loading data from database...
[09:44:20] [LoadElevatorStuff] 20 floors loaded.
[09:44:20] [LoadHelp] Loading data from database...
[09:44:20] [MiscLoad] Misc Loaded
[09:44:20] Resetting news...
[09:44:20] Resetting default server variables..
[09:44:20] Adjusted the server time...
[09:44:20] [LoadParkingMeters] Loading data from database...
[09:44:20] [Streamer] ATM Points Loaded
[09:44:20] [Streamer] Bank System Loaded
[09:44:20] [Pay Phones] Loading pay phones from database...
[09:44:20] [Textdraws] Loading Textdraws...
[09:44:20] [Textdraws] Loaded textdraws.
[09:44:20] [Dynamic Groups] Loading Dynamic Groups...
[09:44:20] [Dynamic Groups] Loading Dynamic Groups Vehicles...
[09:44:20] [Dynamic Crate Boxes] Loading Dynamic Crate Boxes from the database, please wait...
[09:44:20] [Dynamic Crate Facility] Loading Dynamic Crate Facilities from the database, please wait...
[09:44:20] [LoadDynamicCrateVehicles] Loading data from database...
[09:44:20] [Dynamic Jobs Names] Loading Dynamic Job names from the database, please wait...
[09:44:20] [Dynamic Jobs] Loading Dynamic Jobs from the database, please wait...
[09:44:20] 
-------------------------------------------
[09:44:20] Next Generation Roleplay

[09:44:20] Copyright (C) Next Generation Gaming, LLC (2010-2014)
[09:44:20] All Rights Reserved
[09:44:20] -------------------------------------------

[09:44:20] Successfully initiated the gamemode...
[09:44:20] Number of vehicle models: 33
[09:44:20] --- Server Shutting Down.
[09:44:20] Exiting the gamemode, please wait...
[09:44:20] 

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

[09:44:20] plugin.mysql: Unloading plugin...
[09:44:20] plugin.mysql: Plugin unloaded.
[09:44:20] 

[09:44:20]  ===============================

[09:44:20]      sscanf plugin unloaded.    

[09:44:20]  ===============================

[09:44:20]  
[09:44:20]  ====================
[09:44:20]  
[09:44:20]   Whirlpool unloaded
[09:44:20]  
[09:44:20]  ====================
[09:44:20]  
[09:44:21] 

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

[09:44:21] 

*** GVar Plugin v1.3 by Incognito unloaded ***
langit is offline   Reply With Quote
Old 01/02/2018, 04:04 AM   #132
Sew_Sumi
Godfather
 
Join Date: Jun 2008
Location: Azerbaijan
Posts: 5,994
Reputation: 494
Default Re: 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...
Sew_Sumi is offline   Reply With Quote
Old 01/02/2018, 08:30 AM   #133
Gforcez1337
High-roller
 
Gforcez1337's Avatar
 
Join Date: Jul 2010
Location: The Netherlands.
Posts: 1,063
Reputation: 362
Default Re: Next Generation Roleplay

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.
__________________

Gforcez1337 is offline   Reply With Quote
Old 01/02/2018, 09:33 AM   #134
langit
Big Clucker
 
Join Date: Dec 2015
Posts: 51
Reputation: 0
Default Re: Next Generation Roleplay

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...

server work but i get
Code:
SA-MP Dedicated Server
----------------------
v0.3.7-R2, (C)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]    (c) 2012 Alex "Y_Less" 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 "Y_Less" 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 (C) 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
langit is offline   Reply With Quote
Old 01/02/2018, 09:40 AM   #135
Gforcez1337
High-roller
 
Gforcez1337's Avatar
 
Join Date: Jul 2010
Location: The Netherlands.
Posts: 1,063
Reputation: 362
Default Re: Next Generation Roleplay

Quote:
Originally Posted by langit View Post
server work but i get
Code:
SA-MP Dedicated Server
----------------------
v0.3.7-R2, (C)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]    (c) 2012 Alex "Y_Less" 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 "Y_Less" 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 (C) 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
__________________

Gforcez1337 is offline   Reply With Quote
Old 01/02/2018, 10:11 AM   #136
langit
Big Clucker
 
Join Date: Dec 2015
Posts: 51
Reputation: 0
Default Re: Next Generation Roleplay

i have already done. total 247 table
langit is offline   Reply With Quote
Old 01/02/2018, 11:15 AM   #137
Sew_Sumi
Godfather
 
Join Date: Jun 2008
Location: Azerbaijan
Posts: 5,994
Reputation: 494
Default Re: Next Generation Roleplay

Quote:
Originally Posted by langit View Post
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.
Sew_Sumi is offline   Reply With Quote
Old 01/02/2018, 11:26 AM   #138
langit
Big Clucker
 
Join Date: Dec 2015
Posts: 51
Reputation: 0
Default Re: Next Generation Roleplay

Quote:
Originally Posted by Sew_Sumi View Post
Obviously either you've imported them incorrectly, or you've missed some. The logs state quite clearly that there are missing tables.

where are table furniturecatalog and payphones? I do not find it.
langit is offline   Reply With Quote
Old 01/02/2018, 12:46 PM   #139
Sew_Sumi
Godfather
 
Join Date: Jun 2008
Location: Azerbaijan
Posts: 5,994
Reputation: 494
Default Re: Next Generation Roleplay

Quote:
Originally Posted by langit View Post
where are table furniturecatalog and payphones? I do not find it.
Those aren't what's doing this... The error that's actually affecting you is when you're logging in it's causing a fail.
Sew_Sumi is offline   Reply With Quote
Old 01/02/2018, 12:58 PM   #140
langit
Big Clucker
 
Join Date: Dec 2015
Posts: 51
Reputation: 0
Default Re: Next Generation Roleplay

Quote:
Originally Posted by Sew_Sumi View Post
Those aren't what's doing this... The error that's actually affecting you is when you're logging in it's causing a fail.
I can register and login. no problem. I can play and saved accounts, just warning it. I tried to make table furniturecatalog. and it works. if anything is missing with this table please correct it

Code:
SET FOREIGN_KEY_CHECKS=0;

-- ----------------------------
-- Table structure for `furniturecatalog`
-- ----------------------------
DROP TABLE IF EXISTS `furniturecatalog`;
CREATE TABLE `furniturecatalog` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `houseid` int(11) NOT NULL DEFAULT '0',
  `slotid` int(11) NOT NULL DEFAULT '0',
  `modelid` int(11) NOT NULL DEFAULT '0',
  `X` float(10,5) NOT NULL DEFAULT '0.00000',
  `Y` float(10,5) NOT NULL DEFAULT '0.00000',
  `Z` float(10,5) NOT NULL DEFAULT '0.00000',
  `rX` float(10,5) NOT NULL DEFAULT '0.00000',
  `rY` float(10,5) NOT NULL DEFAULT '0.00000',
  `rZ` float(10,5) NOT NULL DEFAULT '0.00000',
  `Text1` varchar(128) NOT NULL DEFAULT '0',
  `Text2` varchar(128) NOT NULL DEFAULT '0',
  `Text3` varchar(128) NOT NULL DEFAULT '0',
  `Text4` varchar(128) NOT NULL DEFAULT '0',
  `col0` int(11) NOT NULL DEFAULT '0',
  `col1` int(11) NOT NULL DEFAULT '0',
  `col2` int(11) NOT NULL DEFAULT '0',
  `col3` int(11) NOT NULL DEFAULT '0',
  `col4` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=401 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of furniturecatalog
-- ----------------------------
langit is offline   Reply With Quote
Reply

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Could someone explain me how to make a dynamic dutymenu like on highrise roleplay and next generation roleplay. Unri Scripting Help 0 15/10/2013 02:50 PM


All times are GMT. The time now is 03:06 AM.


Powered by vBulletin® Version 3.8.6
Copyright ©2000 - 2018, Jelsoft Enterprises Ltd.