Changing feed update property results in error with MySQL < 4.1

[adam@…]

As of svn revision 1312, when editing a feed and changing the "Allow Update" property on a system backed by MySQL 4.0 or earlier, a SQL error occurs...

Failed to execute the SQL query

insert into  properties (fk_ref_object_id, proptype, property, value) values ('186','feed','rss.input.allowupdates','b:0;') ON DUPLICATE KEY UPDATE value='b:0;'

Error 1064: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'ON DUPLICATE KEY UPDATE value='b:0;'' at line 1

INSERT ... ON DUPLICATE KEY was added in MySQL 4.1.

Either the code needs to be changed or the system requirements need to be updated to reflect MySQL 4.1 as the minimum required version.

[adam@…]

Patch to make property updates conform to ANSI SQL

[anonymous]

in [1313]. Well spotted, Adam, thanks!