I've upgraded Workflow from 7.x-2.0-beta12 to 7.x-2.3 and I've the following error after running update.php

PDOException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'base.name' in 'field list': SELECT base.tid AS tid, base.name AS name, base.label AS label, base.sid AS sid, base.target_sid AS target_sid, base.roles AS roles FROM {workflow_transitions} base; Array ( ) in EntityAPIController->query() (regel 187 van /Applications/MAMP/htdocs/www.tdms.be/sites/all/modules/contrib/entity/includes/entity.controller.inc).

When i set the foreach as last in workflow_update_7011() it works.

Comments

  • Commit 3716651 on 7.x-2.x by johnv:
    Issue #2265147: Fixed error in workflow_update_7011() during update.php.
    
johnv’s picture

Status: Active » Fixed

Thanks, this should be fixed in next version.

The upgrade does a re-save of your workflows. You can do this by hand, too.

Status: Fixed » Closed (fixed)

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

yan’s picture

Version: 7.x-2.3 » 7.x-2.5
Status: Closed (fixed) » Active

Similar error when I enable the module during the upgrade process from D6 to D7 and before I run the upgrade script (which produces no errors in my case):

PDOException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'base.label' in 'field list': SELECT base.wid AS wid, base.name AS name, base.label AS label, base.status AS status, base.module AS module, base.tab_roles AS tab_roles, base.options AS options FROM {workflows} base; Array() in EntityAPIController->query() (line 187 of /sites/all/modules/entity/includes/entity.controller.inc).

PDOException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'base.label' in 'field list': SELECT base.wid AS wid, base.name AS name, base.label AS label, base.status AS status, base.module AS module, base.tab_roles AS tab_roles, base.options AS options FROM {workflows} base; Array() in EntityAPIController->query() (line 187 of /sites/all/modules/entity/includes/entity.controller.inc).

Cannot modify header information - headers already sent by (output started at /usr/share/php/drush/includes/output.inc:38) bootstrap.inc:1232

The upgrade seems to work, though. (Just that views with workflow options are extremely (!) slow.)

johnv’s picture

Status: Active » Postponed (maintainer needs more info)

@yan, which version of the entity module are/were you using?

yan’s picture

Priority: Normal » Minor
Status: Postponed (maintainer needs more info) » Active

I'm using Entity API 7.x-1.6.
But iirc the error just appears when I enable the module before running update.php.

johnv’s picture

Status: Active » Closed (works as designed)

OK, that's normal behaviour.
Between uploading a newversion of a module and running update.php, the system is in an undetermined state.
Even during running update.php, Drupal puts the site on 'maintenence mode'.

Let's call this 'works as designed', OK?

yan’s picture

Ok. What's confusing to me is that it seems that some modules need to be enabled before running update.php and others afterwards.