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
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 Can you give a hand? -----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 _______________________________________________ DBmail mailing list [email protected] https://mailman.fastxs.nl/mailman/listinfo/dbmail _______________________________________________ DBmail mailing list [email protected] https://mailman.fastxs.nl/mailman/listinfo/dbmail
