Uploaded image for project: 'COmanage'
  1. COmanage
  2. CO-1427

Renaming or changing index settings on CO Extended Attribute throws SQL syntax error (mysql)

    XMLWordPrintable

Details

    Description

      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)

      Attachments

        Issue Links

          Activity

            People

              tzeller Tom Zeller (Inactive)
              arlen.johnson@at.internet2.edu Arlen Johnson (google.com)
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: