Syntax error sometimes when trying to move a layout
Permalink
Hi,
periodically I receive a syntax error when trying to move stubborn (read as, refuses to move where I want them to go) layouts. Here is the error I receive:
An exception occurred while executing 'UPDATE CollectionVersionBlocks SET cbDisplayOrder = CASE bID END WHERE bID in () AND cID = ? AND cvID = ?' with params ["276", "10"]: SQLSTATE[42000]: Syntax error or access violation: 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 'END WHERE bID in () AND cID = '276' AND cvID = '10'' at line 1
I am currently logged in as the admin user I created when I setup c5.
this is c5version 8.2.1 on PHP7 and MySQL 5.6.32
does anyone have any suggestions on where to look and what to look for to correct this annoying use for me?
thanks
periodically I receive a syntax error when trying to move stubborn (read as, refuses to move where I want them to go) layouts. Here is the error I receive:
An exception occurred while executing 'UPDATE CollectionVersionBlocks SET cbDisplayOrder = CASE bID END WHERE bID in () AND cID = ? AND cvID = ?' with params ["276", "10"]: SQLSTATE[42000]: Syntax error or access violation: 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 'END WHERE bID in () AND cID = '276' AND cvID = '10'' at line 1
I am currently logged in as the admin user I created when I setup c5.
this is c5version 8.2.1 on PHP7 and MySQL 5.6.32
does anyone have any suggestions on where to look and what to look for to correct this annoying use for me?
thanks
