Blog crashed ??

[Cameraman]

Hi everyone


since this morning i cant access my blog through its url: http://www.blacksun-productions.com/blog anymore, i always get this error message:

Table './d60448204/pixelpost_visitors' is marked as crashed and last (automatic?) repair failed

does anyone know what this means and what i can do ?
im running the latest pixelpost version.
i can still access my admin page and everything looks "normal" there.

thanks


dom

[dakwegmo]

If you have phpMyAdmin or shell access, you can try to repair the table again. If you aren't familiar with this, you should contact your host and see if they can do this for you.

The visitor table logs some basic information about your visitors. If all else fails you can empty the table and the only thing that will be affected within PixelPost is some of the stats. If you have a recent backup, you should try to restore just this table, so you can save some of the data.

[Cameraman]

im in phpmyadmin now, if i click on the pixelpost_visitors table there it also only says:

MySQL said:

Table './d60448204/pixelpost_visitors' is marked as crashed and last (automatic?) repair failed

the option to EMPTY the table is greyed out, but i an DROP it, would that help ?

[dakwegmo]

You can drop it, but you'll need to recreate it. Run this query in phpMyAdmin for your PixelPost database.

CREATE TABLE `pixelpost_visitors` (
`id` int(11) NOT NULL auto_increment,
`datetime` datetime NOT NULL default '0000-00-00 00:00:00',
`host` varchar(100) NOT NULL default '',
`referer` varchar(255) NOT NULL default '',
`ua` varchar(255) NOT NULL default '',
`ip` varchar(255) NOT NULL default '',
`ruri` varchar(150) NOT NULL default '',
PRIMARY KEY (`id`),
KEY `datetime` (`datetime`),
KEY `referer` (`referer`),
KEY `ip` (`ip`)
)

[Cameraman]

that did it, thanks so much for the quick help :)