MySQL Internal Error

[Moneyman]

MyBB has experienced an internal SQL error and cannot continue.

SQL Error:
1146 - Table 'webmaste_mybb.mybb_adminlog' doesn't exist
Query:
SELECT COUNT(l.dateline) AS count FROM mybb_adminlog l LEFT JOIN mybb_users u ON (u.uid=l.uid) WHERE 1=1

This is what I get when I look at the admin logs.

MyBB has experienced an internal SQL error and cannot continue.

SQL Error:
1146 - Table 'webmaste_mybb.mybb_adminlog' doesn't exist
Query:
INSERT INTO mybb_adminlog (`uid`,`ipaddress`,`dateline`,`module`,`action`,`data`) VALUES ('1','173.245.62.63','1360992735','user-users','edit','a:2:{i:0;s:1:\"7\";i:1;s:9:\"Aliva Dua\";}')

Please contact the MyBB Group for support.

This is what I get when I try to edit one of my users. The admin logs don't exist, it says. Before it worked normally, but I'm thinking that when our forum got hacked, our "hacker" took out the adminlog table. Now, what I'm trying to ask is how do I fix this? Do I merge a fresh database or...?

 

[meSingh]

First get into your hosts PHPmyadmin and see if there is that table or not. In case it is not there then do a fresh installation of mybb somewhere on your localhost or anywhere. Then just backup that table only and import it back to your forum. It should work then.

If this do not work and you are not good with mysql then get a professional to do it for you.

 

[Moneyman]

Thanks meSingh, but thank god my host had a copy of my table in my previously hosted server so he moved it there 🙂

 

[meSingh]

Thanks meSingh, but thank god my host had a copy of my table in my previously hosted server so he moved it there 🙂

That`s good! 🙂

Can`t believe i forgot about that 😛 I too have a account with HawkHost, but just forgot about this.

 

[Moneyman]

Exactly mate, this is solved!