Answers.Body: <p>It seems that you may have deleted the 'Activity Assignees' option from the 'activity_contacts' option group. That's what the missing id is supposed to refer to in <code>IN (2, , 3)</code></p>
  
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2015-07-05T18:26:05.327Z
Answers.LastActivityDate: 2015-07-05T18:26:05.327Z
Answers.UserDisplayName: Coleman
Answers.Body: <p>Did you look in your database to see what value it's referring to? I had a database problem when upgrading (not these specific versions) and I had to remove the apostrophe in my organization's name for the upgrade to run successfully. Also, if you've not already tried, I'd recommend incremental upgrades, see if smaller steps like 4.3.9 to 4.3.10 works.</p>
  
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2015-07-06T00:07:33.450Z
Answers.Text: Would be great if you reported the upgrade error message you saw to a new ticket on issues.civicrm.org, that sounds like something worth fixing!
Answers.UserDisplayName: Chris Burgess
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2015-07-04T14:37:40.970Z
Answers.LastActivityDate: 2015-07-04T14:37:40.970Z
Answers.UserDisplayName: RayWright
Body: <p>I am unable to upgrade 4.3.9 version into new version ..</p>
  
  <p>I am getting this error : Error: Consolidate activity contacts</p>
  
  <pre><code>Type    DB_Error
  Code    -2
  Message DB Error: syntax error
  Mode    16
  UserInfo    UPDATE civicrm_option_value SET is_reserved = 1 WHERE option_group_id = 62 AND value IN (2, , 3) [nativecode=1064 ** You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ' 3)' at line 3]
  DebugInfo   UPDATE civicrm_option_value SET is_reserved = 1 WHERE option_group_id = 62 AND value IN (2, , 3) [nativecode=1064 ** You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ' 3)' at line 3]
  </code></pre>
  
Tags: <upgrade><database>
Title: Joomla CiviCRM Upgrade 4.3.9 to 4.4.x version
ThreadText: # Joomla CiviCRM Upgrade 4.3.9 to 4.4.x version
  
  (Asked by: username_0 on 2015-06-30)
  
  I am unable to upgrade 4.3.9 version into new version ..
  I am getting this error : Error: Consolidate activity contacts
  Type    DB_Error
  Code    -2
  Message DB Error: syntax error
  Mode    16
  UserInfo    UPDATE civicrm_option_value SET is_reserved = 1 WHERE option_group_id = 62 AND value IN (2, , 3) [nativecode=1064 ** You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ' 3)' at line 3]
  DebugInfo   UPDATE civicrm_option_value SET is_reserved = 1 WHERE option_group_id = 62 AND value IN (2, , 3) [nativecode=1064 ** You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ' 3)' at line 3]
  
  **Tags:** upgrade, database
  
  
  ---
  
  ## 2 answers
  
  ### Answer by username_1 on 2015-07-05. Score: 1
  
  It seems that you may have deleted the 'Activity Assignees' option from the 'activity\_contacts' option group. That's what the missing id is supposed to refer to in `IN (2, , 3)`
  
  
  ---
  
  ### Answer by username_2 on 2015-07-04. Score: 0
  
  Did you look in your database to see what value it's referring to? I had a database problem when upgrading (not these specific versions) and I had to remove the apostrophe in my organization's name for the upgrade to run successfully. Also, if you've not already tried, I'd recommend incremental upgrades, see if smaller steps like 4.3.9 to 4.3.10 works.
  
  > **Comments:**
  > **username_3**: Would be great if you reported the upgrade error message you saw to a new ticket on issues.civicrm.org, that sounds like something worth fixing!  
  
  ---
  
  