I am upgrading a site from D6 to D7. When I installed the D7 version of block_class (7.x-1.2), and ran update.php, the updates fail:
drush updb
The following updates are pending:
block_class module :
7100 - Alters the structure of {block_class} schema.
7101 - Fix too long primary key length in {block_class}.
Do you wish to run all pending updates? (y/n): y
SQLSTATE[42000]: Syntax error or access violation: 1071 Specified key was too long; max key length is 1000 [error]
bytes
Performed update: block_class_update_7100 [ok]

Both updates remain in queue (try to run and fail whenever I run updb). I tried disabling the module, still fails.

I would prefer not to completely uninstall the module and potentially lose data, but I will if I have to. Thanks.

Comments

DYdave’s picture

Status: Active » Closed (duplicate)

This issue sounds a lot like a duplicate of #1838014: PDOException - Specified key was too long (Apache).

I allowed myself to mark this issue as closed (duplicate) for now, but feel free to re-open it, or post a new ticket, at any time if you have any further objections and find this issue different from the one at #1838014: PDOException - Specified key was too long (Apache) (we would surely be happy to hear your feedback).

Please let me know if you would have any further comments, feedback, questions, issues, objections, suggestions or concerns on #1838014: PDOException - Specified key was too long (Apache) or this ticket in general, I would be glad to provide more information or explain in more details.

Thanks again to everyone for your help, reviews, feedback and comments on this issue.
Cheers!