Error in linkit_update_7303: Unknown column 'weight' in 'field list'

Created on 11 January 2017, almost 8 years ago
Updated 20 October 2023, about 1 year ago

Introduced in #2311957: Add weights to linkit profiles with commit:
http://cgit.drupalcode.org/linkit/commit/?h=7.x-3.x&id=542ad173c232b08d8...

Steps to reproduce:

  1. Install 7.x-2.7
  2. Have at least one Linkit profile.
  3. Update to latest 7.x-3.x-dev

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'weight' in 'field list'

🐛 Bug report
Status

Fixed

Version

3.0

Component

Code

Created by

🇧🇬Bulgaria MiroslavBanov

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.

  • 🇮🇹Italy eliosh Bacoli

    Hi,
    I was coming from 2.7 and patch in #11 doesn't work, with the same message as always:

    $ drush updb
     Linkit  7303  Fixed 7302. Set URL type to "Entity view page" to preserve current behavior.  
     Linkit  7304  Make sure admin_description can be null.                                      
     Linkit  7305  Add profile 'weight' column.
    Do you wish to run all pending updates? (y/n): y
    SQLSTATE[42S22]: Column not found: 1054 Unknown column 'weight' in 'field list'                                                                                                                                       [error]
    Performed update: linkit_update_7303                                                                                                                                                                                  [ok]
    
    
  • 🇬🇧United Kingdom featherbelly London, UK

    @eliosh you'll probably need to run ALL of the updates again as the patch affects linkit_update_7300.

  • 🇮🇹Italy eliosh Bacoli

    @fatherbelly I've changed the system table and set schema_version to 7227.
    Run drush updb and...

    # drush8 updb
    
     Linkit  7300  Migrate settings from v2 to v3 if needed.                                     
     Linkit  7301  Do nothing. Update the schema version.                                        
     Linkit  7302  Reverted.                                                                     
     Linkit  7303  Fixed 7302. Set URL type to "Entity view page" to preserve current behavior.  
     Linkit  7304  Make sure admin_description can be null.                                      
     Linkit  7305  Add profile 'weight' column.
    Do you wish to run all pending updates? (y/n): y
    Performed update: linkit_update_7300                                                                                                      [ok]
    Performed update: linkit_update_7301                                                                                                      [ok]
    Performed update: linkit_update_7302                                                                                                      [ok]
    SQLSTATE[42S22]: Column not found: 1054 Unknown column 'weight' in 'field list'                                                           [error]
    
    
  • 🇷🇺Russia skylord

    #11 worked fine for upgrade from 2.7 to 3.6. Have disabled module, replaced files, applied patch and run "drush updb".

  • 🇨🇦Canada danrod Ottawa

    Patch # 11 is not working for me, can anyone provide the steps on how to apply the patch and run the updates, please?

  • 🇫🇮Finland sthomen

    This patch might work better. #11 requires that you have not already run 7300. Instead of removing the removal of the 'weight' field I just add it back in 7303. This patch (like #11) also removes the risky use of drupal_get_schema_unprocessed() (it will give you the _current_ schema, but how do you know it represents the expected schema at the given update?).

  • 🇨🇦Canada optasy

    Patch #17 did the work for me, thanks for that @sthomen !

  • Status changed to Fixed about 1 year ago
  • 🇺🇸United States mark_fullmer Tucson

    Thanks for the input, everyone! I've committed the patch from #17 to the 7.x-3.x branch.

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

Production build 0.71.5 2024