Am 28.03.2014 22:58, schrieb Masood Rahim: > I’m currently at 3.1.9
upgrade to 3.1.13 anyways, there are important bugfixes
> My sorting from date in roundcube is completely broken
you just missed sql/mysql/3:0_2-3_1_0.mysql
DROP VIEW IF EXISTS dbmail_datefield;
CREATE VIEW dbmail_datefield AS
SELECT physmessage_id,datefield,sortfield
FROM dbmail_messages m
JOIN dbmail_header h USING (physmessage_id)
JOIN dbmail_headername n ON h.headername_id = n.id
JOIN dbmail_headervalue v ON h.headervalue_id = v.id
WHERE n.headername='date';
signature.asc
Description: OpenPGP digital signature
_______________________________________________ DBmail mailing list [email protected] http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail
