26.01.2018, 09:27
(
Последний раз редактировалось JulianWilliams; 26.01.2018 в 09:57.
)
Quote:
|
Originally Posted by jlalt
 Missing tables, there's .sql files in a folder called SQL Files you gotta execute them in your mysql database.
if you want them as one file: |
Update:
Even though I got a timeout message during the execution of SQL, running it was almost a success:
Код:
---------- Loaded log file: "server_log.txt". ---------- SA-MP Dedicated Server ---------------------- v0.3.7-R2, ©2005-2015 SA-MP Team [14:44:38] [14:44:38] Server Plugins [14:44:38] -------------- [14:44:38] Loading plugin: crashdetect.dll [14:44:38] CrashDetect v4.16 is OK. [14:44:38] Loaded. [14:44:38] Loading plugin: streamer.dll [14:44:38] *** Streamer Plugin v2.8.2 by Incognito loaded *** [14:44:38] Loaded. [14:44:38] Loading plugin: mysql.dll [14:44:38] >> plugin.mysql: R41-4 successfully loaded. [14:44:38] Loaded. [14:44:38] Loading plugin: sscanf.dll [14:44:38] [14:44:38] =============================== [14:44:38] sscanf plugin loaded. [14:44:38] Version: 2.8.2 [14:44:38] © 2012 Alex "******" Cole [14:44:38] =============================== [14:44:38] Loaded. [14:44:38] Loading plugin: Whirlpool.dll [14:44:38] [14:44:38] ================== [14:44:38] [14:44:38] Whirlpool loaded [14:44:38] [14:44:38] ================== [14:44:38] [14:44:38] Loaded. [14:44:38] Loading plugin: irc.dll [14:44:38] Failed. [14:44:38] Loading plugin: gvar.dll [14:44:38] *** GVar Plugin v1.3 by Incognito loaded *** [14:44:38] Loaded. [14:44:38] Loaded 6 plugins. [14:44:38] [14:44:38] Filterscripts [14:44:38] --------------- [14:44:38] Loading filterscript 'FurnitureSystem.amx'... [14:44:38] Loading filterscript 'Server.amx'... [14:44:38] Loaded 2 filterscripts. [14:44:38] [14:44:38] [14:44:38] [14:44:38] ======================================= [14:44:38] | | [14:44:38] | YSI version 3.09.0684 | [14:44:38] | By Alex "******" Cole | [14:44:38] | | [14:44:38] ======================================= [14:44:38] [14:44:38] [14:44:38] [14:44:38] [Streamer] Loading Dynamic Areas... [14:44:38] [Streamer] Loading Dynamic Buttons... [14:44:38] [Streamer] Dynamic Buttons has been loaded. [14:44:38] [Streamer] Loading Dynamic Objects... [14:44:38] [Streamer] Dynamic Objects has been loaded. [14:44:38] [Streamer] Loading Dynamic Pickups... [14:44:38] [Streamer] Dynamic Pickups have been loaded. [14:44:38] [Streamer] Loading 3D Text Labels... [14:44:38] [Streamer] Dynamic 3D Text Labels has been loaded. [14:44:38] [Streamer] Loading Dynamic Static Vehicles... [14:44:38] [Streamer] Dynamic Static Vehicles have been loaded. [14:44:38] Preparing the gamemode, please wait... [14:44:38] [MySQL] (Main Pipelines) Connecting to localhost... [14:44:38] [MySQL] (MainPipeline) Connection successful toward MySQL Database Server! [14:44:38] [Dynamic Giftbox] Loading the Dynamic Giftbox... [14:44:38] [LoadHouses] Loading data from database... [14:44:38] [LoadDynamicDoors] Loading data from database... [14:44:38] [LoadDynamicMapIcons] Loading data from database... [14:44:38] [LoadMailboxes] Loading data from database... [14:44:38] [LoadBusinesses] Loading data from database... [14:44:38] [LoadAuctions] Loading data from database... [14:44:38] [LoadTxtLabels] Loading data from database... [14:44:38] [SpeedCameras] Loading data from database... [14:44:38] [LoadPayNSprays] Loading data from database... [14:44:38] [LoadArrestPoints] Loading data from database... [14:44:38] [LoadImpoundPoints] Loading data from database... [14:44:38] [LoadRelayForLifeTeams] Loading data from database... [14:44:38] [LoadGarages] Loading data from database... [14:44:38] [LoadCrimes] Loading Crimes... [14:44:38] [LoadBusinessSales] Loading data from database... [14:44:38] [LoadPaintballArenas] Loading Paintball Arenas from the database, please wait... [14:44:38] [LoadGates] Loading data from database... [14:44:38] [Dynamic Points] Loading Dynamic Points from the database, please wait... [14:44:38] [Turf Wars] Loading turfs from the database, please wait... [14:44:38] [LoadPlants] Loading data from database... [14:44:38] [LoadHelp] Loading data from database... [14:44:38] [MiscLoad] Misc Loaded [14:44:38] Resetting news... [14:44:38] Resetting default server variables.. [14:44:38] Adjusted the server time... [14:44:38] [LoadParkingMeters] Loading data from database... [14:44:38] [Streamer] ATM Points Loaded [14:44:38] [Streamer] Bank System Loaded [14:44:38] [Pay Phones] Loading pay phones from database... [14:44:38] [Textdraws] Loading Textdraws... [14:44:38] [Textdraws] Loaded textdraws. [14:44:38] [Dynamic Groups] Loading Dynamic Groups... [14:44:38] [Dynamic Groups] Loading Dynamic Groups Vehicles... [14:44:38] [Dynamic Crate Boxes] Loading Dynamic Crate Boxes from the database, please wait... [14:44:38] [Dynamic Crate Facility] Loading Dynamic Crate Facilities from the database, please wait... [14:44:38] [LoadDynamicCrateVehicles] Loading data from database... [14:44:38] [Dynamic Jobs Names] Loading Dynamic Job names from the database, please wait... [14:44:38] [Dynamic Jobs] Loading Dynamic Jobs from the database, please wait... [14:44:38] ------------------------------------------- [14:44:38] Next Generation Roleplay [14:44:38] Copyright © Next Generation Gaming, LLC (2010-2014) [14:44:38] All Rights Reserved [14:44:38] ------------------------------------------- [14:44:38] Successfully initiated the gamemode... [14:44:38] Number of vehicle models: 33 [14:44:38] [Dynamic Giftbox] Successfully loaded the dynamic giftbox. [14:44:38] [LoadHouses] Failed to load any houses. [14:44:38] [LoadDynamicDoors] Failed to load any doors. [14:44:38] [LoadDynamicMapIcons] Failed to load any map icons. [14:44:38] [LoadMailboxes] Failed to load any mailboxes. [14:44:38] [LoadBusinesses] Failed to load any businesses. [14:44:38] [SpeedCameras] No Speed Cameras loaded. [14:44:39] [LoadRelayForLifeTeams] Failed to load any teams. [14:44:39] [LoadGarages] Failed to load any garages. [14:44:39] [LoadCrimes] Crime Data Loaded. [14:44:39] [LOADSALEDATA] Inserted new row into `sales` [14:44:39] [LoadPaintBallArenas] No Paintball Arenas have been loaded. [14:44:39] [Dynamic Points] 20 dynamic points has been loaded. [14:44:39] [LoadTurfWars] Failed to load any turfs. [14:44:39] [LoadPlants] Error: Failed to load any plants! [14:44:39] [LoadHelp] 2 help entries rehashed/loaded. [14:44:39] [Parking Meters] No parking meters loaded. [14:44:39] [Gov Weapon Prices] Loaded 47 Weapons [14:44:39] [Metal Detectors] Successfully loaded 4 metal detectors [14:44:39] [MySQL] Query Error - (ErrorID: 1146) [14:44:39] [MySQL] Check mysql_log.txt to review the query that threw the error. [14:44:39] Dumping query from 2018/1/26 (14:44:39) Description: Table 'ngg rp sql.payphones' doesn't exist (index 0). Query: [14:44:39] SELECT * FROM `payphones` [14:44:39] [Dynamic Crate Boxes] There are no dynamic crate boxes to load. [14:44:39] [Dynamic Crate Facility] 10 dynamic Crate Facilities have been loaded. [14:44:39] [LoadDynamicCrateVehicles] No dynamic crate vehicles have been loaded. [14:44:39] [Dynamic Job Names] 24 dynamic job names have been loaded. [14:44:39] [Dynamic Job Points] No dynamic job points has been loaded. [14:44:39] [Gang Tags] There are no gang tags in the database. [14:44:39] [MySQL] Query Error - (ErrorID: 1146) [14:44:39] [MySQL] Check mysql_log.txt to review the query that threw the error. [14:44:39] Dumping query from 2018/1/26 (14:44:39) Description: Table 'ngg rp sql.furniturecatalog' doesn't exist (index 0). Query: [14:44:39] SELECT * FROM `furniturecatalog` [14:44:39] TotalSold0: 0 | AmountMade0: 0 [14:44:39] TotalSold1: 0 | AmountMade1: 0 [14:44:39] TotalSold2: 0 | AmountMade2: 0 [14:44:39] TotalSold3: 0 | AmountMade3: 0 [14:44:39] TotalSold4: 0 | AmountMade4: 0 [14:44:39] TotalSold5: 0 | AmountMade5: 0 [14:44:39] TotalSold6: 0 | AmountMade6: 0 [14:44:39] TotalSold7: 0 | AmountMade7: 0 [14:44:39] TotalSold8: 0 | AmountMade8: 0 [14:44:39] TotalSold9: 0 | AmountMade9: 0 [14:44:39] TotalSold10: 0 | AmountMade10: 0 [14:44:39] TotalSold11: 0 | AmountMade11: 0 [14:44:39] TotalSold12: 0 | AmountMade12: 0 [14:44:39] TotalSold13: 0 | AmountMade13: 0 [14:44:39] TotalSold14: 0 | AmountMade14: 0 [14:44:39] TotalSold15: 0 | AmountMade15: 0 [14:44:39] TotalSold16: 0 | AmountMade16: 0 [14:44:39] TotalSold17: 0 | AmountMade17: 0 [14:44:39] TotalSold18: 0 | AmountMade18: 0 [14:44:39] TotalSold19: 0 | AmountMade19: 0 [14:44:39] TotalSold20: 0 | AmountMade20: 0 [14:44:39] TotalSold21: 0 | AmountMade21: 0 [14:44:39] TotalSold22: 0 | AmountMade22: 0 [14:44:39] TotalSold23: 0 | AmountMade23: 0 [14:44:39] TotalSold24: 0 | AmountMade24: 0 [14:44:39] TotalSold25: 0 | AmountMade25: 0 [14:44:39] TotalSold26: 0 | AmountMade26: 0 [14:44:39] TotalSold27: 0 | AmountMade27: 0 [14:44:39] TotalSold28: 0 | AmountMade28: 0 [14:44:39] TotalSold29: 0 | AmountMade29: 0 [14:44:39] TotalSold30: 0 | AmountMade30: 0 [14:44:39] TotalSold31: 0 | AmountMade31: 0 [14:44:39] TotalSold32: 0 | AmountMade32: 0 [14:44:39] TotalSold33: 0 | AmountMade33: 0 [14:44:39] TotalSold34: 0 | AmountMade34: 0 [14:44:39] TotalSold35: 0 | AmountMade35: 0 [14:44:39] TotalSold36: 0 | AmountMade36: 0 [14:44:39] TotalSold37: 0 | AmountMade37: 0 [14:44:39] TotalSold38: 0 | AmountMade38: 0 [14:44:39] TotalSold39: 0 | AmountMade39: 0 [14:44:39] TotalSold40: 0 | AmountMade40: 0 [14:44:39] TotalSold41: 0 | AmountMade41: 0 [14:44:39] TotalSold42: 0 | AmountMade42: 0 [14:44:39] TotalSold43: 0 | AmountMade43: 0 [14:44:39] TotalSoldMicro0: 0 | AmountMadeMicro0: 0 [14:44:39] TotalSoldMicro1: 0 | AmountMadeMicro1: 0 [14:44:39] TotalSoldMicro2: 0 | AmountMadeMicro2: 0 [14:44:39] TotalSoldMicro3: 0 | AmountMadeMicro3: 0 [14:44:39] TotalSoldMicro4: 0 | AmountMadeMicro4: 0 [14:44:39] TotalSoldMicro5: 0 | AmountMadeMicro5: 0 [14:44:39] TotalSoldMicro6: 0 | AmountMadeMicro6: 0 [14:44:39] TotalSoldMicro7: 0 | AmountMadeMicro7: 0 [14:44:39] TotalSoldMicro8: 0 | AmountMadeMicro8: 0 [14:44:39] TotalSoldMicro9: 0 | AmountMadeMicro9: 0 [14:44:39] TotalSoldMicro10: 0 | AmountMadeMicro10: 0 [14:44:39] TotalSoldMicro11: 0 | AmountMadeMicro11: 0 [14:44:39] TotalSoldMicro12: 0 | AmountMadeMicro12: 0 [14:44:39] TotalSoldMicro13: 0 | AmountMadeMicro13: 0 [14:44:39] TotalSoldMicro14: 0 | AmountMadeMicro14: 0 [14:44:39] TotalSoldMicro15: 0 | AmountMadeMicro15: 0 [14:44:39] TotalSoldMicro16: 0 | AmountMadeMicro16: 0 [14:44:39] TotalSoldMicro17: 0 | AmountMadeMicro17: 0 [14:44:39] TotalSoldMicro18: 0 | AmountMadeMicro18: 0 [14:44:39] TotalSoldMicro19: 0 | AmountMadeMicro19: 0
Код:
[14:45:33] [connection] 192.168.1.102:53821 requests connection cookie. [14:45:34] [connection] incoming connection: 192.168.1.102:53821 id: 0 [14:45:35] [join] Morgan_Freeman has joined the server (0:192.168.1.102) [14:45:35] [PlayerName] Formatted Morgan_Freeman to the correct RP-format standards. [14:45:35] [MySQL] Query Error - (ErrorID: 1146) [14:45:35] [MySQL] Check mysql_log.txt to review the query that threw the error. [14:45:35] Dumping query from 2018/1/26 (14:45:35) Description: Table 'ngg rp sql.ban' doesn't exist (index 0). Query: [14:45:35] SELECT `IP` FROM `ban` WHERE `IP` = '192.168.1.102' AND `active` = '1' [14:45:47] [part] Morgan_Freeman has left the server (0:1)
Код:
[14:46:28] [debug] Run time error 4: "Array index out of bounds" [14:46:28] [debug] Attempted to read/write array element at index 100 in array of size 100 [14:46:28] [debug] AMX backtrace: [14:46:28] [debug] #0 00808d18 in PlantTimer () at ./includes/core/drugcore.pwn:1015 [14:46:28] [debug] #1 0002d7d0 in public SyncTime () at ./includes/timers.pwn:235 [14:47:33] [debug] Run time error 4: "Array index out of bounds" [14:47:33] [debug] Attempted to read/write array element at index 100 in array of size 100 [14:47:33] [debug] AMX backtrace: [14:47:33] [debug] #0 00808d18 in PlantTimer () at ./includes/core/drugcore.pwn:1015 [14:47:33] [debug] #1 0002d7d0 in public SyncTime () at ./includes/timers.pwn:235 [14:48:37] [debug] Run time error 4: "Array index out of bounds" [14:48:37] [debug] Attempted to read/write array element at index 100 in array of size 100 [14:48:37] [debug] AMX backtrace: [14:48:37] [debug] #0 00808d18 in PlantTimer () at ./includes/core/drugcore.pwn:1015 [14:48:37] [debug] #1 0002d7d0 in public SyncTime () at ./includes/timers.pwn:235 [14:49:42] [debug] Run time error 4: "Array index out of bounds" [14:49:42] [debug] Attempted to read/write array element at index 100 in array of size 100 [14:49:42] [debug] AMX backtrace: [14:49:42] [debug] #0 00808d18 in PlantTimer () at ./includes/core/drugcore.pwn:1015 [14:49:42] [debug] #1 0002d7d0 in public SyncTime () at ./includes/timers.pwn:235