Author Topic: upgrade db error (Read 3166 times)

myles · January 13, 2009, 07:36:06 am

Sorry. A non-recoverable error has occurred.

DB Error: already exists

Database Error Code: Duplicate entry '7' for key 1, 1062

Return to home page.

Error Details:

Array
(
[callback] => Array
(

=> CRM_Core_Error

Code: [Select]

 => -5
    [message] => DB Error: already exists
    [mode] => 16
    [debug_info] => INSERT INTO `civicrm_component` (`id`, `name`, `namespace`) VALUES ( 7,'CiviCase','CRM_Case' ) [nativecode=1062 ** Duplicate entry '7' for key 1]
    [type] => DB_Error
    [user_info] => INSERT INTO `civicrm_component` (`id`, `name`, `namespace`) VALUES ( 7,'CiviCase','CRM_Case' ) [nativecode=1062 ** Duplicate entry '7' for key 1]
    [to_string] => [db_error: message="DB Error: already exists" code=-5 mode=callback callback=CRM_Core_Error::handle prefix="" info="INSERT INTO `civicrm_component` (`id`, `name`, `namespace`) VALUES ( 7,'CiviCase','CRM_Case' ) [nativecode=1062 ** Duplicate entry '7' for key 1]"]
)

I have to break off for a while, more debugging / info as I unearth it!

Kurund Jalmi · January 13, 2009, 07:42:27 am

Did you start upgrade with clean CiviCRM 2.1.x db ?

Kurund

myles · January 13, 2009, 09:59:16 am

Clean?

This is a development environment using a copy of actual data.

Nothing rude though!

Kurund Jalmi · January 13, 2009, 10:07:48 am

Quote

Clean?

I mean can you import 2.1 working db and retry upgrade.

Kurund

Michał Mach · January 14, 2009, 12:39:32 am

Hey,

Quote from: myles on January 13, 2009, 07:36:06 am

Database Error Code: Duplicate entry '7' for key 1, 1062

Did you have any custom components defined in your civicrm_component table? It seems like there is a record with id = 7 already... Can you please check the contents of this table?

Thx,
m

myles · January 14, 2009, 01:21:10 am

I'm afraid that there will be a delay of a couple of days - I am an operational member of a charity who happened to have once had roles in IT - since I couldn't stand not having tools to do my job I have been putting things together - I have to attend to the day job for a couple of days and will then work out how to get round this.

For now some further background on the installation - It was a clean, working 2.1 database. I could and probably shall restore it once I've understood the nature of the error, that I am delighted to investigate.

I have been tracking civicase for some time and have had cases turned on since 1.x exploring ways of using it. It may be that - I shall investigate, but don't expect answers for a couple of days - sorry.

myles · January 22, 2009, 05:26:58 am

I rolled back to 2.1 database and code and ensured that everything was working as it should.

I then checked the components table - it looked something like this:

id	name	namespace
1	CiviEvent	CRM_Event
2	CiviContribute	CRM_Contribute
3	CiviMember	CRM_Member
4	CiviMail	CRM_Mail
5	CiviGrant	CRM_Grant
6	CiviEvent	CRM_Event
7	CiviContribute	CRM_Contribute
8	CiviMember	CRM_Member
9	CiviMail	CRM_Mail
10	CiviGrant	CRM_Grant
11	CiviEvent	CRM_Event
12	CiviContribute	CRM_Contribute
13	CiviMember	CRM_Member
14	CiviMail	CRM_Mail
15	CiviGrant	CRM_Grant
16	CiviPledge	CRM_Pledge

So
I deleted all the duplicates;
changed the Pledge id to 6 (having first updated the constraining fields in the menu table);
re-applied the upgrade...

Upgrade reported success and everything appears to work... now to start exploring!

CiviCRM Community Forums (archive)

News:

Author Topic: upgrade db error (Read 3166 times)

myles

upgrade db error

Kurund Jalmi

Re: upgrade db error

myles

Re: upgrade db error

Kurund Jalmi

Re: upgrade db error

Michał Mach

Re: upgrade db error

myles

Re: upgrade db error

myles

Re: upgrade db error - success (with odd bits)