MySQL Related HELP Plz help!
#1

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)
Reply
#2

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.
Reply
#3

I knew it!, I was thinking this to create those database

EDIT: How to create those database queries?? Please help!
Reply
#4

BUMPPPPPPPPPPPPPPPPPPPPPPPPPPPPPPPPPP
Reply
#5

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!
http://php.about.com/od/learnmysql/ss/create_tables.htm
Reply


Forum Jump:


Users browsing this thread: 2 Guest(s)