By bertboerland on

Hi

My hosts died on me in an ugly way, and I am stuck with a not working watchdog table (all other tables I was able to repair)

This results in not being able to go to /admin (/admin/block etc work) since the logs are presented on the first admin page (if this is needed in the first place is another question)

I tried to repair the table but it fails

mysql> repair table watchdog;
+----------------+--------+----------+-----------------------------+
| Table          | Op     | Msg_type | Msg_text                    |
+----------------+--------+----------+-----------------------------+
| willy.watchdog | repair | error    | 28 when writing to datafile |
| willy.watchdog | repair | error    | 28 when writing to datafile |
| willy.watchdog | repair | status   | Operation failed            |
+----------------+--------+----------+-----------------------------+

Since watchdog is only used for the admin, I think I can just delete the table and recreate it? Is this the case and if so, could someone give some instructions for a 4.5 instalation?

Comments

killes@www.drop.org’s picture

killes@www.drop.org commented

You can indeed simply delete the table. Look at the databyse.mysql file what the definition is to recreate it.
--
Drupal services
My Drupal services

--
Drupal services
My Drupal services

bertboerland’s picture

bertboerland commented

mysql> drop table watchdog;
Query OK, 0 rows affected (4.13 sec)

mysql> CREATE TABLE watchdog (
-> wid int(5) NOT NULL auto_increment,
-> uid int(10) NOT NULL default '0',
-> type varchar(16) NOT NULL default '',
-> message longtext NOT NULL,
-> link varchar(255) NOT NULL default '',
-> location varchar(128) NOT NULL default '',
-> hostname varchar(128) NOT NULL default '',
-> timestamp int(11) NOT NULL default '0',
-> PRIMARY KEY (wid)
-> ) TYPE=MyISAM;
Query OK, 0 rows affected (0.06 sec)

--
groets
bertb

--
groets
bert boerland