Answers.Body: <p>The code that is failing is trying to update a name_badge format.  It looks like 3 new types of labels were added at some point but one of them had an issue and this code is updating that one.</p>
  
  <p>It looks for the id of name_badge in the civicrm_option_group table. It uses that in this sql</p>
  
  <pre><code> UPDATE civicrm_option_value
   SET value = '{$dimension}'
   WHERE option_group_id = %1 AND name = 'Fattorini Name Badge 100x65'
  </code></pre>
  
  <p>I'm guessing for some reason the array that feeds %1 is not an integer.</p>
  
  <p>So what to do?  You can, as link in the comment suggest, comment out the update.  In this case in civicrm/CRM/Upgrade/Incremental/php/FourFour.php around line 176 comment out this code:</p>
  
  <pre><code>CRM_Core_DAO::executeQuery($query, array(1 =&gt; array($ogID, 'Integer')));
  </code></pre>
  
  <p>You might get the problem again with another upgrade.</p>
  
  <p>You might check to see if the following sql comes back with anything</p>
  
  <pre><code>SELECT * FROM `civicrm_option_group` WHERE name = 'name_badge'
  </code></pre>
  
  <p>I think it will.  If so, use the id in the following query.</p>
  
  <pre><code>SELECT name FROM civicrm_option_value WHERE option_group_id =
  </code></pre>
  
  <p>I think you should get back four rows</p>
  
  <pre><code>Avery 5395
  A6 Badge Portrait 150x106
  Fattorini Name Badge 100x65
  Hanging Badge 3-3/4" x 4-3"/4
  </code></pre>
  
  <p>If you don't get anything back from the civicrm_option_group` WHERE name = 'name_badge' query check to see if the civicrm_option_value exists</p>
  
  <pre><code>SELECT option_group_id, 
         name 
  FROM   civicrm_option_value 
  WHERE  name in ('Avery 5395',
                  'A6 Badge Portrait 150x106',
                  'Fattorini Name Badge 100x65',
                  'Hanging Badge 3-3/4" x 4-3"/4')
  </code></pre>
  
  <p>I'm not sure how recommended this is but you can just add the missing name badge row to the civicrm_option_group table.</p>
  
  <pre><code>INSERT INTO `civicrm_option_group` (`name`, `title`, `is_reserved`, `is_active`, `is_locked`) 
                          VALUES ('name_badge','Name Badge Format',true, true, false)
  </code></pre>
  
  <p>Now if you got any of the four option values back you'll need to change their option_group_id to match the id of the row you added with the insert.</p>
  
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2015-08-15T01:16:27.873Z
Answers.Text: Thanks Paul, I've had a look and there's no 'name_badge' row in that table, the closest is 'event_badge'.
Answers.UserDisplayName: mjcarter
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2015-08-15T03:13:35.200Z
Answers.Text: I'm not sure if just editing the answer will make it pop back up for you.  I added some stuff at the end.  I will be backpacking away from electronic for the next four day so...
Answers.UserDisplayName: Paul-Tahoe
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2015-08-16T01:59:26.780Z
Answers.Text: I ran the insert query but got an error because the is_locked column doesn't exist - worked ok without that column specified. I got an empty result set with the SELECT statement. 
  
  Yesterday I tried running the upgrade after commenting out line 9 and that failed because my civicrm_line_item table doesn't have a contribution_id column - not sure if there is something going on with missing columns in the DB, though I found this https://github.com/civicrm/civicrm-core/pull/3240 which suggests that column was added after 4.34
Answers.UserDisplayName: mjcarter
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2015-08-17T03:54:44.903Z
Answers.Text: I ran the schema changes there manually on the DB, but then got an error 'already exists' related to this https://issues.civicrm.org/jira/browse/CRM-14894 - I applied the schema update there and the upgrade completed. However, there was a WSOD after upgrade related to this https://www.drupal.org/node/2363903 - I applied the schema update and was able to load Drupal pages of the site, but there is still a WSOD with Civi, looking at the logs it's due to a missing table error (civicrm_recurring_entity).
Answers.UserDisplayName: mjcarter
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2015-08-17T03:57:29.677Z
Answers.Text: It's as if the upgrade process isn't doing the schema updates. Could this be related to Civi being installed in a combined DB with Drupal rather than in it's own database? At the bottom of the Drupal settings.php I've spotted a bunch of lines starting like this
  
  $databases['default']['default']['prefix']= array(
    'civicrm_acl'                              => '`dbname`.',
    'civicrm_acl_cache'                        => '`dbname`.',
    'civicrm_acl_contact_cache'                => '`dbname`.',
  ...
Answers.UserDisplayName: mjcarter
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2015-08-13T21:19:02.223Z
Answers.LastActivityDate: 2015-08-15T03:12:03.340Z
Answers.LastEditDate: 2015-08-15T03:12:03.340Z
Answers.UserDisplayName: Paul-Tahoe
Body: <p>Have the following error trying to upgrade the DB, any help would be appreciated:</p>
  
  <pre><code>$ drush civicrm-upgrade-db
  Exception: "A fatal error was triggered: One of parameters  (value: ) is not of the type Integer"
  #0 C:\xampp\htdocs\ma\html\sites\all\modules\civicrm\CRM\Utils\Type.php(362): CRM_Core_Error::fatal("One of parameters
  (value: ) is not of the type Integer")
  #1 C:\xampp\htdocs\ma\html\sites\all\modules\civicrm\CRM\Core\DAO.php(1247): CRM_Utils_Type::validate(NULL, "Integer")
  #2 C:\xampp\htdocs\ma\html\sites\all\modules\civicrm\CRM\Core\DAO.php(1166): CRM_Core_DAO::composeQuery("UPDATE civicrm_
  option_value\n        SET value = '{\"paper-size\":\"a4\",\"or...", (Array:1), TRUE)
  #3 C:\xampp\htdocs\ma\html\sites\all\modules\civicrm\CRM\Upgrade\Incremental\php\FourFour.php(176): CRM_Core_DAO::execut
  eQuery("UPDATE civicrm_option_value\n        SET value = '{\"paper-size\":\"a4\",\"or...", (Array:1))
  #4 C:\xampp\htdocs\ma\html\sites\all\modules\civicrm\CRM\Upgrade\Form.php(683): CRM_Upgrade_Incremental_php_FourFour-&gt;up
  grade_4_4_1("4.4.1", "4.3.4", "4.6.5")
  #5 [internal function](): CRM_Upgrade_Form::doIncrementalUpgradeStep(Object(CRM_Queue_TaskContext), "4.4.1", "4.3.4", "4
  .6.5", "C:\Users\Miles\AppData\Local\Temp\civA92E.tmp")
  #6 C:\xampp\htdocs\ma\html\sites\all\modules\civicrm\CRM\Queue\Task.php(88): call_user_func_array((Array:2), (Array:5))
  #7 C:\xampp\htdocs\ma\html\sites\all\modules\civicrm\CRM\Queue\Runner.php(213): CRM_Queue_Task-&gt;run(Object(CRM_Queue_Tas
  kContext))
  #8 C:\xampp\htdocs\ma\html\sites\all\modules\civicrm\CRM\Queue\Runner.php(168): CRM_Queue_Runner-&gt;runNext()
  #9 C:\xampp\htdocs\ma\html\sites\all\modules\civicrm\CRM\Upgrade\Headless.php(67): CRM_Queue_Runner-&gt;runAll()
  #10 C:\xampp\htdocs\ma\html\sites\all\modules\civicrm\drupal\drush\civicrm.drush.inc(689): CRM_Upgrade_Headless-&gt;run()
  #11 [internal function](): drush_civicrm_upgrade_db()
  #12 C:\ProgramData\Drush\includes\command.inc(362): call_user_func_array("drush_civicrm_upgrade_db", (Array:0))
  #13 C:\ProgramData\Drush\includes\command.inc(214): _drush_invoke_hooks((Array:29), (Array:0))
  #14 [internal function](): drush_command()
  #15 C:\ProgramData\Drush\includes\command.inc(182): call_user_func_array("drush_command", (Array:0))
  #16 C:\ProgramData\Drush\drush.php(92): drush_dispatch((Array:29))
  #17 C:\ProgramData\Drush\drush.php(61): _drush_bootstrap_and_dispatch()
  #18 C:\ProgramData\Drush\drush.php(16): drush_main()
  #19 {main}
  WD php: Exception: A fatal error was triggered: One of parameters  (value: ) is not of the type Integer in       [error]
  
  CRM_Core_Error::fatal() (line 328 of C:\xampp\htdocs\ma\html\sites\all\modules\civicrm\CRM\Core\Error.php).
  Exception: A fatal error was triggered: One of parameters  (value: ) is not of the type Integer in CRM_Core_Error::fatal
  () (line 328 of C:\xampp\htdocs\ma\html\sites\all\modules\civicrm\CRM\Core\Error.php).
  Drush command terminated abnormally due to an unrecoverable error.                                               [error]
  </code></pre>
  
Comments.ContentLicense: CC BY-SA 3.0
Comments.CreationDate: 2015-08-13T07:05:01.363Z
Comments.Text: We always suggest searching.  A quick google found this. Is it of any help? https://forum.civicrm.org/index.php?topic=30158.0
Comments.UserDisplayName: petednz - fuzion
Comments.ContentLicense: CC BY-SA 3.0
Comments.CreationDate: 2015-08-15T01:14:56.460Z
Comments.Text: Cheers Pete, yep I already saw that and 'Credit Card' is enabled
Comments.UserDisplayName: mjcarter
Tags: <upgrade>
Title: Issue upgrading from 4.34 - Fatal Error (value: is not of the type integer
ThreadText: # Issue upgrading from 4.34 - Fatal Error (value: is not of the type integer
  
  (Asked by: username_0 on 2015-08-13)
  
  Have the following error trying to upgrade the DB, any help would be appreciated:
  
  ```
  $ drush civicrm-upgrade-db
  Exception: "A fatal error was triggered: One of parameters  (value: ) is not of the type Integer"
  #0 C:\xampp\htdocs\ma\html\sites\all\modules\civicrm\CRM\Utils\Type.php(362): CRM_Core_Error::fatal("One of parameters
  (value: ) is not of the type Integer")
  #1 C:\xampp\htdocs\ma\html\sites\all\modules\civicrm\CRM\Core\DAO.php(1247): CRM_Utils_Type::validate(NULL, "Integer")
  #2 C:\xampp\htdocs\ma\html\sites\all\modules\civicrm\CRM\Core\DAO.php(1166): CRM_Core_DAO::composeQuery("UPDATE civicrm_
  option_value\n        SET value = '{\"paper-size\":\"a4\",\"or...", (Array:1), TRUE)
  #3 C:\xampp\htdocs\ma\html\sites\all\modules\civicrm\CRM\Upgrade\Incremental\php\FourFour.php(176): CRM_Core_DAO::execut
  eQuery("UPDATE civicrm_option_value\n        SET value = '{\"paper-size\":\"a4\",\"or...", (Array:1))
  #4 C:\xampp\htdocs\ma\html\sites\all\modules\civicrm\CRM\Upgrade\Form.php(683): CRM_Upgrade_Incremental_php_FourFour->up
  grade_4_4_1("4.4.1", "4.3.4", "4.6.5")
  #5 [internal function](): CRM_Upgrade_Form::doIncrementalUpgradeStep(Object(CRM_Queue_TaskContext), "4.4.1", "4.3.4", "4
  .6.5", "C:\Users\Miles\AppData\Local\Temp\civA92E.tmp")
  #6 C:\xampp\htdocs\ma\html\sites\all\modules\civicrm\CRM\Queue\Task.php(88): call_user_func_array((Array:2), (Array:5))
  #7 C:\xampp\htdocs\ma\html\sites\all\modules\civicrm\CRM\Queue\Runner.php(213): CRM_Queue_Task->run(Object(CRM_Queue_Tas
  kContext))
  #8 C:\xampp\htdocs\ma\html\sites\all\modules\civicrm\CRM\Queue\Runner.php(168): CRM_Queue_Runner->runNext()
  #9 C:\xampp\htdocs\ma\html\sites\all\modules\civicrm\CRM\Upgrade\Headless.php(67): CRM_Queue_Runner->runAll()
  #10 C:\xampp\htdocs\ma\html\sites\all\modules\civicrm\drupal\drush\civicrm.drush.inc(689): CRM_Upgrade_Headless->run()
  #11 [internal function](): drush_civicrm_upgrade_db()
  #12 C:\ProgramData\Drush\includes\command.inc(362): call_user_func_array("drush_civicrm_upgrade_db", (Array:0))
  #13 C:\ProgramData\Drush\includes\command.inc(214): _drush_invoke_hooks((Array:29), (Array:0))
  #14 [internal function](): drush_command()
  #15 C:\ProgramData\Drush\includes\command.inc(182): call_user_func_array("drush_command", (Array:0))
  #16 C:\ProgramData\Drush\drush.php(92): drush_dispatch((Array:29))
  #17 C:\ProgramData\Drush\drush.php(61): _drush_bootstrap_and_dispatch()
  #18 C:\ProgramData\Drush\drush.php(16): drush_main()
  #19 {main}
  WD php: Exception: A fatal error was triggered: One of parameters  (value: ) is not of the type Integer in       [error]
  
  CRM_Core_Error::fatal() (line 328 of C:\xampp\htdocs\ma\html\sites\all\modules\civicrm\CRM\Core\Error.php).
  Exception: A fatal error was triggered: One of parameters  (value: ) is not of the type Integer in CRM_Core_Error::fatal
  () (line 328 of C:\xampp\htdocs\ma\html\sites\all\modules\civicrm\CRM\Core\Error.php).
  Drush command terminated abnormally due to an unrecoverable error.                                               [error]
  
  ```
  
  **Tags:** upgrade
  
  > **Comments:**
  > **username_1**: We always suggest searching.  A quick google found this. Is it of any help? https://forum.civicrm.org/index.php?topic=30158.0  
  > **username_0**: Cheers Pete, yep I already saw that and 'Credit Card' is enabled  
  
  ---
  
  ## 1 answers
  
  ### Answer by username_2 on 2015-08-13. Score: 1
  
  The code that is failing is trying to update a name\_badge format. It looks like 3 new types of labels were added at some point but one of them had an issue and this code is updating that one.
  
  It looks for the id of name\_badge in the civicrm\_option\_group table. It uses that in this sql
  
  ```
   UPDATE civicrm_option_value
   SET value = '{$dimension}'
   WHERE option_group_id = %1 AND name = 'Fattorini Name Badge 100x65'
  
  ```
  
  I'm guessing for some reason the array that feeds %1 is not an integer.
  
  So what to do? You can, as link in the comment suggest, comment out the update. In this case in civicrm/CRM/Upgrade/Incremental/php/FourFour.php around line 176 comment out this code:
  
  ```
  CRM_Core_DAO::executeQuery($query, array(1 => array($ogID, 'Integer')));
  
  ```
  
  You might get the problem again with another upgrade.
  
  You might check to see if the following sql comes back with anything
  
  ```
  SELECT * FROM `civicrm_option_group` WHERE name = 'name_badge'
  
  ```
  
  I think it will. If so, use the id in the following query.
  
  ```
  SELECT name FROM civicrm_option_value WHERE option_group_id =
  
  ```
  
  I think you should get back four rows
  
  ```
  Avery 5395
  A6 Badge Portrait 150x106
  Fattorini Name Badge 100x65
  Hanging Badge 3-3/4" x 4-3"/4
  
  ```
  
  If you don't get anything back from the civicrm\_option\_group` WHERE name = 'name\_badge' query check to see if the civicrm\_option\_value exists
  
  ```
  SELECT option_group_id, 
         name 
  FROM   civicrm_option_value 
  WHERE  name in ('Avery 5395',
                  'A6 Badge Portrait 150x106',
                  'Fattorini Name Badge 100x65',
                  'Hanging Badge 3-3/4" x 4-3"/4')
  
  ```
  
  I'm not sure how recommended this is but you can just add the missing name badge row to the civicrm\_option\_group table.
  
  ```
  INSERT INTO `civicrm_option_group` (`name`, `title`, `is_reserved`, `is_active`, `is_locked`) 
                          VALUES ('name_badge','Name Badge Format',true, true, false)
  
  ```
  
  Now if you got any of the four option values back you'll need to change their option\_group\_id to match the id of the row you added with the insert.
  
  > **Comments:**
  > **username_0**: Thanks Paul, I've had a look and there's no 'name_badge' row in that table, the closest is 'event_badge'.  
  > **username_2**: I'm not sure if just editing the answer will make it pop back up for you.  I added some stuff at the end.  I will be backpacking away from electronic for the next four day so...  
  > **username_0**: I ran the insert query but got an error because the is_locked column doesn't exist - worked ok without that column specified. I got an empty result set with the SELECT statement.   Yesterday I tried running the upgrade after commenting out line 9 and that failed because my civicrm_line_item table doesn't have a contribution_id column - not sure if there is something going on with missing columns in the DB, though I found this https://github.com/civicrm/civicrm-core/pull/3240 which suggests that column was added after 4.34  
  > **username_0**: I ran the schema changes there manually on the DB, but then got an error 'already exists' related to this https://issues.civicrm.org/jira/browse/CRM-14894 - I applied the schema update there and the upgrade completed. However, there was a WSOD after upgrade related to this https://www.drupal.org/node/2363903 - I applied the schema update and was able to load Drupal pages of the site, but there is still a WSOD with Civi, looking at the logs it's due to a missing table error (civicrm_recurring_entity).  
  > **username_0**: It's as if the upgrade process isn't doing the schema updates. Could this be related to Civi being installed in a combined DB with Drupal rather than in it's own database? At the bottom of the Drupal settings.php I've spotted a bunch of lines starting like this  $databases['default']['default']['prefix']= array(   'civicrm_acl'                              => '`dbname`.',   'civicrm_acl_cache'                        => '`dbname`.',   'civicrm_acl_contact_cache'                => '`dbname`.', ...  
  
  ---
  
  