By cesars on

upgrading Drupal 6.22 to 7.7, using theme Garland, without contrib modules.

in update.php step, show this error:

7005 - Migrate {taxonomy_term_node} table to field storage. @todo: This function can possibly be made much faster by wrapping a transaction around all the inserts.
taxonomy update #7005 PDOException: SQLSTATE[22003]: Numeric value out of range: 1264 Out of range value for column 'created' at row 1: INSERT INTO {taxonomy_index} (nid, tid, sticky, created) VALUES (:db_insert_placeholder_0, :db_insert_placeholder_1, :db_insert_placeholder_2, :db_insert_placeholder_3); Array ( [:db_insert_placeholder_0] => 1 [:db_insert_placeholder_1] => 92 [:db_insert_placeholder_2] => 0 [:db_insert_placeholder_3] => -2147483648 ) in taxonomy_update_7005() (line 711 of /var/site/site1/modules/taxonomy/taxonomy.install).

ideas?

⋅ Categories: Drupal 7.x

Comments

fixus971’s picture

fixus971 commented 
Update #7005
Failed: PDOException: SQLSTATE[22003]: Numeric value out of range: 1264 Out of range value for column 'created' at row 1: INSERT INTO {taxonomy_index} (nid, tid, sticky, created) VALUES (:db_insert_placeholder_0, :db_insert_placeholder_1, :db_insert_placeholder_2, :db_insert_placeholder_3); Array ( [:db_insert_placeholder_0] => 212 [:db_insert_placeholder_1] => 2 [:db_insert_placeholder_2] => 0 [:db_insert_placeholder_3] => -1 ) in taxonomy_update_7005() (line 696 of /home/fixus/www/fixweb/modules/taxonomy/taxonomy.install).

I spent hours to resolve it but simply get in other troubles.

I tray solution on this page: http://drupal.org/node/1140746

StuartDH’s picture

StuartDH commented

looks like the problem might be due to a -1 value for one of your term ids