Upgrade from 1.4 to 2.0 failure due to revision tables naming pattern difference

Created on 22 April 2021, over 3 years ago
Updated 26 May 2023, over 1 year ago

Problem/Motivation

I've followed instructions from the homepage of the project to upgrade from 1.x to 2.x. It fails on step 5 (running update.php) ; I get the following:

The following updates returned messages:
jquery_colorpicker module
Update #8200

    Failed: Drupal\Core\Entity\EntityStorageException: Exception thrown while performing a schema update. SQLSTATE[42S22]: Column not found: 1054 Unknown column 'field_session_theme_color_name' in 'where clause': SELECT 1 AS expression FROM {taxonomy_term_r__43de13ff41} t WHERE (field_session_theme_color_name IS NOT NULL) OR (field_session_theme_color_color IS NOT NULL) LIMIT 1 OFFSET 0; Array ( ) in Drupal\Core\Entity\Sql\SqlContentEntityStorage->wrapSchemaException() (line 1619 of /web/core/lib/Drupal/Core/Entity/Sql/SqlContentEntityStorage.php).

I don't know why but it looks for a column called "field_session_theme_color_name" whereas I can see it is called "field_session_theme_color_value" in the table. Suffixes are different.

πŸ› Bug report
Status

Fixed

Version

3.0

Component

Miscellaneous

Created by

πŸ‡«πŸ‡·France progzy

Live updates comments and jobs are added and updated live.
Sign in to follow issues

Comments & Activities

Not all content is available!

It's likely this issue predates Contrib.social: some issue and comment data are missing.

  • πŸ‡ΊπŸ‡¦Ukraine ankondrat4 Lutsk

    Hello.

    I had tried to upgrade module Jquery Colorpicker from 1.4 to 3.0 version, but stopped on Fatal error during update DB:

    wodby@php.container:/var/www/html $ drush cr
     [success] Cache rebuild complete.
    wodby@php.container:/var/www/html $ drush updb
     -------------------- ----------- --------------- --------------------------------------------------------------------------------------------------- 
      Module               Update ID   Type            Description                                                                                        
     -------------------- ----------- --------------- --------------------------------------------------------------------------------------------------- 
      jquery_colorpicker   8200        hook_update_n   Updates the Jquery Colorpicker module from 8.x-1.x to 8.x-2.x.   Version 8.x-2.x of the module     
                                                       changes the underlying field type from  jquery_colorpicker to colorapi_color, adding a dependency  
                                                       on the Color API  module. As such, the configuration needs to be converted to match the new        
                                                       structure. This function handles the configuration changes.                                        
     -------------------- ----------- --------------- --------------------------------------------------------------------------------------------------- 
    
    
     Do you wish to run the specified pending updates? (yes/no) [yes]:
     > 
    >  [notice] Update started: jquery_colorpicker_update_8200
    >  [error]  The "media_image" plugin does not exist. Valid plugin IDs for Drupal\Core\Field\FormatterPluginManager are: colorapi_raw_hex_display, colorapi_raw_rgb_display, colorapi_text_display, colorapi_color_display, comment_username, comment_default, comment_permalink, country_iso_code, country_default, datetime_time_ago, datetime_plain, datetime_custom, datetime_default, entity_reference_revisions_entity_view, file_filemime, file_uri, file_url_plain, file_video, file_rss_enclosure, file_default, file_audio, file_link, file_table, file_size, file_extension, fivestar_percentage, fivestar_stars, fivestar_rating, geofield_latlon, geofield_default, image, image_url, jquery_colorpicker_text_display, jquery_colorpicker_color_display, jquery_colorpicker_raw_rgb_display, jquery_colorpicker_raw_hex_display, link_separate, link, oembed, media_thumbnail, slideshare_embed, metatag_empty_formatter, list_key, list_default, redirect_source, responsive_image, smart_trim, smileeu_common_string, smileeu_fivestar_stars, entity_reference_rss_category, text_summary_or_trimmed, text_default, text_trimmed, user_name, author, video_embed_field_thumbnail, video_embed_field_video, video_embed_field_lazyload, video_embed_field_colorbox, voting_api_formatter, webform_entity_reference_link, webform_entity_reference_entity_view, webform_entity_reference_url, paragraph_summary, entity_reference_entity_id, language, boolean, number_integer, timestamp, number_unformatted, entity_reference_entity_view, string, entity_reference_label, basic_string, timestamp_ago, email_mailto, uri_link, number_decimal 
    >  [error]  Update failed: jquery_colorpicker_update_8200 
     [error]  Update aborted by: jquery_colorpicker_update_8200 
     [error]  Finished performing updates. 
    
    

    How to resolve this issue and continue upgrade to major version?

    Please, help.

  • πŸ‡ΊπŸ‡¦Ukraine podarok Ukraine

    @ankondrat4 could you open a new issue, please?

  • πŸ‡ΊπŸ‡¦Ukraine ankondrat4 Lutsk

    @podarok yes, I have created new issue #3360322

Production build 0.71.5 2024