SQL Kalender Installation unter Joomla 1.5 nicht möglich

[Riseofdead]

Hallo

Ich möchte gerne den Kalender von schlu.net für Joomla 1.5 installieren. Da ich von SQL keine Ahnung hab und alles andere sonst auch immer Reibungslos lief frag ich einfach einmal hier was da sein kann.

Folgende Fehlermeldung kommt bei der Installation

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

Ich hab überall statt TYPE=MyISAM einfach TYPE=Engine eingefügt weil das wo in einem Forum stand aber dies löste das Problem nicht.

Die Daten die ich von meinem Hoster beim phpmyadmin Interface rausbekommen habe:

MySQL

Server: bplaced MySQL-Database Interface (Localhost via UNIX socket)
Server Version: 5.5.27
Protokoll-Version: 10
Benutzer: androidflash@localhost
MySQL-Zeichensatz: UTF-8 Unicode (utf8)

Webserver

Apache/2.4
MySQL-Client-Version: MySQL 5.0.8-dev Native Driver
PHP Erweiterung: mysqli

 

[E.o.B]

Hi,

zu 'TYPE=Engine' , "Engine" ist keine Speicher-Engine die MySQL bekannt ist. (Wo stand das denn?)
Was für eine Fehlermeldung kahm den mit MyISAM?

---

Kann es sein, dass Du da etwas falsch verstanden hast und laut dem von Dir gefunden POST mit der "Engine" eigentlich "TYPE=MyISAM" zu "ENGINE=MyISAM" ändern solltest?

 

[Riseofdead]

danke das war das Problem. ENGINE=MyISAM