opencats.org

Hi OpenCats Forum

having a little issue when adding Extra Fields and then trying to move them up
I get this error message.... Any help would be appreciated

Query Error -- Report to System Administrator ASAP


MySQL Query Failed: 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 'WHERE
extra_field_settings.site_id = 1
AND
' at line 5

UPDATE
extra_field_settings
SET
extra_field_settings.position =
WHERE
extra_field_settings.site_id = 1
AND
extra_field_settings.data_item_type = 100
AND
extra_field_settings.field_name = 'AHPRA MEDICARE Registration number'

HI,

I've just created this extra field on the test site at http://demo.opencats.org and moved the field up and down with no issues. So apologies but I cannot reproduce your issue on 0.9.4