PDA

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?