schnitzelteller
Karma: 0
|
Glossary 2.5J installation error - 2008/08/20 11:49
Hi,
when installing Glossary 2.5J on Joomla 1.5 I receive the following Error:
| Code: |
* 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 'DEFAULT CHARSET=utf8' at line 8 SQL=CREATE TABLE IF NOT EXISTS `jos_glossaries` ( `id` int(10) NOT NULL auto_increment, `name` varchar(120) NOT NULL default '', `description` varchar(255) NOT NULL default '', `published` tinyint(1) UNSIGNED NOT NULL default 0, `isdefault` tinyint(1) UNSIGNED NOT NULL default 0, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
SQL =
CREATE TABLE IF NOT EXISTS `jos_glossaries` (
`id` int(10) NOT NULL auto_increment,
`name` varchar(120) NOT NULL default '',
`description` varchar(255) NOT NULL default '',
`published` tinyint(1) UNSIGNED NOT NULL default 0,
`isdefault` tinyint(1) UNSIGNED NOT NULL default 0,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
* Komponente 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 'DEFAULT CHARSET=utf8' at line 8 SQL=CREATE TABLE IF NOT EXISTS `jos_glossaries` ( `id` int(10) NOT NULL auto_increment, `name` varchar(120) NOT NULL default '', `description` varchar(255) NOT NULL default '', `published` tinyint(1) UNSIGNED NOT NULL default 0, `isdefault` tinyint(1) UNSIGNED NOT NULL default 0, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
SQL =
CREATE TABLE IF NOT EXISTS `jos_glossaries` (
`id` int(10) NOT NULL auto_increment,
`name` varchar(120) NOT NULL default '',
`description` varchar(255) NOT NULL default '',
`published` tinyint(1) UNSIGNED NOT NULL default 0,
`isdefault` tinyint(1) UNSIGNED NOT NULL default 0,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
|
Any suggestions how I can fix this? Thanx!
|
Forum
