Updating the panels module from version 3.3 directly to version 3.6 results in a problem during the database updating process. Error "Unknown column 'storage_type' in field list" is thrown during panels_update_7302, probably because the panel display methods used there already work with the storage_type while it is not existent until panels_update_7305.

Possible solutions for the user at the moment:
Either install update by update instead of skipping 3.4 and 3.5 (version 3.5 is sufficient) or manually set the schema_version of panels to 7302 in the system-table, run update.php, switch back to 7301 (or 0) and run update.php again.

PS: panels_update_7305 is missing a db_field_exists check, I had to add it to avoid an error when running the update multiple times.

CommentFileSizeAuthor
#11 panels-update-fix-2786073-11.patch977 bytesdsnopek
#9 unknown_column-2786073-9.patch1.57 KBmalcomio
#8 unknown_column-2786073-8.patch1.2 KBmalcomio
#4 panels_update_7305-2786073-4.patch569 bytesericjenkins
Support from Acquia helps fund testing for Drupal Acquia logo

Comments

Martin Schauer created an issue. See original summary.

Martin Schauer’s picture

Martin Schauer CreditAttribution: Martin Schauer commented
Issue summary: View changes
dsnopek’s picture

dsnopek
he/him
Primary language English
Location USA
CreditAttribution: dsnopek commented
Parent issue: » #2786071: Plan for Panels 7.x-3.7 release
ericjenkins’s picture

ericjenkins CreditAttribution: ericjenkins at Exel Digital for Promet Source commented
FileSize
panels_update_7305-2786073-4.patch569 bytes

I encountered the same error when upgrading from 3.3 to 3.6.

Uploaded patch #4 for addressing the db_field_exists check that was pointed out by @Martin Schauer . Please let me know if this looks appropriate.

After updating code to version 3.6, apply the patch and then run the following drush commands in order:

drush sqlq "update system set schema_version=7302 where name='panels'"
drush updb
drush sqlq "update system set schema_version=7301 where name='panels'"
drush updb
bcobin’s picture

bcobin CreditAttribution: bcobin commented

Thanks - you're a lifesaver!

pmkanse’s picture

pmkanse CreditAttribution: pmkanse commented

+1

lstoetzel’s picture

lstoetzel CreditAttribution: lstoetzel commented

+1 to #4, fixed it for me

malcomio’s picture

malcomio CreditAttribution: malcomio at Capgemini commented
FileSize
unknown_column-2786073-8.patch1.2 KB

Here's a patch that seems to work without needing the extra drush commands, although it needs more testing.

malcomio’s picture

malcomio CreditAttribution: malcomio at Capgemini commented
FileSize
unknown_column-2786073-9.patch1.57 KB

Thinking about it, here's a cleaner, DRY-er version.

malcomio’s picture

malcomio CreditAttribution: malcomio at Capgemini commented
dsnopek’s picture

dsnopek
he/him
Primary language English
Location USA
CreditAttribution: dsnopek commented
Status: Needs work » Needs review
FileSize
panels-update-fix-2786073-11.patch977 bytes

@malcomio: Thanks for the patch! I agree with the DRY-ness of it, but here's a different form that keeps the code looking similar to it's current state and solutions to the same problem in the past.

  • japerry committed 3fa0312 on 7.x-3.x 
    Issue #2787123, #2188277, #2786073 by malcomio, japerry, dsnopek,...
japerry’s picture

japerry
Location KVUO
CreditAttribution: japerry commented
Status: Needs review » Fixed

This is fixed.. for now. However, we may need to address the core issue that is causing this problem, see #2787123: Re-write panels_update_7302() to not call panels_save_display() for more info.

Status: Fixed » Closed (fixed)

Automatically closed - issue fixed for 2 weeks with no activity.

webatelier’s picture

webatelier CreditAttribution: webatelier commented

how do i apply this patch when allready updated to 3.7 ?
can i patch 3.7 or do i reverse to 3.6, patch and then update (since 3.7 has solved critical vulnerabilities ...

alek123’s picture

alek123 CreditAttribution: alek123 commented

If you have access to MySQL and you have Panels 3.6 (patched) or 3.7... you can run:

UPDATE `databasename`.`system` SET `schema_version` = '7304' WHERE `system`.`filename` = 'sites/all/modules/panels/panels.module';

Then go to update.php

Alek