error in SQL code?

lgammo - April 26, 2008 - 22:23
Project:Dex: Contact Information Manager
Version:5.x-0.1
Component:Code
Category:bug report
Priority:normal
Assigned:Unassigned
Status:closed
Description

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

David Strauss - April 28, 2008 - 14:24

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

lgammo - April 29, 2008 - 09:18

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

#3

David Strauss - April 29, 2008 - 15:43

#4

David Strauss - April 29, 2008 - 15:49

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

David Strauss - April 29, 2008 - 17:05
Status:active» fixed

#6

Anonymous (not verified) - May 13, 2008 - 17:13
Status:fixed» closed

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

 
 

Drupal is a registered trademark of Dries Buytaert.