Support

Mandatory information about my setup:

Have I read the related troubleshooter articles above before posting (which pages?)? Yes nothing on this error.
Have I searched the tickets before posting? Yes
Have I read the documentation before posting (which pages?)? Yes 24-29 are relevant.
Joomla! version: 1.7.0
PHP version: >=5.1.6
MySQL version: 3.3.8.1
Host: 205.178.146.110
Akeeba Backup version which took the backup: 3.4.3
Kickstart version used to extract the backup: 3.4.1

Description of my issue:
I am getting an SQL error when I try to resore a backup of my site. Here is the error text...
Error at the line 111: CREATE TABLE `phplist_user_blacklist_data` ( `email` varchar(255) NOT NULL, `name` varchar(100) NOT NULL, `data` text, UNIQUE KEY `email` (`email`), KEY `emailidx` (`email`), KEY `emailnam ...MySQL: MySQL query failed with error 1071 (Specified key was too long; max key length is 1000 bytes). The query was:CREATE TABLE `phplist_user_blacklist_data` ( `email` varchar(255) NOT NULL, `name` varchar(100) NOT NULL, `data` text, UNIQUE KEY `email` (`email`), KEY `emailidx` (`email`), KEY `emailnameidx` (`email`,`name`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8

We are in the process of moving hosts so I am restoring to a new database. I don't have access to the old database so I can't do any other type of backup. Any ideas on things that I can configure in the installer or in mySQL to fix this?

Thanks

Alright, sorry about that. I called the host and I have outdated information. PHP: 5.3.8 MySQL: 5.0.89
Thanks

Thanks for the response. I did what you recommended and it worked. Looks like phpList has a issue with creating that specific table. One of the fields needed to be created with a size of 233 rather than 255.

Thanks.