-
Type:
Bug
-
Resolution: Fixed
-
Priority:
Minor
-
Affects Version/s: COmanage Registry 2.0.0 (Passing Fad)
-
Component/s: Registry
-
Environment:On mysql Distrib 5.7.17, for Linux (x86_64)
Adding and updating the description of a CO Extended Attribute works fine on mysql 5.7.17, but altering its name or altering its index setting after creation throws a SQL error like the following:
Error: 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 'COLUMN atestone TO atesttwo' at line 2
SQL Query: ALTER TABLE cm_co_2_person_extended_attributes RENAME COLUMN atestone TO atesttwo
at
APP/Controller/CoExtendedAttributesController.php line 324 → Model->query(string)