Help Needed: Incorrect key file Error
Hi, I am about two weeks into learning PHP/MySQL from the book and have come up against a brick wall. After fixing the e-mail/email issue the Chaper 12 CMS exercise seems to run fine except...
I create an article and save it (fine). I then Edit the article, make a change and save it (fine). I then repeat this and I get the following error message:
Could not update article; Incorrect key file for table: 'cms_articles'. Try to repair it
This message comes from the 'Save Changes' sequence in transact-article.php The table is then unusable until I run the REPAIR TABLES cms_articles command.
At the moment I don't know if it is a bug in the code, a problem with the way the Keys are set up in the cms_articles table, or something to do with the way my Database or MySQL is configured. Apart from the e-mail fix and the required changes to conn.php I am using the code unchanged and as downloaded from this site.
I am using the phpDev5 bundle from firepages.com.au comprising:
apache 1.3.2 7AND/OR apache 2.0.43
Zend Optimiser
PHP4.2.3
MySQL4 (alpha but stabler than the older release version
phpMyAdmin 2.3.2
Perl 5.6.1
Mod_Perl 1.27 dev
There must be someone out there who knows what this is all about and can come to my aid - please help keep me sane!
|