updatedb errors from 2.33 > 2.40.rc|2.40|2.41 [#2486689]

drush updatedb (7.2.33 > 7.2.40.rc)

 Oa_core        7231  Mark that node access needs to be rebuilt.                                                 
 Oa_discussion  7104  Convert discussion replies to comments. This is batched and may take a while, and will run 
                      twice per reply.                                                                           
 Oa_related     7101  Update the Related content paragraph styles.
Do you wish to run all pending updates? (y/n): y
Performed update: oa_related_update_7101                                                                [ok]
<strong>WD comment: PDOException:  in drupal_write_record() (line 7320 of                                       [error]</strong>
<stong>oa/includes/common.inc).</strong>
<strong>SQLSTATE[HY000]: General error: 1366 Incorrect string value: '\xC3' for column 'subject' at row 1       [error]</strong>
Performed update: oa_discussion_update_7104                                                             [ok]
'all' cache was cleared.                                                                                [success]
Finished performing updates.                                                                            [ok]

drush updatedb (7.2.33 > 7.2.40)

 Bootstrap_tour    7200  Upgrade old 1.x tours to the new 2.x Entity format, then delete the old DB table.      
 Colorizer         7100  7100 -                                                                                 
 Oa_core           7231  Mark that node access needs to be rebuilt.                                             
 Oa_core           7232  Remove orphaned records in og_role table.                                              
 Oa_discussion     7104  Convert discussion replies to comments. This is batched and may take a while, and will 
                         run twice per reply.                                                                   
 Oa_discussion     7105  Update discussion widgets to use new comment widgets.                                  
 Oa_related        7101  Update the Related content paragraph styles.                                           
 Panopoly_core     7103  Disown content types that belong to disabled modules.                                  
 Panopoly_images   7103  Change the image style labels.                                                         
 Panopoly_wysiwyg  7102  Add image classes to captions so responsive images don't break                         
 Panopoly_wysiwyg  7103  Remove the 'Convert line breaks into HTML' filter from the WYSIWYG format.             
 Paragraphs        7100  Make sure all paragraph fields have the new index on revision_id.                      
 Paragraphs        7101  Make sure the entitycache table exists.
Do you wish to run all pending updates? (y/n): y
Performed update: panopoly_wysiwyg_update_7102                                                          [ok]
class_implements(): Class BootstrapTourEntityController does not exist and could not be loaded          [warning]
entity.module:1474
in_array() expects parameter 2 to be array, boolean given entity.module:1474                            [warning]
PHP Fatal error:  Class 'EntityInlineEntityFormController' not found in oa/profiles/openatrium/modules/contrib/bootstrap_tour/includes/bootstrap_tour.controller.inc on line 94

Fatal error: Class 'EntityInlineEntityFormController' not found in oa/profiles/openatrium/modules/contrib/bootstrap_tour/includes/bootstrap_tour.controller.inc on line 94
<strong>Drush command terminated abnormally due to an unrecoverable error.                                      [error]</strong>
<strong>Error: Class 'EntityInlineEntityFormController' not found in
oa/profiles/openatrium/modules/contrib/bootstrap_tour/includes/bootstrap_tour.controller.inc,
line 94</strong>
<strong>The external command could not be executed due to an application error.                                 [error]</strong>
<strong>PHP Fatal error:  Class 'EntityInlineEntityFormController' not found in oa/profiles/openatrium/modules/contrib/bootstrap_tour/includes/bootstrap_tour.controller.inc on line 94</strong>
<strong>Drush command terminated abnormally due to an unrecoverable error.                                      [error]</strong>
<strong>Error: Class 'EntityInlineEntityFormController' not found in
oa/profiles/openatrium/modules/contrib/bootstrap_tour/includes/bootstrap_tour.controller.inc,
line 94</strong>
<strong>The external command could not be executed due to an application error.                                 [error]</strong>
Finished performing updates.                                                                            [ok]

drush updatedb (7.2.33 > 7.2.41)

 Bootstrap_tour    7200  Upgrade old 1.x tours to the new 2.x Entity format, then delete the old DB table.      
 Colorizer         7100  7100 -                                                                                 
 Oa_core           7231  Mark that node access needs to be rebuilt.                                             
 Oa_core           7232  Remove orphaned records in og_role table.                                              
 Oa_discussion     7104  Convert discussion replies to comments. This is batched and may take a while, and will 
                         run twice per reply.                                                                   
 Oa_discussion     7105  Update discussion widgets to use new comment widgets.                                  
 Oa_related        7101  Update the Related content paragraph styles.                                           
 Panopoly_core     7103  Disown content types that belong to disabled modules.                                  
 Panopoly_images   7103  Change the image style labels.                                                         
 Panopoly_wysiwyg  7102  Add image classes to captions so responsive images don't break                         
 Panopoly_wysiwyg  7103  Remove the 'Convert line breaks into HTML' filter from the WYSIWYG format.             
 Paragraphs        7100  Make sure all paragraph fields have the new index on revision_id.                      
 Paragraphs        7101  Make sure the entitycache table exists.
Do you wish to run all pending updates? (y/n): y
Performed update: panopoly_wysiwyg_update_7102                                                          [ok]
DOMDocument::loadHTML(): Unexpected end tag : p in Entity, line: 4 panopoly_wysiwyg.module:392          [warning]
DOMDocument::loadHTML(): Unexpected end tag : p in Entity, line: 5 panopoly_wysiwyg.module:392          [warning]
DOMDocument::loadHTML(): Unexpected end tag : p in Entity, line: 6 panopoly_wysiwyg.module:392          [warning]
<strong>WD comment: PDOException:  in drupal_write_record() (line 7320 of                                       [error]</strong>
<strong>oa/includes/common.inc).</strong>
<strong>SQLSTATE[HY000]: General error: 1366 Incorrect string value: '\xC3' for column 'subject' at row 1       [error]</strong>
Performed update: oa_discussion_update_7104                                                             [ok]
'all' cache was cleared.                                                                                [success]
Finished performing updates.                                                                            [ok]

Comments

Comment #1

Andrés Chandía CreditAttribution: Andrés Chandía commented 15 May 2015 at 14:55

In one of my installations I did this as suggested in https://www.drupal.org/node/2485587 and it worked:

mv myoainstallation myoainstallation_old
tar zxvf openatrium-7.x-2.41-core.tar.gz
mv openatrium-7.x-2.41 myoainstallation
cp -ar myoainstallation_old/sites myoainstallation
drush pm-enable inline_entity_form
drush updatedb

but on my other installation it didn't work, I copy all the process for you see what could be wrong, and hopefully help me on how to solve it, thanks.

root@parles:/srv/web/llocs/gp2# drush pm-enable inline_entity_form
inline_entity_form is already enabled.                                                                          [ok]
There were no extensions that could be enabled.                                                                 [ok]
root@parles:/srv/web/llocs/gp2# drush updatedb
 Bootstrap_tour    7200  Upgrade old 1.x tours to the new 2.x Entity format, then delete the old DB table.                
 Colorizer         7100  7100 -                                                                                           
 Oa_core           7231  Mark that node access needs to be rebuilt.                                                       
 Oa_core           7232  Remove orphaned records in og_role table.                                                        
 Oa_discussion     7104  Convert discussion replies to comments. This is batched and may take a while, and will run twice 
                         per reply.                                                                                       
 Oa_discussion     7105  Update discussion widgets to use new comment widgets.                                            
 Oa_related        7101  Update the Related content paragraph styles.                                                     
 Panopoly_core     7103  Disown content types that belong to disabled modules.                                            
 Panopoly_images   7103  Change the image style labels.                                                                   
 Panopoly_wysiwyg  7102  Add image classes to captions so responsive images don't break                                   
 Panopoly_wysiwyg  7103  Remove the 'Convert line breaks into HTML' filter from the WYSIWYG format.                       
 Paragraphs        7100  Make sure all paragraph fields have the new index on revision_id.                                
 Paragraphs        7101  Make sure the entitycache table exists.
Do you wish to run all pending updates? (y/n): y
Performed update: panopoly_wysiwyg_update_7102                                                                  [ok]
DOMDocument::loadHTML(): Unexpected end tag : p in Entity, line: 4 panopoly_wysiwyg.module:392                  [warning]
DOMDocument::loadHTML(): Unexpected end tag : p in Entity, line: 5 panopoly_wysiwyg.module:392                  [warning]
DOMDocument::loadHTML(): Unexpected end tag : p in Entity, line: 6 panopoly_wysiwyg.module:392                  [warning]
WD comment: PDOException:  in drupal_write_record() (line 7320 of /srv/web/llocs/gp2/includes/common.inc).      [error]
SQLSTATE[HY000]: General error: 1366 Incorrect string value: '\xC3' for column 'subject' at row 1               [error]
Performed update: oa_discussion_update_7104                                                                     [ok]
WD bootstrap_tour_step: PDOException: SQLSTATE[42S02]: Base table or view not found: 1146 Table                 [error]
'gp2.bootstrap_tour_step' doesn't exist: INSERT INTO {bootstrap_tour_step} (path, selector, placement, title,
content, content_text_format) VALUES (:db_insert_placeholder_0, :db_insert_placeholder_1,
:db_insert_placeholder_2, :db_insert_placeholder_3, :db_insert_placeholder_4, :db_insert_placeholder_5); Array
(
    [:db_insert_placeholder_0] => node/add/oa-space
    [:db_insert_placeholder_1] => #edit-field-oa-banner-position-und
    [:db_insert_placeholder_2] => right
    [:db_insert_placeholder_3] => Space Banner
    [:db_insert_placeholder_4] => Select a banner image to be uploaded. &nbsp;Banner images should have an
aspect ratio appropriate for streching across the full width of the site.
    [:db_insert_placeholder_5] => panopoly_wysiwyg_text
)
 in drupal_write_record() (line 7320 of /srv/web/llocs/gp2/includes/common.inc).
WD php: PDOException: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'gp2.bootstrap_tour_step'       [error]
doesn't exist: INSERT INTO {bootstrap_tour_step} (path, selector, placement, title, content,
content_text_format) VALUES (:db_insert_placeholder_0, :db_insert_placeholder_1, :db_insert_placeholder_2,
:db_insert_placeholder_3, :db_insert_placeholder_4, :db_insert_placeholder_5); Array
(
    [:db_insert_placeholder_0] => node/add/oa-space
    [:db_insert_placeholder_1] => #edit-field-oa-banner-position-und
    [:db_insert_placeholder_2] => right
    [:db_insert_placeholder_3] => Space Banner
    [:db_insert_placeholder_4] => Select a banner image to be uploaded. &nbsp;Banner images should have an
aspect ratio appropriate for streching across the full width of the site.
    [:db_insert_placeholder_5] => panopoly_wysiwyg_text
)
 in drupal_write_record() (line 7320 of /srv/web/llocs/gp2/includes/common.inc).
Drush command terminated abnormally due to an unrecoverable error.                                              [error]
PDOException: SQLSTATE[42S02]: Base table or view not found: 1146 Table &#039;gp2.bootstrap_tour_step&#039; doesn&#039;t exist: INSERT INTO {bootstrap_tour_step} (path, selector, placement, title, content, content_text_format) VALUES (:db_insert_placeholder_0, :db_insert_placeholder_1, :db_insert_placeholder_2, :db_insert_placeholder_3, :db_insert_placeholder_4, :db_insert_placeholder_5); Array
(
    [:db_insert_placeholder_0] => node/add/oa-space
    [:db_insert_placeholder_1] => #edit-field-oa-banner-position-und
    [:db_insert_placeholder_2] => right
    [:db_insert_placeholder_3] => Space Banner
    [:db_insert_placeholder_4] => <p><span>Select a banner image to be uploaded. &nbsp;</span></p><p><span>Banner images should have an aspect ratio appropriate for streching across the full width of the site.</span></p>
    [:db_insert_placeholder_5] => panopoly_wysiwyg_text
)
 a drupal_write_record() (línia 7320 de /srv/web/llocs/gp2/includes/common.inc).
Finished performing updates.                                                                                    [ok]

Comment #2

gandhiano CreditAttribution: gandhiano as a volunteer and commented 11 June 2015 at 21:41

Getting a similar issue on upgrading from 2.33 > 2.41 through Aegir

Executing oa_discussion_update_7104
WD comment: PDOException: in drupal_write_record() (line 7320 of /data/disk/anchovy/static/co-munity-7.x-2.41/includes/common.inc).
SQLSTATE[22007]: Invalid datetime format: 1366 Incorrect string value: '\xC2' for column 'subject' at row 1

Comment #3

mpotter CreditAttribution: mpotter commented 12 June 2015 at 12:58

Status:

Active

» Fixed

The error in #2 can be fixed with the patch here: http://cgit.drupalcode.org/oa_discussion/commit/?id=0ca6b93651c0980c3fbc... It's already part of the oa_discussion dev version and was caused by long discussion reply subjects that contained unicode characters.