Incorrect Key File errors?
I installed tiki1.9.0 on my shared host server without a problem. But when I tried to install it on my local Windows (Apache+MySQL) machine, I got a bunch of SQL errors. Firstly I got some 'key length exceeds 1k' errors. After increasing Key Cache Block Size from 1k to 4k, these errors are gone, but some other errors came up (listed below). I am not familiar with MySQL setup, but I had Drupal and Bitweaver installed on the same machine, so generally speaking MySQL setup should be OK. Can someone give me a hint on how to fix these errors?
BTW: One dumb question, which stroage db should I use? MyIsam or InnoDB, what's the diff and does it matter? Thanks.
1. First are some 'Incorrect Key File erros', e.g.:
Command: INSERT INTO tiki_menu_options (menuId,type,name,url,position,section,perm,groupname) VALUES (42,'o','Live support','tiki-live_support_admin.php',1055,'feature_live_support','tiki_p_live_support_admin','')
Message: Incorrect key file for table 'tiki_menu_options'; try to repair it
2. And some 'duplicate entry' errors, e.g.:
Command: INSERT INTO tiki_quicktags (taglabel, taginsert, tagicon, tagcategory) VALUES ('New Outputformat','OUTPUTFORMAT\r\n NAME\r\n DRIVER " "\r\n MIMETYPE "myimagetype"\r\n IMAGEMODE RGB\r\n EXTENSION "png"\r\nEND','img/icons/opera.gif','maps')
Message: Duplicate entry '1' for key 1