Installation fails with SQLite [#2345693]

Created a brand new quick Drupal installation to test this module on a fresh drupal install and installed module via drush receiving the following output:

~/Sites/drupal7/quick-drupal-20140926192315/drupal  drush en -y taxonomy_field_menu
taxonomy_field_menu was not found.                                                                         [warning]
The following projects provide some or all of the extensions not found:                                    [ok]
taxonomy_field_menu
Would you like to download them? (y/n): y
Project taxonomy_field_menu (7.x-1.0) downloaded to sites/all/modules/taxonomy_field_menu.                 [success]
The following projects have unmet dependencies:                                                            [ok]
taxonomy_field_menu requires pathauto
Would you like to download them? (y/n): y
Project pathauto (7.x-1.2) downloaded to sites/all/modules/pathauto.                                       [success]
The following projects have unmet dependencies:                                                            [ok]
taxonomy_field_menu requires token
Would you like to download them? (y/n): y
Project token (7.x-1.5) downloaded to sites/all/modules/token.                                             [success]
The following extensions will be enabled: taxonomy_field_menu, token, pathauto
Do you really want to continue? (y/n): y
WD php: PDOException: SQLSTATE[HY000]: General error: 1 near "name": syntax error: CREATE INDEX            [error]
main.taxonomy_field_menu_menu name ON taxonomy_field_menu (menu_name);
; Array
(
)
 in db_create_table() (line 2720 of
/Users/dustin/Sites/drupal7/quick-drupal-20140926192315/drupal/includes/database/database.inc).
Cannot modify header information - headers already sent by (output started at                              [warning]
/usr/local/Cellar/drush/6.3.0/libexec/includes/output.inc:38) bootstrap.inc:1224
PDOException: SQLSTATE[HY000]: General error: 1 near "name": syntax error: CREATE INDEX main.taxonomy_field_menu_menu name ON taxonomy_field_menu (menu_name);
; Array
(
)
 in db_create_table() (line 2720 of /Users/dustin/Sites/drupal7/quick-drupal-20140926192315/drupal/includes/database/database.inc).
Drush command terminated abnormally due to an unrecoverable error.

I also completely reinstalled Drupal (dropped sqlite db and reinstalled) and tried to turn on module via UI and got the lovely attached error message.

i am developing on Mac OSX 10.9.5 with homebrew built php55 using sqlite and built in drush server.

running a quick install vs a mysql database installation installs without issue.

Comment	File	Size	Author
	Screenshot 2014-09-26 15.32.35.png	81.39 KB	dustinleblanc

Support from Acquia helps fund testing for Drupal Acquia logo

Comments

Comment #1

dustinleblanc

he/him/his

English

Ithaca, NY

CreditAttribution: dustinleblanc commented 26 September 2014 at 19:43

Issue summary:

View changes

spelling

Comment #2

smiletrl CreditAttribution: smiletrl commented 23 October 2014 at 09:23

Currently, I don't have plan to provide SQLite support considering my own workload. Maybe you can use mysql instead of SQLite?

Comment #3

dustinleblanc

he/him/his

English

Ithaca, NY

CreditAttribution: dustinleblanc commented 27 October 2014 at 17:44

I usually use MySQL anyway, this just happened to be an insttnace where I was testing the module via quick-drupal. Issue isn't really critical but ideally database driver shouldn't break the module.

Comment #4

smiletrl CreditAttribution: smiletrl commented 28 October 2014 at 12:42

database driver shouldn't break the module.

Agreed. I will see if I can find time to debug it.

In the meantime, the first error reported by drush indicates the sql is using wrong index command,

CREATE INDEX main.taxonomy_field_menu_menu name ON taxonomy_field_menu (menu_name);
; Array
(
)
The index name is not 'menu name', but some weird "main.taxonomy_field_menu_menu name ". Does it happen if you update following lines from the install file?

//line 83
    'indexes' => array(
      'menu name' => array('menu_name'), // Remove this line, or update it to 'menu_name' => array('menu_name')
      'vid' => array('vid'),
    ),

The second issue from module interface ui says the duplicate table. I think this issue happens the db has already installed this table. Are you sure you have totally used a new db to install drupal and this module? That error shows you have already used the db before..