MYSQL,Tables question gamemode
#1

Hey guys so a friend of mine gaved me a gamemode based on role play

now there is a mysql in it and it tried to run it but it gives me so damm much things about the tables..


Quote:

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

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


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

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


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

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


[12:14:10] SELECT * FROM `giftbox`
[12:14:10] [MySQL] Query Error - (ErrorID: 1146) (Handle: 1)
[12:14:10] [MySQL] Check mysql_log.txt to review the query that threw the error.
[12:14:10] Dumping query from 2014/12/22 (12:14:10)

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


[12:14:10] SELECT * FROM `crates`
[12:14:10] [MySQL] Query Error - (ErrorID: 1146) (Handle: 1)
[12:14:10] [MySQL] Check mysql_log.txt to review the query that threw the error.
[12:14:10] Dumping query from 2014/12/22 (12:14:10)

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


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

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


[12:14:10] SELECT * FROM `ddoors`
[12:14:10] [MySQL] Query Error - (ErrorID: 1146) (Handle: 1)
[12:14:10] [MySQL] Check mysql_log.txt to review the query that threw the error.
[12:14:10] Dumping query from 2014/12/22 (12:14:10)

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


[12:14:10] SELECT * FROM `dmapicons`
[12:14:10] [MySQL] Query Error - (ErrorID: 1146) (Handle: 1)
[12:14:10] [MySQL] Check mysql_log.txt to review the query that threw the error.
[12:14:10] Dumping query from 2014/12/22 (12:14:10)

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


[12:14:10] SELECT * FROM `mailboxes`
[12:14:10] [MySQL] Query Error - (ErrorID: 1146) (Handle: 1)
[12:14:10] [MySQL] Check mysql_log.txt to review the query that threw the error.
[12:14:10] Dumping query from 2014/12/22 (12:14:10)

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


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

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


[12:14:10] SELECT * FROM `auctions`
[12:14:10] [MySQL] Query Error - (ErrorID: 1146) (Handle: 1)
[12:14:10] [MySQL] Check mysql_log.txt to review the query that threw the error.
[12:14:10] Dumping query from 2014/12/22 (12:14:10)

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


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

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


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

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


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

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


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

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


[12:14:10] SELECT * FROM `arrestpoints`
[12:14:10] [MySQL] Query Error - (ErrorID: 1146) (Handle: 1)
[12:14:10] [MySQL] Check mysql_log.txt to review the query that threw the error.
[12:14:10] Dumping query from 2014/12/22 (12:14:10)

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


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

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


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

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


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

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


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

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


[12:14:10] SELECT * FROM `businesssales`
[12:14:10] [MySQL] Query Error - (ErrorID: 1146) (Handle: 1)
[12:14:10] [MySQL] Check mysql_log.txt to review the query that threw the error.
[12:14:10] Dumping query from 2014/12/22 (12:14:10)

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


[12:14:10] SELECT * FROM `gates`
[12:14:10] [MySQL] Query Error - (ErrorID: 1146) (Handle: 1)
[12:14:10] [MySQL] Check mysql_log.txt to review the query that threw the error.
[12:14:10] Dumping query from 2014/12/22 (12:14:10)

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


[12:14:10] SELECT * FROM `families`
[12:14:10] [MySQL] Query Error - (ErrorID: 1146) (Handle: 1)
[12:14:10] [MySQL] Check mysql_log.txt to review the query that threw the error.
[12:14:10] Dumping query from 2014/12/22 (12:14:10)

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


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

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


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

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


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

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


[12:14:10] SELECT * FROM `groups`
[12:14:10] [MySQL] Query Error - (ErrorID: 1146) (Handle: 1)
[12:14:10] [MySQL] Check mysql_log.txt to review the query that threw the error.
[12:14:10] Dumping query from 2014/12/22 (12:14:10)

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


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

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


[12:14:10] SELECT * FROM `jurisdictions`
[12:14:10] [MySQL] Query Error - (ErrorID: 1146) (Handle: 1)
[12:14:10] [MySQL] Check mysql_log.txt to review the query that threw the error.
[12:14:10] Dumping query from 2014/12/22 (12:14:10)

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


if anyone can help me out with this i realy appreciate it.

i'm kinda noob in mysql


sorry for the bad english language
Reply
#2

Ask your friend for the .sql file, otherwise you'll have to make it yourself.
Reply


Forum Jump:


Users browsing this thread: 1 Guest(s)