Our forum crashed today and the hosting company says all is well on their end. We get an error when trying to load the forum. Here is the error:
Table './issy3/smf_messages' is marked as crashed and last (automatic?) repair failed
Any ideas?
Quote from: Cygnus on April 22, 2013, 05:18:39 PM
Our forum crashed today and the hosting company says all is well on their end. We get an error when trying to load the forum. Here is the error:
Table './issy3/smf_messages' is marked as crashed and last (automatic?) repair failed
Any ideas?
1. Any mod installed before this problem?
2. if you have access؛ check you'r error log.
Welcome to SMF! :)
Which version of SMF are you on (http://www.simplemachines.org/community/index.php?topic=502344.0)?
Do you have access to cPanel/phpMyAdmin?
We don't know which version we are running at the moment, we have no access.
We are not aware of any mods being installed recently.
We can reach our login page and get the message Cygnus posted above.
OK, cool. We'll merge the topics when we can sort out the version. :)
Back to this though:
QuoteDo you have access to cPanel/phpMyAdmin?
Does your host provide such a thing (I have to hope they do).
Our host is GoDaddy, and sadly I'm not sure if they do or not.
We have had others handling any tech issues in the past.
OK, can you ask GoDaddy to go repair that table in your database? Maybe ask them to provide such a common hosting thing as cPanel/phpMyAdmin too? :)
Just sent a service request to GoDaddy per your post.
It says to expect a reply in 9 hours.
I will update again when they reply.
Thanks for your help so far.
If your Godaddy setup is anything like mine, after you login to your Godaddy account you should have a link somewhere to Databases > SQL. From there you can access your phpmyadmin. It isn't cPanel like anybody else knows it, it's a weird custom setup.
Login -> My Account -> Web Hosting -> Launch -> Databases -> MySQL
Separate login for phpmyadmin - iirc, it's your db name and password, which is in Settings.php.
Quote from: DiverTexas on April 22, 2013, 05:33:34 PM
Our host is GoDaddy, and sadly I'm not sure if they do or not.
We have had others handling any tech issues in the past.
I really, really suggest you find another hosting site. GoDaddy.com has had some extremely bad reviews. I for one would never use them. If you PM me, i could suggest you an excellent host.
Well darn, just spent 30 minutes on the phone with GoDaddy only to be told the issue is with SMF and not the hosting.
Any ideas where to look next?
Thanks for the help so far.
Quote from: Krash. on April 22, 2013, 11:31:18 PM
Login -> My Account -> Web Hosting -> Launch -> Databases -> MySQL
Separate login for phpmyadmin - iirc, it's your db name and password, which is in Settings.php.
Can you try that?
Yes Sir, I did try that.
Apparently the user name or PW are something different.
Yep, that indeed would be the case. Krash points out that the username/password is stored in Settings.php. If you have FTP/File Manager access, you should be able to download that file and examine it for those details to get you in phpMyAdmin to repair the table.
I am currently in the setting section of my account.
Apparently I'm missing something.
Without providing any kind of sensitive information, can you provide a screen shot of what you're seeing? If the screen shot includes any kind of login/password information, blur it out if you can.
Settings.php is a file that lives in the main folder where your forum is and is essentially the brains of your site.
I'm hoping this works.
I really appreciate you trying to help us get back on line.
(https://www.simplemachines.org/community/proxy.php?request=http%3A%2F%2Fi39.photobucket.com%2Falbums%2Fe178%2Fdivertexas%2F18ce8110-12e1-489c-885a-99761be94fab_zps286c37c0.jpg&hash=fa613bb9018b6981840635dd7d9eaafbc5a6fe97)
What is on the Products tab/page? The Settings page there is for your entire account with GoDaddy (and thanks for blacking out the personal stuff).
This is what I see on the products page.
(https://www.simplemachines.org/community/proxy.php?request=http%3A%2F%2Fi39.photobucket.com%2Falbums%2Fe178%2Fdivertexas%2Fissy2_zps91f4806f.png&hash=0c99e44c64319e7e9214869ad48074c9fb36a0dd)
What is on the Web Hosting page next?
This is the web hosting screen shot.
(https://www.simplemachines.org/community/proxy.php?request=http%3A%2F%2Fi39.photobucket.com%2Falbums%2Fe178%2Fdivertexas%2Fissy3_zps10582d19.jpg&hash=dca92f9c6e4c3564cd0b7224e11c0026ec98bc4b)
Interesting. I don't see anything regarding FTP. Wondering if you can call GoDaddy back and ask where that option is in their hosting environment?
I found that there was a place to update for SMF.
I have submitted that request.
I'll keep my fingers crossed that will help.
(https://www.simplemachines.org/community/proxy.php?request=http%3A%2F%2Fi39.photobucket.com%2Falbums%2Fe178%2Fdivertexas%2Fissy4_zps0c8c0136.jpg&hash=d2e5f472e1cb24077073ce0ec2d97cf37a3598b1)
I'm going to strongly suggest NOT to use that area to update SMF. SMF has a place for that in the main Admin area.
Hopefully when you get some sort of FTP/File Manager access, you'll be able to determine your database credentials. :)
Darn it, I submitted the request already.
I had been doing updates through the admin panel when we could access the site.
Found this, maybe something here to work with?
(https://www.simplemachines.org/community/proxy.php?request=http%3A%2F%2Fi39.photobucket.com%2Falbums%2Fe178%2Fdivertexas%2Fissy5_zpsbdf37031.png&hash=3cce008516d2e9b7b5548071ce606b116ed51100)
That's File Manager! Sweet. OK. In the forum folder (assuming that's the place where SMF is), you can find Settings.php. Download that to your computer and use Notepad (Notepad++ is better) and look for these things:
Quote$db_user = 'USERNAMEHERE';
$db_passwd = 'PASSWORDHERE';
You'll also see this:
Quote$db_name = 'DATABASENAME';
That will let you know which database to look for after you login using phpMyAdmin.
I found the user name and the password I believe.
It does show that this is where the SMF files are.
Cool...now off to that tab labeled phpMyAdmin. Use those credentials to get in there.
This might help you in that part:
http://php.about.com/od/mysqladministration/qt/repair_mysql.htm
Sorry I'm so unfamiliar with this.
I'm not finding the phpmyadmin.
This is what I see.
(https://www.simplemachines.org/community/proxy.php?request=http%3A%2F%2Fi39.photobucket.com%2Falbums%2Fe178%2Fdivertexas%2Fissy6_zps5e0fd26a.jpg&hash=6e026ed1c57523566bda7d57896070c81fc22031)
Quote from: DiverTexas on April 23, 2013, 08:38:48 AM
This is the web hosting screen shot.
(https://www.simplemachines.org/community/proxy.php?request=http%3A%2F%2Fi39.photobucket.com%2Falbums%2Fe178%2Fdivertexas%2Fissy3_zps10582d19.jpg&hash=dca92f9c6e4c3564cd0b7224e11c0026ec98bc4b)
The last tab in your browser window here is labeled phpMyAdmin. That's the place to go next. :)
I wish I could remember how I got there.
I have about 30 browsers open now.
I will shut most of them down and try to figure out how I got there before.
QuoteError
#1045 - Access denied for user XXXXXXXXXXXXXXX (using password: YES)
I'm using the password and username that is in the database info code.
Man, what a bummer! Last resort is to call GoDaddy technical support and ask them to repair that database for you.
Mashby, your help is greatly appreciated.
I will follow up with Godaddy and see if we can get it up and running again.
Many thanks to all who offered suggestions too.
Quote from: Krash. on April 22, 2013, 11:31:18 PM
Login -> My Account -> Web Hosting -> Launch -> Databases -> MySQL
If you've gotten this far, you click on 'phpmyadmin' and get a login screen. You use your
$db_name and
$db_passwd from
Settings.php to login. If it doesn't work, there's a way to reset or change the db password, but don't remember where it is. Should be somewhere on the GoDaddy MySQL page. If you change the pw, you must update
Settings.php to the new pw.
It gets confusing because GoDaddy databases are at a different domain (GoDaddy apparently outsources their db storage), that's why there's a separate login.
@DiverTexas,
I'm with Go Daddy and came across your post.
Have you been able to repair your database and get your site back up and working?
If not I would like to assist you further and help you get your site back up and running. Please feel free to reply or send me a private message with additional details on your site.
The same problem with my smf forum and Godaddy shared hosting.
I copy you the sequence of my frustration with the technical support.
Me:
Hi. I have problems with my website. The database with Hostname xxxxxxx.hostedresource.com is not working. I get the error:
"Table 'smf_messages' is marked as crashed and last (automatic?) repair failed". I have tried to repair the table by phpMyAdmin but I get the error: "#2006 - MySQL server has gone away".
Could you help me to solve this problem?
Support Staff Response:
Thank you for contacting Online Support. To trouble shoot this further can we have screen shots of the errors you are encountering, the exact error messages being received, the call-in PIN associated with your account, and permission to change the password on the database and make modifications if needed.
Me:
My PIN is xxxx and you have permission to change the password on the database and make modifications if needed.
You can visit the domain and see the error message by yourself.
The problem is with the table smf_messages in the database xxxxxx.hostedresource.com. This table is marked as crashed and I cannot repair it with phpmyadmin because I get the error "#2006 - MySQL server has gone away".
I think you can try to repair it from SSH.
Support Staff Response:
Thank you for contacting Online Support. I have reviewed your MySQL database and we have attempted a manual repair on the database, but we lost connection to the MySQL server during query. At this point, you will need to review the table and database to ensure that the size isn't too big for phpMyAdmin to repair it.
For more database information, you may visit:.......
Me:
I cannot review the database because it is in your server. You can try to repair the database from SSH very easily:
supportfacility.com/blog/mysql/how-to-repair-mysql-table-from-ssh/
Please, contact with someone who knows how. This is not the first problem with SMF Forums as you can see here:
http://www.simplemachines.org/community/index.php?topic=502343.0
If you don't solve this problem I'll lose my entire forum.
Support Staff Response:
Thank you for your reply. You can download a copy of the database to view/edit locally and restore after you are finished. I have included instructions below on how to backup and restore the database for your convenience:
Backing up a MySQL or MSSQL Database
You can back up MySQL and MSSQL databases from the Database section of the Control Panel in your hosting account. etc...
Me:
I tried to restore the database but is not possible. I get only a file in the _db_backups directory with the next text:
-- MySQL dump 10.13 Distrib 5.5.19, for Linux (x86_64)
--
-- Host: xxxxxx Database: xxxxxxx
-- ------------------------------------------------------
-- Server version 4.1.24-log
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
Please, you could try the next (I promise, it's very easy but you need someone with root privileges on the server):
Login to your server as root.
Firstly check the status of MySQL on your dedicated server. Normally, it should be ok – as you're getting this error.
The database table can be repaired only if the Mysql server is in running status. You can check the status by the command.
root# /etc/init.d/myssql status
Now, login to the MySQL database for a required user.
mysql> mysql –u databaseusername –p database password databasename
You need to select that particular database having problem.
mysql> use databasename;
Now, you will have to check whether the table is corrupted. On giving the below command you will get a NULL value as your output if it is corrupted otherwise it's alright.
mysql> check table tablename;
If the table is corrupted for that particular database, then you need
to repair the table by giving the following command.
mysql> repair table tablename;
This will repair the table for you.
----
So... I am here waiting the tech support to try the SSH solution (if they can find someone with root privileges).
Godaddy refuses to repair the database using SSH despite being the way to go. This is the response to a VIP customer that has spent a decade with them:
In order to successfully restore your hosting account, we will need the Following information.
Please Clearly state Restore That You accept the fee of $ 150.00 (USD).
Quote from: Encabronado on May 06, 2013, 10:45:13 PM
Godaddy refuses to repair the database using SSH despite being the way to go. This is the response to a VIP customer that has spent a decade with them:
In order to successfully restore your hosting account, we will need the Following information.
Please Clearly state Restore That You accept the fee of $ 150.00 (USD).
I am not sure which hosting plan you're on but I use the Godaddy Deluxe plan which is like $7 a month. Anyway a few weeks ago my forum was hacked and all data was wiped I was left with a blank forum that I couldn't log into. I didn't have a backup. Thankfully, I was able to restore everything database and FTP directory back to one day earlier with godaddy for free. You should have access to this service as well, I didn't pay for it. It's a bit tricky to find but it's there in file manager. Call support and they should be able to help you. Contrary to many posters I am very satisfied with godaddy.
@Encabronado,
Thanks for your message and patience with my reply as I have been out of the office.
I was able to locate your ticket with support and the database issue should be resolved. You may wish to consider creating a new database with MySQL 5.0 and adding your data there. Feel free to reply or email me directly with any additional information.
Thank you very much, Ken. It solved the problem satisfactorily. Everyone on the support team should be like you.