Need help with my script!! MYSQL
#1

Hey guys this is my ERROR help me out fast
Quote:

[MySQL] Query Error - (ErrorID: 1146) (Handle: 1)
[19:45:56] [MySQL] Check mysql_log.txt to review the query that threw the error.
[19:45:56] Dumping query from 2014/3/30 (19:45:56)

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


[19:45:56] SELECT `gMOTD`,`aMOTD`,`vMOTD`,`cMOTD`,`pMOTD`,`ShopTechP ay`,`GiftCode`,`GiftCodeBypass`,`TotalCitizens`,`T RCitizens`,`SecurityCode`,`ShopClosed`,`RimMod`,`C arVoucher`,`PVIPVoucher`, `GarageVW`, `PumpkinStock`, `HalloweenShop` FROM `misc`
[19:45:57] [MySQL] Query Error - (ErrorID: 1146) (Handle: 1)
[19:45:57] [MySQL] Check mysql_log.txt to review the query that threw the error.
[19:45:57] Dumping query from 2014/3/30 (19:45:57)

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


[19:45:57] UPDATE `accounts` SET `Online` = 0 WHERE `Online` = 0
[19:45:57] [MySQL] Query Error - (ErrorID: 1146) (Handle: 1)
[19:45:57] [MySQL] Check mysql_log.txt to review the query that threw the error.
[19:45:57] Dumping query from 2014/3/30 (19:45:57)

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


[19:45:57] SELECT * FROM `giftbox`
[19:45:57] [MySQL] Query Error - (ErrorID: 1146) (Handle: 1)
[19:45:57] [MySQL] Check mysql_log.txt to review the query that threw the error.
[19:45:57] Dumping query from 2014/3/30 (19:45:57)

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


[19:45:57] SELECT * FROM `crates`
[19:45:57] [MySQL] Query Error - (ErrorID: 1146) (Handle: 1)
[19:45:57] [MySQL] Check mysql_log.txt to review the query that threw the error.
[19:45:57] Dumping query from 2014/3/30 (19:45:57)

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


[19:45:57] SELECT OwnerName.Username, h.* FROM houses h LEFT JOIN accounts OwnerName ON h.OwnerID = OwnerName.id
[19:45:57] [MySQL] Query Error - (ErrorID: 1146) (Handle: 1)
[19:45:57] [MySQL] Check mysql_log.txt to review the query that threw the error.
[19:45:57] Dumping query from 2014/3/30 (19:45:57)

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


[19:45:57] SELECT * FROM `ddoors`
[19:45:57] [MySQL] Query Error - (ErrorID: 1146) (Handle: 1)
[19:45:57] [MySQL] Check mysql_log.txt to review the query that threw the error.
[19:45:57] Dumping query from 2014/3/30 (19:45:57)

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


[19:45:57] SELECT * FROM `dmapicons`
[19:45:57] [MySQL] Query Error - (ErrorID: 1146) (Handle: 1)
[19:45:57] [MySQL] Check mysql_log.txt to review the query that threw the error.
[19:45:57] Dumping query from 2014/3/30 (19:45:57)

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


[19:45:57] SELECT * FROM `mailboxes`
[19:45:57] [MySQL] Query Error - (ErrorID: 1146) (Handle: 1)
[19:45:57] [MySQL] Check mysql_log.txt to review the query that threw the error.
[19:45:57] Dumping query from 2014/3/30 (19:45:57)

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


[19:45:57] SELECT OwnerName.Username, b.* FROM businesses b LEFT JOIN accounts OwnerName ON b.OwnerID = OwnerName.id
[19:45:57] [MySQL] Query Error - (ErrorID: 1146) (Handle: 1)
[19:45:57] [MySQL] Check mysql_log.txt to review the query that threw the error.
[19:45:57] Dumping query from 2014/3/30 (19:45:57)

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


[19:45:57] SELECT * FROM `auctions`
[19:45:58] [MySQL] Query Error - (ErrorID: 1146) (Handle: 1)
[19:45:58] [MySQL] Check mysql_log.txt to review the query that threw the error.
[19:45:58] Dumping query from 2014/3/30 (19:45:5

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


[19:45:58] SELECT * FROM `text_labels`
[19:45:58] [MySQL] Query Error - (ErrorID: 1146) (Handle: 1)
[19:45:58] [MySQL] Check mysql_log.txt to review the query that threw the error.
[19:45:58] Dumping query from 2014/3/30 (19:45:5

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


[19:45:58] SELECT * FROM `plants`
[19:45:58] [MySQL] Query Error - (ErrorID: 1146) (Handle: 1)
[19:45:58] [MySQL] Check mysql_log.txt to review the query that threw the error.
[19:45:58] Dumping query from 2014/3/30 (19:45:5

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


[19:45:58] SELECT * FROM speed_cameras
[19:45:58] [MySQL] Query Error - (ErrorID: 1146) (Handle: 1)
[19:45:58] [MySQL] Check mysql_log.txt to review the query that threw the error.
[19:45:58] Dumping query from 2014/3/30 (19:45:5

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


[19:45:58] SELECT * FROM `paynsprays`
[19:45:58] [MySQL] Query Error - (ErrorID: 1146) (Handle: 1)
[19:45:58] [MySQL] Check mysql_log.txt to review the query that threw the error.
[19:45:58] Dumping query from 2014/3/30 (19:45:5

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


[19:45:58] SELECT * FROM `arrestpoints`
[19:45:58] [MySQL] Query Error - (ErrorID: 1146) (Handle: 1)
[19:45:58] [MySQL] Check mysql_log.txt to review the query that threw the error.
[19:45:58] Dumping query from 2014/3/30 (19:45:5

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


[19:45:58] SELECT * FROM `impoundpoints`
[19:45:58] [MySQL] Query Error - (ErrorID: 1146) (Handle: 1)
[19:45:58] [MySQL] Check mysql_log.txt to review the query that threw the error.
[19:45:58] Dumping query from 2014/3/30 (19:45:5

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


[19:45:58] SELECT * FROM `rflteams`
[19:45:58] [MySQL] Query Error - (ErrorID: 1146) (Handle: 1)
[19:45:58] [MySQL] Check mysql_log.txt to review the query that threw the error.
[19:45:58] Dumping query from 2014/3/30 (19:45:5

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


[19:45:58] SELECT * FROM `sales` WHERE `Month` > NOW() - INTERVAL 1 MONTH
[19:45:58] [MySQL] Query Error - (ErrorID: 1146) (Handle: 1)
[19:45:58] [MySQL] Check mysql_log.txt to review the query that threw the error.
[19:45:58] Dumping query from 2014/3/30 (19:45:5

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


[19:45:58] SELECT * FROM `shopprices`
[19:45:59] [MySQL] Query Error - (ErrorID: 1146) (Handle: 1)
[19:45:59] [MySQL] Check mysql_log.txt to review the query that threw the error.
[19:45:59] Dumping query from 2014/3/30 (19:45:59)

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


[19:45:59] SELECT * FROM `businesssales`
[19:45:59] [MySQL] Query Error - (ErrorID: 1146) (Handle: 1)
[19:45:59] [MySQL] Check mysql_log.txt to review the query that threw the error.
[19:45:59] Dumping query from 2014/3/30 (19:45:59)

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


[19:45:59] SELECT * FROM `gates`
[19:45:59] [MySQL] Query Error - (ErrorID: 1146) (Handle: 1)
[19:45:59] [MySQL] Check mysql_log.txt to review the query that threw the error.
[19:45:59] Dumping query from 2014/3/30 (19:45:59)

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


[19:45:59] SELECT * FROM `families`
[19:45:59] [MySQL] Query Error - (ErrorID: 1146) (Handle: 1)
[19:45:59] [MySQL] Check mysql_log.txt to review the query that threw the error.
[19:45:59] Dumping query from 2014/3/30 (19:45:59)

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


[19:45:59] SELECT * FROM `points`
[19:45:59] [MySQL] Query Error - (ErrorID: 1146) (Handle: 1)
[19:45:59] [MySQL] Check mysql_log.txt to review the query that threw the error.
[19:45:59] Dumping query from 2014/3/30 (19:45:59)

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


[19:45:59] SELECT NULL FROM `accounts` WHERE `Nation` = 1 && `UpdateDate` > NOW() - INTERVAL 1 WEEK
[19:45:59] [MySQL] Query Error - (ErrorID: 1146) (Handle: 1)
[19:45:59] [MySQL] Check mysql_log.txt to review the query that threw the error.
[19:45:59] Dumping query from 2014/3/30 (19:45:59)

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


[19:45:59] SELECT NULL FROM `accounts` WHERE `UpdateDate` > NOW() - INTERVAL 1 WEEK
[19:45:59] [MySQL] Query Error - (ErrorID: 1146) (Handle: 1)
[19:45:59] [MySQL] Check mysql_log.txt to review the query that threw the error.
[19:45:59] Dumping query from 2014/3/30 (19:45:59)

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


[19:45:59] SELECT * FROM `groups`
[19:45:59] [MySQL] Query Error - (ErrorID: 1146) (Handle: 1)
[19:45:59] [MySQL] Check mysql_log.txt to review the query that threw the error.
[19:45:59] Dumping query from 2014/3/30 (19:45:59)

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


[19:45:59] SELECT * FROM `lockers`
[19:45:59] [MySQL] Query Error - (ErrorID: 1146) (Handle: 1)
[19:45:59] [MySQL] Check mysql_log.txt to review the query that threw the error.
[19:45:59] Dumping query from 2014/3/30 (19:45:59)

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


[19:45:59] SELECT * FROM `jurisdictions`
[19:45:59] [MySQL] Query Error - (ErrorID: 1146) (Handle: 1)
[19:45:59] [MySQL] Check mysql_log.txt to review the query that threw the error.
[19:45:59] Dumping query from 2014/3/30 (19:45:59)

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


[19:45:59] SELECT * FROM `groupvehs`

Reply
#2

Does no one know how to fix it ?!
Reply
#3

Quote:

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

Check your table name in your script matches the MySQL database name.
Reply


Forum Jump:


Users browsing this thread: 2 Guest(s)