Jorge Bastos wrote: > Hum... i'm getting mad. > Paul, can you give me a help? > > I have two situations: > 1st, I have values in dbmail_subscription that doesn't have any mailbox in > dbmail_mailboxes > * this is the problem you already know
That also means you did not add the foreign keys. You can not add a foreign key if there are records that violate the restraint. > > 2nd, I have values in dbmail_mailboxes that doesn't have the corresponding > value in dbmail_subscription > * this new problem, it doesn't give any problem with 2.2x code, but with > 2.3x it complains No Jorge, that is not a problem. That just means you have mailboxes no-one subscribes to, which is perfectly valid. > > > Can you give a hand? Show me your schema as you have it: 'mysqldump -d dbmail' > > > > -----Original Message----- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf > Of Jorge Bastos > Sent: domingo, 10 de Fevereiro de 2008 12:42 > To: 'DBMail mailinglist' > Subject: RE: [Dbmail] DBMail 2.3.2 released > > Right, > > The other time i thinked i only had that record missing and didn't checked > for more NULL's. > Now I checked for that, and ops, I have a lot. > > > > -----Original Message----- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf > Of Paul J Stevens > Sent: domingo, 10 de Fevereiro de 2008 9:20 > To: DBMail mailinglist > Subject: Re: [Dbmail] DBMail 2.3.2 released > > Jorge Bastos wrote: >> Ok Paul, >> I'm really having no luck on the upgrade. >> You have a full log in attach, i was checking the log, and saw this: >> >> Feb 10 02:00:27 lira dbmail/imap4d[4143]: Debug:[sql] >> dbmysql.c,db_query(+301): query [SELECT login, sock_allow, sock_deny, >> userid FROM dbmail_usermap WHERE login in ('mail@ *_<====== >> where's the rest of the query??? >> _*Feb 10 02:00:27 lira dbmail/imap4d[4143]: Debug:[db] >> dbmodule.c,db_query(+154): last query took [0] seconds >> Feb 10 02:00:27 lira dbmail/imap4d[4143]: Debug:[db] >> dm_db.c,db_usermap_resolve(+4826): login [EMAIL PROTECTED] not found in >> usermap >> Feb 10 02:00:27 lira dbmail/imap4d[4143]: Debug:[sql] >> dbmysql.c,db_query(+301): query [SELECT user_idnr FROM dbmail_users >> WHERE lower(userid) = lower('[EMAIL PROTECTED]' <mailto:'[EMAIL >> PROTECTED]'>)] >> >> more below: > > > Nothing wrong here at all! Strings are truncated in the syslog to keep > the linelength within bounds. > >> Feb 10 02:00:27 lira dbmail/imap4d[4143]: Error:[imapsession] >> dbmail-imapsession.c,dbmail_imap_session_get_mbxinfo(+786): failure >> retrieving mbxinfo for unreadable mailbox > > > select * from dbmail_subscriptions where mailbox_id=50; > > select * from dbmail_mailboxes where mailbox_idnr=50; > > The first one returns a row, the second one does not. Hence, your > foreign key constraints are incomplete! > > > -- ________________________________________________________________ Paul Stevens paul at nfg.nl NET FACILITIES GROUP GPG/PGP: 1024D/11F8CD31 The Netherlands________________________________http://www.nfg.nl _______________________________________________ DBmail mailing list [email protected] https://mailman.fastxs.nl/mailman/listinfo/dbmail
