Textpattern CMS

#1 2008-01-04 21:37:44

jameslynn

New Member

Registered: 2008-01-04

Posts: 2

Warning: Can't open file: 'txp_log.MYI' (errno: 145)

Hi

Everything has been fine for the past 4 months and suddenly I get this on every page:

Warning: Can’t open file: ‘txp_log.MYI’. (errno: 145) select host from txp_log where ip=‘70.45.86.18’ limit 1 in /home/unilibro/libreriaisla-www/portal/textpattern/lib/txplib_db.php on line 84

Warning: Can’t open file: ‘txp_log.MYI’. (errno: 145) insert into txp_log set `time`=now(),page=’/portal/?c=Eventos’,ip=‘70.45.86.18’,host=‘host-70-45-86-18.onelinkpr.net’,refer=’‘,status=‘200’,method=‘GET’ in /home/unilibro/libreriaisla-www/portal/textpattern/lib/txplib_db.php on line 84

http://libreriaisla.com/portal/biografias/

Please advice.

—
James

Last edited by jameslynn (2008-01-04 21:38:08)

#2 2008-01-04 23:02:05

els

Moderator

From: The Netherlands

Registered: 2004-06-06

Posts: 7,458

Re: Warning: Can't open file: 'txp_log.MYI' (errno: 145)

Try repairing the txp_log table (using phpMyAdmin or rss_admin_db_manager).

#3 2008-01-05 07:12:42

ruud

Developer Emeritus

From: a galaxy far far away

Registered: 2006-06-04

Posts: 5,068

Website

Re: Warning: Can't open file: 'txp_log.MYI' (errno: 145)

And if that doesn’t work and you don’t use the built in TXP logs, disable logging in the preferences (not really a solution, but at least the error will be gone)

#4 2008-01-05 15:53:09

jameslynn

New Member

Registered: 2008-01-04

Posts: 2

Re: Warning: Can't open file: 'txp_log.MYI' (errno: 145)

I repaired the database table. That fixed the problem.

Thanks a lot for your help!!

—
James