Key length greater than 1000 bytes causes install error on MyISAM

I forgot to mention that the above error appears when trying to access the configuration page (admin/config/search/apachesolr).

The install was a little messy because it didn't allow installing both the framework and search at once, but I uninstalled it and reinstalled it again, all steps with running update.php. I will try it again with a fresh install of drupal maybe it will work. I will come back with results...

Steps:

Existing Drupal 7.0-rc1 site, with all non-core modules disabled and without a previous install of Apache Solr.

drush @dev dl apachesolr-7.x-1.0-beta1
cd /srv/www/dev.vladgh.com/sites/all/modules/apachesolr/
svn checkout -r22 http://solr-php-client.googlecode.com/svn/trunk/ SolrPhpClient
chown -R www-data:www-data /srv/www/dev.vladgh.com

Install Apache Solr Framework

PDOException: SQLSTATE[42000]: Syntax error or access violation: 1071 Specified key was too long; max key length is 1000 bytes: CREATE TABLE {apachesolr_server} ( `asid` INT NOT NULL auto_increment COMMENT 'Integer primary key.', `server_id` VARCHAR(64) NOT NULL COMMENT 'Unique identifier for the server', `name` VARCHAR(255) NOT NULL DEFAULT '' COMMENT 'Human-readable name for the server', `scheme` VARCHAR(10) NOT NULL DEFAULT 'http' COMMENT 'Preferred scheme for the registered server', `host` VARCHAR(255) NOT NULL DEFAULT '' COMMENT 'Host name for the registered server', `port` VARCHAR(10) NOT NULL DEFAULT '' COMMENT 'Port number for the registered server', `path` VARCHAR(255) NOT NULL DEFAULT '' COMMENT 'Path to the registered server', `service_class` VARCHAR(255) NOT NULL DEFAULT '' COMMENT 'Optional class name to use for connection', PRIMARY KEY (`asid`), UNIQUE KEY `server_id` (`server_id`), UNIQUE KEY `host_post_path` (`host`, `port`, `path`) ) ENGINE = InnoDB DEFAULT CHARACTER SET utf8 COMMENT 'The Solr server table.'; Array ( ) in db_create_table() (line 2554 of /srv/www/dev.vladgh.com/includes/database/database.inc).

It remains checked, like it is installed.

Install Apache Solr search submodule -- OK, no errors

Go to Config Page (admin/config/search/apachesolr)
PDOException: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'testvgh.apachesolr_server' doesn't exist: SELECT * FROM {apachesolr_server} WHERE server_id = :server_id; Array ( [:server_id] => solr ) in apachesolr_server_id_load() (line 1612 of /srv/www/dev.vladgh.com/sites/all/modules/apachesolr/apachesolr.module).

The same errors appear with complete fresh install of drupal 7.0-rc1 (standard and minimal profiles)

I have an Ubuntu 10.10 default install with mysql 5.1.49. But I think that the real problem is at the bottom of that error:

ENGINE = InnoDB DEFAULT CHARACTER SET utf8

I have InnoDB disabled in my.cnf. I will try with it enabled to see what happens, and I will come back...

I went back and enabled InnoDB in my.cnf and I was able to install the framework and search without any errors. So it works only with innodb which is not quite fair because on small machines the first thing people do is to add skip-innodb to my.cnf.
Anyway it works until one point: when I try to add a new server or edit the existing one I get the follwing error:

Warning: Parameter 1 to apachesolr_server_edit_form() expected to be a reference, value given in drupal_retrieve_form() (line 766 of /srv/www/dev.vladgh.com/includes/form.inc).

The only way I could add my own server (custom port and path) was to edit the mysql table directly and it works. Maybe I should open another issue with this. It looks like a php 5.3... error

Still, we want this to work on MyISAM too.

That would be great...