- 19 May 2017, 05:32
#3001
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'
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'