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

2.0 activity upgrade Step 4 fails with SQL syntax error due to unescaped quotes

          Details

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

            Description

            CiviCRM 2.0.2
            There's an example here: http://forum.civicrm.org/index.php/topic,3128.msg13747.html#msg13747

            • the INSERT into activity_history fails if activity_summary contains a single quote.
              I added a sprintf and two mysql_real_escape_strings at lines 113-5 of CRM/Upgrade/TwoZero/Form/Step4.php, which fixed it. Not sure what the correct Civi coding style is for this.

              Attachments

                Activity

                  People

                  • Assignee:
                    amit Amiteshwar Prasad
                    Reporter:
                    davej Dave Jenkins
                  • Votes:
                    0 Vote for this issue
                    Watchers:
                    0 Start watching this issue

                    Dates

                    • Created:
                      Updated:
                      Resolved: