vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vB3 General Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=111)
-   -   Site down after repair and optimizing tables (https://vborg.vbsupport.ru/showthread.php?t=280175)

Xplosive60 03-16-2012 04:55 PM

Site down after repair and optimizing tables
 
1 Attachment(s)
Received this error and site went down.

Database error in vBulletin 3.8.4:

Invalid SQL:
REPAIR TABLE `attachment`;

MySQL Error : Query execution was interrupted
Error Number : 1317
Request Date : Saturday, March 17th 2012 @ 12:10:10 AM
Error Date : Saturday, March 17th 2012 @ 12:11:47 AM
Script : hxxp://xxxxxxxxx/admincp/repair.php?do=dorepair
Referrer : hxxp://xxxxxxxxx/admincp/repair.php?do=
IP Address : xxxxxxxxxx
Username : xxxxxxxxxx
Classname : vB_Database
MySQL Version : 5.1.53

I have recently migrated from a linux shared server to a windows cloud hosting server and has been a nitemare since.
Also found attached errors ...
Any ideas?

King Justice 03-16-2012 08:55 PM

Can you try and repair and optimize the entire database and all it's tables in your server control panel or at least in phpMyAdmin?

Simon Lloyd 03-16-2012 10:34 PM

Don't do the entire database, just the ones that show in use (normally corrupt or crashed, if none show in use or corrupt then repair any that you had a database error for), if you cannot repair a crashed table you will need to get your host to search via ssh for the .TMD of that table and delete it, you will then be able to repair it.

Xplosive60 03-18-2012 02:35 PM

Sorry but i can't find anywhere to access these things. I'm new to this WebsitePanel
Can't find my.cnf file, there is no ect. folder. Site been down 3 days now and server saying it's a vbull issue..... sigh

kh99 03-18-2012 02:43 PM

I'm not familiar with WebsitePanel - I searched and found doc but didn't see anything about databases. Do you have any way to see your database (outside of vbulletin)?

Xplosive60 03-18-2012 03:31 PM

No i can't find any way to access database at all.

Simon Lloyd 03-18-2012 03:35 PM

Its a Dot Net Panel, check here http://support.othellotech.net/kb/in...d=448&relid=42

Xplosive60 03-18-2012 04:52 PM

Yes, when i do that is when i get the error.

kh99 03-19-2012 02:21 PM

Quote:

Originally Posted by Xplosive60 (Post 2310690)
Yes, when i do that is when i get the error.


Which error? In the first post you included an error that's from vbulletin so I don't understand why you'd get that error from phpMyAdmin. In any case, maybe you should contact your host and tell them you need to repair the database but you don't know how.

Xplosive60 03-19-2012 04:30 PM

The errors come when i try to get into databse. The host has finally fixed it but i don't know how or where. I have moved my attachments to file system to take the load off the database. I think that may have been root of the problem. Thanks for your help guys.


All times are GMT. The time now is 08:31 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.01367 seconds
  • Memory Usage 1,726KB
  • 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_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (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
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete