Can't create MySQL Table

[GoogleCodeExporter]

Hello

running Roundcube 0.3.1 with all last plugin (Trunk 3216).
Can't create MySQL Table for Google_contacts plugin.

Mysql message: #1005 - Can't create 
table '.\roundcubemail\google_contacts.frm' (errno: 121

Of course, I've all the rights (root)

Original issue reported on code.google.com by tparv...@gmail.com on 1 Feb 2010 at 10:12

[GoogleCodeExporter]

I see the poblem and will fix it.

Meanwhile just do:

CREATE TABLE google_contacts LIKE contacts;

ALTER TABLE `google_contacts`
  ADD CONSTRAINT `google_contacts_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `users` 
(`user_id`) ON DELETE CASCADE ON UPDATE CASCADE;

google_contacts has to have the same structure as table contacts.

Original comment by rol...@liebl.ath.cx on 2 Feb 2010 at 10:35

• Changed state: Accepted

[GoogleCodeExporter]

ok, solved

Original comment by tparv...@gmail.com on 2 Feb 2010 at 8:55

[GoogleCodeExporter]

Solved with the following script: 

CREATE TABLE collected_contacts LIKE contacts;

ALTER TABLE `collected_contacts`
  ADD CONSTRAINT `collected_contacts_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `users` 
(`user_id`) ON DELETE CASCADE ON UPDATE CASCADE;

Original comment by tparv...@gmail.com on 7 Feb 2010 at 8:54

[GoogleCodeExporter]

Original comment by rol...@liebl.ath.cx on 14 Mar 2010 at 11:05

• Changed state: Fixed