automatic addressbook plugin: mysql error

[cbrace]

Hi all,

I am trying to install the automatic addressbook plugin under RC v0.5.2, however I encounter an error trying to initialize the MySQL database.

In phpMyAdmin, I paste the following code (the contents of roundcube/plugins/automatic_addressbook/SQL/mysql.initial.sql) into the SQL tab:
 

Code: [Select]

CREATE TABLE `collected_contacts` (
 `contact_id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
 `changed` datetime NOT NULL DEFAULT '1000-01-01 00:00:00',
 `del` tinyint(1) NOT NULL DEFAULT '0',
 `name` varchar(128) NOT NULL,
 `email` varchar(128) NOT NULL,
 `firstname` varchar(128) NOT NULL,
 `surname` varchar(128) NOT NULL,
 `vcard` text NULL,
 `user_id` int(10) UNSIGNED NOT NULL DEFAULT '0',
 PRIMARY KEY(`contact_id`),
 INDEX `user_collected_contacts_index` (`user_id`,`email`),
 CONSTRAINT `user_id_fk_contacts` FOREIGN KEY (`user_id`)
   REFERENCES `users`(`user_id`)
   --!40008
   --ON DELETE CASCADE
   --ON UPDATE CASCADE
);Upon executing this, I see this error message:

Code: [Select]

#1064 - 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 '--!40008 --ON DELETE CASCADE --ON UPDATE CASCADE )' at line 15
Any ideas what is going wrong here? I have MySQL 5.5 installed.

Thanks.

[spid3r]

did you find the solution ? i don't get it either... my sql-fu is weak

[cbrace]

Not yet, still hoping an SQL guru will turn up here some time

[aaareg]

So the answer was given
Linguarde - Client for Google Translator - Free Translate

[JocelynD]

Should be fixed in latest SVN by now, see Roundcube plugin(s) - Anomalie #23: MySQL - #1005 - Can't create table - Redmine