Am trying to install 1.9-BRANCH (1.9.8) on my server. 1.9.7 worked fine, 1.10 worked fine after a tweak, but this 1.9.8 install seems to barf.
Running Mysql 4.1.1, and have even copied the db/tiki-1.9-mysql.sql contents for the create table segments that failed and used phpMyAdmin without success. A full example is:
Command: CREATE TABLE tiki_articles (
articleId int(8) NOT NULL auto_increment,
topline varchar(255) default NULL,
title varchar(80) default NULL,
subtitle varchar(255) default NULL,
linkto varchar(255) default NULL,
lang varchar(16) default NULL,
state char(1) default 's',
authorName varchar(60) default NULL,
topicId int(14) default NULL,
topicName varchar(40) default NULL,
size int(12) default NULL,
useImage char(1) default NULL,
image_name varchar(80) default NULL,
image_caption text default NULL,
image_type varchar(80) default NULL,
image_size int(14) default NULL,
image_x int(4) default NULL,
image_y int(4) default NULL,
image_data longblob,
publishDate int(14) default NULL,
expireDate int(14) default NULL,
created int(14) default NULL,
heading text,
body text,
hash varchar(32) default NULL,
author varchar(200) default NULL,
nbreads int(14) default NULL,
votes int(8) default NULL,
points int(14) default NULL,
type varchar(50) default NULL,
rating decimal(3,2) default NULL,
isfloat char(1) default NULL,
PRIMARY KEY (articleId),
KEY title (title),
KEY heading 255,
KEY body 255,
KEY nbreads (nbreads),
KEY author 32,
KEY topicId (topicId),
KEY publishDate (publishDate),
KEY expireDate (expireDate),
KEY type (type),
FULLTEXT KEY ft (title,heading,body)
) TYPE=MyISAM AUTO_INCREMENT=1
Message: Incorrect sub part key. The used key part isn't a string, the used length is longer than the key part or the storage engine doesn't support unique sub keys
and
Command: CREATE TABLE tiki_blogs (
blogId int(8) NOT NULL auto_increment,
created int(14) default NULL,
lastModif int(14) default NULL,
title varchar(200) default NULL,
description text,
user varchar(40) default NULL,
public char(1) default NULL,
posts int(8) default NULL,
maxPosts int(8) default NULL,
hits int(8) default NULL,
activity decimal(4,2) default NULL,
heading text,
use_find char(1) default NULL,
use_title char(1) default NULL,
add_date char(1) default NULL,
add_poster char(1) default NULL,
allow_comments char(1) default NULL,
show_avatar char(1) default NULL,
PRIMARY KEY (blogId),
KEY title (title),
KEY description 255,
KEY hits (hits),
FULLTEXT KEY ft (title,description)
) TYPE=MyISAM AUTO_INCREMENT=1
Message: Specified key was too long. Max key length is 500
which ultimately cause:
Command: # --------------------
INSERT INTO tiki_modules (name,position,ord,cache_time,groups) VALUES ('login_box','r',1,0,'a:2:{i:0;s:10:"Registered";i:1;s:9:"Anonymous";}')
Message: Table 'tiki-19branch.tiki_modules' doesn't exist
because the table never gets created.
I'm not sure how to go about fixing this problem.
To help developers solve the bug, we kindly request that you demonstrate your bug on a show2.tiki.org instance. To start, simply select a version and click on "Create show2.tiki.org instance". Once the instance is ready (in a minute or two), as indicated in the status window below, you can then access that instance, login (the initial admin username/password is "admin") and configure the Tiki to demonstrate your bug. Priority will be given to bugs that have been demonstrated on show2.tiki.org.
To help developers solve the bug, we kindly request that you demonstrate your bug on a show.tikiwiki.org instance. To start, simply select a version and click on "Create show.tikiwiki.org instance". Once the instance is ready (in a minute or two), as indicated in the status window below, you can then access that instance, login (the initial admin username/password is "admin") and configure the Tiki to demonstrate your bug. Priority will be given to bugs that have been demonstrated on show.tikiwiki.org.
filename | created | hits | comment | version | filetype | ||
---|---|---|---|---|---|---|---|
No attachments for this item |