vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vB3 General Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=111)
-   -   Please help!!!! (https://vborg.vbsupport.ru/showthread.php?t=160458)

Jason Black 10-17-2007 06:13 PM

Please help!!!!
 
Click this link
www.rapfeinds.com

It says
Database error
The www.Rapfeinds.com database has encountered a problem.

--------------------------------------------------------------------------------

Please try the following:
Load the page again by clicking the Refresh button in your web browser.
Open the rapfeinds.com home page, then try to open another page.
Click the Back button to try another link.

The rapfeinds.com forum technical staff have been notified of the error, though you may contact them if the problem persists.

We apologise for any inconvenience.

i have no idea what that is

Paul M 10-17-2007 06:15 PM

MySQL Error : Table './rapfeind_sitemagixprod/user' is marked as crashed and should be repaired

You need to repair your user table - you will need to do that via phpmyadmin.

Jason Black 10-17-2007 06:17 PM

it doesn't say that though

SCRIPT3R 10-17-2007 06:18 PM

Quote:

Originally Posted by Jason Black (Post 1362536)
it doesn't say that though

try unplugging the server then... actually, it DOES say that. you asked for help and you got it, why not just try doing what he suggested?

Code:

<!--
Database error in vBulletin 3.6.8:

Invalid SQL:

                        SELECT * FROM user FORCE INDEX (lastactivity)
                        WHERE lastactivity &gt; 1192600800 ORDER BY username;

MySQL Error  : Table './rapfeind_sitemagixprod/user' is marked as crashed and should be repaired
Error Number : 145
Date        : Wednesday, October 17th 2007 @ 02:18:33 PM
Script      : http://www.rapfeinds.com/
Referrer    : https://vborg.vbsupport.ru/showthread.php?p=1362537
IP Address  : ...
Username    : Unregistered
Classname    : vB_Database
-->


Jason Black 10-17-2007 06:20 PM

nah the only reason why i said that is because i don't know how to do it lol....i was hoping he could tell me how to get there. i mean, i know how to get the phpmyadmin, but where do i go afterwards

SCRIPT3R 10-17-2007 06:29 PM

oh... from myadmin, just bring up your database in question, select that table or tables in question, and you should see a drop-down menu to fix and repair tables. do that.

Jason Black 10-17-2007 06:37 PM

thank you guys...i appreciate the help, now it works

wally 11-03-2007 03:33 PM

Does anyone know the command line for this ?? (i dont have a phpadmin)

Lynne 11-03-2007 04:48 PM

You can repair/optimize in your Admin CP also.

A couple of useful links:
http://www.vbulletin.com/docs/html/m..._repair_tables
http://dev.mysql.com/doc/refman/5.0/...nance-sql.html

snakes1100 11-03-2007 06:27 PM

Quote:

Originally Posted by wally (Post 1374890)
Does anyone know the command line for this ?? (i dont have a phpadmin)

What type of shell access do you have and is this a dedicated/vps/vhost server?

If you have a dedicated/vps server, you can do the following:

1. cd to database folder or type the entire path into the command

typical install of mysql: cd /var/lib/mysql/dbnamehere
myisamchk -r *
myisamchk -o *
myisamchk -r /path/to/db/folder/ *
myisamchk -o /path/to/db/folder/ *

myisamchk --help (will list the switches and their meanings)

2. on a vhost server with improper permissions, you wont be able to run those commands, so i will not get into that.


All times are GMT. The time now is 10:28 PM.

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.01216 seconds
  • Memory Usage 1,737KB
  • 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
  • (1)bbcode_code_printable
  • (2)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (1)pagenav_pagelink
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (10)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
  • pagenav_page
  • pagenav_complete
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete