I got this error upon install of this module:
user warning: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '` FOREIGN KEY (`uid`) REFERENCES users (`uid`) ON DELETE CASCADE, ADD CO' at line 2 query: ALTER TABLE dex_card ADD CONSTRAINT dex_card_ibfk_2` FOREIGN KEY (`uid`) REFERENCES users (`uid`) ON DELETE CASCADE, ADD CONSTRAINT dex_card_ibfk_1` FOREIGN KEY (`nid`) REFERENCES node (`nid`) ON DELETE CASCADE; in <...>/includes/database.mysql.inc on line 172.

I am not if this an incompatibility with my setup of not: (shared hosting):
Drupal
Version 5.7

Web server
Type Apache
Version 1.3.34
Operating system Linux
PHP interface cgi

PHP
Version 5.2.5
Database
Type MySQL
Version 5.0.51a

THanks,

Comments

david strauss’s picture

Currently, the module requires all the tables in your database to be InnoDB, specifically the users and node tables. Try converting those tables to InnoDB and installing again.

lgammo’s picture

Ooh! Can I do this conversion on a shared host (1and1)????

david strauss’s picture

david strauss’s picture

I've posted release 1.1-1, which will automatically convert the node and user tables for you. Be sure to fully uninstall and reinstall.

david strauss’s picture

Status: Active » Fixed
Anonymous’s picture

Status: Fixed » Closed (fixed)

Automatically closed -- issue fixed for two weeks with no activity.