Hallo,
ich bin noch ein relativ “neuer” Jooma-Nutzer und den damit verbundenen Datenbanken.
In meiner Joomlainstallation möchte ich nun das “easyguestbook reloaded” installieren bekomme aber folgende Fehlermeldung:
[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 ‘TYPE=MyISAM’ at line 20 SQL=CREATE TABLE IF NOT EXISTS jos_easybook ( id int(10) NOT NULL auto_increment, gbip varchar(15) NOT NULL default ‘’, gbname varchar(40) NOT NULL default ‘’, gbmail varchar(60) default NULL, gbmailshow tinyint(1) NOT NULL default ‘0’, gbloca varchar(50) default NULL, gbpage varchar(150) default NULL, gbvote int(10) default NULL, gbtext text NOT NULL, gbdate datetime default NULL, gbcomment text, published tinyint(1) NOT NULL default ‘0’, gbicq varchar(20) default NULL, gbaim varchar(50) default NULL, gbmsn varchar(50) default NULL, gbyah varchar(50) default NULL, gbskype varchar(50) default NULL, PRIMARY KEY (id) ) TYPE=MyISAM;
SQL =
CREATE TABLE IF NOT EXISTS `jos_easybook` (
`id` int(10) NOT NULL auto_increment,
`gbip` varchar(15) NOT NULL default '',
`gbname` varchar(40) NOT NULL default '',
`gbmail` varchar(60) default NULL,
`gbmailshow` tinyint(1) NOT NULL default '0',
`gbloca` varchar(50) default NULL,
`gbpage` varchar(150) default NULL,
`gbvote` int(10) default NULL,
`gbtext` text NOT NULL,
`gbdate` datetime default NULL,
`gbcomment` text,
`published` tinyint(1) NOT NULL default '0',
`gbicq` varchar(20) default NULL,
`gbaim` varchar(50) default NULL,
`gbmsn` varchar(50) default NULL,
`gbyah` varchar(50) default NULL,
`gbskype` varchar(50) default NULL,
PRIMARY KEY (`id`)
) TYPE=MyISAM;
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=MyISAM' at line 20 SQL=CREATE TABLE IF NOT EXISTS `jos_easybook` ( `id` int(10) NOT NULL auto_increment, `gbip` varchar(15) NOT NULL default '', `gbname` varchar(40) NOT NULL default '', `gbmail` varchar(60) default NULL, `gbmailshow` tinyint(1) NOT NULL default '0', `gbloca` varchar(50) default NULL, `gbpage` varchar(150) default NULL, `gbvote` int(10) default NULL, `gbtext` text NOT NULL, `gbdate` datetime default NULL, `gbcomment` text, `published` tinyint(1) NOT NULL default '0', `gbicq` varchar(20) default NULL, `gbaim` varchar(50) default NULL, `gbmsn` varchar(50) default NULL, `gbyah` varchar(50) default NULL, `gbskype` varchar(50) default NULL, PRIMARY KEY (`id`) ) TYPE=MyISAM;
SQL =
CREATE TABLE IF NOT EXISTS `jos_easybook` (
`id` int(10) NOT NULL auto_increment,
`gbip` varchar(15) NOT NULL default '',
`gbname` varchar(40) NOT NULL default '',
`gbmail` varchar(60) default NULL,
`gbmailshow` tinyint(1) NOT NULL default '0',
`gbloca` varchar(50) default NULL,
`gbpage` varchar(150) default NULL,
`gbvote` int(10) default NULL,
`gbtext` text NOT NULL,
`gbdate` datetime default NULL,
`gbcomment` text,
`published` tinyint(1) NOT NULL default '0',
`gbicq` varchar(20) default NULL,
`gbaim` varchar(50) default NULL,
`gbmsn` varchar(50) default NULL,
`gbyah` varchar(50) default NULL,
`gbskype` varchar(50) default NULL,
PRIMARY KEY (`id`)
) TYPE=MyISAM;
[/code]
In einem Forum habe gelesen man solle den Eintrag “TYPE=MyISAM” durch “ENGINE=MyISAM” ersetzen oder ganz löschen - ohne Erfolg.
Was kann ich tum um das Gästebuch in bplaced zu installieren?
Installiere ich es Lokal auf dem Rechner in einer XAMPP-Umgebung funktioniert die Installation.
Volker
