MySql Errors/ Help ?
#1

So I uploaded the database zipped,
The servers starts up kinda once it's loading it keeps saying searching for your accounts which it never finds.

Anyone Know a fix to this error listed below,

Also I know I must create the tables for it but I'm still learning this stuff...


Код:
[07:10:08] SELECT `gMOTD`,`aMOTD`,`vMOTD`,`cMOTD`,`pMOTD`,`ShopTechPay`,`GiftCode`,`GiftCodeBypass`,`TotalCitizens`,`TRCitizens`,`SecurityCode`,`ShopClosed`,`RimMod`,`CarVoucher`,`PVIPVoucher`, `GarageVW`, `PumpkinStock`, `HalloweenShop` FROM `misc`
[07:10:08] [Dynamic Giftbox] Successfully loaded the dynamic giftbox.
[07:10:08] [LoadCrates] Loading Crates Finished
[07:10:09] [LoadHouses] 2472 houses rehashed/loaded.
[07:10:09] [LoadDynamicDoors] 3000 doors rehashed/loaded.
[07:10:09] [LoadDynamicMapIcons] 400 map icons rehashed/loaded.
[07:10:09] [MySQL] Query Error - (ErrorID: 1146) (Handle: 1)
[07:10:09] [MySQL] Check mysql_log.txt to review the query that threw the error.
[07:10:09] Dumping query from 2014/7/2 (7:10:9)

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


[07:10:09] SELECT * FROM `mailboxes`
[07:10:09] [LoadBusinesses] 200 businesses rehashed/loaded.
[07:10:09] [MySQL] Query Error - (ErrorID: 1146) (Handle: 1)
[07:10:09] [MySQL] Check mysql_log.txt to review the query that threw the error.
[07:10:09] Dumping query from 2014/7/2 (7:10:9)

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


[07:10:09] SELECT * FROM `text_labels`
[07:10:09] [MySQL] Query Error - (ErrorID: 1146) (Handle: 1)
[07:10:09] [MySQL] Check mysql_log.txt to review the query that threw the error.
[07:10:09] Dumping query from 2014/7/2 (7:10:9)

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


[07:10:09] SELECT * FROM `plants`
[07:10:09] [MySQL] Query Error - (ErrorID: 1146) (Handle: 1)
[07:10:09] [MySQL] Check mysql_log.txt to review the query that threw the error.
[07:10:09] Dumping query from 2014/7/2 (7:10:9)

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


[07:10:09] SELECT * FROM speed_cameras
[07:10:09] [MySQL] Query Error - (ErrorID: 1146) (Handle: 1)
[07:10:09] [MySQL] Check mysql_log.txt to review the query that threw the error.
[07:10:09] Dumping query from 2014/7/2 (7:10:9)

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


[07:10:09] SELECT * FROM `paynsprays`
[07:10:09] [MySQL] Query Error - (ErrorID: 1146) (Handle: 1)
[07:10:09] [MySQL] Check mysql_log.txt to review the query that threw the error.
[07:10:09] Dumping query from 2014/7/2 (7:10:9)

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


[07:10:09] SELECT * FROM `impoundpoints`
[07:10:09] [MySQL] Query Error - (ErrorID: 1146) (Handle: 1)
[07:10:09] [MySQL] Check mysql_log.txt to review the query that threw the error.
[07:10:09] Dumping query from 2014/7/2 (7:10:9)

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


[07:10:09] SELECT * FROM `rflteams`
[07:10:09] [MySQL] Query Error - (ErrorID: 1146) (Handle: 1)
[07:10:09] [MySQL] Check mysql_log.txt to review the query that threw the error.
[07:10:09] Dumping query from 2014/7/2 (7:10:9)

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


[07:10:09] SELECT * FROM `sales` WHERE `Month` > NOW() - INTERVAL 1 MONTH
[07:10:09] [MySQL] Query Error - (ErrorID: 1146) (Handle: 1)
[07:10:09] [MySQL] Check mysql_log.txt to review the query that threw the error.
[07:10:09] Dumping query from 2014/7/2 (7:10:9)

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


[07:10:09] SELECT * FROM `shopprices`
[07:10:09] [MySQL] Query Error - (ErrorID: 1146) (Handle: 1)
[07:10:09] [MySQL] Check mysql_log.txt to review the query that threw the error.
[07:10:09] Dumping query from 2014/7/2 (7:10:9)

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


[07:10:09] SELECT * FROM `points`
[07:10:09] [MySQL] Query Error - (ErrorID: 1146) (Handle: 1)
[07:10:09] [MySQL] Check mysql_log.txt to review the query that threw the error.
[07:10:09] Dumping query from 2014/7/2 (7:10:9)

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


[07:10:09] SELECT * FROM `lockers`
[07:10:09] [MySQL] Query Error - (ErrorID: 1146) (Handle: 1)
[07:10:09] [MySQL] Check mysql_log.txt to review the query that threw the error.
[07:10:09] Dumping query from 2014/7/2 (7:10:9)

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


[07:10:09] SELECT * FROM `jurisdictions`
[07:11:13] [MySQL] Query Error - (ErrorID: 1146) (Handle: 1)
[07:11:13] [MySQL] Check mysql_log.txt to review the query that threw the error.
[07:11:13] Dumping query from 2014/7/2 (7:11:13)

Description: Table 'samp.letters' doesn't exist (index 0). Query:


[07:11:13] UPDATE `letters` SET `Delivery_Min` = `Delivery_Min` - 1 WHERE `Delivery_Min` > 0
[07:11:13] [MySQL] Query Error - (ErrorID: 1146) (Handle: 1)
[07:11:13] [MySQL] Check mysql_log.txt to review the query that threw the error.
[07:11:13] Dumping query from 2014/7/2 (7:11:13)

Description: Table 'samp.letters' doesn't exist (index 0). Query:


[07:11:13] SELECT `Receiver_Id` FROM `letters` WHERE `Delivery_Min` = 1
[07:12:18] [MySQL] Query Error - (ErrorID: 1146) (Handle: 1)
[07:12:18] [MySQL] Check mysql_log.txt to review the query that threw the error.
[07:12:18] Dumping query from 2014/7/2 (7:12:18)

Description: Table 'samp.letters' doesn't exist (index 0). Query:


[07:12:18] UPDATE `letters` SET `Delivery_Min` = `Delivery_Min` - 1 WHERE `Delivery_Min` > 0
[07:12:18] [MySQL] Query Error - (ErrorID: 1146) (Handle: 1)
[07:12:18] [MySQL] Check mysql_log.txt to review the query that threw the error.
[07:12:18] Dumping query from 2014/7/2 (7:12:18)

Description: Table 'samp.letters' doesn't exist (index 0). Query:


[07:12:18] SELECT `Receiver_Id` FROM `letters` WHERE `Delivery_Min` = 1
[07:13:23] [MySQL] Query Error - (ErrorID: 1146) (Handle: 1)
[07:13:23] [MySQL] Check mysql_log.txt to review the query that threw the error.
[07:13:23] Dumping query from 2014/7/2 (7:13:23)

Description: Table 'samp.letters' doesn't exist (index 0). Query:


[07:13:23] UPDATE `letters` SET `Delivery_Min` = `Delivery_Min` - 1 WHERE `Delivery_Min` > 0
[07:13:23] [MySQL] Query Error - (ErrorID: 1146) (Handle: 1)
[07:13:23] [MySQL] Check mysql_log.txt to review the query that threw the error.
[07:13:23] Dumping query from 2014/7/2 (7:13:23)

Description: Table 'samp.letters' doesn't exist (index 0). Query:


[07:13:23] SELECT `Receiver_Id` FROM `letters` WHERE `Delivery_Min` = 1
[07:13:39] Incoming connection: 127.0.0.1:59443
[07:13:40] [join] Nick_Percy has joined the server (0:127.0.0.1)
[07:13:40] [MySQL] Query Error - (ErrorID: 1146) (Handle: 1)
[07:13:40] [MySQL] Check mysql_log.txt to review the query that threw the error.
[07:13:40] Dumping query from 2014/7/2 (7:13:40)

Description: Table 'samp.ip_bans' doesn't exist (index 0). Query:


[07:13:40] SELECT `ip` FROM `ip_bans` WHERE `ip` = '127.0.0.1'
[07:13:43] [MySQL] Query Error - (ErrorID: 1146) (Handle: 1)
[07:13:43] [MySQL] Check mysql_log.txt to review the query that threw the error.
[07:13:43] Dumping query from 2014/7/2 (7:13:43)

Description: Table 'samp.shop_orders' doesn't exist (index 0). Query:


[07:13:43] SELECT * FROM `shop_orders` WHERE `user_id` = -1 AND `status` = 0
[07:14:16] [MySQL] Query Error - (ErrorID: 1146) (Handle: 1)
[07:14:16] [MySQL] Check mysql_log.txt to review the query that threw the error.
[07:14:16] Dumping query from 2014/7/2 (7:14:16)

Description: Table 'samp.shop_orders' doesn't exist (index 0). Query:


[07:14:16] SELECT * FROM `shop_orders` WHERE `user_id` = -1 AND `status` = 0
[07:14:28] [MySQL] Query Error - (ErrorID: 1146) (Handle: 1)
[07:14:28] [MySQL] Check mysql_log.txt to review the query that threw the error.
[07:14:28] Dumping query from 2014/7/2 (7:14:28)

Description: Table 'samp.letters' doesn't exist (index 0). Query:


[07:14:28] UPDATE `letters` SET `Delivery_Min` = `Delivery_Min` - 1 WHERE `Delivery_Min` > 0
[07:14:28] [MySQL] Query Error - (ErrorID: 1146) (Handle: 1)
[07:14:28] [MySQL] Check mysql_log.txt to review the query that threw the error.
[07:14:28] Dumping query from 2014/7/2 (7:14:28)

Description: Table 'samp.letters' doesn't exist (index 0). Query:


[07:14:29] SELECT `Receiver_Id` FROM `letters` WHERE `Delivery_Min` = 1
[07:14:51] [MySQL] Query Error - (ErrorID: 1146) (Handle: 1)
[07:14:51] [MySQL] Check mysql_log.txt to review the query that threw the error.
[07:14:51] Dumping query from 2014/7/2 (7:14:51)

Description: Table 'samp.shop_orders' doesn't exist (index 0). Query:


[07:14:51] SELECT * FROM `shop_orders` WHERE `user_id` = -1 AND `status` = 0
[07:15:00] [chat] [Nick_Percy]: yoo
[07:15:03] [part] Nick_Percy has left the server (0:1)
[07:15:34] [MySQL] Query Error - (ErrorID: 1146) (Handle: 1)
[07:15:34] [MySQL] Check mysql_log.txt to review the query that threw the error.
[07:15:34] Dumping query from 2014/7/2 (7:15:34)

Description: Table 'samp.letters' doesn't exist (index 0). Query:


[07:15:34] UPDATE `letters` SET `Delivery_Min` = `Delivery_Min` - 1 WHERE `Delivery_Min` > 0
[07:15:34] [MySQL] Query Error - (ErrorID: 1146) (Handle: 1)
[07:15:34] [MySQL] Check mysql_log.txt to review the query that threw the error.
[07:15:34] Dumping query from 2014/7/2 (7:15:34)

Description: Table 'samp.letters' doesn't exist (index 0). Query:


[07:15:34] SELECT `Receiver_Id` FROM `letters` WHERE `Delivery_Min` = 1
Reply
#2

The tables are missing, obviously. If you know you have to create them, why don't you do that?
Reply


Forum Jump:


Users browsing this thread: 1 Guest(s)