D5->D6: Unknown columns and DB upgrade failures [#1394126]

After re-enabling all project modules manually I ran updates and got this:

user warning: Unknown column 'r.version_api_tid' in 'where clause' query: SELECT n.nid, n.title, n.created, r.* FROM node n INNER JOIN project_release_nodes r ON r.nid = n.nid WHERE (r.pid = 1) AND (r.version_api_tid = 1) AND (r.version_major = 3) AND (n.status = 1) ORDER BY r.rebuild, r.version_minor DESC, r.version_patch DESC, r.version_extra_weight DESC, r.version_extra_delta DESC, r.version_extra DESC in sites\all\modules\project\release\project_release.module on line 1297.
user warning: Unknown column 'r.version_api_tid' in 'where clause' query: SELECT n.nid, n.title, n.created, r.* FROM node n INNER JOIN project_release_nodes r ON r.nid = n.nid WHERE (r.pid = 1) AND (r.version_api_tid = 1) AND (r.version_major = 3) AND (n.status = 1) ORDER BY r.rebuild, r.version_minor DESC, r.version_patch DESC, r.version_extra_weight DESC, r.version_extra_delta DESC, r.version_extra DESC in sites\all\modules\project\release\project_release.module on line 1297.
user warning: Unknown column 'r.version_api_tid' in 'where clause' query: SELECT n.nid, n.title, n.created, r.* FROM node n INNER JOIN project_release_nodes r ON r.nid = n.nid WHERE (r.pid = 4) AND (r.version_api_tid = 1) AND (r.version_major = 3) AND (n.status = 1) ORDER BY r.rebuild, r.version_minor DESC, r.version_patch DESC, r.version_extra_weight DESC, r.version_extra_delta DESC, r.version_extra DESC in sites\all\modules\project\release\project_release.module on line 1297.
user warning: Unknown column 'r.version_api_tid' in 'where clause' query: SELECT n.nid, n.title, n.created, r.* FROM node n INNER JOIN project_release_nodes r ON r.nid = n.nid WHERE (r.pid = 4) AND (r.version_api_tid = 1) AND (r.version_major = 3) AND (n.status = 1) ORDER BY r.rebuild, r.version_minor DESC, r.version_patch DESC, r.version_extra_weight DESC, r.version_extra_delta DESC, r.version_extra DESC in sites\all\modules\project\release\project_release.module on line 1297.
user warning: Unknown column 'r.version_api_tid' in 'where clause' query: SELECT n.nid, n.title, n.created, r.* FROM node n INNER JOIN project_release_nodes r ON r.nid = n.nid WHERE (r.pid = 4) AND (r.version_api_tid = 2) AND (r.version_major = 3) AND (n.status = 1) ORDER BY r.rebuild, r.version_minor DESC, r.version_patch DESC, r.version_extra_weight DESC, r.version_extra_delta DESC, r.version_extra DESC in sites\all\modules\project\release\project_release.module on line 1297.
user warning: Unknown column 'r.version_api_tid' in 'where clause' query: SELECT n.nid, n.title, n.created, r.* FROM node n INNER JOIN project_release_nodes r ON r.nid = n.nid WHERE (r.pid = 4) AND (r.version_api_tid = 2) AND (r.version_major = 3) AND (n.status = 1) ORDER BY r.rebuild, r.version_minor DESC, r.version_patch DESC, r.version_extra_weight DESC, r.version_extra_delta DESC, r.version_extra DESC in sites\all\modules\project\release\project_release.module on line 1297.
user warning: Unknown column 'r.version_api_tid' in 'where clause' query: SELECT n.nid, n.title, n.created, r.* FROM node n INNER JOIN project_release_nodes r ON r.nid = n.nid WHERE (r.pid = 6) AND (r.version_api_tid = 1) AND (r.version_major = 1) AND (n.status = 1) ORDER BY r.rebuild, r.version_minor DESC, r.version_patch DESC, r.version_extra_weight DESC, r.version_extra_delta DESC, r.version_extra DESC in sites\all\modules\project\release\project_release.module on line 1297.
user warning: Unknown column 'r.version_api_tid' in 'where clause' query: SELECT n.nid, n.title, n.created, r.* FROM node n INNER JOIN project_release_nodes r ON r.nid = n.nid WHERE (r.pid = 6) AND (r.version_api_tid = 1) AND (r.version_major = 1) AND (n.status = 1) ORDER BY r.rebuild, r.version_minor DESC, r.version_patch DESC, r.version_extra_weight DESC, r.version_extra_delta DESC, r.version_extra DESC in sites\all\modules\project\release\project_release.module on line 1297.
user warning: Unknown column 'r.version_api_tid' in 'where clause' query: SELECT n.nid, n.title, n.created, r.* FROM node n INNER JOIN project_release_nodes r ON r.nid = n.nid WHERE (r.pid = 6) AND (r.version_api_tid = 2) AND (r.version_major = 1) AND (n.status = 1) ORDER BY r.rebuild, r.version_minor DESC, r.version_patch DESC, r.version_extra_weight DESC, r.version_extra_delta DESC, r.version_extra DESC in sites\all\modules\project\release\project_release.module on line 1297.
user warning: Unknown column 'r.version_api_tid' in 'where clause' query: SELECT n.nid, n.title, n.created, r.* FROM node n INNER JOIN project_release_nodes r ON r.nid = n.nid WHERE (r.pid = 6) AND (r.version_api_tid = 2) AND (r.version_major = 1) AND (n.status = 1) ORDER BY r.rebuild, r.version_minor DESC, r.version_patch DESC, r.version_extra_weight DESC, r.version_extra_delta DESC, r.version_extra DESC in sites\all\modules\project\release\project_release.module on line 1297.
user warning: Unknown column 'r.version_api_tid' in 'where clause' query: SELECT n.nid, n.title, n.created, r.* FROM node n INNER JOIN project_release_nodes r ON r.nid = n.nid WHERE (r.pid = 12) AND (r.version_api_tid = 1) AND (r.version_major = 3) AND (n.status = 1) ORDER BY r.rebuild, r.version_minor DESC, r.version_patch DESC, r.version_extra_weight DESC, r.version_extra_delta DESC, r.version_extra DESC in sites\all\modules\project\release\project_release.module on line 1297.
user warning: Unknown column 'r.version_api_tid' in 'where clause' query: SELECT n.nid, n.title, n.created, r.* FROM node n INNER JOIN project_release_nodes r ON r.nid = n.nid WHERE (r.pid = 12) AND (r.version_api_tid = 1) AND (r.version_major = 3) AND (n.status = 1) ORDER BY r.rebuild, r.version_minor DESC, r.version_patch DESC, r.version_extra_weight DESC, r.version_extra_delta DESC, r.version_extra DESC in sites\all\modules\project\release\project_release.module on line 1297.
user warning: Unknown column 'r.version_api_tid' in 'where clause' query: SELECT n.nid, n.title, n.created, r.* FROM node n INNER JOIN project_release_nodes r ON r.nid = n.nid WHERE (r.pid = 12) AND (r.version_api_tid = 2) AND (r.version_major = 3) AND (n.status = 1) ORDER BY r.rebuild, r.version_minor DESC, r.version_patch DESC, r.version_extra_weight DESC, r.version_extra_delta DESC, r.version_extra DESC in sites\all\modules\project\release\project_release.module on line 1297.
user warning: Unknown column 'r.version_api_tid' in 'where clause' query: SELECT n.nid, n.title, n.created, r.* FROM node n INNER JOIN project_release_nodes r ON r.nid = n.nid WHERE (r.pid = 12) AND (r.version_api_tid = 2) AND (r.version_major = 3) AND (n.status = 1) ORDER BY r.rebuild, r.version_minor DESC, r.version_patch DESC, r.version_extra_weight DESC, r.version_extra_delta DESC, r.version_extra DESC in sites\all\modules\project\release\project_release.module on line 1297.
user warning: Unknown column 'r.version_api_tid' in 'where clause' query: SELECT n.nid, n.title, n.created, r.* FROM node n INNER JOIN project_release_nodes r ON r.nid = n.nid WHERE (r.pid = 4) AND (r.version_api_tid = 2) AND (r.version_major = 6) AND (n.status = 1) ORDER BY r.rebuild, r.version_minor DESC, r.version_patch DESC, r.version_extra_weight DESC, r.version_extra_delta DESC, r.version_extra DESC in sites\all\modules\project\release\project_release.module on line 1297.
user warning: Unknown column 'r.version_api_tid' in 'where clause' query: SELECT n.nid, n.title, n.created, r.* FROM node n INNER JOIN project_release_nodes r ON r.nid = n.nid WHERE (r.pid = 4) AND (r.version_api_tid = 2) AND (r.version_major = 6) AND (n.status = 1) ORDER BY r.rebuild, r.version_minor DESC, r.version_patch DESC, r.version_extra_weight DESC, r.version_extra_delta DESC, r.version_extra DESC in sites\all\modules\project\release\project_release.module on line 1297.
user warning: Unknown column 'r.version_api_tid' in 'where clause' query: SELECT n.nid, n.title, n.created, r.* FROM node n INNER JOIN project_release_nodes r ON r.nid = n.nid WHERE (r.pid = 12) AND (r.version_api_tid = 1) AND (r.version_major = 5) AND (n.status = 1) ORDER BY r.rebuild, r.version_minor DESC, r.version_patch DESC, r.version_extra_weight DESC, r.version_extra_delta DESC, r.version_extra DESC in sites\all\modules\project\release\project_release.module on line 1297.
user warning: Unknown column 'r.version_api_tid' in 'where clause' query: SELECT n.nid, n.title, n.created, r.* FROM node n INNER JOIN project_release_nodes r ON r.nid = n.nid WHERE (r.pid = 12) AND (r.version_api_tid = 1) AND (r.version_major = 5) AND (n.status = 1) ORDER BY r.rebuild, r.version_minor DESC, r.version_patch DESC, r.version_extra_weight DESC, r.version_extra_delta DESC, r.version_extra DESC in sites\all\modules\project\release\project_release.module on line 1297.
user warning: Unknown column 'r.version_extra_delta' in 'order clause' query: SELECT n.nid, n.title, n.created, r.* FROM node n INNER JOIN project_release_nodes r ON r.nid = n.nid WHERE (r.pid = 1) AND (r.version_api_tid = 1) AND (r.version_major = 3) AND (n.status = 1) ORDER BY r.rebuild, r.version_minor DESC, r.version_patch DESC, r.version_extra_weight DESC, r.version_extra_delta DESC, r.version_extra DESC in sites\all\modules\project\release\project_release.module on line 1297.
user warning: Unknown column 'r.version_extra_delta' in 'order clause' query: SELECT n.nid, n.title, n.created, r.* FROM node n INNER JOIN project_release_nodes r ON r.nid = n.nid WHERE (r.pid = 1) AND (r.version_api_tid = 1) AND (r.version_major = 3) AND (n.status = 1) ORDER BY r.rebuild, r.version_minor DESC, r.version_patch DESC, r.version_extra_weight DESC, r.version_extra_delta DESC, r.version_extra DESC in sites\all\modules\project\release\project_release.module on line 1297.
user warning: Unknown column 'r.version_extra_delta' in 'order clause' query: SELECT n.nid, n.title, n.created, r.* FROM node n INNER JOIN project_release_nodes r ON r.nid = n.nid WHERE (r.pid = 4) AND (r.version_api_tid = 1) AND (r.version_major = 3) AND (n.status = 1) ORDER BY r.rebuild, r.version_minor DESC, r.version_patch DESC, r.version_extra_weight DESC, r.version_extra_delta DESC, r.version_extra DESC in sites\all\modules\project\release\project_release.module on line 1297.
user warning: Unknown column 'r.version_extra_delta' in 'order clause' query: SELECT n.nid, n.title, n.created, r.* FROM node n INNER JOIN project_release_nodes r ON r.nid = n.nid WHERE (r.pid = 4) AND (r.version_api_tid = 1) AND (r.version_major = 3) AND (n.status = 1) ORDER BY r.rebuild, r.version_minor DESC, r.version_patch DESC, r.version_extra_weight DESC, r.version_extra_delta DESC, r.version_extra DESC in sites\all\modules\project\release\project_release.module on line 1297.
user warning: Unknown column 'r.version_extra_delta' in 'order clause' query: SELECT n.nid, n.title, n.created, r.* FROM node n INNER JOIN project_release_nodes r ON r.nid = n.nid WHERE (r.pid = 4) AND (r.version_api_tid = 2) AND (r.version_major = 3) AND (n.status = 1) ORDER BY r.rebuild, r.version_minor DESC, r.version_patch DESC, r.version_extra_weight DESC, r.version_extra_delta DESC, r.version_extra DESC in sites\all\modules\project\release\project_release.module on line 1297.
user warning: Unknown column 'r.version_extra_delta' in 'order clause' query: SELECT n.nid, n.title, n.created, r.* FROM node n INNER JOIN project_release_nodes r ON r.nid = n.nid WHERE (r.pid = 4) AND (r.version_api_tid = 2) AND (r.version_major = 3) AND (n.status = 1) ORDER BY r.rebuild, r.version_minor DESC, r.version_patch DESC, r.version_extra_weight DESC, r.version_extra_delta DESC, r.version_extra DESC in sites\all\modules\project\release\project_release.module on line 1297.
user warning: Unknown column 'r.version_extra_delta' in 'order clause' query: SELECT n.nid, n.title, n.created, r.* FROM node n INNER JOIN project_release_nodes r ON r.nid = n.nid WHERE (r.pid = 6) AND (r.version_api_tid = 1) AND (r.version_major = 1) AND (n.status = 1) ORDER BY r.rebuild, r.version_minor DESC, r.version_patch DESC, r.version_extra_weight DESC, r.version_extra_delta DESC, r.version_extra DESC in sites\all\modules\project\release\project_release.module on line 1297.
user warning: Unknown column 'r.version_extra_delta' in 'order clause' query: SELECT n.nid, n.title, n.created, r.* FROM node n INNER JOIN project_release_nodes r ON r.nid = n.nid WHERE (r.pid = 6) AND (r.version_api_tid = 1) AND (r.version_major = 1) AND (n.status = 1) ORDER BY r.rebuild, r.version_minor DESC, r.version_patch DESC, r.version_extra_weight DESC, r.version_extra_delta DESC, r.version_extra DESC in sites\all\modules\project\release\project_release.module on line 1297.
user warning: Unknown column 'r.version_extra_delta' in 'order clause' query: SELECT n.nid, n.title, n.created, r.* FROM node n INNER JOIN project_release_nodes r ON r.nid = n.nid WHERE (r.pid = 6) AND (r.version_api_tid = 2) AND (r.version_major = 1) AND (n.status = 1) ORDER BY r.rebuild, r.version_minor DESC, r.version_patch DESC, r.version_extra_weight DESC, r.version_extra_delta DESC, r.version_extra DESC in sites\all\modules\project\release\project_release.module on line 1297.
user warning: Unknown column 'r.version_extra_delta' in 'order clause' query: SELECT n.nid, n.title, n.created, r.* FROM node n INNER JOIN project_release_nodes r ON r.nid = n.nid WHERE (r.pid = 6) AND (r.version_api_tid = 2) AND (r.version_major = 1) AND (n.status = 1) ORDER BY r.rebuild, r.version_minor DESC, r.version_patch DESC, r.version_extra_weight DESC, r.version_extra_delta DESC, r.version_extra DESC in sites\all\modules\project\release\project_release.module on line 1297.
user warning: Unknown column 'r.version_extra_delta' in 'order clause' query: SELECT n.nid, n.title, n.created, r.* FROM node n INNER JOIN project_release_nodes r ON r.nid = n.nid WHERE (r.pid = 12) AND (r.version_api_tid = 1) AND (r.version_major = 3) AND (n.status = 1) ORDER BY r.rebuild, r.version_minor DESC, r.version_patch DESC, r.version_extra_weight DESC, r.version_extra_delta DESC, r.version_extra DESC in sites\all\modules\project\release\project_release.module on line 1297.
user warning: Unknown column 'r.version_extra_delta' in 'order clause' query: SELECT n.nid, n.title, n.created, r.* FROM node n INNER JOIN project_release_nodes r ON r.nid = n.nid WHERE (r.pid = 12) AND (r.version_api_tid = 1) AND (r.version_major = 3) AND (n.status = 1) ORDER BY r.rebuild, r.version_minor DESC, r.version_patch DESC, r.version_extra_weight DESC, r.version_extra_delta DESC, r.version_extra DESC in sites\all\modules\project\release\project_release.module on line 1297.
user warning: Unknown column 'r.version_extra_delta' in 'order clause' query: SELECT n.nid, n.title, n.created, r.* FROM node n INNER JOIN project_release_nodes r ON r.nid = n.nid WHERE (r.pid = 12) AND (r.version_api_tid = 2) AND (r.version_major = 3) AND (n.status = 1) ORDER BY r.rebuild, r.version_minor DESC, r.version_patch DESC, r.version_extra_weight DESC, r.version_extra_delta DESC, r.version_extra DESC in sites\all\modules\project\release\project_release.module on line 1297.
user warning: Unknown column 'r.version_extra_delta' in 'order clause' query: SELECT n.nid, n.title, n.created, r.* FROM node n INNER JOIN project_release_nodes r ON r.nid = n.nid WHERE (r.pid = 12) AND (r.version_api_tid = 2) AND (r.version_major = 3) AND (n.status = 1) ORDER BY r.rebuild, r.version_minor DESC, r.version_patch DESC, r.version_extra_weight DESC, r.version_extra_delta DESC, r.version_extra DESC in sites\all\modules\project\release\project_release.module on line 1297.
user warning: Unknown column 'r.version_extra_delta' in 'order clause' query: SELECT n.nid, n.title, n.created, r.* FROM node n INNER JOIN project_release_nodes r ON r.nid = n.nid WHERE (r.pid = 4) AND (r.version_api_tid = 2) AND (r.version_major = 6) AND (n.status = 1) ORDER BY r.rebuild, r.version_minor DESC, r.version_patch DESC, r.version_extra_weight DESC, r.version_extra_delta DESC, r.version_extra DESC in sites\all\modules\project\release\project_release.module on line 1297.
user warning: Unknown column 'r.version_extra_delta' in 'order clause' query: SELECT n.nid, n.title, n.created, r.* FROM node n INNER JOIN project_release_nodes r ON r.nid = n.nid WHERE (r.pid = 4) AND (r.version_api_tid = 2) AND (r.version_major = 6) AND (n.status = 1) ORDER BY r.rebuild, r.version_minor DESC, r.version_patch DESC, r.version_extra_weight DESC, r.version_extra_delta DESC, r.version_extra DESC in sites\all\modules\project\release\project_release.module on line 1297.
user warning: Unknown column 'r.version_extra_delta' in 'order clause' query: SELECT n.nid, n.title, n.created, r.* FROM node n INNER JOIN project_release_nodes r ON r.nid = n.nid WHERE (r.pid = 12) AND (r.version_api_tid = 1) AND (r.version_major = 5) AND (n.status = 1) ORDER BY r.rebuild, r.version_minor DESC, r.version_patch DESC, r.version_extra_weight DESC, r.version_extra_delta DESC, r.version_extra DESC in sites\all\modules\project\release\project_release.module on line 1297.
user warning: Unknown column 'r.version_extra_delta' in 'order clause' query: SELECT n.nid, n.title, n.created, r.* FROM node n INNER JOIN project_release_nodes r ON r.nid = n.nid WHERE (r.pid = 12) AND (r.version_api_tid = 1) AND (r.version_major = 5) AND (n.status = 1) ORDER BY r.rebuild, r.version_minor DESC, r.version_patch DESC, r.version_extra_weight DESC, r.version_extra_delta DESC, r.version_extra DESC in sites\all\modules\project\release\project_release.module on line 1297.
user warning: Duplicate column name 'weight' query: ALTER TABLE project_release_file ADD `weight` TINYINT NOT NULL DEFAULT 0 in includes\database.mysql-common.inc on line 306.
user warning: Duplicate column name 'downloads' query: ALTER TABLE project_release_file ADD `downloads` INT NOT NULL DEFAULT 0 in includes\database.mysql-common.inc on line 306.

Comment	File	Size	Author
#8	1394126_D5-D6_Added+broken+upgrade+path+workaround.patch	5.58 KB	hass
#5	1394126_D5-D6_Added+broken+upgrade+path+workaround.patch	5.58 KB	hass
#4	1394126+project_release_file+table+incorrectly+created.patch	1.48 KB	hass

Comments

Comment #1

hass commented 4 January 2012 at 19:01

Update #6011
Failed: ALTER TABLE {project_release_file} ADD `weight` TINYINT NOT NULL DEFAULT 0
Update #6012
Failed: ALTER TABLE {project_release_file} ADD `downloads` INT NOT NULL DEFAULT 0

Comment #2

hass commented 4 January 2012 at 19:25

May found the reason...

project_release_update_6004() executes project_release_check_supported_versions() before project_release_update_6005() ran and created the column 'version_api_tid'.

Comment #3

hass commented 4 January 2012 at 19:31

project_release_update_6001() installs the project_release_file table based on

  $schema = project_release_schema();
  db_create_table($ret, 'project_release_file', $schema['project_release_file']);

Never do such things... always copy the array to the update function... tables can change later...

Comment #4

hass commented 4 January 2012 at 19:39

Status	File	Size
new	1394126+project_release_file+table+incorrectly+created.patch	1.48 KB

First patch for the project_release_file table bug. (Update #6011 & Update #6012)

Comment #5

hass commented 4 January 2012 at 21:06

Status:

Active

» Needs review

Status	File	Size
new	1394126_D5-D6_Added+broken+upgrade+path+workaround.patch	5.58 KB

This fixes all crashes while updating of release module on my side.

Comment #6

4 January 2012 at 21:08

Status:

Needs review

» Needs work

The last submitted patch, 1394126_D5-D6_Added+broken+upgrade+path+workaround.patch, failed testing.

Comment #7

hass commented 4 January 2012 at 21:17

Patch is not failing because of my patch. There are other bugs in the module.

Comment #8

hass commented 4 January 2012 at 21:25

Status:

Needs work

» Needs review

Status	File	Size
new	1394126_D5-D6_Added+broken+upgrade+path+workaround.patch	5.58 KB

Somehow passed some tabs into the patch. Fixed.

Comment #9

4 January 2012 at 21:28

Status:	Needs review	» Needs work
Issue tags:	-6.x-1.0 blocker

The last submitted patch, 1394126_D5-D6_Added+broken+upgrade+path+workaround.patch, failed testing.

Comment #10

hass commented 17 January 2012 at 01:47

Status:

Needs work

» Needs review

#8: 1394126_D5-D6_Added+broken+upgrade+path+workaround.patch queued for re-testing.

Comment #11

17 January 2012 at 01:50

Status:	Needs review	» Needs work
Issue tags:		+6.x-1.0 blocker

The last submitted patch, 1394126_D5-D6_Added+broken+upgrade+path+workaround.patch, failed testing.

Comment #12

hass commented 27 February 2013 at 07:47

Issue tags:

+6.x-1.0 blocker

I should run the tests against DEV :-)

Comment #13

hass commented 23 February 2013 at 21:35

Version:	6.x-1.0-alpha5	» 6.x-1.x-dev
Status:	Needs work	» Needs review
Issue tags:	-6.x-1.0 blocker

#8: 1394126_D5-D6_Added+broken+upgrade+path+workaround.patch queued for re-testing.

Comment #14

hass commented 24 October 2015 at 12:37

Status:

Needs review

» Fixed

Comment #15

24 October 2015 at 12:37

hass committed 40fc9e2 on 6.x-1.x

Issue #1394126 by hass: D5->D6: Unknown columns and DB upgrade failures

Comment #16

7 November 2015 at 12:44

Status:

Fixed

» Closed (fixed)

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

D5->D6: Unknown columns and DB upgrade failures

Comments

Comment #1

Comment #2

Comment #3

Comment #4

Comment #5

Comment #6

Comment #7

Comment #8

Comment #9

Comment #10

Comment #11

Comment #12

Comment #13

Comment #14

Comment #15

Comment #16

News items

Our community

Documentation

Drupal code base

Governance of community