01.04.2016, 07:42
Hello guys, I have a script which tends to work perfectly under my local host mySQL database, the thing is I got the script by someone else therefore I received only the .dll plugins, and the host under which I'm running the server is linux which basically requires .so files. I created the tables, and tried them both on different databases both paid and free ones, however still the same error pops up. I tried to update the plugins to their latest versions but I guess this is creating conflicts between them? Thanks!
Here's the mysql error logs:
and here the server logs:
would love some help
Here's the mysql error logs:
Код:
[03:41:05] [DEBUG] mysql_format - connection: 1, len: 128, format: "SELECT * FROM `Advertisements` WHERE `Active` = 1 ORDER BY `ID` ASC LIMIT 1" [03:41:05] [DEBUG] mysql_tquery - connection: 1, query: "SELECT * FROM `Advertisements` WHERE `Active` = 1 ORDER BY `ID` ", callback: "RecieveAdvertisement", format: "d" [03:41:05] [DEBUG] CMySQLQuery::Execute[RecieveAdvertisement] - starting query execution [03:41:05] [ERROR] CMySQLQuery::Execute[RecieveAdvertisement] - (error #1146) Table 'daniboy.Advertisements' doesn't exist [03:41:05] [DEBUG] CMySQLQuery::Execute[RecieveAdvertisement] - error will be triggered in OnQueryError [03:48:31] [DEBUG] mysql_connect - host: "db4free.net", user: "daniboy", database: "daniboy", password: "****", port: 3306, autoreconnect: true, pool_size: 2 [03:48:31] [DEBUG] CMySQLHandle::Create - creating new connection.. [03:48:31] [DEBUG] CMySQLHandle::CMySQLHandle - constructor called [03:48:31] [DEBUG] CMySQLHandle::Create - connection created (id: 1) [03:48:31] [DEBUG] CMySQLConnection::Connect - establishing connection to database... [03:48:31] [DEBUG] CMySQLConnection::Connect - connection was successful [03:48:31] [DEBUG] CMySQLConnection::Connect - auto-reconnect has been enabled [03:48:31] [DEBUG] mysql_errno - connection: 1 [03:48:31] [DEBUG] CMySQLConnection::Connect - establishing connection to database... [03:48:31] [DEBUG] CMySQLConnection::Connect - establishing connection to database... [03:48:31] [DEBUG] CMySQLConnection::Connect - establishing connection to database... [03:48:32] [DEBUG] mysql_tquery - connection: 1, query: "SELECT * FROM `BusinessInfo`", callback: "OnLoadBusinesses", format: "d" [03:48:32] [DEBUG] mysql_tquery - connection: 1, query: "SELECT * FROM `FactionInfo`", callback: "OnLoadFactions", format: "d" [03:48:32] [DEBUG] mysql_tquery - connection: 1, query: "SELECT * FROM `HQInfo`", callback: "OnLoadHQs", format: "d" [03:48:32] [DEBUG] mysql_tquery - connection: 1, query: "SELECT * FROM `WHInfo`", callback: "OnLoadWHs", format: "d" [03:48:32] [DEBUG] mysql_tquery - connection: 1, query: "SELECT * FROM `VehicleInfo`", callback: "OnLoadVehicles", format: "d" [03:48:32] [DEBUG] mysql_tquery - connection: 1, query: "SELECT * FROM `GangZones`", callback: "OnLoadGangZones", format: "(null)" [03:48:32] [DEBUG] mysql_tquery - connection: 1, query: "SELECT * FROM `HouseInfo`", callback: "OnLoadHouses", format: "d" [03:48:32] [DEBUG] mysql_tquery - connection: 1, query: "SELECT * FROM `FurnitureInfo`", callback: "OnLoadFurniture", format: "d" [03:48:32] [DEBUG] mysql_tquery - connection: 1, query: "SELECT * FROM `TeleportInfo`", callback: "OnLoadTeleports", format: "d" [03:48:32] [DEBUG] mysql_tquery - connection: 1, query: "SELECT * FROM `ATMInfo`", callback: "OnLoadATMS", format: "d" [03:48:32] [DEBUG] mysql_tquery - connection: 1, query: "SELECT * FROM `GateInfo`", callback: "OnLoadGates", format: "d" [03:48:32] [DEBUG] CMySQLConnection::Connect - connection was successful [03:48:32] [DEBUG] CMySQLConnection::Connect - auto-reconnect has been enabled [03:48:32] [DEBUG] CMySQLQuery::Execute[OnLoadBusinesses] - starting query execution [03:48:32] [DEBUG] CMySQLConnection::Connect - connection was successful [03:48:32] [DEBUG] CMySQLConnection::Connect - auto-reconnect has been enabled [03:48:32] [DEBUG] CMySQLConnection::Connect - connection was successful [03:48:32] [DEBUG] CMySQLConnection::Connect - auto-reconnect has been enabled [03:48:32] [ERROR] CMySQLQuery::Execute[OnLoadBusinesses] - (error #1146) Table 'daniboy.BusinessInfo' doesn't exist [03:48:32] [DEBUG] CMySQLQuery::Execute[OnLoadBusinesses] - error will be triggered in OnQueryError [03:48:32] [DEBUG] CMySQLQuery::Execute[OnLoadFactions] - starting query execution [03:48:32] [ERROR] CMySQLQuery::Execute[OnLoadFactions] - (error #1146) Table 'daniboy.FactionInfo' doesn't exist [03:48:32] [DEBUG] CMySQLQuery::Execute[OnLoadFactions] - error will be triggered in OnQueryError [03:48:32] [DEBUG] CMySQLQuery::Execute[OnLoadHQs] - starting query execution [03:48:32] [ERROR] CMySQLQuery::Execute[OnLoadHQs] - (error #1146) Table 'daniboy.HQInfo' doesn't exist [03:48:32] [DEBUG] CMySQLQuery::Execute[OnLoadHQs] - error will be triggered in OnQueryError [03:48:32] [DEBUG] CMySQLQuery::Execute[OnLoadWHs] - starting query execution [03:48:32] [ERROR] CMySQLQuery::Execute[OnLoadWHs] - (error #1146) Table 'daniboy.WHInfo' doesn't exist [03:48:32] [DEBUG] CMySQLQuery::Execute[OnLoadWHs] - error will be triggered in OnQueryError [03:48:32] [DEBUG] CMySQLQuery::Execute[OnLoadVehicles] - starting query execution [03:48:32] [ERROR] CMySQLQuery::Execute[OnLoadVehicles] - (error #1146) Table 'daniboy.VehicleInfo' doesn't exist [03:48:32] [DEBUG] CMySQLQuery::Execute[OnLoadVehicles] - error will be triggered in OnQueryError [03:48:32] [DEBUG] CMySQLQuery::Execute[OnLoadGangZones] - starting query execution [03:48:32] [ERROR] CMySQLQuery::Execute[OnLoadGangZones] - (error #1146) Table 'daniboy.GangZones' doesn't exist [03:48:32] [DEBUG] CMySQLQuery::Execute[OnLoadGangZones] - error will be triggered in OnQueryError [03:48:32] [DEBUG] CMySQLQuery::Execute[OnLoadHouses] - starting query execution [03:48:33] [ERROR] CMySQLQuery::Execute[OnLoadHouses] - (error #1146) Table 'daniboy.HouseInfo' doesn't exist [03:48:33] [DEBUG] CMySQLQuery::Execute[OnLoadHouses] - error will be triggered in OnQueryError [03:48:33] [DEBUG] CMySQLQuery::Execute[OnLoadFurniture] - starting query execution [03:48:33] [ERROR] CMySQLQuery::Execute[OnLoadFurniture] - (error #1146) Table 'daniboy.FurnitureInfo' doesn't exist [03:48:33] [DEBUG] CMySQLQuery::Execute[OnLoadFurniture] - error will be triggered in OnQueryError [03:48:33] [DEBUG] CMySQLQuery::Execute[OnLoadTeleports] - starting query execution [03:48:33] [ERROR] CMySQLQuery::Execute[OnLoadTeleports] - (error #1146) Table 'daniboy.TeleportInfo' doesn't exist [03:48:33] [DEBUG] CMySQLQuery::Execute[OnLoadTeleports] - error will be triggered in OnQueryError [03:48:33] [DEBUG] CMySQLQuery::Execute[OnLoadATMS] - starting query execution [03:48:33] [ERROR] CMySQLQuery::Execute[OnLoadATMS] - (error #1146) Table 'daniboy.ATMInfo' doesn't exist [03:48:33] [DEBUG] CMySQLQuery::Execute[OnLoadATMS] - error will be triggered in OnQueryError [03:48:33] [DEBUG] CMySQLQuery::Execute[OnLoadGates] - starting query execution [03:48:33] [ERROR] CMySQLQuery::Execute[OnLoadGates] - (error #1146) Table 'daniboy.GateInfo' doesn't exist [03:48:33] [DEBUG] CMySQLQuery::Execute[OnLoadGates] - error will be triggered in OnQueryError [03:49:21] [DEBUG] mysql_connect - host: "db4free.net", user: "daniboy", database: "daniboy", password: "****", port: 3306, autoreconnect: true, pool_size: 2 [03:49:21] [DEBUG] CMySQLHandle::Create - creating new connection.. [03:49:21] [DEBUG] CMySQLHandle::CMySQLHandle - constructor called [03:49:21] [DEBUG] CMySQLHandle::Create - connection created (id: 1) [03:49:21] [DEBUG] CMySQLConnection::Connect - establishing connection to database... [03:49:21] [DEBUG] CMySQLConnection::Connect - connection was successful [03:49:21] [DEBUG] CMySQLConnection::Connect - auto-reconnect has been enabled [03:49:21] [DEBUG] mysql_errno - connection: 1 [03:49:21] [DEBUG] mysql_tquery - connection: 1, query: "SELECT * FROM `BusinessInfo`", callback: "OnLoadBusinesses", format: "d" [03:49:21] [DEBUG] mysql_tquery - connection: 1, query: "SELECT * FROM `FactionInfo`", callback: "OnLoadFactions", format: "d" [03:49:21] [DEBUG] mysql_tquery - connection: 1, query: "SELECT * FROM `HQInfo`", callback: "OnLoadHQs", format: "d" [03:49:21] [DEBUG] mysql_tquery - connection: 1, query: "SELECT * FROM `WHInfo`", callback: "OnLoadWHs", format: "d" [03:49:21] [DEBUG] mysql_tquery - connection: 1, query: "SELECT * FROM `VehicleInfo`", callback: "OnLoadVehicles", format: "d" [03:49:21] [DEBUG] mysql_tquery - connection: 1, query: "SELECT * FROM `GangZones`", callback: "OnLoadGangZones", format: "(null)" [03:49:21] [DEBUG] mysql_tquery - connection: 1, query: "SELECT * FROM `HouseInfo`", callback: "OnLoadHouses", format: "d" [03:49:21] [DEBUG] mysql_tquery - connection: 1, query: "SELECT * FROM `FurnitureInfo`", callback: "OnLoadFurniture", format: "d" [03:49:21] [DEBUG] mysql_tquery - connection: 1, query: "SELECT * FROM `TeleportInfo`", callback: "OnLoadTeleports", format: "d" [03:49:21] [DEBUG] mysql_tquery - connection: 1, query: "SELECT * FROM `ATMInfo`", callback: "OnLoadATMS", format: "d" [03:49:21] [DEBUG] mysql_tquery - connection: 1, query: "SELECT * FROM `GateInfo`", callback: "OnLoadGates", format: "d" [03:49:21] [DEBUG] CMySQLConnection::Connect - establishing connection to database... [03:49:21] [DEBUG] CMySQLConnection::Connect - establishing connection to database... [03:49:21] [DEBUG] CMySQLConnection::Connect - establishing connection to database... [03:49:21] [DEBUG] CMySQLConnection::Connect - connection was successful [03:49:21] [DEBUG] CMySQLConnection::Connect - auto-reconnect has been enabled [03:49:21] [DEBUG] CMySQLQuery::Execute[OnLoadBusinesses] - starting query execution [03:49:21] [DEBUG] CMySQLConnection::Connect - connection was successful [03:49:21] [DEBUG] CMySQLConnection::Connect - auto-reconnect has been enabled [03:49:21] [DEBUG] CMySQLConnection::Connect - connection was successful [03:49:21] [DEBUG] CMySQLConnection::Connect - auto-reconnect has been enabled [03:49:22] [ERROR] CMySQLQuery::Execute[OnLoadBusinesses] - (error #1146) Table 'daniboy.BusinessInfo' doesn't exist [03:49:22] [DEBUG] CMySQLQuery::Execute[OnLoadBusinesses] - error will be triggered in OnQueryError [03:49:22] [DEBUG] CMySQLQuery::Execute[OnLoadFactions] - starting query execution [03:49:22] [ERROR] CMySQLQuery::Execute[OnLoadFactions] - (error #1146) Table 'daniboy.FactionInfo' doesn't exist [03:49:22] [DEBUG] CMySQLQuery::Execute[OnLoadFactions] - error will be triggered in OnQueryError [03:49:22] [DEBUG] CMySQLQuery::Execute[OnLoadHQs] - starting query execution [03:49:22] [ERROR] CMySQLQuery::Execute[OnLoadHQs] - (error #1146) Table 'daniboy.HQInfo' doesn't exist [03:49:22] [DEBUG] CMySQLQuery::Execute[OnLoadHQs] - error will be triggered in OnQueryError [03:49:22] [DEBUG] CMySQLQuery::Execute[OnLoadWHs] - starting query execution [03:49:22] [ERROR] CMySQLQuery::Execute[OnLoadWHs] - (error #1146) Table 'daniboy.WHInfo' doesn't exist [03:49:22] [DEBUG] CMySQLQuery::Execute[OnLoadWHs] - error will be triggered in OnQueryError [03:49:22] [DEBUG] CMySQLQuery::Execute[OnLoadVehicles] - starting query execution [03:49:22] [ERROR] CMySQLQuery::Execute[OnLoadVehicles] - (error #1146) Table 'daniboy.VehicleInfo' doesn't exist [03:49:22] [DEBUG] CMySQLQuery::Execute[OnLoadVehicles] - error will be triggered in OnQueryError [03:49:22] [DEBUG] CMySQLQuery::Execute[OnLoadGangZones] - starting query execution [03:49:22] [ERROR] CMySQLQuery::Execute[OnLoadGangZones] - (error #1146) Table 'daniboy.GangZones' doesn't exist [03:49:22] [DEBUG] CMySQLQuery::Execute[OnLoadGangZones] - error will be triggered in OnQueryError [03:49:22] [DEBUG] CMySQLQuery::Execute[OnLoadHouses] - starting query execution [03:49:22] [ERROR] CMySQLQuery::Execute[OnLoadHouses] - (error #1146) Table 'daniboy.HouseInfo' doesn't exist [03:49:22] [DEBUG] CMySQLQuery::Execute[OnLoadHouses] - error will be triggered in OnQueryError [03:49:22] [DEBUG] CMySQLQuery::Execute[OnLoadFurniture] - starting query execution [03:49:22] [ERROR] CMySQLQuery::Execute[OnLoadFurniture] - (error #1146) Table 'daniboy.FurnitureInfo' doesn't exist [03:49:22] [DEBUG] CMySQLQuery::Execute[OnLoadFurniture] - error will be triggered in OnQueryError [03:49:22] [DEBUG] CMySQLQuery::Execute[OnLoadTeleports] - starting query execution [03:49:22] [ERROR] CMySQLQuery::Execute[OnLoadTeleports] - (error #1146) Table 'daniboy.TeleportInfo' doesn't exist [03:49:22] [DEBUG] CMySQLQuery::Execute[OnLoadTeleports] - error will be triggered in OnQueryError [03:49:22] [DEBUG] CMySQLQuery::Execute[OnLoadATMS] - starting query execution [03:49:22] [ERROR] CMySQLQuery::Execute[OnLoadATMS] - (error #1146) Table 'daniboy.ATMInfo' doesn't exist [03:49:22] [DEBUG] CMySQLQuery::Execute[OnLoadATMS] - error will be triggered in OnQueryError [03:49:22] [DEBUG] CMySQLQuery::Execute[OnLoadGates] - starting query execution [03:49:23] [ERROR] CMySQLQuery::Execute[OnLoadGates] - (error #1146) Table 'daniboy.GateInfo' doesn't exist [03:49:23] [DEBUG] CMySQLQuery::Execute[OnLoadGates] - error will be triggered in OnQueryError [03:50:22] [DEBUG] mysql_format - connection: 1, len: 275, format: "SELECT `Password` FROM `PlayerInfo` WHERE `PlayerName` = '%e' LIMIT 1" [03:50:22] [DEBUG] mysql_tquery - connection: 1, query: "SELECT `Password` FROM `PlayerInfo` WHERE `PlayerName` = 'Dani_B", callback: "OnCheckPlayerAccount", format: "i" [03:50:22] [DEBUG] CMySQLQuery::Execute[OnCheckPlayerAccount] - starting query execution [03:50:22] [ERROR] CMySQLQuery::Execute[OnCheckPlayerAccount] - (error #1146) Table 'daniboy.PlayerInfo' doesn't exist [03:50:22] [DEBUG] CMySQLQuery::Execute[OnCheckPlayerAccount] - error will be triggered in OnQueryError [03:50:22] [DEBUG] mysql_format - connection: 1, len: 128, format: "SELECT * FROM `Advertisements` WHERE `Active` = 1 ORDER BY `ID` ASC LIMIT 1" [03:50:22] [DEBUG] mysql_tquery - connection: 1, query: "SELECT * FROM `Advertisements` WHERE `Active` = 1 ORDER BY `ID` ", callback: "RecieveAdvertisement", format: "d" [03:50:22] [DEBUG] CMySQLQuery::Execute[RecieveAdvertisement] - starting query execution [03:50:22] [ERROR] CMySQLQuery::Execute[RecieveAdvertisement] - (error #1146) Table 'daniboy.Advertisements' doesn't exist [03:50:22] [DEBUG] CMySQLQuery::Execute[RecieveAdvertisement] - error will be triggered in OnQueryError [03:50:35] [DEBUG] mysql_format - connection: 1, len: 248, format: "INSERT INTO `LoginDB` (`PlayerName`, `IP`, `DateTime`, `Successful`) VALUES ('%e', '%e', '%e', %d)" [03:50:35] [DEBUG] mysql_tquery - connection: 1, query: "INSERT INTO `LoginDB` (`PlayerName`, `IP`, `DateTime`, `Successf", callback: "(null)", format: "(null)" [03:50:35] [DEBUG] CMySQLQuery::Execute[] - starting query execution [03:50:35] [ERROR] CMySQLQuery::Execute[] - (error #1146) Table 'daniboy.LoginDB' doesn't exist [03:50:35] [DEBUG] CMySQLQuery::Execute[] - error will be triggered in OnQueryError [03:51:23] [DEBUG] mysql_format - connection: 1, len: 128, format: "SELECT * FROM `Advertisements` WHERE `Active` = 1 ORDER BY `ID` ASC LIMIT 1" [03:51:23] [DEBUG] mysql_tquery - connection: 1, query: "SELECT * FROM `Advertisements` WHERE `Active` = 1 ORDER BY `ID` ", callback: "RecieveAdvertisement", format: "d" [03:51:23] [DEBUG] CMySQLQuery::Execute[RecieveAdvertisement] - starting query execution [03:51:24] [ERROR] CMySQLQuery::Execute[RecieveAdvertisement] - (error #1146) Table 'daniboy.Advertisements' doesn't exist [03:51:24] [DEBUG] CMySQLQuery::Execute[RecieveAdvertisement] - error will be triggered in OnQueryError [03:52:25] [DEBUG] mysql_format - connection: 1, len: 128, format: "SELECT * FROM `Advertisements` WHERE `Active` = 1 ORDER BY `ID` ASC LIMIT 1" [03:52:25] [DEBUG] mysql_tquery - connection: 1, query: "SELECT * FROM `Advertisements` WHERE `Active` = 1 ORDER BY `ID` ", callback: "RecieveAdvertisement", format: "d" [03:52:25] [DEBUG] CMySQLQuery::Execute[RecieveAdvertisement] - starting query execution [03:52:25] [ERROR] CMySQLQuery::Execute[RecieveAdvertisement] - (error #1146) Table 'daniboy.Advertisements' doesn't exist [03:52:25] [DEBUG] CMySQLQuery::Execute[RecieveAdvertisement] - error will be triggered in OnQueryError [03:53:26] [DEBUG] mysql_format - connection: 1, len: 128, format: "SELECT * FROM `Advertisements` WHERE `Active` = 1 ORDER BY `ID` ASC LIMIT 1" [03:53:26] [DEBUG] mysql_tquery - connection: 1, query: "SELECT * FROM `Advertisements` WHERE `Active` = 1 ORDER BY `ID` ", callback: "RecieveAdvertisement", format: "d" [03:53:26] [DEBUG] CMySQLQuery::Execute[RecieveAdvertisement] - starting query execution [03:53:26] [ERROR] CMySQLQuery::Execute[RecieveAdvertisement] - (error #1146) Table 'daniboy.Advertisements' doesn't exist [03:53:26] [DEBUG] CMySQLQuery::Execute[RecieveAdvertisement] - error will be triggered in OnQueryError [03:54:27] [DEBUG] mysql_format - connection: 1, len: 128, format: "SELECT * FROM `Advertisements` WHERE `Active` = 1 ORDER BY `ID` ASC LIMIT 1" [03:54:27] [DEBUG] mysql_tquery - connection: 1, query: "SELECT * FROM `Advertisements` WHERE `Active` = 1 ORDER BY `ID` ", callback: "RecieveAdvertisement", format: "d" [03:54:27] [DEBUG] CMySQLQuery::Execute[RecieveAdvertisement] - starting query execution [03:54:27] [ERROR] CMySQLQuery::Execute[RecieveAdvertisement] - (error #1146) Table 'daniboy.Advertisements' doesn't exist [03:54:27] [DEBUG] CMySQLQuery::Execute[RecieveAdvertisement] - error will be triggered in OnQueryError
Код:
[03:49:18] *** IRC Plugin v1.4.5 by Incognito unloaded *** [03:49:18] plugin.mysql: Unloading plugin... [03:49:18] plugin.mysql: Plugin unloaded. [03:49:18] [03:49:18] =============================== [03:49:18] sscanf plugin unloaded. [03:49:18] =============================== [03:49:18] [03:49:18] ==================== [03:49:18] [03:49:18] Whirlpool unloaded [03:49:18] [03:49:18] ==================== [03:49:18] ---------- Loaded log file: "server_log.txt". ---------- SA-MP Dedicated Server ---------------------- v0.3.7-R2, ©2005-2015 SA-MP Team [03:49:21] password = "" (string) [03:49:21] filterscripts = "" (string) [03:49:21] [03:49:21] Server Plugins [03:49:21] -------------- [03:49:21] Loading plugin: irc.so [03:49:21] *** IRC Plugin v1.4.5 by Incognito loaded *** [03:49:21] Loaded. [03:49:21] Loading plugin: mysqlR39.so [03:49:21] >> plugin.mysql: R39-4 successfully loaded. [03:49:21] Loaded. [03:49:21] Loading plugin: streamer.so [03:49:21] *** Streamer Plugin v2.8 by Incognito loaded *** [03:49:21] Loaded. [03:49:21] Loading plugin: sscanf.so [03:49:21] [03:49:21] =============================== [03:49:21] sscanf plugin loaded. [03:49:21] Version: 2.8.1 [03:49:21] © 2012 Alex "******" Cole [03:49:21] =============================== [03:49:21] Loaded. [03:49:21] Loading plugin: whirlpool.so [03:49:21] [03:49:21] ================== [03:49:21] [03:49:21] Whirlpool loaded [03:49:21] [03:49:21] ================== [03:49:21] [03:49:21] Loaded. [03:49:21] Loading plugin: nativechecker.so [03:49:21] Loaded. [03:49:21] Loaded 6 plugins. [03:49:21] [03:49:21] Ban list [03:49:21] -------- [03:49:21] Loaded: samp.ban [03:49:21] [03:49:21] [03:49:21] Filterscripts [03:49:21] --------------- [03:49:21] Loaded 0 filterscripts. [03:49:21] Max Objects: -1 [03:49:21] [ConnectToMainPipeline:] Connecting to daniboy... [03:49:21] Number of vehicle models: 0 [03:50:18] [connection] 46.99.100.36:24917 requests connection cookie. [03:50:19] [connection] incoming connection: 46.99.100.36:24917 id: 0 [03:50:20] [join] Dani_Boy has joined the server (0:46.99.100.36) [03:50:35] [part] Dani_Boy has left the server (0:1)