Problem/Motivation

Did 'drush up' and drush dutifully updated draggableviews from 7.x-1.x-dev to 7.x-2.0. However the database update failed - see message below:

Update #7001
Failed: PDOException: SQLSTATE[42000]: Syntax error or access violation: 1071 Specified key was too long; max key length is 1000 bytes: ALTER TABLE {draggableviews_structure} CHANGE `view_name` `view_name` VARCHAR(128) NOT NULL DEFAULT '' COMMENT 'Makes the order unique for each view.'; Array ( ) in db_change_field() (line 2988 of /home/kayak/public_html/includes/database/database.inc).

Proposed resolution

??? Perhaps I did something wrong..?

Remaining tasks

Patch needed, I suppose

User interface changes

N/A

API changes

N/A

Comments

akalata’s picture

akalata commented
Status: Active » Closed (duplicate)

Marking as duplicate #1987838: DW : Error when upgrade from D6 to D7

earthangelconsulting’s picture

earthangelconsulting commented
Issue summary: View changes

if this happens to you: make sure your table is InnoDB and not MyISAM ,and that will allow a larger key size!