On Thu, 25 Mar 2010 10:24:37 +0100, Andre Hübner andre.huebner@gmx.de articulated:
i use successfully mysql-quotasystem with dovecot 1.2.11 on different servers except for mysql 4.0 servers dovecot internally uses sql: "ON DUPLICATE KEY UPDATE" which was introduced in mysql 4.1 Is there a chance to make this statement mysql 4.0 compatible or should i update mysql? i want to avoid updating mysql because some old software is running which is not compatible to higher mysql versions.
In my opinion, continued use of depreciated software is a practice that should be avoided whenever possible. Inevitably, it causes problems as you are now experiencing.
I am somewhat surprised that the older software is not compatible with the newer version of MySQL. Usually, it is the other way around. Have you checked to see if newer versions of the incompatible software exist? I would be willing to wager that they have been updated to accommodate the newer MySQL versions.
-- Jerry Dovecot.user@seibercom.net
Disclaimer: off-list followups get on-list replies or get ignored. Please do not ignore the Reply-To header.
There's a fine line between courage and foolishness. Too bad it's not a fence.