Update #7003 - Filter module - Failed [#1084866]

Hi all,

I still can't finish update from 6.20 to 7.0

All modules besides core ones are disabled. But the following error occurs after update process.

The following updates returned messages
filter module
Update #7003

    * Failed: DatabaseSchemaObjectDoesNotExistException: Cannot rename <em class="placeholder">filters</em> to <em class="placeholder">d6_upgrade_filter</em>: table <em class="placeholder">filters</em> doesn't exist. in DatabaseSchema_mysql->renameTable() (line 300 of /home/www/domain.com/www/includes/database/mysql/schema.inc).

Comments

Comment #1

texis commented 27 April 2011 at 13:12

OK sorry - correct error message is:

filter module
Update #7003

    Failed: PDOException: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '1-filter_autop' for key 1: INSERT INTO {filter} (format, module, name, weight, settings, status) VALUES (:db_insert_placeholder_0, :db_insert_placeholder_1, :db_insert_placeholder_2, :db_insert_placeholder_3, :db_insert_placeholder_4, :db_insert_placeholder_5); Array ( [:db_insert_placeholder_0] => 1 [:db_insert_placeholder_1] => filter [:db_insert_placeholder_2] => filter_autop [:db_insert_placeholder_3] => 2 [:db_insert_placeholder_4] => a:0:{} [:db_insert_placeholder_5] => 1 ) in filter_update_7003() (line 333 of /home/www/ciganek.cz/www/modules/filter/filter.install).

I have used the 685486_13_filter_update_7003.patch before upgrade process:
http://drupal.org/files/issues/685486_13_filter_update_7003.patch

Comment #2

tlangston commented 4 July 2011 at 01:54

The filter.install file has a spelling error in the filter_update_7003(). Changed 'filters' to 'filter' and got past this error.

Comment #3

texis commented 4 July 2011 at 18:21

Can you be more specific? I do not see any issue with the name. I see at the begining:

db_rename_table('filters', 'd6_upgrade_filter');

but there is also table filters so why should I change filters to filter and where?

Thanks
TC

Comment #4

tlangston commented 5 July 2011 at 22:52

The following error is happening because the table filters doesn't exist (table filters doesn't exist.). Since the table filter does exist, it seems reasonable to make this change. The error clears.

* Failed: DatabaseSchemaObjectDoesNotExistException: Cannot rename filters to d6_upgrade_filter: table filters doesn't exist. in DatabaseSchema_mysql->renameTable() (line 300 of /home/www/domain.com/www/includes/database/mysql/schema.inc).

Comment #5

texis commented 6 July 2011 at 09:50

Sory - maybe I did something wrong previously. What I can see now, after re-trying to update again, is that original the table filters really exists. So now I can see the following error.

Failed: PDOException: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '1-filter_autop' for key 'PRIMARY': INSERT INTO {filter} (format, module, name, weight, settings, status) VALUES (:db_insert_placeholder_0, :db_insert_placeholder_1, :db_insert_placeholder_2, :db_insert_placeholder_3, :db_insert_placeholder_4, :db_insert_placeholder_5); Array ( [:db_insert_placeholder_0] => 1 [:db_insert_placeholder_1] => filter [:db_insert_placeholder_2] => filter_autop [:db_insert_placeholder_3] => 2 [:db_insert_placeholder_4] => a:0:{} [:db_insert_placeholder_5] => 1 ) in filter_update_7003() (line 333 of /home/www/clients/client20/web51/web/modules/filter/filter.install).

So it seems to me there is something wrong after a new Drupal 7 table filter is created. But I have no ideal how to solve this.

Thanks