MySQL Related HELP Plz help! - Printable Version
+- SA-MP Forums Archive (https://sampforum.blast.hk)
+-- Forum: SA-MP Scripting and Plugins (https://sampforum.blast.hk/forumdisplay.php?fid=8)
+--- Forum: Scripting Help (https://sampforum.blast.hk/forumdisplay.php?fid=12)
+--- Thread: MySQL Related HELP Plz help! (/showthread.php?tid=519776)
+- SA-MP Forums Archive (https://sampforum.blast.hk)
+-- Forum: SA-MP Scripting and Plugins (https://sampforum.blast.hk/forumdisplay.php?fid=8)
+--- Forum: Scripting Help (https://sampforum.blast.hk/forumdisplay.php?fid=12)
+--- Thread: MySQL Related HELP Plz help! (/showthread.php?tid=519776)
MySQL Related HELP Plz help! - ZombieNest - 15.06.2014
Whenever I start my server, It starts and loads up and connects to the database, When the script files are loading from MySQL They gave me errors and I cant even spawn/register, when I connect it stucks at looking my account at the database.
Errors:
Код:
[22:11:15] [MySQL] Query Error - (ErrorID: 1146) (Handle: 1) [22:11:15] [MySQL] Check /logs/querydump.log to review the query that threw the error. [22:11:15] Dumping query from 2014/6/15 (22:11:15) Description: Table 'Kevin_Hendrews_NCRP.misc' doesn't exist (index 0). Query: [22:11:15] SELECT `gMOTD`,`aMOTD`,`vMOTD`,`cMOTD`,`pMOTD`,`ShopTechPay` FROM `misc` [22:11:15] [MySQL] Query Error - (ErrorID: 1146) (Handle: 1) [22:11:15] [MySQL] Check /logs/querydump.log to review the query that threw the error. [22:11:15] Dumping query from 2014/6/15 (22:11:15) Description: Table 'Kevin_Hendrews_NCRP.accounts' doesn't exist (index 0). Query: [22:11:15] UPDATE `accounts` SET `Online` = 0 WHERE `Online` = 1 [22:11:15] [MySQL] Query Error - (ErrorID: 1146) (Handle: 1) [22:11:15] [MySQL] Check /logs/querydump.log to review the query that threw the error. [22:11:15] Dumping query from 2014/6/15 (22:11:15) Description: Table 'Kevin_Hendrews_NCRP.houses' doesn't exist (index 0). Query: [22:11:15] SELECT * FROM `houses` [22:11:15] [MySQL] Query Error - (ErrorID: 1146) (Handle: 1) [22:11:15] [MySQL] Check /logs/querydump.log to review the query that threw the error. [22:11:15] Dumping query from 2014/6/15 (22:11:15) Description: Table 'Kevin_Hendrews_NCRP.ddoors' doesn't exist (index 0). Query: [22:11:15] SELECT * FROM `ddoors` [22:11:15] [MySQL] Query Error - (ErrorID: 1146) (Handle: 1) [22:11:15] [MySQL] Check /logs/querydump.log to review the query that threw the error. [22:11:15] Dumping query from 2014/6/15 (22:11:15) Description: Table 'Kevin_Hendrews_NCRP.dmapicons' doesn't exist (index 0). Query: [22:11:15] SELECT * FROM `dmapicons` [22:11:15] [MySQL] Query Error - (ErrorID: 1146) (Handle: 1) [22:11:15] [MySQL] Check /logs/querydump.log to review the query that threw the error. [22:11:15] Dumping query from 2014/6/15 (22:11:15) Description: Table 'Kevin_Hendrews_NCRP.dtexts' doesn't exist (index 0). Query: [22:11:15] SELECT * FROM `dtexts` [22:11:38] Incoming connection: 192.168.0.100:49785 [22:11:39] [join] Kevin_Hendrews has joined the server (0:192.168.0.100) [22:11:39] [MySQL] Query Error - (ErrorID: 1146) (Handle: 1) [22:11:39] [MySQL] Check /logs/querydump.log to review the query that threw the error. [22:11:39] Dumping query from 2014/6/15 (22:11:39) Description: Table 'Kevin_Hendrews_NCRP.accounts' doesn't exist (index 0). Query: [22:11:39] SELECT `Username` FROM `accounts` WHERE `Username` = 'Kevin_Hendrews' [22:12:53] [chat] [Kevin_Hendrews]: 5/4365345 [22:12:55] [part] Kevin_Hendrews has left the server (0:1) [22:13:29] Incoming connection: 192.168.0.100:61652 [22:13:29] [join] Kevin_Hendrew has joined the server (0:192.168.0.100) [22:13:30] [MySQL] Query Error - (ErrorID: 1146) (Handle: 1) [22:13:30] [MySQL] Check /logs/querydump.log to review the query that threw the error. [22:13:30] Dumping query from 2014/6/15 (22:13:30) Description: Table 'Kevin_Hendrews_NCRP.accounts' doesn't exist (index 0). Query: [22:13:30] SELECT `Username` FROM `accounts` WHERE `Username` = 'Kevin_Hendrew' Console input: ok Console input: SELECT `Username` from Console input: select [22:25:43] [chat] [Kevin_Hendrew]: q [22:25:44] [chat] [Kevin_Hendrew]: wt [22:25:46] [chat] [Kevin_Hendrew]: tw [22:25:48] [chat] [Kevin_Hendrew]: ttttttttttttttttttttttttttttttttttttt [22:25:53] [chat] [Kevin_Hendrew]: ttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttt [22:26:06] [part] Kevin_Hendrew has left the server (0:1)
Re : MySQL Related HELP Plz help! - S4t3K - 15.06.2014
I think all the errors are fully explicit : all the tables you are looking for through your queries don't exist in your database (I think it's Kevin_Hendrews_NCRP).
Create all the tables with all the necessaries fields and you won't see problems or errors any more.
It's common sense.
Re: MySQL Related HELP Plz help! - ZombieNest - 16.06.2014
I knew it!, I was thinking this to create those database
EDIT: How to create those database queries?? Please help!
Re: MySQL Related HELP Plz help! - ZombieNest - 16.06.2014
BUMPPPPPPPPPPPPPPPPPPPPPPPPPPPPPPPPPP
Re: MySQL Related HELP Plz help! - Cutt3r - 16.06.2014
Quote:
|
Originally Posted by ZombieNest
 I knew it!, I was thinking this to create those database
EDIT: How to create those database queries?? Please help! |