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
