Uploaded image for project: 'Moodle'
  1. Moodle
  2. MDL-7611

Upgrading from 1.6.3 to 1.7 - italian Version - problem with apostrophe - bad formed SQL syntax

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Blocker
    • Resolution: Fixed
    • Affects Version/s: 1.7
    • Fix Version/s: 1.7.1, 1.8
    • Component/s: Installation
    • Labels:
      None
    • Environment:
      Debia Sarge + PostgreSql7
    • Database:
      PostgreSQL
    • Affected Branches:
      MOODLE_17_STABLE
    • Fixed Branches:
      MOODLE_17_STABLE, MOODLE_18_STABLE

      Description

      the upgrade from 1.6.3 to 1.7 of italian version doesn't work because a problem with ' (apostrophe).
      To correct this behaviour you can patch moodle/lib/accesslib.php, line 1605, function create_role:

      • from: $role->description = $description;
      • to: $role->description = str_replace("'","\'",$description);

      this preserve from crash the SQL command for create some role (function insert_record()).

      I do not know if other situations exist that produce bad sql sintax.

        Attachments

          Activity

            People

            • Assignee:
              skodak Petr Skoda
              Reporter:
              maxmnc Massimo Mancini
              Tester:
              Nobody
              Participants:
              Component watchers:
              Matteo Scaramuccia, Andrew Nicols, Jun Pataleta, Michael Hawkins, Shamim Rezaie, Simey Lameze
            • Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved:
                Fix Release Date:
                17/Jan/07