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

CommentFileSizeAuthor
#1 import-446424-1.patch1.18 KBcyberswat

Comments

cyberswat’s picture

cyberswat commented
StatusFileSize
new import-446424-1.patch1.18 KB

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 ;)

cyberswat’s picture

cyberswat commented

@heehoo Any chance you can help follow up on this so I can get it committed?

Seagull_JL’s picture

Seagull_JL commented

I kill VARCHAR(256) & VARCHAR(32)

But TNX for path.

cyberswat’s picture

cyberswat commented
Status: Active » Closed (won't fix)