[MySQL] Table x.x doesn't exist
#1

Код:
[07:19:44] [DEBUG] mysql_connect - host: "localhost", user: "skatim", database: "zskatim0", password: "****", port: 3306, autoreconnect: true, pool_size: 2
[07:19:44] [DEBUG] CMySQLHandle::Create - creating new connection..
[07:19:44] [DEBUG] CMySQLHandle::CMySQLHandle - constructor called
[07:19:44] [DEBUG] CMySQLHandle::Create - connection created (id: 1)
[07:19:44] [DEBUG] CMySQLConnection::Connect - establishing connection to database...
[07:19:44] [DEBUG] CMySQLConnection::Connect - connection was successful
[07:19:44] [DEBUG] CMySQLConnection::Connect - auto-reconnect has been enabled
[07:19:44] [DEBUG] mysql_errno - connection: 1
[07:19:44] [DEBUG] mysql_tquery - connection: 1, query: "SELECT * FROM `BusinessInfo`", callback: "OnLoadBusinesses", format: "d"
[07:19:44] [DEBUG] mysql_tquery - connection: 1, query: "SELECT * FROM `FactionInfo`", callback: "OnLoadFactions", format: "d"
[07:19:44] [DEBUG] mysql_tquery - connection: 1, query: "SELECT * FROM `HQInfo`", callback: "OnLoadHQs", format: "d"
[07:19:44] [DEBUG] mysql_tquery - connection: 1, query: "SELECT * FROM `WHInfo`", callback: "OnLoadWHs", format: "d"
[07:19:44] [DEBUG] mysql_tquery - connection: 1, query: "SELECT * FROM `VehicleInfo`", callback: "OnLoadVehicles", format: "d"
[07:19:44] [DEBUG] mysql_tquery - connection: 1, query: "SELECT * FROM `GangZones`", callback: "OnLoadGangZones", format: "(null)"
[07:19:44] [DEBUG] mysql_tquery - connection: 1, query: "SELECT * FROM `HouseInfo`", callback: "OnLoadHouses", format: "d"
[07:19:44] [DEBUG] mysql_tquery - connection: 1, query: "SELECT * FROM `FurnitureInfo`", callback: "OnLoadFurniture", format: "d"
[07:19:44] [DEBUG] mysql_tquery - connection: 1, query: "SELECT * FROM `TeleportInfo`", callback: "OnLoadTeleports", format: "d"
[07:19:44] [DEBUG] mysql_tquery - connection: 1, query: "SELECT * FROM `ATMInfo`", callback: "OnLoadATMS", format: "d"
[07:19:44] [DEBUG] mysql_tquery - connection: 1, query: "SELECT * FROM `GateInfo`", callback: "OnLoadGates", format: "d"
[07:19:44] [DEBUG] CMySQLConnection::Connect - establishing connection to database...
[07:19:44] [DEBUG] CMySQLConnection::Connect - establishing connection to database...
[07:19:44] [DEBUG] CMySQLConnection::Connect - establishing connection to database...
[07:19:44] [DEBUG] CMySQLConnection::Connect - connection was successful
[07:19:44] [DEBUG] CMySQLConnection::Connect - connection was successful
[07:19:44] [DEBUG] CMySQLConnection::Connect - connection was successful
[07:19:44] [DEBUG] CMySQLConnection::Connect - auto-reconnect has been enabled
[07:19:44] [DEBUG] CMySQLConnection::Connect - auto-reconnect has been enabled
[07:19:44] [DEBUG] CMySQLQuery::Execute[OnLoadBusinesses] - starting query execution
[07:19:44] [DEBUG] CMySQLConnection::Connect - auto-reconnect has been enabled
[07:19:44] [ERROR] CMySQLQuery::Execute[OnLoadBusinesses] - (error #1146) Table 'zskatim0.BusinessInfo' doesn't exist
[07:19:44] [DEBUG] CMySQLQuery::Execute[OnLoadBusinesses] - error will be triggered in OnQueryError
[07:19:44] [DEBUG] CMySQLQuery::Execute[OnLoadFactions] - starting query execution
[07:19:44] [ERROR] CMySQLQuery::Execute[OnLoadFactions] - (error #1146) Table 'zskatim0.FactionInfo' doesn't exist
[07:19:44] [DEBUG] CMySQLQuery::Execute[OnLoadFactions] - error will be triggered in OnQueryError
[07:19:44] [DEBUG] CMySQLQuery::Execute[OnLoadHQs] - starting query execution
[07:19:44] [ERROR] CMySQLQuery::Execute[OnLoadHQs] - (error #1146) Table 'zskatim0.HQInfo' doesn't exist
[07:19:44] [DEBUG] CMySQLQuery::Execute[OnLoadHQs] - error will be triggered in OnQueryError
[07:19:44] [DEBUG] CMySQLQuery::Execute[OnLoadWHs] - starting query execution
[07:19:44] [ERROR] CMySQLQuery::Execute[OnLoadWHs] - (error #1146) Table 'zskatim0.WHInfo' doesn't exist
[07:19:44] [DEBUG] CMySQLQuery::Execute[OnLoadWHs] - error will be triggered in OnQueryError
[07:19:44] [DEBUG] CMySQLQuery::Execute[OnLoadVehicles] - starting query execution
[07:19:44] [ERROR] CMySQLQuery::Execute[OnLoadVehicles] - (error #1146) Table 'zskatim0.VehicleInfo' doesn't exist
[07:19:44] [DEBUG] CMySQLQuery::Execute[OnLoadVehicles] - error will be triggered in OnQueryError
[07:19:44] [DEBUG] CMySQLQuery::Execute[OnLoadGangZones] - starting query execution
[07:19:44] [ERROR] CMySQLQuery::Execute[OnLoadGangZones] - (error #1146) Table 'zskatim0.GangZones' doesn't exist
[07:19:44] [DEBUG] CMySQLQuery::Execute[OnLoadGangZones] - error will be triggered in OnQueryError
[07:19:44] [DEBUG] CMySQLQuery::Execute[OnLoadHouses] - starting query execution
[07:19:44] [ERROR] CMySQLQuery::Execute[OnLoadHouses] - (error #1146) Table 'zskatim0.HouseInfo' doesn't exist
[07:19:44] [DEBUG] CMySQLQuery::Execute[OnLoadHouses] - error will be triggered in OnQueryError
[07:19:44] [DEBUG] CMySQLQuery::Execute[OnLoadFurniture] - starting query execution
[07:19:44] [ERROR] CMySQLQuery::Execute[OnLoadFurniture] - (error #1146) Table 'zskatim0.FurnitureInfo' doesn't exist
[07:19:44] [DEBUG] CMySQLQuery::Execute[OnLoadFurniture] - error will be triggered in OnQueryError
[07:19:44] [DEBUG] CMySQLQuery::Execute[OnLoadTeleports] - starting query execution
[07:19:44] [ERROR] CMySQLQuery::Execute[OnLoadTeleports] - (error #1146) Table 'zskatim0.TeleportInfo' doesn't exist
[07:19:44] [DEBUG] CMySQLQuery::Execute[OnLoadTeleports] - error will be triggered in OnQueryError
[07:19:44] [DEBUG] CMySQLQuery::Execute[OnLoadATMS] - starting query execution
[07:19:44] [ERROR] CMySQLQuery::Execute[OnLoadATMS] - (error #1146) Table 'zskatim0.ATMInfo' doesn't exist
[07:19:44] [DEBUG] CMySQLQuery::Execute[OnLoadATMS] - error will be triggered in OnQueryError
[07:19:44] [DEBUG] CMySQLQuery::Execute[OnLoadGates] - starting query execution
[07:19:44] [ERROR] CMySQLQuery::Execute[OnLoadGates] - (error #1146) Table 'zskatim0.GateInfo' doesn't exist
[07:19:44] [DEBUG] CMySQLQuery::Execute[OnLoadGates] - error will be triggered in OnQueryError
[07:20:46] [DEBUG] mysql_format - connection: 1, len: 128, format: "SELECT * FROM `Advertisements` WHERE `Active` = 1 ORDER BY `ID` ASC LIMIT 1"
[07:20:46] [DEBUG] mysql_tquery - connection: 1, query: "SELECT * FROM `Advertisements` WHERE `Active` = 1 ORDER BY `ID` ", callback: "RecieveAdvertisement", format: "d"
[07:20:46] [DEBUG] CMySQLQuery::Execute[RecieveAdvertisement] - starting query execution
[07:20:46] [ERROR] CMySQLQuery::Execute[RecieveAdvertisement] - (error #1146) Table 'zskatim0.Advertisements' doesn't exist
[07:20:46] [DEBUG] CMySQLQuery::Execute[RecieveAdvertisement] - error will be triggered in OnQueryError
Tabelele exista, dar imi zica ca nu?

Код:
Database server

Server: Localhost via UNIX socket
Server type: MySQL
Server version: 5.5.53-0ubuntu0.14.04.1 - (Ubuntu)
Protocol version: 10
User: skatim@localhost
Server charset: UTF-8 Unicode (utf8)
Reply
#2

Ciudat...
Verifica OnQueryError(...), posibil sa te ajute. Pune si un printscreen cu tabelele daca poti.
Reply


Forum Jump:


Users browsing this thread: 1 Guest(s)