SQL error

[shozy]

hi guyzz i am having problem in my forum admincp

it looks like this :

Please try the following:
Load the page again by clicking the Refresh button in your web browser.
Open the www.forum.rushlush.com home page, then try to open another page.
Click the Back button to try another link.
The www.forum.rushlush.com forum technical staff have been notified of the error, though you may contact them if the problem persists.

We apologise for any inconvenience.

Database error in vBulletin 4.0.2:

Invalid SQL:

SELECT adminmessage.adminmessageid
FROM adminmessage AS adminmessage
INNER JOIN adminlog AS adminlog ON (adminlog.script = adminmessage.script AND adminlog.action = adminmessage.action)
WHERE adminmessage.status = 'undone'
AND adminmessage.script <> ''
AND adminlog.dateline > adminmessage.dateline
GROUP BY adminmessage.adminmessageid;

MySQL Error : Table 'sadiaforum.adminlog' doesn't exist
Error Number : 1146
Request Date : Wednesday, March 17th 2010 @ 11:43:35 AM
Error Date : Wednesday, March 17th 2010 @ 11:43:35 AM
Script : http://www.forum.rushlush.com/admincp/index.php?do=home
Referrer : http://www.forum.rushlush.com/admincp/
IP Address : 78.15.229.44
Username : ╰☆╮♡ Sh?zу ♡╰☆╮
Classname : vB_Database
MySQL Version : 5.0.51a-log

What i have to do for solve it please help

[borbole]

Originally Posted by shozy

hi guyzz i am having problem in my forum admincp

it looks like this :

Please try the following:
Load the page again by clicking the Refresh button in your web browser.
Open the www.forum.rushlush.com home page, then try to open another page.
Click the Back button to try another link.
The www.forum.rushlush.com forum technical staff have been notified of the error, though you may contact them if the problem persists.

We apologise for any inconvenience.



What i have to do for solve it please help

According to the error you have a missing db table (adminlog). try to recreate it and see fi that would help.

[shozy]

please tell me the whole process

where i go for make new table ?? please

[borbole]

Originally Posted by shozy

please tell me the whole process

where i go for make new table ?? please

You can see the syntax for the creating of the db tables at the mysql-schema.php file in the /install/ folder. Whereas the query can be run at the SQL box in the phpmyadmin in the cp of your db. Make sure to select the db name that your forum resides on though.