View Full Version : What's wrong with my database?
Ckrismoney
06-07-2009, 11:33 PM
When I go to my home page it looks fine but when I try to view a category it says database error.
here's the link http://www.ckwikmoney.com/forumdisplay.php?f=2
What do I have to do to fix it?
HMBeaty
06-07-2009, 11:40 PM
This is your error
MySQL Error : Table './ckwikmon_ckwikmoneyforum/vb3post' is marked as crashed and should be repaired
Your vb3post table has crashed and needs repaired. If you have a recent backup, just restore that backup and it should fix your problem
Ckrismoney
06-07-2009, 11:45 PM
How do I repair it?
BSMedia
06-07-2009, 11:49 PM
There are a lot of ways to repair it the best is probably done via SSH, do you have SSH enabled/access to your database?
If not you can try to run the repair via phpMyAdmin or also in the vBulletin AdminCP
Becareful though, cause repair/optimize can not only fix your problems it can also create more.
HMBeaty
06-07-2009, 11:54 PM
Yep. Which is why you should make a database backup beforehand and regardless, you should make a backup of your database regularly. I usually make one every couple of days for right now
Ckrismoney
06-08-2009, 12:20 AM
Thanks both of you for your help.
I repaired it through the Admincp and all threads are fine except the 2 most recent threads
This is what they look like:
http://www.ckwikmoney.com/showthread.php?t=620
and
http://www.ckwikmoney.com/showthread.php?t=619
and when I try to reply just to see what happens it says "Sorry! This forum is not accepting new posts."
But I can reply to other threads in that section.
Just want to try and save a couple posts.
Lynne
06-08-2009, 01:43 AM
Sometimes you have to run repair/optimize a couple of times on the table. How many times did you run it?
vBulletin® v3.8.12 by vBS, Copyright ©2000-2025, vBulletin Solutions Inc.