Please describe the issue you're having
If you accept the answer, please mark the topic as [SOLVED] by clicking the tick.

Moderators: RussH, cptr13

Forum rules: Just please remember to play nicely once you walk through the door. You can disagree with us, or any other commenters in this forum, but respect our space and keep your comments directed to the topic at hand.
By djansen
#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'
User avatar
By RussH
#3086
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

It's essential to keep these synchronized to ensur[…]

Export part in Job Order order search

Same problem as mine. Maybe you're right, I'll che[…]

The error message you're encountering indicates th[…]

Errors restoring mysqldump backup

doesnot work for me