Support for Drupal 7 is ending on 5 January 2025—it’s time to migrate to Drupal 10! Learn about the many benefits of Drupal 10 and find migration tools in our resource center.
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.
Comment | File | Size | Author |
---|---|---|---|
#2 | drupal-boxes-pgsql.diff | 369 bytes | asaddi |
drupal-block-ambiguous-column.diff | 507 bytes | asaddi | |
Comments
Comment #1
drummThe title column should not be there. It is not in the MySQL version.
Comment #2
asaddi CreditAttribution: asaddi commentedAh. 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. :)
Comment #3
drummStraightforward Postgres consistency fix.
Comment #4
Dries CreditAttribution: Dries commentedCommitted to CVS HEAD. Thanks.
Comment #5
drummCommitted to 5.
Comment #6
(not verified) CreditAttribution: commented