error in your SQL syntax
Hi I am having a problem with my installation... i am using (DreamHost Mysql5.0.18)
Print operations failed
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,
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),
KEY author 32,
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 'reads int(14) default NULL,
votes int(8) default NULL,
points int(14) defaul' at line 28
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,
resume text,
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 'reads int(14) default NULL,
votes int(8) default NULL,
points int(14) defaul' at line 29
How do i solve this? Thanks