Scusate se non è la sezione giusta per questa discussione
i problema:
ho un sito su sgaragnao uso joombla 1.5.25
sgaragnao mi mette a disposizione
| Versione database: | 5.5.18-55-log |
| Collation Database: | utf8_general_ci |
| Versione PHP: | 5.3.8 |
| Server Web: | Apache/2.2 |
| Server web per interfaccia PHP: | cgi-fcgi |
| Versione di Joomla!: | Joomla! 1.5.25 Stable [ senu takaa ama mamni ] 14-November-2011 18:00 GMT |
| User Agent: | Mozilla/5.0 (Windows NT 6.1; rv:8.0) Gecko/20100101 Firefox/8.0 |
provo ad installare eventlist e mi ritorna 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=InnoDB CHARACTER SET `utf8` COLLATE `utf8_general_ci`' at line 29 SQL=CREATE TABLE IF NOT EXISTS `jos_eventlist_events` ( `id` int(11) unsigned NOT NULL auto_increment, `locid` int(11) unsigned NOT NULL default '0', `catsid` int(11) unsigned NOT NULL default '0', `dates` date NOT NULL default '0000-00-00', `enddates` date NULL default NULL, `times` time NULL default NULL, `endtimes` time NULL default NULL, `title` varchar(100) NOT NULL default '', `alias` varchar(100) NOT NULL default '', `created_by` int(11) unsigned NOT NULL default '0', `modified` datetime NOT NULL, `modified_by` int(11) unsigned NOT NULL default '0', `author_ip` varchar(15) NOT NULL default '', `created` datetime NOT NULL, `datdescription` mediumtext NOT NULL, `meta_keywords` varchar(200) NOT NULL default '', `meta_description` varchar(255) NOT NULL default '', `recurrence_number` int(2) NOT NULL default '0', `recurrence_type` int(2) NOT NULL default '0', `recurrence_counter` date NOT NULL default '0000-00-00', `datimage` varchar(100) NOT NULL default '', `checked_out` int(11) NOT NULL default '0', `checked_out_time` datetime NOT NULL default '0000-00-00 00:00:00', `registra` tinyint(1) NOT NULL default '0', `unregistra` tinyint(1) NOT NULL default '0', `published` tinyint(1) NOT NULL default '0', PRIMARY KEY (`id`) ) TYPE=MyISAM CHARACTER SET `utf8` COLLATE `utf8_general_ci`;creo sul DB la tabella
`jos_eventlist_events`modificando in quanto deprecato
TYPE=MyISAM CHARACTER SET `utf8` COLLATE `utf8_general_ci`;in ENGINE=MyISAM CHARACTER SET `utf8` COLLATE `utf8_general_ci`;riprovo ad installare ma mi torna lo stesso errore
potete aiutarmi
grazie
