| Junior Mamber
Join Date: Jul 2004
Posts: 41
| Fehler beim Installieren verschiedener komponenten beim installieren vom wrapper bekomme ich diesen fehler: SQL Error DB function failed with error number 1064
You have an error in your SQL syntax near '; ' at line 13 SQL=CREATE TABLE IF NOT EXISTS `mos_wrapper` ( `id` int(11) NOT NULL auto_increment, `name` varchar(100) NOT NULL default '', `url` text, `height` varchar(50) NOT NULL default '', `width` varchar(50) NOT NULL default '', `auto` int(11) default '0', `frame` int(11) default '0', `wlink` int(11) default '0', `showname` int(11) default '0', `scroll` text NOT NULL, PRIMARY KEY (`id`) ) TYPE=MyISAM AUTO_INCREMENT=9 ;
SQL =
CREATE TABLE IF NOT EXISTS `mos_wrapper` (
`id` int(11) NOT NULL auto_increment,
`name` varchar(100) NOT NULL default '',
`url` text,
`height` varchar(50) NOT NULL default '',
`width` varchar(50) NOT NULL default '',
`auto` int(11) default '0',
`frame` int(11) default '0',
`wlink` int(11) default '0',
`showname` int(11) default '0',
`scroll` text NOT NULL,
PRIMARY KEY (`id`)
) TYPE=MyISAM AUTO_INCREMENT=9 ;
beim installieren von akogallery: SQL Error DB function failed with error number 1064
You have an error in your SQL syntax near '; ' at line 15 SQL= CREATE TABLE `mos_akocomment` ( `id` int(10) NOT NULL auto_increment, `parentid` int(10) NOT NULL default '0', `status` int(10) NOT NULL default '0', `contentid` int(10) NOT NULL default '0', `ip` varchar(15) NOT NULL default '', `name` varchar(30) NOT NULL default '', `title` varchar(40) NOT NULL default '', `comment` text NOT NULL, `date` datetime NOT NULL default '0000-00-00 00:00:00', `published` tinyint(1) NOT NULL default '0', `ordering` int(11) NOT NULL default '0', PRIMARY KEY (`id`) ) TYPE=MyISAM;
SQL =
CREATE TABLE `mos_akocomment` (
`id` int(10) NOT NULL auto_increment,
`parentid` int(10) NOT NULL default '0',
`status` int(10) NOT NULL default '0',
`contentid` int(10) NOT NULL default '0',
`ip` varchar(15) NOT NULL default '',
`name` varchar(30) NOT NULL default '',
`title` varchar(40) NOT NULL default '',
`comment` text NOT NULL,
`date` datetime NOT NULL default '0000-00-00 00:00:00',
`published` tinyint(1) NOT NULL default '0',
`ordering` int(11) NOT NULL default '0',
PRIMARY KEY (`id`)
) TYPE=MyISAM;
beim installieren von akocomment:SQL Error DB function failed with error number 1064
You have an error in your SQL syntax near '; ' at line 15 SQL= CREATE TABLE `mos_akocomment` ( `id` int(10) NOT NULL auto_increment, `parentid` int(10) NOT NULL default '0', `status` int(10) NOT NULL default '0', `contentid` int(10) NOT NULL default '0', `ip` varchar(15) NOT NULL default '', `name` varchar(30) NOT NULL default '', `title` varchar(40) NOT NULL default '', `comment` text NOT NULL, `date` datetime NOT NULL default '0000-00-00 00:00:00', `published` tinyint(1) NOT NULL default '0', `ordering` int(11) NOT NULL default '0', PRIMARY KEY (`id`) ) TYPE=MyISAM;
SQL =
CREATE TABLE `mos_akocomment` (
`id` int(10) NOT NULL auto_increment,
`parentid` int(10) NOT NULL default '0',
`status` int(10) NOT NULL default '0',
`contentid` int(10) NOT NULL default '0',
`ip` varchar(15) NOT NULL default '',
`name` varchar(30) NOT NULL default '',
`title` varchar(40) NOT NULL default '',
`comment` text NOT NULL,
`date` datetime NOT NULL default '0000-00-00 00:00:00',
`published` tinyint(1) NOT NULL default '0',
`ordering` int(11) NOT NULL default '0',
PRIMARY KEY (`id`)
) TYPE=MyISAM;
Ich habe auch bereits andere komponenten installiert, und es hat einwandfrei geklappt, kann mir vielleicht jemand helfen? |