Come together with the global Drupal community in Rotterdam, 28 Sept – 1 Oct 2026. Sessions, contribution, connection, and Early Bird savings until 8 June.I got this error when I was trying to install Amazon Tools.
user warning: Specified key was too long; max key length is 1000 bytes query: CREATE TABLE amazonitem ( asin varchar(10) NOT NULL default '', detailpageurl text, smallimageurl varchar(255) default NULL, smallimageheight int(10) default NULL, smallimagewidth int(10) default NULL, mediumimageurl varchar(255) default NULL, mediumimageheight int(10) default NULL, mediumimagewidth int(10) default NULL, largeimageurl varchar(255) default NULL, largeimageheight int(10) default NULL, largeimagewidth int(10) default NULL, author varchar(255) default NULL, editorialreview longtext, binding varchar(100) default NULL, listamount int(10) default NULL, listcurrencycode char(3) default NULL, listformattedprice varchar(10) default NULL, title varchar(100) default NULL, amount int(10) default NULL, currencycode char(3) default NULL, formattedprice varchar(10) default NULL, availability varchar(50) default NULL, pricedate datetime default NULL, PRIMARY KEY (asin), KEY Title (title), KEY Author (author,title) ) /*!40100 DEFAULT CHARACTER SET utf8 */ in /home/robbt/websites/drupaltest/includes/database.mysql.inc on line 120.
Perhaps its similar to the problem here http://drupal.org/node/55372
Comments
Comment #1
Prometheus6 commentedSomewhat...The problem is that utf-8 characters can be more than 1 byte per character, so the Author index (Author @255 chars and title @100 chars) can be larger than 1000 bytes.
That array is less than useful anyway. I need to think about how that index should be defined.
Comment #2
Prometheus6 commented