Re: error in your SQL syntax
i am also experiencing a SQL issue with postgresql it dies after creating 100 tables.
> 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