Public Forums 71,145 posts

[ineedcta Friend ineedctaJoin date: September 2006Posts: 1Downloads:0Uploads:0]

#117272

I get this message when i try to install the repository ext:

SQL Error DB function failed with error number 1067
Invalid default value for 'id' SQL=CREATE TABLE IF NOT EXISTS `jos_downloads_comments` ( `id` int(255) NOT NULL default '', `comment` varchar(255) NOT NULL default '', `userid` int(11) NOT NULL default '0', `time` varchar(14) NOT NULL default '0', KEY `id` (`id`), KEY `userid` (`userid`) ) TYPE=MyISAM;
SQL =

CREATE TABLE IF NOT EXISTS `jos_downloads_comments` (
`id` int(255) NOT NULL default '',
`comment` varchar(255) NOT NULL default '',
`userid` int(11) NOT NULL default '0',
`time` varchar(14) NOT NULL default '0',
KEY `id` (`id`),
KEY `userid` (`userid`)
) TYPE=MyISAM;

Can some one tell me what it means and how to fix it?

Thanks.

[harthoofd Friend harthoofdJoin date: October 2006Posts: 1Downloads:1Uploads:0]

#210936

<blockquote>CREATE TABLE IF NOT EXISTS `jos_downloads_comments` (
`id` int(255) NOT NULL default ”,
`comment` varchar(255) NOT NULL default ”,
`userid` int(11) NOT NULL default ‘0’,
`time` varchar(14) NOT NULL default ‘0’,
KEY `id` (`id`),
KEY `userid` (`userid`)
) TYPE=MyISAM;</blockquote>

the default value from id has not been given, you should change this in install.xml or so to
`id` int(255) NOT NULL default ‘0’ ”

I think it should than work,..

[Author]

Posts