Issue upgrading from 4.34 - Fatal Error (value: is not of the type integer
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 =&gt; 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.