Joomla.it Forum

Joomla! 1.5.x (versione con supporto terminato) => Joomla! 1.5 => Installazione, migrazione e aggiornamento => : stepish 13 Jan 2012, 08:39:19

: Errore installazione joomla 3.27 e successivi (in locale)
: stepish 13 Jan 2012, 08:39:19

 Ciao a tutti,ho cercato di installare acajoom e mi dà quest'errore...che devo fare?Posso cambiare newsletter? Esiste una semplice e funzionale come acajoom per la 1.7???

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

GrazieStefano

: Re:Errore installazione joomla 3.27 e successivi (in locale)
: hapax 13 Jan 2012, 19:12:17

: stepish  13 Jan 2012, 08:39:19

Ciao a tutti,ho cercato di installare acajoom e mi dà quest'errore...che devo fare?Posso cambiare newsletter? Esiste una semplice e funzionale come acajoom per la 1.7???

..potresti provare "AcyMailing"

http://extensions.joomla.org/extensions/content-sharing/newsletter/10341

ciao

 :)