By creativepragmatic on

I am not sure if I should have filed this as an issue. The error below appears when upgrading from Drupal 6.22 to Drupal 7.8. Postgres is the database.


The following updates returned messages

system module

Update #7016
Failed: PDOException: 
SQLSTATE[2BP01]: Dependent objects still exist: 7 
ERROR: cannot drop type smallint_unsigned because other objects depend on it 
DETAIL: 
default for table comment column status depends on type smallint_unsigned 
default for table node_access column grant_view depends on type smallint_unsigned 
default for table node_access column grant_update depends on type smallint_unsigned 
default for table node_access column grant_delete depends on type smallint_unsigned 
default for table taxonomy_vocabulary column relations depends on type smallint_unsigned 
default for table taxonomy_vocabulary column hierarchy depends on type smallint_unsigned 
default for table taxonomy_vocabulary column multiple depends on type smallint_unsigned 
default for table taxonomy_vocabulary column required depends on type smallint_unsigned 
default for table taxonomy_vocabulary column tags depends on type smallint_unsigned 
default for table watchdog column severity depends on type smallint_unsigned 
HINT: Use DROP ... CASCADE to drop the dependent objects too.: 
DROP DOMAIN IF EXISTS smallint_unsigned; 
Array ( ) in system_update_7016() 
(line 2058 of /home/appadmin/solarheadlines.com/html/modules/system/system.install).

Any ideas?

⋅ Categories: Drupal 7.x

Comments

creativepragmatic’s picture

creativepragmatic commented

After removing the following lines from system.install, no installation errors are displayed and the home page displays correctly but the administrative area becomes inaccessible.

    db_query('DROP DOMAIN IF EXISTS smallint_unsigned');
    db_query('DROP DOMAIN IF EXISTS int_unsigned');
    db_query('DROP DOMAIN IF EXISTS bigint_unsigned');

When I try to drop each domain manually using the CASCADE option, Drupal shows a series of errors on the home page. Having never developed a module, I guess I'm stuck with version 6.

Jaime_Pomales’s picture

Jaime_Pomales commented

This is probably WAY too late to help you, but I had the same problem upon a drupal 6 to drupal 7 upgrade using PostgreSQL 8.4.

Just add CASCADE to the end of each DROP statemente like this:

    db_query('DROP DOMAIN IF EXISTS smallint_unsigned CASCADE');
    db_query('DROP DOMAIN IF EXISTS int_unsigned CASCADE');
    db_query('DROP DOMAIN IF EXISTS bigint_unsigned CASCADE');

And you are good to go. Hope this helps someone.