Installation error

9 years 3 months ago #168289 by gordonsteel
Installation error was created by gordonsteel
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

Please Log in to join the conversation.

9 years 3 months ago #168296 by jciconsult
Replied by jciconsult on topic Re: Installation error
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.

Please Log in to join the conversation.

9 years 3 months ago #168363 by wolverton
Replied by wolverton on topic Re: Installation error
Can you install other components?

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

Please Log in to join the conversation.

9 years 3 months ago #168407 by gordonsteel
Replied by gordonsteel on topic Re: Installation error
Fixed all errors with CB Tools, re-installed CB Juice but still get same error.

Please Log in to join the conversation.

9 years 3 months ago #168408 by gordonsteel
Replied by gordonsteel on topic Re: Installation error
Thanks Wolverton you were correct, the auto increment was gone. I re-selected it and all OK.

Please Log in to join the conversation.

Moderators: beatnantjciconsultwolvertonkrileon
Time to create page: 0.401 seconds

Facebook Twitter LinkedIn