Uwe, you need to apply all the relevant migration scripts in sql/XXsql/... *and* run dbmail-util -by
The latest migration nuked the dbmail_headervalue table which needs to be re-filled. Uwe Kiewel wrote: > Hi, > > I took a backup of my dbmail-2.2 db and migrated it to the latest git. > I can open and read the emails but thunderbird does not show Sender, > Subject, Date. > > The logfile sayes: > > Apr 15 21:32:47 dedi0031 dbmail/imap4d[19498]: [0x80abdb8] Error:[db] > db_query(+349): SQLException: > Apr 15 21:32:47 dedi0031 dbmail/imap4d[19498]: [0x80abdb8] Error:[db] > db_query(+350): failed query [SELECT m.message_idnr, n.headername, > v.headervalue FROM dbmail_header h JOIN dbmail_messages m ON h.physme > Apr 15 21:32:48 dedi0031 dbmail/imap4d[19498]: [0x80abd48] Error:[db] > db_set_msgflag(+3036): SQLException: > Apr 15 21:32:53 dedi0031 dbmail/imap4d[19498]: [0x80abbf8] Error:[db] > db_query(+349): SQLException: > Apr 15 21:32:53 dedi0031 dbmail/imap4d[19498]: [0x80abbf8] Error:[db] > db_query(+350): failed query [SELECT k.message_idnr, keyword FROM > dbmail_keywords k JOIN dbmail_messages m USING (message_idnr) JOIN dbm > Apr 15 21:32:53 dedi0031 dbmail/imap4d[19498]: [0x80abbf8] Error:[db] > db_query(+349): SQLException: > Apr 15 21:32:53 dedi0031 dbmail/imap4d[19498]: [0x80abbf8] Error:[db] > db_query(+350): failed query [SELECT DISTINCT(keyword) FROM > dbmail_keywords k JOIN dbmail_messages m ON k.message_idnr=m.message_idnr JO > Apr 15 21:32:53 dedi0031 dbmail/imap4d[19498]: [0x80abbf8] Error:[db] > db_query(+349): SQLException: > Apr 15 21:32:53 dedi0031 dbmail/imap4d[19498]: [0x80abbf8] Error:[db] > db_query(+350): failed query [SELECT DISTINCT(keyword) FROM > dbmail_keywords k JOIN dbmail_messages m ON k.message_idnr=m.message_idnr JO > Apr 15 21:32:53 dedi0031 dbmail/imap4d[19498]: [0x80abbf8] Error:[db] > db_query(+349): SQLException: > Apr 15 21:32:53 dedi0031 dbmail/imap4d[19498]: [0x80abbf8] Error:[db] > db_query(+350): failed query [SELECT DISTINCT(keyword) FROM > dbmail_keywords k JOIN dbmail_messages m ON k.message_idnr=m.message_idnr JO > Apr 15 21:32:53 dedi0031 dbmail/imap4d[19498]: [0x80abbf8] Error:[db] > db_query(+349): SQLException: > Apr 15 21:32:53 dedi0031 dbmail/imap4d[19498]: [0x80abbf8] Error:[db] > db_query(+350): failed query [SELECT DISTINCT(keyword) FROM > dbmail_keywords k JOIN dbmail_messages m ON k.message_idnr=m.message_idnr JO > > > Whats going on? > > Thanks, > Uwe _______________________________________________ Dbmail-dev mailing list [email protected] http://mailman-new.icns.fastxs.net/cgi-bin/mailman/listinfo/dbmail-dev -- ________________________________________________________________ Paul Stevens paul at nfg.nl NET FACILITIES GROUP GPG/PGP: 1024D/11F8CD31 The Netherlands________________________________http://www.nfg.nl _______________________________________________ Dbmail-dev mailing list [email protected] http://mailman-new.icns.fastxs.net/cgi-bin/mailman/listinfo/dbmail-dev
