Duplicate entry \'0\' for key 1 SQL=INSERT INTO jos_fb_whoisonline (`userid` , `time`, `what`, `task`, `do`, `func`,`link`, `userip`, `user`) \n VALUES (\'0\', \'1223374851\', \'Re:Installationsproblem\',\'\',\'\',\'view\',\'/index.php?option=com_fireboard&Itemid=42&func=view&catid=9&id=761\', \'38.103.63.59\', \'0\')
Re:Installationsproblem (0 viewing)
Favoured: 0
|
|
|
TOPIC: Re:Installationsproblem
|
redruM (User)
Fresh Boarder
Posts: 3
|
|
Installationsproblem 2 Years, 9 Months ago
|
Karma: 0
|
Hallo zusammen!
Ich erhalte bei der Installation folgende Fehlermeldung:
| Code: |
SQL Error DB function failed with error number 1064
You have an error in your SQL syntax near 'ENGINE=MyISAM' at line 53 SQL=CREATE TABLE `mos_estateagent` ( `id` int(10) NOT NULL auto_increment, `obj_id` varchar(25) default NULL, `cat` tinyint(4) NOT NULL default '0', `type` tinyint(2) NOT NULL default '0', `title` varchar(255) NOT NULL, `description` text, `location` text, `condition` text, `other` text, `rooms` smallint(4) default NULL, `space` decimal(10,2) default NULL, `homes` smallint(5) default NULL, `homes_size` decimal(10,2) default NULL, `pp_size` decimal(10,2) default NULL, `trade_units` smallint(5) default NULL, `trade_size` decimal(10,2) default NULL, `position` varchar(50) default NULL, `lift` tinyint(1) NOT NULL default '0', `yobuilt` smallint(6) NOT NULL default '0', `toheat` tinytext, `toheat_ufloor` tinyint(1) NOT NULL default '0', `balcony` tinyint(1) NOT NULL default '0', `terrace` tinyint(1) NOT NULL default '0', `garden_size` decimal(10,2) default NULL, `parkarea` tinyint(1) NOT NULL default '0', `garage` tinyint(1) NOT NULL default '0', `rent` decimal(10,2) NOT NULL default '0.00', `rent_extra` decimal(10,2) NOT NULL default '0.00', `price` decimal(10,2) NOT NULL default '0.00', `commis` varchar(15) NOT NULL default '', `secure` decimal(10,2) NOT NULL default '0.00', `receipts` decimal(10,2) NOT NULL default '0.00', `street` varchar(255) default NULL, `streetnr` varchar(5) default NULL, `pcode` varchar(10) default NULL, `town` tinytext, `district` tinytext, `state` tinytext, `country` tinytext, `hits` int(6) NOT NULL default '0', `hot` tinyint(1) NOT NULL default '0', `metadesc` varchar(255) default NULL, `metakey` varchar(255) default NULL, `created` date NOT NULL default '0000-00-00', `created_by` int(11) NOT NULL default '0', `access` tinyint(3) NOT NULL default '0', `publish_up` datetime default '0000-00-00 00:00:00', `publish_down` datetime default '0000-00-00 00:00:00', `publish` tinyint(1) NOT NULL default '0', PRIMARY KEY (`id`), UNIQUE KEY `id` (`id`) ) ENGINE=MyISAM;
SQL =
CREATE TABLE `mos_estateagent` (
`id` int(10) NOT NULL auto_increment,
`obj_id` varchar(25) default NULL,
`cat` tinyint(4) NOT NULL default '0',
`type` tinyint(2) NOT NULL default '0',
`title` varchar(255) NOT NULL,
`description` text,
`location` text,
`condition` text,
`other` text,
`rooms` smallint(4) default NULL,
`space` decimal(10,2) default NULL,
`homes` smallint(5) default NULL,
`homes_size` decimal(10,2) default NULL,
`pp_size` decimal(10,2) default NULL,
`trade_units` smallint(5) default NULL,
`trade_size` decimal(10,2) default NULL,
`position` varchar(50) default NULL,
`lift` tinyint(1) NOT NULL default '0',
`yobuilt` smallint(6) NOT NULL default '0',
`toheat` tinytext,
`toheat_ufloor` tinyint(1) NOT NULL default '0',
`balcony` tinyint(1) NOT NULL default '0',
`terrace` tinyint(1) NOT NULL default '0',
`garden_size` decimal(10,2) default NULL,
`parkarea` tinyint(1) NOT NULL default '0',
`garage` tinyint(1) NOT NULL default '0',
`rent` decimal(10,2) NOT NULL default '0.00',
`rent_extra` decimal(10,2) NOT NULL default '0.00',
`price` decimal(10,2) NOT NULL default '0.00',
`commis` varchar(15) NOT NULL default '',
`secure` decimal(10,2) NOT NULL default '0.00',
`receipts` decimal(10,2) NOT NULL default '0.00',
`street` varchar(255) default NULL,
`streetnr` varchar(5) default NULL,
`pcode` varchar(10) default NULL,
`town` tinytext,
`district` tinytext,
`state` tinytext,
`country` tinytext,
`hits` int(6) NOT NULL default '0',
`hot` tinyint(1) NOT NULL default '0',
`metadesc` varchar(255) default NULL,
`metakey` varchar(255) default NULL,
`created` date NOT NULL default '0000-00-00',
`created_by` int(11) NOT NULL default '0',
`access` tinyint(3) NOT NULL default '0',
`publish_up` datetime default '0000-00-00 00:00:00',
`publish_down` datetime default '0000-00-00 00:00:00',
`publish` tinyint(1) NOT NULL default '0',
PRIMARY KEY (`id`),
UNIQUE KEY `id` (`id`)
) ENGINE=MyISAM;
|
Kann mir jemand da weiter helfen?
MfG
redruM |
|
|
|
|
|
|
The administrator has disabled public write access.
|
sox (User)
Fresh Boarder
Posts: 2
|
|
Re:Installationsproblem 2 Years, 9 Months ago
|
Karma: 0
|
|
Hello!
I changed "estateagent.xml"　as follows, and it's works!(Installed successfully)
-------------------------------------------------
::before:: ) ENGINE=MyISAM;
::after:: ) TYPE=MyISAM
-------------------------------------------------
Is this change OK, Darko?
|
|
|
|
|
|
|
The administrator has disabled public write access.
|
|
|
|
Re:Installationsproblem 2 Years, 9 Months ago
|
Karma: 32
|
|
Hi,
if it works - it?s ok. Thx foryour support.
@redruM: which mySQL version do you use - is it the 3.23.x?
regards,
Darko
|
|
|
|
|
|
|
kindly regards / beste Gruesse
Admin
|
|
|
The administrator has disabled public write access.
|
cjohan (User)
Fresh Boarder
Posts: 3
|
|
Re:Installationsproblem 2 Years, 9 Months ago
|
Karma: 0
|
|
I have the same problem and im running MySQL Version 4.0.15....<br><br>Post edited by: cjohan, at: 2006/01/06 15:40
|
|
|
|
|
|
|
The administrator has disabled public write access.
|
|
|
|
|
|
Forum 
