PDA

View Full Version : Database and config error/will pay to fix

revmitchell
05-30-2008, 10:32 AM
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
05-30-2008, 10:33 AM
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 (https://vborg.vbsupport.ru/forumdisplay.php?f=30)
Opserty
05-30-2008, 10:41 AM
For your database error, you can see if my reply to this thread (https://vborg.vbsupport.ru/showthread.php?t=181002) works. (Changing 'post' to 'phrase')
Marco van Herwaarden
05-30-2008, 10:52 AM
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
05-30-2008, 10:52 AM
For your database error, you can see if my reply to this thread (https://vborg.vbsupport.ru/showthread.php?t=181002) 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 1212148405 at 1212148405 ---------------

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
05-30-2008, 11:20 AM
Please Marco's response fully...
revmitchell
05-30-2008, 11:33 AM
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
05-31-2008, 07:38 AM
Often you will need to run the repair 2 or 3 times.

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