it is, dbmail 3.0.2 is happy too after apply there is only one additional field in the view and the other both are present too, applied on production servers to not get hurt by forget it later at dbmail-updates
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'; Am 19.06.2013 10:37, schrieb Harald Leithner: > Is this change backward compatible? > > Maybe a better sql change communication would be great, because I checked all > commits and no one say that there is > a sql structure change. > > Am 19.06.2013, 09:54 Uhr, schrieb Paul J Stevens <[email protected]>: > > On 06/18/2013 01:43 PM, Reindl Harald wrote: > >>>> below the full query and the debug-log with maksed db-password >>>> maybe you can guess what roundcube mail does not like with it too > > Ok, found it. You need to apply > > sql/mysql/3_0_2-3_0_3.mysql > > since a view was updated to fix sort
signature.asc
Description: OpenPGP digital signature
_______________________________________________ DBmail mailing list [email protected] http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail
