Loading...
 
Architecture / Installation

Architecture / Installation


Incorrect Key File errors?

posts: 10

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

posts: 10

Yes, I had 4.1.11 on my local machine. Doesn't tiki 1.9.x work with MySQL 4.1? The Requirements and Setup page does claim: " TikiWiki 1.9 works with MySQL 4.1. TikiWIki 1.9.1 and later will support the enhanced mysqli driver too."

Anyway, I installed MySQL 4.0.25 and it works fine with tiki. Thanks for the help.


> I guess locally you are trying to use MySQL 4.1 or 5? Try downgrading to MySQL 4.0
>
> Damian
> http://tikihost.net
>

posts: 2881 United Kingdom

> Yes, I had 4.1.11 on my local machine. Doesn't tiki 1.9.x work with MySQL 4.1? The Requirements and Setup page does claim: " TikiWiki 1.9 works with MySQL 4.1. TikiWIki 1.9.1 and later will support the enhanced mysqli driver too."
>
> Anyway, I installed MySQL 4.0.25 and it works fine with tiki. Thanks for the help.

1.9.0 was meant to include 4.1 support, but the release manager decided it wasnt important, so it never happened. Anyway 1.9.1 which is currently in CVS and soon to be released does.

Damian
http://tikihost.net


p.s. No there is no release date decided yet. rolleyes


Upcoming Events

1)  18 Apr 2024 14:00 GMT-0000
Tiki Roundtable Meeting
2)  16 May 2024 14:00 GMT-0000
Tiki Roundtable Meeting
3)  20 Jun 2024 14:00 GMT-0000
Tiki Roundtable Meeting
4)  18 Jul 2024 14:00 GMT-0000
Tiki Roundtable Meeting
5)  15 Aug 2024 14:00 GMT-0000
Tiki Roundtable Meeting
6)  19 Sep 2024 14:00 GMT-0000
Tiki Roundtable Meeting
7) 
Tiki birthday
8)  17 Oct 2024 14:00 GMT-0000
Tiki Roundtable Meeting
9)  21 Nov 2024 14:00 GMT-0000
Tiki Roundtable Meeting
10)  19 Dec 2024 14:00 GMT-0000
Tiki Roundtable Meeting