Loading...
 
Architecture / Installation

Architecture / Installation


Tiki 1.8.2/1.9 Installation Error

posts: 1

Hi,

I just wanted to setup Tikiwiki 1.8.2 on my FreeBSD 5.2.1-box, equipped with Apache 1.3.29, PHP 4.3.4, and MySQL 4.1.0, but unfortunately when trying to setup the database using tiki-install.php I got several failure notifications.

So I tried to use Tiki 1.9RC2 instead, but I just received the very same error messages (see at the end of this posting).

When replacing 'hash' with eg. 'hash0' everything went just fine (at least in terms of creating the database, no the code has to hacked accordingly! :-( ). Obviously 'hash' seems to be a reserved word in MySQL 4.1.x.


[-]
  • *+* FAILURE NOTIFICATIONS *+*+*

Command: CREATE TABLE galaxia_instance_comments (
cId int(14) NOT NULL auto_increment,
instanceId int(14) NOT NULL default '0',
user varchar(200) default NULL,
activityId int(14) default NULL,
hash varchar(32) default NULL,
title varchar(250) default NULL,
comment text,
activity varchar(80) default NULL,
timestamp int(14) default NULL,
PRIMARY KEY (cId)
) TYPE=MyISAM AUTO_INCREMENT=1
Message: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'hash varchar(32) default NULL,
title varchar(250) default NUL


Command: CREATE TABLE messu_messages (
msgId int(14) NOT NULL auto_increment,
user varchar(200) NOT NULL default '',
user_from varchar(200) NOT NULL default '',
user_to text,
user_cc text,
user_bcc text,
subject varchar(255) default NULL,
body text,
hash varchar(32) default NULL,
date int(14) default NULL,
isRead char(1) default NULL,
isReplied char(1) default NULL,
isFlagged char(1) default NULL,
priority int(2) default NULL,
PRIMARY KEY (msgId)
) TYPE=MyISAM AUTO_INCREMENT=1
Message: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'hash varchar(32) default NULL,
date int(14) default NULL,
i


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,
bibliographical_references text default NULL,
resume text default NULL,
heading text,
body text,
hash varchar(32) default NULL,
author varchar(200) default NULL,
reads 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 reads (reads),
FULLTEXT KEY ft (title,heading,body)
) TYPE=MyISAM AUTO_INCREMENT=1
Message: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'hash varchar(32) default NULL,
author varchar(200) default NU


Command: CREATE TABLE tiki_comments (
threadId int(14) NOT NULL auto_increment,
object varchar(255) NOT NULL default '',
objectType varchar(32) NOT NULL default '',
parentId int(14) default NULL,
userName varchar(200) default NULL,
commentDate int(14) default NULL,
hits int(8) default NULL,
type char(1) default NULL,
points decimal(8,2) default NULL,
votes int(8) default NULL,
average decimal(8,4) default NULL,
title varchar(100) default NULL,
data text,
hash varchar(32) default NULL,
user_ip varchar(15) default NULL,
summary varchar(240) default NULL,
smiley varchar(80) default NULL,
message_id varchar(250) default NULL,
in_reply_to varchar(250) default NULL,
comment_rating tinyint(2) default NULL,
PRIMARY KEY (threadId),
KEY title (title),
KEY data 255,
KEY object (object),
KEY hits (hits),
KEY tc_pi (parentId),
FULLTEXT KEY ft (title,data)
) TYPE=MyISAM AUTO_INCREMENT=1
Message: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'hash varchar(32) default NULL,
user_ip varchar(15) default NU


Command: CREATE TABLE tiki_files (
fileId int(14) NOT NULL auto_increment,
galleryId int(14) NOT NULL default '0',
name varchar(200) NOT NULL default '',
description text,
created int(14) default NULL,
filename varchar(80) default NULL,
filesize int(14) default NULL,
filetype varchar(250) default NULL,
data longblob,
user varchar(200) default NULL,
downloads int(14) default NULL,
votes int(8) default NULL,
points decimal(8,2) default NULL,
path varchar(255) default NULL,
reference_url varchar(250) default NULL,
is_reference char(1) default NULL,
hash varchar(32) default NULL,
PRIMARY KEY (fileId),
KEY name (name),
KEY description 255,
KEY downloads (downloads),
FULLTEXT KEY ft (name,description)
) TYPE=MyISAM AUTO_INCREMENT=1
Message: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'hash varchar(32) default NULL,
PRIMARY KEY (fileId),
KEY n


Command: CREATE TABLE tiki_forums_queue (
qId int(14) NOT NULL auto_increment,
object varchar(32) default NULL,
parentId int(14) default NULL,
forumId int(14) default NULL,
timestamp int(14) default NULL,
user varchar(200) default NULL,
title varchar(240) default NULL,
data text,
type varchar(60) default NULL,
hash varchar(32) default NULL,
topic_smiley varchar(80) default NULL,
topic_title varchar(240) default NULL,
summary varchar(240) default NULL,
PRIMARY KEY (qId)
) TYPE=MyISAM AUTO_INCREMENT=1
Message: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'hash varchar(32) default NULL,
topic_smiley varchar(80) defau


Command: CREATE TABLE tiki_received_articles (
receivedArticleId int(14) NOT NULL auto_increment,
receivedFromSite varchar(200) default NULL,
receivedFromUser varchar(200) default NULL,
receivedDate int(14) default NULL,
title varchar(80) default NULL,
authorName varchar(60) default NULL,
size int(12) default NULL,
useImage char(1) default NULL,
image_name varchar(80) 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 longblob,
hash varchar(32) default NULL,
author varchar(200) default NULL,
type varchar(50) default NULL,
rating decimal(3,2) default NULL,
PRIMARY KEY (receivedArticleId)
) TYPE=MyISAM AUTO_INCREMENT=1
Message: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'hash varchar(32) default NULL,
author varchar(200) default NU


Command: CREATE TABLE tiki_shoutbox (
msgId int(10) NOT NULL auto_increment,
message varchar(255) default NULL,
timestamp int(14) default NULL,
user varchar(200) default NULL,
hash varchar(32) default NULL,
PRIMARY KEY (msgId)
) TYPE=MyISAM AUTO_INCREMENT=1
Message: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'hash varchar(32) default NULL,
PRIMARY KEY (msgId)
) TYPE=My


Command: CREATE TABLE tiki_submissions (
subId 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,
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,
bibliographical_references text default NULL,
resume text default NULL,
heading text,
body text,
hash varchar(32) default NULL,
author varchar(200) default NULL,
reads 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 (subId)
) TYPE=MyISAM AUTO_INCREMENT=1
Message: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'hash varchar(32) default NULL,
author varchar(200) default NU


Command: CREATE TABLE tiki_user_watches (
user varchar(200) NOT NULL default '',
event varchar(40) NOT NULL default '',
object varchar(200) NOT NULL default '',
hash varchar(32) default NULL,
title varchar(250) default NULL,
type varchar(200) default NULL,
url varchar(250) default NULL,
email varchar(200) default NULL,
PRIMARY KEY (user,event,object)
) TYPE=MyISAM
Message: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'hash varchar(32) default NULL,
title varchar(250) default NUL


Command: CREATE TABLE users_users (
userId int(8) NOT NULL auto_increment,
email varchar(200) default NULL,
login varchar(40) NOT NULL default '',
password varchar(30) default '',
provpass varchar(30) default NULL,
default_group varchar(255),
lastLogin int(14) default NULL,
currentLogin int(14) default NULL,
registrationDate int(14) default NULL,
challenge varchar(32) default NULL,
pass_due int(14) default NULL,
hash varchar(32) default NULL,
created int(14) default NULL,
avatarName varchar(80) default NULL,
avatarSize int(14) default NULL,
avatarFileType varchar(250) default NULL,
avatarData longblob,
avatarLibName varchar(200) default NULL,
avatarType char(1) default NULL,
score int4 NOT NULL default 0,
PRIMARY KEY (userId),
KEY (score)
) TYPE=MyISAM AUTO_INCREMENT=1
Message: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'hash varchar(32) default NULL,
created int(14) default NULL,



Command: # --------------------

      1. Administrator account

INSERT INTO users_users(email,login,password,hash) VALUES ('','admin','admin',md5('adminadmin'))
Message: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'hash) VALUES ('','admin','admin',md5('adminadmin'))' at line 3


Command: UPDATE users_users set currentLogin=lastLogin, registrationDate=lastLogin
Message: Table 'tikiwiki.users_users' doesn't exist


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