[ariel918]

[14:14:06] Successfully initiated the gamemode...
[14:14:06] Number of vehicle models: 29
[14:14:06] [MySQL] Query Error - (ErrorID: 1146) (Handle: 1)
[14:14:06] [MySQL] Check mysql_log.txt to review the query that threw the error.
[14:14:06] Dumping query from 2015/11/26 (14:14:6)

Description: Table 'mysql.misc' doesn't exist (index 0). Query:

Thank for the help

[iKarim]

Show us your mysql_log.txt. and mysql query codes.

[ariel918]

Quote:

Originally Posted by PawnHunter Show us your mysql_log.txt. and mysql query codes.

Код HTML:

[14:14:05] Preparing the gamemode, please wait...
[14:14:05] [MySQL] (Main Pipelines) Connecting to localhost...
[14:14:05] [MySQL] (MainPipeline) Connection successful toward MySQL Database Server!
[14:14:05] [Dynamic Giftbox] Loading the Dynamic Giftbox...
[14:14:05] [LoadCrates] Load Query Sent
[14:14:05] [LoadHouses] Loading data from database...
[14:14:05] [LoadDynamicDoors] Loading data from database...
[14:14:05] [LoadDynamicMapIcons] Loading data from database...
[14:14:05] [LoadMailboxes] Loading data from database...
[14:14:05] [LoadBusinesses] Loading data from database...
[14:14:05] [LoadAuctions] Loading data from database...
[14:14:05] [LoadTxtLabels] Loading data from database...
[14:14:05] [LoadPlants] Loading data from database...
[14:14:05] [SpeedCameras] Loading data from database...
[14:14:05] [LoadPayNSprays] Loading data from database...
[14:14:05] [LoadArrestPoints] Loading data from database...
[14:14:05] [LoadImpoundPoints] Loading data from database...
[14:14:05] [LoadRelayForLifeTeams] Loading data from database...
[14:14:05] [LoadBusinessSales] Loading data from database...
[14:14:06] [LoadTurfWars] 65 turfs loaded.
[14:14:06] [LoadPaintballArenas] 10 paintball arenas loaded.
[14:14:06] [LoadEventPoints] 0 event points loaded.
[14:14:06] [LoadGates] Loading data from database...
[14:14:06] [LoadElevatorStuff] 20 floors loaded.
[14:14:06] [LoadFamilies] Loading data from database...
[14:14:06] [LoadFamilyPoints] Loading Family Points from the database, please wait...
[14:14:06] [MiscLoad] Misc Loaded
[14:14:06] Resetting news...
[14:14:06] Resetting default server variables..
[14:14:06] Adjusted the server time...
[14:14:06] [Streamer] Loading Dynamic Static Vehicles...
[14:14:06] [Streamer] Dynamic Static Vehicles has been loaded.
[14:14:06] [Streamer] Loading Dynamic Pickups...
[14:14:06] [Streamer] Dynamic Pickups has been loaded.
[14:14:06] [Streamer] Loading 3D Text Labels...
[14:14:06] [Streamer] Dynamic 3D Text Labels has been loaded.
[14:14:06] [Streamer] Loading Dynamic Buttons...
[14:14:06] [Streamer] Dynamic Buttons has been loaded.
[14:14:06] [Streamer] Loading Dynamic Objects...
[14:14:06] [Streamer] Dynamic Objects has been loaded.
[14:14:06] [Textdraws] Loading Textdraws...
[14:14:06] [Textdraws] Loaded textdraws.
[14:14:06] [Dynamic Groups] Loading Dynamic Groups...
[14:14:06] [Dynamic Groups] Loading Dynamic Groups Vehicles...

[14:14:06] Successfully initiated the gamemode...
[14:14:06] Number of vehicle models: 29
[14:14:06] [MySQL] Query Error - (ErrorID: 1146) (Handle: 1)
[14:14:06] [MySQL] Check mysql_log.txt to review the query that threw the error.
[14:14:06] Dumping query from 2015/11/26 (14:14:6)

Description: Table 'mysql.misc' doesn't exist (index 0). Query:


[14:14:06] SELECT `gMOTD`,`aMOTD`,`vMOTD`,`cMOTD`,`pMOTD`,`ShopTechPay`,`GiftCode`,`GiftCodeBypass`,`TotalCitizens`,`TRCitizens`,`SecurityCode`,`ShopClosed`,`RimMod`,`CarVoucher`,`PVIPVoucher`, `GarageVW`, `PumpkinStock`, `HalloweenShop` FROM `misc`
[14:14:06] [MySQL] Query Error - (ErrorID: 1146) (Handle: 1)
[14:14:06] [MySQL] Check mysql_log.txt to review the query that threw the error.
[14:14:06] Dumping query from 2015/11/26 (14:14:6)

Description: Table 'mysql.accounts' doesn't exist (index 0). Query:


[14:14:06] UPDATE `accounts` SET `Online` = 0 WHERE `Online` = 0
[14:14:06] [MySQL] Query Error - (ErrorID: 1146) (Handle: 1)
[14:14:06] [MySQL] Check mysql_log.txt to review the query that threw the error.
[14:14:06] Dumping query from 2015/11/26 (14:14:6)

Description: Table 'mysql.giftbox' doesn't exist (index 0). Query:


[14:14:06] SELECT * FROM `giftbox`
[14:14:06] [MySQL] Query Error - (ErrorID: 1146) (Handle: 1)
[14:14:06] [MySQL] Check mysql_log.txt to review the query that threw the error.
[14:14:06] Dumping query from 2015/11/26 (14:14:6)

Description: Table 'mysql.crates' doesn't exist (index 0). Query:


[14:14:06] SELECT * FROM `crates`
[14:14:06] [MySQL] Query Error - (ErrorID: 1146) (Handle: 1)
[14:14:06] [MySQL] Check mysql_log.txt to review the query that threw the error.
[14:14:06] Dumping query from 2015/11/26 (14:14:6)

Description: Table 'mysql.houses' doesn't exist (index 0). Query:


[14:14:06] SELECT OwnerName.Username, h.* FROM houses h LEFT JOIN accounts OwnerName ON h.OwnerID = OwnerName.id
[14:14:06] [MySQL] Query Error - (ErrorID: 1146) (Handle: 1)
[14:14:06] [MySQL] Check mysql_log.txt to review the query that threw the error.
[14:14:06] Dumping query from 2015/11/26 (14:14:6)

Description: Table 'mysql.ddoors' doesn't exist (index 0). Query:


[14:14:06] SELECT * FROM `ddoors`
[14:14:06] [MySQL] Query Error - (ErrorID: 1146) (Handle: 1)
[14:14:06] [MySQL] Check mysql_log.txt to review the query that threw the error.
[14:14:06] Dumping query from 2015/11/26 (14:14:6)

Description: Table 'mysql.dmapicons' doesn't exist (index 0). Query:


[14:14:06] SELECT * FROM `dmapicons`
[14:14:06] [MySQL] Query Error - (ErrorID: 1146) (Handle: 1)
[14:14:06] [MySQL] Check mysql_log.txt to review the query that threw the error.
[14:14:06] Dumping query from 2015/11/26 (14:14:6)

Description: Table 'mysql.mailboxes' doesn't exist (index 0). Query:


[14:14:06] SELECT * FROM `mailboxes`
[14:14:06] [MySQL] Query Error - (ErrorID: 1146) (Handle: 1)
[14:14:06] [MySQL] Check mysql_log.txt to review the query that threw the error.
[14:14:06] Dumping query from 2015/11/26 (14:14:6)

Description: Table 'mysql.businesses' doesn't exist (index 0). Query:


[14:14:06] SELECT OwnerName.Username, b.* FROM businesses b LEFT JOIN accounts OwnerName ON b.OwnerID = OwnerName.id
[14:14:06] [MySQL] Query Error - (ErrorID: 1146) (Handle: 1)
[14:14:06] [MySQL] Check mysql_log.txt to review the query that threw the error.
[14:14:06] Dumping query from 2015/11/26 (14:14:6)

Description: Table 'mysql.auctions' doesn't exist (index 0). Query:


[14:14:06] SELECT * FROM `auctions`
[14:14:06] [MySQL] Query Error - (ErrorID: 1146) (Handle: 1)
[14:14:06] [MySQL] Check mysql_log.txt to review the query that threw the error.
[14:14:06] Dumping query from 2015/11/26 (14:14:6)

Description: Table 'mysql.text_labels' doesn't exist (index 0). Query:


[14:14:06] SELECT * FROM `text_labels`
[14:14:06] [MySQL] Query Error - (ErrorID: 1146) (Handle: 1)
[14:14:06] [MySQL] Check mysql_log.txt to review the query that threw the error.
[14:14:06] Dumping query from 2015/11/26 (14:14:6)

Description: Table 'mysql.plants' doesn't exist (index 0). Query:


[14:14:06] SELECT * FROM `plants`
[14:14:06] [MySQL] Query Error - (ErrorID: 1146) (Handle: 1)
[14:14:06] [MySQL] Check mysql_log.txt to review the query that threw the error.
[14:14:06] Dumping query from 2015/11/26 (14:14:6)

Description: Table 'mysql.speed_cameras' doesn't exist (index 0). Query:


[14:14:06] SELECT * FROM speed_cameras
[14:14:06] [MySQL] Query Error - (ErrorID: 1146) (Handle: 1)
[14:14:06] [MySQL] Check mysql_log.txt to review the query that threw the error.
[14:14:06] Dumping query from 2015/11/26 (14:14:6)

Description: Table 'mysql.paynsprays' doesn't exist (index 0). Query:


[14:14:06] SELECT * FROM `paynsprays`
[14:14:06] [MySQL] Query Error - (ErrorID: 1146) (Handle: 1)
[14:14:06] [MySQL] Check mysql_log.txt to review the query that threw the error.
[14:14:06] Dumping query from 2015/11/26 (14:14:6)

Description: Table 'mysql.arrestpoints' doesn't exist (index 0). Query:


[14:14:06] SELECT * FROM `arrestpoints`
[14:14:06] [MySQL] Query Error - (ErrorID: 1146) (Handle: 1)
[14:14:06] [MySQL] Check mysql_log.txt to review the query that threw the error.
[14:14:06] Dumping query from 2015/11/26 (14:14:6)

Description: Table 'mysql.impoundpoints' doesn't exist (index 0). Query:


[14:14:06] SELECT * FROM `impoundpoints`
[14:14:06] [MySQL] Query Error - (ErrorID: 1146) (Handle: 1)
[14:14:06] [MySQL] Check mysql_log.txt to review the query that threw the error.
[14:14:06] Dumping query from 2015/11/26 (14:14:6)

Description: Table 'mysql.rflteams' doesn't exist (index 0). Query:


[14:14:06] SELECT * FROM `rflteams`
[14:14:06] [MySQL] Query Error - (ErrorID: 1146) (Handle: 1)
[14:14:06] [MySQL] Check mysql_log.txt to review the query that threw the error.
[14:14:06] Dumping query from 2015/11/26 (14:14:6)

Description: Table 'mysql.sales' doesn't exist (index 0). Query:


[14:14:06] SELECT * FROM `sales` WHERE `Month` > NOW() - INTERVAL 1 MONTH
[14:14:06] [MySQL] Query Error - (ErrorID: 1146) (Handle: 1)
[14:14:06] [MySQL] Check mysql_log.txt to review the query that threw the error.
[14:14:06] Dumping query from 2015/11/26 (14:14:6)

Description: Table 'mysql.shopprices' doesn't exist (index 0). Query:


[14:14:06] SELECT * FROM `shopprices`
[14:14:06] [MySQL] Query Error - (ErrorID: 1146) (Handle: 1)
[14:14:06] [MySQL] Check mysql_log.txt to review the query that threw the error.
[14:14:06] Dumping query from 2015/11/26 (14:14:6)

Description: Table 'mysql.businesssales' doesn't exist (index 0). Query:


[14:14:06] SELECT * FROM `businesssales`
[14:14:06] [MySQL] Query Error - (ErrorID: 1146) (Handle: 1)
[14:14:06] [MySQL] Check mysql_log.txt to review the query that threw the error.
[14:14:06] Dumping query from 2015/11/26 (14:14:6)

Description: Table 'mysql.gates' doesn't exist (index 0). Query:


[14:14:06] SELECT * FROM `gates`
[14:14:06] [MySQL] Query Error - (ErrorID: 1146) (Handle: 1)
[14:14:06] [MySQL] Check mysql_log.txt to review the query that threw the error.
[14:14:06] Dumping query from 2015/11/26 (14:14:6)

Description: Table 'mysql.families' doesn't exist (index 0). Query:


[14:14:06] SELECT * FROM `families`
[14:14:06] [MySQL] Query Error - (ErrorID: 1146) (Handle: 1)
[14:14:06] [MySQL] Check mysql_log.txt to review the query that threw the error.
[14:14:06] Dumping query from 2015/11/26 (14:14:6)

Description: Table 'mysql.points' doesn't exist (index 0). Query:


[14:14:06] SELECT * FROM `points`
[14:14:06] [MySQL] Query Error - (ErrorID: 1146) (Handle: 1)
[14:14:06] [MySQL] Check mysql_log.txt to review the query that threw the error.
[14:14:06] Dumping query from 2015/11/26 (14:14:6)

Description: Table 'mysql.accounts' doesn't exist (index 0). Query:


[14:14:06] SELECT NULL FROM `accounts` WHERE `Nation` = 1 && `UpdateDate` > NOW() - INTERVAL 1 WEEK
[14:14:06] [MySQL] Query Error - (ErrorID: 1146) (Handle: 1)
[14:14:06] [MySQL] Check mysql_log.txt to review the query that threw the error.
[14:14:06] Dumping query from 2015/11/26 (14:14:6)

Description: Table 'mysql.accounts' doesn't exist (index 0). Query:


[14:14:06] SELECT NULL FROM `accounts` WHERE `UpdateDate` > NOW() - INTERVAL 1 WEEK
[14:14:06] [MySQL] Query Error - (ErrorID: 1146) (Handle: 1)
[14:14:06] [MySQL] Check mysql_log.txt to review the query that threw the error.
[14:14:06] Dumping query from 2015/11/26 (14:14:6)

Description: Table 'mysql.groups' doesn't exist (index 0). Query:


[14:14:06] SELECT * FROM `groups`
[14:14:06] [MySQL] Query Error - (ErrorID: 1146) (Handle: 1)
[14:14:06] [MySQL] Check mysql_log.txt to review the query that threw the error.
[14:14:06] Dumping query from 2015/11/26 (14:14:6)

Description: Table 'mysql.lockers' doesn't exist (index 0). Query:


[14:14:06] SELECT * FROM `lockers`
[14:14:06] [MySQL] Query Error - (ErrorID: 1146) (Handle: 1)
[14:14:06] [MySQL] Check mysql_log.txt to review the query that threw the error.
[14:14:06] Dumping query from 2015/11/26 (14:14:6)

Description: Table 'mysql.jurisdictions' doesn't exist (index 0). Query:


[14:14:06] SELECT * FROM `jurisdictions`
[14:14:06] [MySQL] Query Error - (ErrorID: 1146) (Handle: 1)
[14:14:06] [MySQL] Check mysql_log.txt to review the query that threw the error.
[14:14:06] Dumping query from 2015/11/26 (14:14:6)

Description: Table 'mysql.groupvehs' doesn't exist (index 0). Query:


[14:14:06] SELECT * FROM `groupvehs`

and i dont have a mysql.text i dont know why but i give you the samp_log
and where i find the mysql cods?

[iKarim]

Your MySQL server doesn't have tables requeird, if you downloaded gamemode, check the thread for mysql tables.

[Vince]

Script is probably stolen. As far as I know only NGG uses the "main pipeline" terminology. So yeah, good luck with that.

[N0FeaR]

probably leaked script thats why he doesn't have mysql.txt