Textpattern CMS

#1 2009-11-03 07:49:22

jeff r

New Member

Registered: 2008-07-09

Posts: 5

Error: Tables marked as crashed and should be repaired

Hi. My site gets these warning errors at the top of the home page:

Warning: Table ‘./agwater_agwater2/txp_log’ is marked as crashed and should be repaired select host from txp_log where ip=‘24.130.48.45’ limit 1 in /home/agwater/public_html/txp/textpattern/lib/txplib_db.php on line 81

Warning: Table ‘./agwater_agwater2/txp_log’ is marked as crashed and should be repaired insert into txp_log Warnin=now(),page=’/txp/index.php’,ip=‘24.130.48.45’,host=‘c-24-130-48-45.hsd1.ca.comcast.net’,refer=’‘,status=‘200’,method=‘GET’ in/home/agwater/public_html/txp/textpattern/lib/txplib_db.php on line 81

The site is at:

http://agwaterstewards.org/txp/index.php

Unfortunately I don’t know php so I have no idea what to do. I can find the relevant files on the server, and I’m capable of cutting and pasting a fix if someone can help me. Or I’d be happy to hire someone to figure this out. I designed the thing, but the client needs a technical person to help them with it, probably on an ongoing basis, if anyone’s interested in some small potatoes work.

#2 2009-11-03 11:23:52

uli

Moderator

From: Cologne

Registered: 2006-08-15

Posts: 4,306

Re: Error: Tables marked as crashed and should be repaired

Login in PHPmyAdmin (required data in config.php in the “textpattern” folder), select the database txp saves to. Now you see a table with all database tables listed. Click “Select all” below that table, from the menu right from there you select “Repair table”. That’s all.

---

_{In bad weather I never leave home without wet_plugout, smd_where_used and adi_form_links}

#3 2009-11-03 18:28:17

jeff r

New Member

Registered: 2008-07-09

Posts: 5

Re: Error: Tables marked as crashed and should be repaired

Help! I did exactly what you said, very easy, and the db repaired okay, with the exception that it said the log had one fewer lines of code now.

BUT the whole site page is now blank and says simply “Database unavailable” —at least before the site was up. Help, my client’s coming over in an hour!

#4 2009-11-03 18:53:48

jeff r

New Member

Registered: 2008-07-09

Posts: 5

Re: Error: Tables marked as crashed and should be repaired

Fixed! Whew, sorry I was panicked there. I think I replaced the config file with an older one by mistake, and the password was different. That was from an earlier attempt to figure out what was wrong, and I uploaded the old one by mistake.

Everything you told me to do was indeed perfectly correct. Thanks a lot! (Always dangerous to try to help people who don’t know what they’re doing… :-)

#5 2009-11-03 23:29:25

uli

Moderator

From: Cologne

Registered: 2006-08-15

Posts: 4,306

Re: Error: Tables marked as crashed and should be repaired

jeff r wrote:

Whew, sorry I was panicked there.

No problem, I was out when your panic mail rolled in ;)
Glad you’ve got it back.

---

_{In bad weather I never leave home without wet_plugout, smd_where_used and adi_form_links}