Blog down, pleas help "Can't open file: 'pixelpost_visitors.MYI' (errno: 145)"

[niklas]

Hi !

My PixelPost site is down with this error:

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

What do i do?

www.niklasstephenson.com

Thanks!

[kevincrafts]

login to your database manager and repair the table - the sql command is REPAIR TABLE pixelpost_visitors

[niklas]

Did not help

[sean36]

i am having the same issue here. i just upgraded to the latest version and got this error after the install. unfortunately i believe this had to do with a corrupt table in the pixelpost_visitors database and i can't restore the backup due to an error message specific to that. is it possible to rebuild the pixelpost_visitors table? any help would be appreciated. thanks!

[dakwegmo+]

If it is the visitors table, you can try to locate the offending entry and remove it, or you can truncate the table ('empty' in phpMyAdmin). If you choose to truncate the table you'll lose all of the information that PP has recorded about your visitors.

[sean36]

thanks for your assistance. this issue i am having with the pixelpost_visitors table in my phpAdmin is that even after attempts to repair the database there is a message that says its in use so i am unable to access the properties to empty the table. is it possible to rebuild a new table or install a new database for pixelpost_visitors? thank you again for your assistance here.

[sean36]

i found my answer in an earlier post. i used the create_visitors.php script and it worked like a charm! thanks!