Database and config error/will pay to fix

[revmitchell]

I have a database and config error. I will be glad to pay someone fix this.


www.pastors-source.com

The config errror is probably simple I just have missed the error in the config,php file i am sure and the database error is:

Database error in vBulletin 3.7.0:

Invalid SQL:

SELECT text, languageid, special
FROM phrase AS phrase
LEFT JOIN phrasetype USING (fieldname)
WHERE phrase.fieldname = 'frontredirect'
AND varname = 'login' AND languageid IN (-1, 0, 1);

MySQL Error : Table './vb/phrase' is marked as crashed and should be repaired
Error Number : 145
Request Date : Thursday, May 29th 2008 @ 01:31:52 PM
Error Date : Thursday, May 29th 2008 @ 01:31:53 PM
Script : http://www.pastors-source.com/vb/login.php?do=login
Referrer : http://www.pastors-source.com/vb/forums.php
IP Address : 97.100.161.197
Username : Revmitchell
Classname : vB_Database
MySQL Version : 5.0.45-community

All this occured as a result of an attempted upgrade to 3.7.1

[Marco van Herwaarden]

Well nobody will be able to help you if you don't provide the details of these errors.

If you want to pay someone to have your problems fixed, then please post in Requests For Paid Services

[Opserty]

For your database error, you can see if my reply to this thread works. (Changing 'post' to 'phrase')

[Marco van Herwaarden]

To fix this run Repair/Optimize in the Admin CP. You may need to run it more than once to fix all errors:

Admin CP -> Maintenance -> Repair/Optimize Tables -> Check All -> Continue

If you can not access your AdminCP, then you can upload the tools.php file from the vbulletin .zip file do_not_upload/ folder into your forumdir/admincp/ directory and run it through the browser, there's a switch there to run optimize and repair. Run it a few times for best result.

If you cannot access either the Admin CP or tools.php you can also use a tool like phpMyAdmin to repair tables.

[revmitchell]

Originally Posted by Opserty

For your database error, you can see if my reply to this thread works. (Changing 'post' to 'phrase')

Before I messed up the config file when I tried to get into the admincp I couldnt because the whole page displyed the datbase error.

--------------- Added [DATE]1212148405[/DATE] at [TIME]1212148405[/TIME] ---------------

Originally Posted by Marco van Herwaarden

To fix this run Repair/Optimize in the Admin CP. You may need to run it more than once to fix all errors:

Admin CP -> Maintenance -> Repair/Optimize Tables -> Check All -> Continue

If you can not access your AdminCP, then you can upload the tools.php file from the vbulletin .zip file do_not_upload/ folder into your forumdir/admincp/ directory and run it through the browser, there's a switch there to run optimize and repair. Run it a few times for best result.

If you cannot access either the Admin CP or tools.php you can also use a tool like phpMyAdmin to repair tables.

The databse error stops me from getting into admincp

[Opserty]

Please Marco's response fully...

[revmitchell]

Originally Posted by Opserty

Please Marco's response fully...

I see. I have tried to repair the table that is marked crash in phpmyadmin but it doesn't seem to work

[Marco van Herwaarden]

Often you will need to run the repair 2 or 3 times.

If it doesn't work, what error message do you get now?