JInstaller::install: SQL-Fehler 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=ENGINE 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=ENGINE CHARACTER SET `utf8` COLLATE `utf8_general_ci`;
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=ENGINE CHARACTER SET `utf8` COLLATE `utf8_general_ci`;
Komponenten Installieren: SQL-Fehler! Fehlende oder nicht lesbare SQL-Datei. 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=ENGINE 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=ENGINE CHARACTER SET `utf8` COLLATE `utf8_general_ci`;
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=ENGINE CHARACTER SET `utf8` COLLATE `utf8_general_ci`;