Public Forums 71,145 posts

[slomas Friend slomasJoin date: January 2007Posts: 3Downloads:0Uploads:0]

#120928

I am trying to install Remository Ext and get the error below. Can anyone tell me how to correct this?

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;

[bipod Friend bipodJoin date: August 2007Posts: 3Downloads:0Uploads:0]

#228275

Re: Error DB function failed with error number 1067
Hi Slomas
I am getting the same error when trying to install this Ext.
Has anyone found the fix for this yet or any ideas?

Thanx
Bipod

[MuffinDCC Friend MuffinDCCJoin date: March 2007Posts: 230Downloads:0Uploads:0]

#228279

Didnt Remository employ this feature already?

[kashxo Friend kashxoJoin date: April 2007Posts: 605Downloads:0Uploads:21 Thanks: 11 Thanked: 78 times in 40 posts]

#228304

As it said, the ID got invalid default value, As ‘ID’ was primary key in most case, you shouldn’t give it a default value.
I suggest you do like this:
– Open XML file inside the install package.
– find the line contain that Query
– Replace
`id` int(255) NOT NULL default ''
with this
`id` INT NOT NULL AUTO_INCREMENT PRIMARY KEY

I think that will work for you guys.

[bipod Friend bipodJoin date: August 2007Posts: 3Downloads:0Uploads:0]

#228368

Thanx for the assist Kashxo:D
I will try this and give you feedback when done.
I didn’t set any values on this but installed the component as was downloaded.
Not sure why this would install for some with this value and with others throw out an error though :confused:

[bipod Friend bipodJoin date: August 2007Posts: 3Downloads:0Uploads:0]

#228430

This seems to be going from one thing to the next on this instal.
Now getting the following error..
/public_html/media/install_46d7057790a73/remository.php does not exist!
I have checked this and the file is there and even tried renaming the file by adding the .php to the end of it but still the same error..
I tried re downloading the zip and then doing the changes to the XML file but still the same.
Is there an updated download available for this component?

[Author]

Posts