Closed (fixed)
Project:
Pathauto paths
Component:
Code
Priority:
Normal
Category:
Bug report
Assigned:
Unassigned
Reporter:
Created:
5 Nov 2012 at 21:10 UTC
Updated:
5 Nov 2012 at 22:07 UTC
Hi,
Thanks for the work on this module, I stumbled into an error when enabling this module through drush. I'm not a developer so not too sure whats going on here. However the module did enable successfully.
drush en pathauto_paths
The following extensions will be enabled: pathauto_paths
Do you really want to continue? (y/n): y
WD php: PDOException: SQLSTATE[42000]: Syntax error or access violation: 1071 Specified key was too long; max key length is 1000 bytes: CREATE TABLE {pathauto_paths} ( [error]
`id` INT unsigned NOT NULL auto_increment COMMENT 'TODO: please describe this field!',
`router_path` VARCHAR(255) NOT NULL COMMENT 'TODO: please describe this field!',
`entity_type` VARCHAR(255) NOT NULL COMMENT 'TODO: please describe this field!',
`bundle` VARCHAR(255) NOT NULL COMMENT 'TODO: please describe this field!',
`pattern` VARCHAR(255) NOT NULL COMMENT 'TODO: please describe this field!',
`language` VARCHAR(12) NULL DEFAULT NULL COMMENT 'TODO: please describe this field!',
PRIMARY KEY (`id`),
UNIQUE KEY `router_path` (`router_path`, `entity_type`, `bundle`, `language`)
) ENGINE = InnoDB DEFAULT CHARACTER SET utf8 COMMENT 'TODO: please describe this table!'; Array
(
)
in db_create_table() (line 2688 of /home/e-smith/files/ibays/sota3/html/includes/database/database.inc).
Cannot modify header information - headers already sent by (output started at /usr/share/pear/drush/includes/output.inc:37) bootstrap.inc:1239 [warning]
PDOException: SQLSTATE[42000]: Syntax error or access violation: 1071 Specified key was too long; max key length is 1000 bytes: CREATE TABLE {pathauto_paths} (
`id` INT unsigned NOT NULL auto_increment COMMENT 'TODO: please describe this field!',
`router_path` VARCHAR(255) NOT NULL COMMENT 'TODO: please describe this field!',
`entity_type` VARCHAR(255) NOT NULL COMMENT 'TODO: please describe this field!',
`bundle` VARCHAR(255) NOT NULL COMMENT 'TODO: please describe this field!',
`pattern` VARCHAR(255) NOT NULL COMMENT 'TODO: please describe this field!',
`language` VARCHAR(12) NULL DEFAULT NULL COMMENT 'TODO: please describe this field!',
PRIMARY KEY (`id`),
UNIQUE KEY `router_path` (`router_path`, `entity_type`, `bundle`, `language`)
) ENGINE = InnoDB DEFAULT CHARACTER SET utf8 COMMENT 'TODO: please describe this table!'; Array
(
)
in db_create_table() (line 2688 of /home/e-smith/files/ibays/sota3/html/includes/database/database.inc).
Drush command terminated abnormally due to an unrecoverable error.
Comments
Comment #1
antonyanimator commentedThe module doesn't work for me, I also get:
PDOException: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'sota3.pathauto_paths' doesn't exist: SELECT pp.* FROM {pathauto_paths} pp; Array ( ) in pathauto_paths_settings_form() (line 76 of /home/e-smith/files/ibays/sota3/html/sites/all/modules/pathauto_integration_for_all_entity_types/pathauto_paths/pathauto_paths.admin.inc)Comment #2
antonyanimator commentedApologies ignore all my posts, I placed the module in the wrong directory