Ciao raga,
ho installato acajoom solo che mi dà l'errore...

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=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;

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;



perchè???
Che devo fare?

Grazie
Stefano