Hi. I installed CB Juice 1.7 on a joomla 1.0 site and got the following error:

DB function failed with error number 1062
Duplicate entry '0' for key 1 SQL=INSERT INTO jos_components VALUES( '', 'CBJUICE', 'option=com_cbjuice', 0, 0, 'option=com_cbjuice', 'CBJUICE', 'com_cbjuice', 0, 'js/ThemeOffice/component.png', 0, '' )
SQL =

INSERT INTO jos_components
VALUES( '', 'CBJUICE', 'option=com_cbjuice', 0, 0, 'option=com_cbjuice', 'CBJUICE', 'com_cbjuice', 0, 'js/ThemeOffice/component.png', 0, '' )

Any help appreciated!

Thanks

I would use the CB tools to check for consistency in your databases before trying any cbjuice stuff. Use the CB tools to repair as appropriate.

Can you install other components?

It might be that the id field in jos_components has lost it's auto-increment.

Fixed all errors with CB Tools, re-installed CB Juice but still get same error.

Thanks Wolverton you were correct, the auto increment was gone. I re-selected it and all OK.