vavroom
|
Can't install - 2006/01/26 00:19
I've grabbed 3.40 beta 2 and am trying to install it, it's a no go. I'm getting the following error message:
| Code: |
SQL Error DB function failed with error number 1067
Invalid default value for 'itemid' SQL=CREATE TABLE IF NOT EXISTS `aliro_downloads_reviews` ( `id` int NOT NULL auto_increment, `sequence` int NOT NULL default '0', `windowtitle` varchar(255) NOT NULL default '', `keywords` varchar(255) NOT NULL default '', `component` varchar (255) NOT NULL default '', `itemid` int NOT NULL default '', `userid` mediumint NOT NULL default '0', `userURL` varchar(255) NOT NULL default '', `title` varchar (255) NOT NULL default '', `comment` text NOT NULL default '', `fullreview` text NOT NULL default '', `date` datetime NOT NULL default '', UNIQUE KEY `id` (`id`), KEY `userid` (`component`,`itemid`,`userid`) ) TYPE=MyISAM;
SQL =
CREATE TABLE IF NOT EXISTS `aliro_downloads_reviews` (
`id` int NOT NULL auto_increment,
`sequence` int NOT NULL default '0',
`windowtitle` varchar(255) NOT NULL default '',
`keywords` varchar(255) NOT NULL default '',
`component` varchar (255) NOT NULL default '',
`itemid` int NOT NULL default '',
`userid` mediumint NOT NULL default '0',
`userURL` varchar(255) NOT NULL default '',
`title` varchar (255) NOT NULL default '',
`comment` text NOT NULL default '',
`fullreview` text NOT NULL default '',
`date` datetime NOT NULL default '',
UNIQUE KEY `id` (`id`),
KEY `userid` (`component`,`itemid`,`userid`)
) TYPE=MyISAM;
|
I'm trying to install locally on a mambo 4.5.3h install.
Any assistance with this would be greatly appreciated.
Thanks
|
Forum
