Page 1 of 1

[fix] Database error 1071 'Specified Key was too long'

PostPosted: 10:05pm, Tue 08 Jan, 2008
by samtherobot
For me this problem occurred because phplist cannot use utf8 tables from what I can tell. There are others who describe the details of this problem in these forums.

The easiest solution is to make sure your database is defaulted to latin1 as the character set for any new tables. To find out what the current default is run this SQL code:
Code: Select all
SHOW CREATE DATABASE databasename

If the encoding shows up as utf8, run the following SQL code on the same table:
Code: Select all
ALTER DATABASE databasename DEFAULT CHARACTER SET latin1


Then run the phplist initialize. If you had run it and it failed, make sure you delete the tables before initializing again.

If you want to change the default encoding back to utf8 for future tables, run this code:
Code: Select all
ALTER DATABASE databasename DEFAULT CHARACTER SET utf8

PostPosted: 6:15am, Wed 09 Jan, 2008
by H2B2

PostPosted: 4:48pm, Mon 30 Mar, 2009
by tiscarabee
again, my message is refused because spammer prevents...
:|

An idea to contact admin ? PM ? Who ?

Sorry, I will post the description of my bugfix...

Shortly, i've changed email by email(233) in the structure php file, in admin directory (line 72) -> re-initialize tables, and it works.

Code: Select all
index_2" => array("emailnameidx (email(233),name)",""),


Thks Michiel and all !

tisco

Re: [fix] Database error 1071 'Specified Key was too long'

PostPosted: 7:07pm, Thu 21 May, 2009
by yawarakai
Thanks. I tried that now it turns into an error 1064. I am going to hate that number soon. I hear it is because I have MySQL 5

Re: [fix] Database error 1071 'Specified Key was too long'

PostPosted: 9:12am, Mon 25 May, 2009
by tiscarabee
I have mysql 5 too.