vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vB3 Programming Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=15)
-   -   Database and config error/will pay to fix (https://vborg.vbsupport.ru/showthread.php?t=181004)

revmitchell 05-30-2008 10:32 AM

Database and config error/will pay to fix
 
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:

Quote:

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

Opserty 05-30-2008 10:41 AM

For your database error, you can see if my reply to this thread 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

Quote:

Originally Posted by Opserty (Post 1536091)
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] ---------------

Quote:

Originally Posted by Marco van Herwaarden (Post 1536100)
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

Quote:

Originally Posted by Opserty (Post 1536120)
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?


All times are GMT. The time now is 04:19 AM.

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.02292 seconds
  • Memory Usage 1,730KB
  • Queries Executed 10 (?)
More Information
Template Usage:
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (4)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (8)printthreadbit
  • (1)spacer_close
  • (1)spacer_open 

Phrase Groups Available:
  • global
  • postbit
  • showthread
Included Files:
  • ./printthread.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/class_bbcode_alt.php
  • ./includes/class_bbcode.php
  • ./includes/functions_bigthree.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • printthread_start
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete