My POSTS sql table still crashes (daily if i want to...)
When i edited an old post (2007) i got these errors and had to repair the table again but i could live with that. I just don't edit my old posts anymore.
But when i edit a post that's 5 days old it now crashes.
We replaced the server a few months ago and i thought the problem was solved but still i get these crashed table errors.
Running a new version of MySQL, new Linux version (OpenSUSE) and new hardware with much more memory, faster HDD's and many more improvements.
I run several database and never have such problems with other databases but now when i edit any post on our board the message is:
Script: /data/vhosts/www.freesat.nl/forum/scripts/modifypost.inc.php - Line: 391
update ubbt_POSTS
set POST_SUBJECT = 'Re: Ethernet kabel verlengen' ,
POST_BODY = 'Je kunt een ISDN koppelstuk gebruiken, bij een Phonehouse ofzo te halen voor 2 euries...' ,
POST_DEFAULT_BODY = 'Je kunt een ISDN koppelstuk gebruiken, bij een Phonehouse ofzo te halen voor 2 euries...',
POST_ICON = 'book.gif' ,
POST_LAST_EDITED_TIME= 0 ,
POST_LAST_EDIT_REASON = '' ,
POST_LAST_EDITED_BY = 'FreeSat' ,
POST_ADD_SIGNATURE = 1 ,
POST_HAS_FILE = '0',
POST_MARKUP_TYPE = 'markup'
where POST_ID = 42763
- Incorrect key file for table './freesat/ubbt_POSTS.MYI'; try to repair it
Why does this keep happening?
Thanks in advance,
Rob
