My favorites | Sign in
Logo
                
New issue | Search
for
| Advanced search | Search tips
Issue 88: Error in gelato_db SQL Script
1 person starred this issue and may be notified of changes. Back to list
Status:  New
Owner:  ----
Type-Defect
Priority-Medium


Sign in to add a comment
 
Reported by mkbaldwin21, Feb 20, 2009

I discovered that there is an error in the create statement for gel_feeds
in the gelato_db.sql script.  You currently have the following code:

CREATE TABLE `gel_feeds` (
	`id_feed` int(11) NOT NULL auto_increment,
	`url` varchar(255) NOT NULL,
	`title` varchar(255) NOT NULL,
	`type` tinyint(4) NOT NULL default '1',
	`updated_at` datetime NOT NULL,
	`error` tinyint(1) NOT NULL default '0',
	`credits` int(1) NOT NULL default '0',
	`site_url` varchar(255) NOT NULL,
	`id_user` int(10) NOT NULL,
	PRIMARY KEY  (`id_feed`)
) ENGINE=MyISAM1 ;

However the engine should be 'MyISAM' not 'MyISAM1'


--- Corrected SQL ---
CREATE TABLE `gel_feeds` (
	`id_feed` int(11) NOT NULL auto_increment,
	`url` varchar(255) NOT NULL,
	`title` varchar(255) NOT NULL,
	`type` tinyint(4) NOT NULL default '1',
	`updated_at` datetime NOT NULL,
	`error` tinyint(1) NOT NULL default '0',
	`credits` int(1) NOT NULL default '0',
	`site_url` varchar(255) NOT NULL,
	`id_user` int(10) NOT NULL,
	PRIMARY KEY  (`id_feed`)
) ENGINE=MyISAM ;
Sign in to add a comment

Hosted by Google Code