1. SA-MP Forums Archive
  2. SA-MP Server
  3. Server Support

Threaded Mode
MySQL Pipeline Error!
ajam123
Huge Clucker
****
Posts: 364
Threads: 40
Joined: May 2012
Reputation: 0
#1

01.11.2016, 16:23
I get this error when starting my server.

Question: You have no table created.
Answer: I do.

Code:
[00:10:05] [DEBUG] CMySQLQuery::Execute[OnLoadGates] - error will be triggered in OnQueryError
[00:12:20] [DEBUG] mysql_connect - host: "HIDDEN", user: "HIDDEN", database: "HIDDEN", password: "****", port: 3306, autoreconnect: true, pool_size: 2
[00:12:20] [DEBUG] CMySQLHandle::Create - creating new connection..
[00:12:20] [DEBUG] CMySQLHandle::CMySQLHandle - constructor called
[00:12:20] [DEBUG] CMySQLHandle::Create - connection created (id: 1)
[00:12:20] [DEBUG] CMySQLConnection::Connect - establishing connection to database...
[00:12:21] [DEBUG] CMySQLConnection::Connect - connection was successful
[00:12:21] [DEBUG] CMySQLConnection::Connect - auto-reconnect has been enabled
[00:12:21] [DEBUG] mysql_errno - connection: 1
[00:12:21] [DEBUG] CMySQLConnection::Connect - establishing connection to database...
 callback: "OnLoadBusinesses", format: "d"
[00:12:21] [DEBUG] mysql_tquery - connection: 1, query: "SELECT * FROM `FactionInfo`", callback: "OnLoadFactions", format: "d"
[00:12:21] [DEBUG] mysql_tquery - connection: 1, query: "SELECT * FROM `HQInfo`", callback: "OnLoadHQs", format: "d"
[00:12:21] [DEBUG] mysql_tquery - connection: 1, query: "SELECT * FROM `WHInfo`", callback: "OnLoadWHs", format: "d"
[00:12:21] [DEBUG] mysql_tquery - connection: 1, query: "SELECT * FROM `VehicleInfo`", callback: "OnLoadVehicles", format: "d"
[00:12:21] [DEBUG] mysql_tquery - connection: 1, query: "SELECT * FROM `GangZones`", callback: "OnLoadGangZones", format: "(null)"
[00:12:21] [DEBUG] CMySQLConnection::Connect - establishing connection to database...
[00:12:21] [DEBUG] CMySQLConnection::Connect - establishing connection to database...
llback: "OnLoadHouses", format: "d"
[00:12:21] [DEBUG] mysql_tquery - connection: 1, query: "SELECT * FROM `FurnitureInfo`", callback: "OnLoadFurniture", format: "d"
[00:12:21] [DEBUG] mysql_tquery - connection: 1, query: "SELECT * FROM `TeleportInfo`", callback: "OnLoadTeleports", format: "d"
[00:12:21] [DEBUG] mysql_tquery - connection: 1, query: "SELECT * FROM `ATMInfo`", callback: "OnLoadATMS", format: "d"
[00:12:21] [DEBUG] mysql_tquery - connection: 1, query: "SELECT * FROM `GateInfo`", callback: "OnLoadGates", format: "d"
[00:12:21] [DEBUG] CMySQLConnection::Connect - connection was successful
[00:12:21] [DEBUG] CMySQLConnection::Connect - auto-reconnect has been enabled
[00:12:21] [DEBUG] CMySQLConnection::Connect - connection was successful
[00:12:21] [DEBUG] CMySQLConnection::Connect - auto-reconnect has been enabled
[00:12:21] [DEBUG] CMySQLConnection::Connect - connection was successful
[00:12:21] [DEBUG] CMySQLConnection::Connect - auto-reconnect has been enabled
[00:12:21] [DEBUG] CMySQLQuery::Execute[OnLoadBusinesses] - starting query execution
[00:12:21] [ERROR] CMySQLQuery::Execute[OnLoadBusinesses] - (error #1146) Table 'sql6142640.BusinessInfo' doesn't exist
[00:12:21] [DEBUG] CMySQLQuery::Execute[OnLoadBusinesses] - error will be triggered in OnQueryError
[00:12:21] [DEBUG] CMySQLQuery::Execute[OnLoadFactions] - starting query execution
[00:12:21] [ERROR] CMySQLQuery::Execute[OnLoadFactions] - (error #1146) Table 'sql6142640.FactionInfo' doesn't exist
[00:12:21] [DEBUG] CMySQLQuery::Execute[OnLoadFactions] - error will be triggered in OnQueryError
[00:12:21] [DEBUG] CMySQLQuery::Execute[OnLoadHQs] - starting query execution
[00:12:21] [ERROR] CMySQLQuery::Execute[OnLoadHQs] - (error #1146) Table 'sql6142640.HQInfo' doesn't exist
[00:12:21] [DEBUG] CMySQLQuery::Execute[OnLoadHQs] - error will be triggered in OnQueryError
[00:12:21] [DEBUG] CMySQLQuery::Execute[OnLoadWHs] - starting query execution
[00:12:21] [ERROR] CMySQLQuery::Execute[OnLoadWHs] - (error #1146) Table 'sql6142640.WHInfo' doesn't exist
[00:12:21] [DEBUG] CMySQLQuery::Execute[OnLoadWHs] - error will be triggered in OnQueryError
[00:12:21] [DEBUG] CMySQLQuery::Execute[OnLoadVehicles] - starting query execution
[00:12:22] [ERROR] CMySQLQuery::Execute[OnLoadVehicles] - (error #1146) Table 'sql6142640.VehicleInfo' doesn't exist
[00:12:22] [DEBUG] CMySQLQuery::Execute[OnLoadVehicles] - error will be triggered in OnQueryError
[00:12:22] [DEBUG] CMySQLQuery::Execute[OnLoadGangZones] - starting query execution
[00:12:22] [ERROR] CMySQLQuery::Execute[OnLoadGangZones] - (error #1146) Table 'sql6142640.GangZones' doesn't exist
[00:12:22] [DEBUG] CMySQLQuery::Execute[OnLoadGangZones] - error will be triggered in OnQueryError
[00:12:22] [DEBUG] CMySQLQuery::Execute[OnLoadHouses] - starting query execution
[00:12:22] [ERROR] CMySQLQuery::Execute[OnLoadHouses] - (error #1146) Table 'sql6142640.HouseInfo' doesn't exist
[00:12:22] [DEBUG] CMySQLQuery::Execute[OnLoadHouses] - error will be triggered in OnQueryError
[00:12:22] [DEBUG] CMySQLQuery::Execute[OnLoadFurniture] - starting query execution
[00:12:22] [ERROR] CMySQLQuery::Execute[OnLoadFurniture] - (error #1146) Table 'sql6142640.FurnitureInfo' doesn't exist
[00:12:22] [DEBUG] CMySQLQuery::Execute[OnLoadFurniture] - error will be triggered in OnQueryError
[00:12:22] [DEBUG] CMySQLQuery::Execute[OnLoadTeleports] - starting query execution
[00:12:22] [ERROR] CMySQLQuery::Execute[OnLoadTeleports] - (error #1146) Table 'sql6142640.TeleportInfo' doesn't exist
[00:12:22] [DEBUG] CMySQLQuery::Execute[OnLoadTeleports] - error will be triggered in OnQueryError
[00:12:22] [DEBUG] CMySQLQuery::Execute[OnLoadATMS] - starting query execution
[00:12:22] [ERROR] CMySQLQuery::Execute[OnLoadATMS] - (error #1146) Table 'sql6142640.ATMInfo' doesn't exist
[00:12:22] [DEBUG] CMySQLQuery::Execute[OnLoadATMS] - error will be triggered in OnQueryError
[00:12:22] [DEBUG] CMySQLQuery::Execute[OnLoadGates] - starting query execution
[00:12:22] [ERROR] CMySQLQuery::Execute[OnLoadGates] - (error #1146) Table 'sql6142640.GateInfo' doesn't exist
[00:12:22] [DEBUG] CMySQLQuery::Execute[OnLoadGates] - error will be triggered in OnQueryError
[00:13:17] [DEBUG] mysql_format - connection: 1, len: 275, format: "SELECT `Password` FROM `PlayerInfo` WHERE `PlayerName` = '%e' LIMIT 1"
[00:13:17] [DEBUG] mysql_tquery - connection: 1, query: "SELECT `Password` FROM `PlayerInfo` WHERE `PlayerName` = 'Quarto", callback: "OnCheckPlayerAccount", format: "i"
[00:13:17] [DEBUG] CMySQLQuery::Execute[OnCheckPlayerAccount] - starting query execution
[00:13:17] [ERROR] CMySQLQuery::Execute[OnCheckPlayerAccount] - (error #1146) Table 'sql6142640.PlayerInfo' doesn't exist
[00:13:17] [DEBUG] CMySQLQuery::Execute[OnCheckPlayerAccount] - error will be triggered in OnQueryError
[00:13:23] [DEBUG] mysql_format - connection: 1, len: 248, format: "INSERT INTO `LoginDB` (`PlayerName`, `IP`, `DateTime`, `Successful`) VALUES ('%e', '%e', '%e', %d)"
[00:13:24] [DEBUG] mysql_tquery - connection: 1, query: "INSERT INTO `LoginDB` (`PlayerName`, `IP`, `DateTime`, `Successf", callback: "(null)", format: "(null)"
[00:13:24] [DEBUG] CMySQLQuery::Execute[] - starting query execution
[00:13:24] [ERROR] CMySQLQuery::Execute[] - (error #1146) Table 'sql6142640.LoginDB' doesn't exist
[00:13:24] [DEBUG] CMySQLQuery::Execute[] - error will be triggered in OnQueryError
[00:13:27] [DEBUG] mysql_format - connection: 1, len: 128, format: "SELECT * FROM `Advertisements` WHERE `Active` = 1 ORDER BY `ID` ASC LIMIT 1"
[00:13:27] [DEBUG] mysql_tquery - connection: 1, query: "SELECT * FROM `Advertisements` WHERE `Active` = 1 ORDER BY `ID` ", callback: "RecieveAdvertisement", format: "d"
[00:13:27] [DEBUG] CMySQLQuery::Execute[RecieveAdvertisement] - starting query execution
[00:13:27] [ERROR] CMySQLQuery::Execute[RecieveAdvertisement] - (error #1146) Table 'sql6142640.Advertisements' doesn't exist
[00:13:27] [DEBUG] CMySQLQuery::Execute[RecieveAdvertisement] - error will be triggered in OnQueryError
[00:14:32] [DEBUG] mysql_format - connection: 1, len: 128, format: "SELECT * FROM `Advertisements` WHERE `Active` = 1 ORDER BY `ID` ASC LIMIT 1"
[00:14:32] [DEBUG] mysql_tquery - connection: 1, query: "SELECT * FROM `Advertisements` WHERE `Active` = 1 ORDER BY `ID` ", callback: "RecieveAdvertisement", format: "d"
[00:14:32] [DEBUG] CMySQLQuery::Execute[RecieveAdvertisement] - starting query execution
[00:14:32] [ERROR] CMySQLQuery::Execute[RecieveAdvertisement] - (error #1146) Table 'sql6142640.Advertisements' doesn't exist
[00:14:32] [DEBUG] CMySQLQuery::Execute[RecieveAdvertisement] - error will be triggered in OnQueryError
Find
Reply
ajam123
Huge Clucker
****
Posts: 364
Threads: 40
Joined: May 2012
Reputation: 0
#2

02.11.2016, 06:42
bump anyone?
Find
Reply
Sithis
Gangsta
*****
Posts: 889
Threads: 4
Joined: Mar 2013
Reputation: 0
#3

02.11.2016, 07:36
You clearly don't have the specified tables.
Find
Reply
ajam123
Huge Clucker
****
Posts: 364
Threads: 40
Joined: May 2012
Reputation: 0
#4

02.11.2016, 08:23
I do have it.
Find
Reply
Sithis
Gangsta
*****
Posts: 889
Threads: 4
Joined: Mar 2013
Reputation: 0
#5

02.11.2016, 11:53
The output you pasted clearly indicates it can't find the specified tables. So either you are using the wrong database or your queries are incorrect.
Find
Reply
Konstantinos
Spam Machine
*****
Posts: 11,827
Threads: 33
Joined: Dec 2011
Reputation: 0
#6

02.11.2016, 12:10
The exact same problem: http://forum.sa-mp.com/showthread.ph...57#post3791657
Find
Reply
« Next Oldest | Next Newest »


Forum Jump:


Users browsing this thread: 1 Guest(s)
  1. SA-MP Forums Archive
  2. SA-MP Server
  3. Server Support