While trying to update from D6 to D7 (using drupal-7.0-alpha6) there was an update to the `system` table to change the `system`.`type` field from varchar(255) to varchar(12). The value 'javascript library' is longer than 12 characters, and this caused the update to fail.

Just FYI. Here is the offending code in system.install

/**
 * Shorten the {system}.type column and modify indexes.
 */
function system_update_7018() {
  db_drop_index('system', 'modules');
  db_drop_index('system', 'type_name');
  db_change_field('system', 'type', 'type', array('type' => 'varchar', 'length' => 12, 'not null' => TRUE, 'default' => ''));
  db_add_index('system', 'type_name', array('type', 'name'));
}

Comments

skilip’s picture

skilip commented

Hi liberatr,

Thanks for reporting! We'll take it into account on the next major version.

mgifford’s picture

mgifford
he/him
Primary language English
commented

Any word on when there will be a D7 version? Looks like it might be handled by http://drupal.org/project/jquery

leisurman’s picture

leisurman commented
Issue summary: View changes

Is there a patch for this? This is coming from the swf upload module in the system.type table, if i change the type to javascript i get a sql_storage error during upgrade, if i leave the type javascript library I get an entity.inc error during upgrade.

https://www.drupal.org/node/1133024

leisurman’s picture

leisurman commented
Priority: Normal » Critical

Is there a way to fix this. Many of us are having the same problem.
https://www.drupal.org/node/1133024
https://www.drupal.org/node/1987378
https://www.drupal.org/node/889778
https://www.drupal.org/node/1256068
https://www.drupal.org/node/1602034
https://www.drupal.org/node/2259031

leisurman’s picture

leisurman commented

I tried to change the varchar 12 to 32 in the system file and in the system.type sql table and then i got a sql_storage error during upgrade

leisurman’s picture

leisurman commented

I fixed my upgrade from d6 to d7 errors.
I reverted back to the d6 database, then went to the system table, looked for swf upload module change its status from 1 to 0, changed the name 'javascript library' to 'javascript'

I also had about 50 sql tables I needed to delete and I think from a failed upgrade attempt. I found this post that really helped.
https://support.mayfirst.org/ticket/8112
Here is a list of the sql table to drop
https://support.mayfirst.org/attachment/ticket/8112/upgrade-notes.org

also i had to patch the text module. I then upgraded to d7 with no errors.