JInstaller::install: Errore SQL. DB function failed with error number 1064
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 'TYPE=InnoDB' at line 35 SQL=CREATE TABLE IF NOT EXISTS `jos_acajoom_lists` ( `id` int(10) NOT NULL auto_increment, `list_name` varchar(101) NOT NULL default '', `list_desc` text NOT NULL, `list_type` tinyint(2) NOT NULL default '0', `sendername` varchar(64) NOT NULL default '', `senderemail` varchar(64) NOT NULL default '', `bounceadres` varchar(64) NOT NULL default '', `layout` text NOT NULL, `template` int(9) NOT NULL default '0', `subscribemessage` text NOT NULL, `unsubscribemessage` text NOT NULL, `unsubscribesend` tinyint(1) NOT NULL default '1', `auto_add` tinyint(1) NOT NULL default '0', `user_choose` tinyint(1) NOT NULL default '0', `cat_id` int(10) NOT NULL default '0', `delay_min` int(2) NOT NULL default '0', `delay_max` int(2) NOT NULL default '7', `follow_up` int(10) NOT NULL default '0', `html` tinyint(1) NOT NULL default '1', `hidden` tinyint(1) NOT NULL default '0', `published` tinyint(1) NOT NULL default '0', `createdate` datetime NOT NULL default '0000-00-00 00:00:00', `acc_level` int(2) NOT NULL default '0', `acc_id` int(11) NOT NULL default '29', `notification` tinyint(1) NOT NULL default '0', `owner` int(11) NOT NULL default '0', `footer` tinyint(1) NOT NULL default '1', `notify_id` int(10) NOT NULL default '0', `next_date` int(11) NOT NULL default 0, `start_date` DATE NOT NULL, `params` text , PRIMARY KEY (`id`), UNIQUE KEY `list_name` (`list_name`) ) TYPE=MyISAM;
SQL = CREATE TABLE IF NOT EXISTS `jos_acajoom_lists` ( `id` int(10) NOT NULL auto_increment, `list_name` varchar(101) NOT NULL default '', `list_desc` text NOT NULL, `list_type` tinyint(2) NOT NULL default '0', `sendername` varchar(64) NOT NULL default '', `senderemail` varchar(64) NOT NULL default '', `bounceadres` varchar(64) NOT NULL default '', `layout` text NOT NULL, `template` int(9) NOT NULL default '0', `subscribemessage` text NOT NULL, `unsubscribemessage` text NOT NULL, `unsubscribesend` tinyint(1) NOT NULL default '1', `auto_add` tinyint(1) NOT NULL default '0', `user_choose` tinyint(1) NOT NULL default '0', `cat_id` int(10) NOT NULL default '0', `delay_min` int(2) NOT NULL default '0', `delay_max` int(2) NOT NULL default '7', `follow_up` int(10) NOT NULL default '0', `html` tinyint(1) NOT NULL default '1', `hidden` tinyint(1) NOT NULL default '0', `published` tinyint(1) NOT NULL default '0', `createdate` datetime NOT NULL default '0000-00-00 00:00:00', `acc_level` int(2) NOT NULL default '0', `acc_id` int(11) NOT NULL default '29', `notification` tinyint(1) NOT NULL default '0', `owner` int(11) NOT NULL default '0', `footer` tinyint(1) NOT NULL default '1', `notify_id` int(10) NOT NULL default '0', `next_date` int(11) NOT NULL default 0, `start_date` DATE NOT NULL, `params` text , PRIMARY KEY (`id`), UNIQUE KEY `list_name` (`list_name`) ) TYPE=MyISAM;
componente Installa: Errore SQL. DB function failed with error number 1064
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 'TYPE=MyISAM' at line 35 SQL=CREATE TABLE IF NOT EXISTS `jos_acajoom_lists` ( `id` int(10) NOT NULL auto_increment, `list_name` varchar(101) NOT NULL default '', `list_desc` text NOT NULL, `list_type` tinyint(2) NOT NULL default '0', `sendername` varchar(64) NOT NULL default '', `senderemail` varchar(64) NOT NULL default '', `bounceadres` varchar(64) NOT NULL default '', `layout` text NOT NULL, `template` int(9) NOT NULL default '0', `subscribemessage` text NOT NULL, `unsubscribemessage` text NOT NULL, `unsubscribesend` tinyint(1) NOT NULL default '1', `auto_add` tinyint(1) NOT NULL default '0', `user_choose` tinyint(1) NOT NULL default '0', `cat_id` int(10) NOT NULL default '0', `delay_min` int(2) NOT NULL default '0', `delay_max` int(2) NOT NULL default '7', `follow_up` int(10) NOT NULL default '0', `html` tinyint(1) NOT NULL default '1', `hidden` tinyint(1) NOT NULL default '0', `published` tinyint(1) NOT NULL default '0', `createdate` datetime NOT NULL default '0000-00-00 00:00:00', `acc_level` int(2) NOT NULL default '0', `acc_id` int(11) NOT NULL default '29', `notification` tinyint(1) NOT NULL default '0', `owner` int(11) NOT NULL default '0', `footer` tinyint(1) NOT NULL default '1', `notify_id` int(10) NOT NULL default '0', `next_date` int(11) NOT NULL default 0, `start_date` DATE NOT NULL, `params` text , PRIMARY KEY (`id`), UNIQUE KEY `list_name` (`list_name`) ) TYPE=MyISAM;
SQL = CREATE TABLE IF NOT EXISTS `jos_acajoom_lists` ( `id` int(10) NOT NULL auto_increment, `list_name` varchar(101) NOT NULL default '', `list_desc` text NOT NULL, `list_type` tinyint(2) NOT NULL default '0', `sendername` varchar(64) NOT NULL default '', `senderemail` varchar(64) NOT NULL default '', `bounceadres` varchar(64) NOT NULL default '', `layout` text NOT NULL, `template` int(9) NOT NULL default '0', `subscribemessage` text NOT NULL, `unsubscribemessage` text NOT NULL, `unsubscribesend` tinyint(1) NOT NULL default '1', `auto_add` tinyint(1) NOT NULL default '0', `user_choose` tinyint(1) NOT NULL default '0', `cat_id` int(10) NOT NULL default '0', `delay_min` int(2) NOT NULL default '0', `delay_max` int(2) NOT NULL default '7', `follow_up` int(10) NOT NULL default '0', `html` tinyint(1) NOT NULL default '1', `hidden` tinyint(1) NOT NULL default '0', `published` tinyint(1) NOT NULL default '0', `createdate` datetime NOT NULL default '0000-00-00 00:00:00', `acc_level` int(2) NOT NULL default '0', `acc_id` int(11) NOT NULL default '29', `notification` tinyint(1) NOT NULL default '0', `owner` int(11) NOT NULL default '0', `footer` tinyint(1) NOT NULL default '1', `notify_id` int(10) NOT NULL default '0', `next_date` int(11) NOT NULL default 0, `start_date` DATE NOT NULL, `params` text , PRIMARY KEY (`id`), UNIQUE KEY `list_name` (`list_name`) ) TYPE=MyISAM;
