I find what cause this problem. I usually use strict mode. In my my.cnf: sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES
After commenting out this line: mysql> CREATE INDEX `admin_views_prepopulatedpostlargeslug_f52cfca0` ON `admin_views_prepopulatedpostlargeslug` (`slug`); Query OK, 0 rows affected, 1 warning (0.02 sec) Records: 0 Duplicates: 0 Warnings: 1 On Tuesday, September 9, 2014 7:37:35 PM UTC+9, Naoki INADA wrote: > > Maybe, this difference is come from MySQL version. > I use MySQL 5.6.20 (Homebrew). > > mysql> show create table admin_views_prepopulatedpostlargeslug\G > *************************** 1. row *************************** > Table: admin_views_prepopulatedpostlargeslug > Create Table: CREATE TABLE `admin_views_prepopulatedpostlargeslug` ( > `id` int(11) NOT NULL AUTO_INCREMENT, > `title` varchar(100) NOT NULL, > `published` tinyint(1) NOT NULL, > `slug` varchar(1000) NOT NULL, > PRIMARY KEY (`id`) > ) ENGINE=InnoDB DEFAULT CHARSET=utf8 > 1 row in set (0.00 sec) > > mysql> CREATE INDEX `admin_views_prepopulatedpostlargeslug_f52cfca0` ON > `admin_views_prepopulatedpostlargeslug` (`slug`); > ERROR 1071 (42000): Specified key was too long; max key length is 767 bytes > > > > On Tuesday, September 9, 2014 7:00:54 PM UTC+9, Florian Apolloner wrote: >> >> Python 2.7.3 and MySQL_python-1.2.5-cp27-none-linux_x86_64.whl >> >> On Tuesday, September 9, 2014 10:41:40 AM UTC+2, Naoki INADA wrote: >>> >>> I run django tests using MySQL-python 1.2.5 (aka, MySQLdb1) and Python >>> 2.7.8. >>> So it means django doesn't work with MySQL with MySQL-python. >>> >>> $ python -V >>> Python 2.7.8 >>> (mysql2)[inada-n@MBA:~] >>> $ pip list >>> MySQL-python (1.2.5) >>> pip (1.5.6) >>> setuptools (3.6) >>> wsgiref (0.1.2) >>> >>> On Tue, Sep 9, 2014 at 5:18 PM, Florian Apolloner <[email protected]> >>> wrote: >>> > On Tuesday, September 9, 2014 9:22:10 AM UTC+2, Naoki INADA wrote: >>> >> >>> >> Failed to install index for admin_views.PrePopulatedPostLargeSlug >>> >> model: (1071, 'Specified key was too long; max key length is 767 >>> bytes') >>> > >>> > >>> > Welcome to the wonderful world to mysql, afaik this is a warning and >>> not an >>> > error; so your database driver might convert that incorrectly. >>> > >>> > -- >>> > You received this message because you are subscribed to a topic in the >>> > Google Groups "Django developers" group. >>> > To unsubscribe from this topic, visit >>> > >>> https://groups.google.com/d/topic/django-developers/n-TI8mBcegE/unsubscribe. >>> >>> >>> > To unsubscribe from this group and all its topics, send an email to >>> > [email protected]. >>> > To post to this group, send email to [email protected]. >>> > Visit this group at http://groups.google.com/group/django-developers. >>> > To view this discussion on the web visit >>> > >>> https://groups.google.com/d/msgid/django-developers/4bd04867-0f32-4db2-85b3-41671f92aecc%40googlegroups.com. >>> >>> >>> > >>> > For more options, visit https://groups.google.com/d/optout. >>> >>> >>> >>> -- >>> INADA Naoki <[email protected]> >>> >> -- You received this message because you are subscribed to the Google Groups "Django developers" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at http://groups.google.com/group/django-developers. To view this discussion on the web visit https://groups.google.com/d/msgid/django-developers/48036f3a-da29-4049-8ba2-7dc7a0a29cc4%40googlegroups.com. For more options, visit https://groups.google.com/d/optout.
