Posted by trueheehoo on April 27, 2009 at 6:06pm
| Project: | Import |
| Version: | 6.x-1.x-dev |
| Component: | Code |
| Category: | bug report |
| Priority: | normal |
| Assigned: | Unassigned |
| Status: | closed (won't fix) |
Issue Summary
Hi,
When I attempt to install this module, I receive the following error:
- user warning: BLOB/TEXT column 'impid' used in key specification without a key length
query: CREATE TABLE drupal_import (
`impid` VARCHAR(256) NOT NULL,
`type` VARCHAR(32) NOT NULL,
PRIMARY KEY (impid, type)
) /*!40100 DEFAULT CHARACTER SET UTF8 */ in /var/www/html/sites/drupal/includes/database.inc on line 515. - user warning: BLOB/TEXT column 'impid' used in key specification without a key length
query: CREATE TABLE drupal_import_fail (
`impid` VARCHAR(256) NOT NULL,
`type` VARCHAR(32) NOT NULL,
`message` LONGTEXT NOT NULL,
PRIMARY KEY (impid, type)
) /*!40100 DEFAULT CHARACTER SET UTF8 */ in /var/www/html/sites/drupal/includes/database.inc on line 515. - user warning: BLOB/TEXT column 'impid' used in key specification without a key length
query: CREATE TABLE drupal_import_pass (
`impid` VARCHAR(256) NOT NULL,
`type` VARCHAR(32) NOT NULL,
PRIMARY KEY (impid, type)
) /*!40100 DEFAULT CHARACTER SET UTF8 */ in /var/www/html/sites/drupal/includes/database.inc on line 515.
We're running Drupal version 6.10 and MySQL version 4.1.22. Any thoughts?
Thanks!
-Brad
Comments
#1
Thanks for the detailed report. I don't have mysql 4.1.* installed on my system and am working with 5. If I understand what is happening it looks like the key length for text fields does not need to be specified in 5 but do in 4. Can you try this patch and let me know if it fixes the problem ... I have no way to test this so have to rely on you ;)
#2
@heehoo Any chance you can help follow up on this so I can get it committed?
#3
I kill VARCHAR(256) & VARCHAR(32)
But TNX for path.
#4