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

[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

[H2B2]

That's is useful info. Thanks!

Related to:
http://mantis.phplist.com/view.php?id=10609
http://mantis.phplist.com/view.php?id=8583

[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

[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

[tiscarabee]

I have mysql 5 too.