Uploaded image for project: 'CiviCRM'
  1. CiviCRM
  2. CRM-5393

check or handle custom field names with reserved mysql words

    Details

    • Type: Bug
    • Status: Done/Fixed
    • Priority: Minor
    • Resolution: Fixed/Completed
    • Affects Version/s: 2.2.9
    • Fix Version/s: Unscheduled
    • Component/s: Core CiviCRM
    • Labels:
      None

      Description

      I created a custom field for membership called "Primary" and it generated a corresponding field name "primary". It didn't fail at that point, but when I tried to actually add any records, the corresponding generated insert statement gave a mysql syntax error. I think the solution is either to be more careful about the corresponding field name generated, or else probably safer is use of quotes in the generation of the sql.

        Attachments

          Activity

            People

            • Assignee:
              lobo Donald A. Lobo
              Reporter:
              adixon Alan Dixon
            • Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: