Il giorno 14/mag/07, alle ore 15:18, Paul J Stevens ha scritto:
Maybe dbmail-util should check (and maybe fix) this?
While this may be feasible for one engine, this will quickly become
a total
nightmare while dealing with even the three engines we have now,
let alone when
we expand into other backends (ingres, oracle, firebird, etc...)
That's right.
The problem is that now I'm stuck with this:
mysql> alter table dbmail_subscription add FOREIGN KEY user_id_fk
(user_id) REFERENCES dbmail_users (user_idnr) ON DELETE CASCADE ON
UPDATE CASCAde;
ERROR 1005 (HY000): Can't create table
'dbmail.#sql-11c81_2f519' (errno: 150)
I've read on mysql's forum that this depends on an error within the
foreign key definition. The InnoDB engine reports a stupid:
070514 15:20:35 Error in foreign key constraint of table dbmail/
#sql-11c81_2f519:
FOREIGN KEY user_id_fk (user_id) REFERENCES dbmail_users (user_idnr)
ON DELETE CASCADE ON UPDATE CASCAde:
Cannot resolve table name close to:
(user_idnr) ON DELETE CASCADE ON UPDATE CASCAde
In the meantime I've been correcting the foreign key on some other
complementary tables, but I can't really get beyond this problem now...
HELP! :-)
Andrea Brancatelli
[EMAIL PROTECTED]
_______________________________________________
DBmail mailing list
[email protected]
https://mailman.fastxs.nl/mailman/listinfo/dbmail
