block_box_get fails with an ambiguous column error with PostGreSQL 8.1.

The boxes and blocks tables both contain a "title" column and this column is referenced without a qualifier in the query.

The error is most readily seen when configuring or deleting a custom block.

Support from Acquia helps fund testing for Drupal Acquia logo

Comments

drumm’s picture

Status: Needs review » Needs work

The title column should not be there. It is not in the MySQL version.

asaddi’s picture

Version: 5.0-rc1 » 5.0-rc2
Component: block.module » system.module
Status: Needs work » Needs review
FileSize
369 bytes

Ah. I withdraw my previous patch and submit a simpler patch against system.install.

It seems that users upgrading from 4.7.x shouldn't see this problem because of system_update_1006. However, I started from a fresh install of 5.0-rc1.

I'm not sure about the correct way to fix this in an automated manner since it seems like you would have to examine the table metadata (to check if the column exists) before dropping the column.

Personally, I'm just going to drop the column manually. :)

drumm’s picture

Version: 5.0-rc2 » 6.x-dev
Status: Needs review » Reviewed & tested by the community

Straightforward Postgres consistency fix.

Dries’s picture

Version: 6.x-dev » 5.x-dev

Committed to CVS HEAD. Thanks.

drumm’s picture

Status: Reviewed & tested by the community » Fixed

Committed to 5.

Anonymous’s picture

Status: Fixed » Closed (fixed)