error in SQL code?
| Project: | Dex: Contact Information Manager |
| Version: | 5.x-0.1 |
| Component: | Code |
| Category: | bug report |
| Priority: | normal |
| Assigned: | Unassigned |
| Status: | closed |
Jump to:
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,

#1
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.
#2
Ooh! Can I do this conversion on a shared host (1and1)????
#3
Yes: http://faq.oneandone.co.uk/scripting/mysql/5.html
#4
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.
#5
#6
Automatically closed -- issue fixed for two weeks with no activity.