Posted by yraffah on January 15, 2011 at 7:40pm
I just tried to upgrade to drupal 7 from 6.20 and after it finished updating, it gave me this update failed message under block module:
PDOException: SQLSTATE[42000]: Syntax error or access violation: 1071 Specified key was too long; max key length is 1000 bytes: ALTER TABLE {block} CHANGE `weight` `weight` INT NOT NULL DEFAULT 0 COMMENT 'Block weight within region.', ADD INDEX `list` (`theme`, `status`, `region`, `weight`, `module`); Array ( ) in db_change_field() (line 2888 of /hsphere/local/home/username/myblog.com/includes/database/database.inc
PHP version is: 5.2.14
According to the status report:
Database updates: Out of date
Core: Up to date
Modules: Up to date
Themes: Up to date
Comments
See
See http://drupal.org/node/935250#comment-6927138