Textpattern CMS support forum
You are not logged in. Register | Login | Help
- Topics: Active | Unanswered
I'm having this error. Maybe you can help me find out what it is...
Hi.
My website was working well.
Now I get this error:
Warning: Table ‘txp_log’ is marked as crashed and should be repaired select host from txp_log where ip=‘195.53.58.86’ limit 1 textpattern/publish/log.php:39 safe_field() in /users/home/francis/domains/diariocientifico.es/web/public/textpattern/lib/txplib_db.php on line 84
Warning: Table ‘txp_log’ is marked as crashed and should be repaired insert into txp_log set `time`=now(),page=’/’,ip=‘195.53.58.86’,host=‘195.53.58.86’,refer=’‘,status=‘200’,method=‘GET’ textpattern/publish/log.php:66 safe_insert() in /users/home/francis/domains/diariocientifico.es/web/public/textpattern/lib/txplib_db.php on line 84
I did not change nothing! I have absolutely no idea of what this is about. Can you help me please.
Many thanks in advance
camello
ps: My website (*ww.diariocientifico.es) is hosted by Textdrive.
Offline
#2 2009-02-12 01:06:21
- Mary
- Sock Enthusiast
- Registered: 2004-06-27
- Posts: 6,236
Re: I'm having this error. Maybe you can help me find out what it is...
The table needs to be repaired. You can do this in phpMyAdmin and other database managers.
Offline
Re: I'm having this error. Maybe you can help me find out what it is...
The table? From Mysql?
Can you help me a little more. I do not heve any idea of what kind of reparation I need to do onto it :-)
Thanks a lot…
camello
ps: How should the table get “broken” anyway?. ..I did nothing to it?
Offline
#4 2009-02-12 03:46:43
- Mary
- Sock Enthusiast
- Registered: 2004-06-27
- Posts: 6,236
Re: I'm having this error. Maybe you can help me find out what it is...
It can happen all by itself.
I believe inside phpMyAdmin if you look at the database there’s an actual “repair” link somewhere next to the table name.
Are you on the old TextDrive servers or on one of the new (shared) Joyent Accelerators?
Offline
#5 2009-02-12 03:51:30
- Mary
- Sock Enthusiast
- Registered: 2004-06-27
- Posts: 6,236
Re: I'm having this error. Maybe you can help me find out what it is...
phpMyAdmin locations:
- For the old TextDrive servers:
https://mysql.*your-server-name*.textdrive.com/ - For the new Joyent shared Accelerators:
https://*your-server-name*.joyent.us/phpmyadmin/
Offline
Re: I'm having this error. Maybe you can help me find out what it is...
Sorry,
I really do not want to bither you…
…But, what I needed was that someone could “translate” this “should be repaired select host from txp_log where ip=‘195.53.58.86’ limit 1 textpattern/publish/log.php:39 safe_field() in /users/home/francis/domains/diariocientifico.es/web/public/textpattern/lib/txplib_db.php on line 84” jargon into someting I can understand. Because right now I know I have to “Table ‘txp_log’ , and fix it, but I do not have an Idea about how to fix it?
Can you help me?
Thanks a lot
camello
Offline
#7 2009-02-12 05:18:29
- Mary
- Sock Enthusiast
- Registered: 2004-06-27
- Posts: 6,236
Re: I'm having this error. Maybe you can help me find out what it is...
- Log into phpMyAdmin.
- On the left hand-side click on the database you’re using for Textpattern.
- Check the box next to “txp_log”.
- Choose “repair table” in the “With selected” dropdown.
- All done. Log out of phpMyAdmin.
Some links with screenshots of repairing tables:
Offline
Re: I'm having this error. Maybe you can help me find out what it is...
:-) Many many thank’s!!!
You see, I never imagined it could be so simple….
Why wouldn’t the error message just say that :-)…
I’m very gratefull for your help and patience…
Thank you
camello
Offline
Re: I'm having this error. Maybe you can help me find out what it is...
Hi,
I did it. It was very easy actually. Thanks. Every table got “OK”.
I’m having one problem though! Noe I cannot access the website. I just get a “Database Unavailable” warning.
www.diariocientifico.es
Is this the end :-( or does it have any solution?
Thanks once again…
Offline
#10 2009-02-12 19:39:29
- els
- Moderator
- From: The Netherlands
- Registered: 2004-06-06
- Posts: 7,458
Re: I'm having this error. Maybe you can help me find out what it is...
If you are still able to access the database in phpMyAdmin, it doesn’t have to be the end ;) Here is a FAQ, maybe it helps. You might need to contact Textdrive.
Offline
#11 2009-02-13 01:47:45
- Mary
- Sock Enthusiast
- Registered: 2004-06-27
- Posts: 6,236
Re: I'm having this error. Maybe you can help me find out what it is...
See if you can still get at your database in phpMyAdmin.
Offline