Support for Drupal 7 is ending on 5 January 2025—it’s time to migrate to Drupal 10! Learn about the many benefits of Drupal 10 and find migration tools in our resource center.The following error happens on upgrade:
SQLSTATE[42000]: Syntax error or access violation: 1071 Specified key was too long; max key length is 1000 bytes
This seems to fixed in 1.x branch, but not in 2.x
The closest existing patch is available at:
https://drupal.org/node/1838014#comment-7255168
| Comment | File | Size | Author |
|---|---|---|---|
| #1 | block_class.install-2128271.patch | 707 bytes | kenorb |
Comments
Comment #1
kenorb CreditAttribution: kenorb commentedComment #3
DYdave CreditAttribution: DYdave commentedHi @kenorb,
Thanks very much for following up on this issue, which was actually raised again 2 months ago at #1838014-11: PDOException - Specified key was too long (Apache).
It could have been committed a while ago to prevent others from having the same problem...
However, I'm wondering why this issue or the attached patch didn't get more feedback in the past 8 months, when they could have been useful to other users who requested for a port of the patch elsewhere...
Anyway, with no further delay, I went ahead and committed the changes against the 7.x-2.x branch at f062706.
I allowed myself to mark this issue as fixed for now, but feel free to re-open it, or post a new ticket, at any time if you have any further objections with this ticket or related commit f062706 (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 the commit or this bug report in general, I would be glad to provide more information or explain in more details.
Thanks again for the patch, testing and feedback on this issue.
Cheers!