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!
Код:
[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
Now that I tried the free database, under my local host without xampp or something else the same error occurs. But if I run my own apache/xampp mysql the server works fine? why's that?
Bumping this up. I still can't get it? Do I need to reset the mysql or something? ON MY LOCAL HOST EVERYTHING WORKS PERFECTLY, I RUN XAMPP AND APACHE AND THE LOGIN BOX APPEARS AND ALL THAT, BUT WHILE LINUX THE GAMEMODE RUNS BUT NO LOGIN BOX APPEARS NOR DO DATAS SAVE? sry for caps tho, anyone?