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
Comment #1
david straussCurrently, 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.
Comment #2
lgammo commentedOoh! Can I do this conversion on a shared host (1and1)????
Comment #3
david straussYes: http://faq.oneandone.co.uk/scripting/mysql/5.html
Comment #4
david straussI've posted release 1.1-1, which will automatically convert the node and user tables for you. Be sure to fully uninstall and reinstall.
Comment #5
david straussComment #6
Anonymous (not verified) commentedAutomatically closed -- issue fixed for two weeks with no activity.