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

Label update field issue in Windows servers

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 1.9.1
    • Fix Version/s: 1.9.2
    • Component/s: Resource
    • Labels:
      None
    • Environment:
      Windows Server 2003, Apache 2, Mysql 5
    • Database:
      MySQL
    • Affected Branches:
      MOODLE_19_STABLE
    • Fixed Branches:
      MOODLE_19_STABLE

      Description

      When trying to update Resource labels on Moodle 1.9 weekly build 20080702, too long portion of label text content is used to update "name" field instead of "content" filed, yielding a "Data too long for column" error. This problem appears only on windows Server, Linux server seems not affected.

      Sample Debugging message:

      Data too long for column 'name' at row 1

      UPDATE mdl_label SET course = '22',name = 'Corso "Tecniche di Project Management" Benvenuto, Il corso ha l\'obiettivo strategico di formare Project Manager e Collaboratori del Project Manager capaci di gestire progetti. In particolare, saranno ideati e sviluppati progetti da inserire nelle modalità di lavoro dei militari impiegati nelle articolazioni dei Re.T.L.A.. Buona fruizione!',content = '<p><strong><font size=\"5\">Corso "Tecniche di Project Management"</font></strong> </p> <p align=\"right\"><img title=\"Project management\" style=\"width: 155px; height: 162px\" height=\"162\" alt=\"Project management\" hspace=\"5\" src=\"http://logos/campus/file.php/22/Project_Management.jpg\" width=\"155\" border=\"0\" /></p> <p><strong><font size=\"4\">Benvenuto,</font></strong></p> <p align=\"justify\"><font size=\"4\">Il corso ha l\'obiettivo strategico di formare Project Manager e Collaboratori del Project Manager capaci di gestire progetti.</font></p> <p align=\"justify\"><font size=\"4\">In particolare, saranno ideati e sviluppati progetti da inserire nelle modalità di lavoro dei militari impiegati nelle articolazioni dei Re.T.L.A..</font> </p> <p align=\"right\"> </p> <p align=\"right\"></p> <p align=\"justify\"><font size=\"4\"><strong> Buona fruizione!</strong></font><br /></p>',timemodified = '1215082909' WHERE id = 136

      line 1704 of lib\dmllib.php: call to debugging()
      line 46 of mod\label\lib.php: call to update_record()
      line 244 of course\modedit.php: call to label_update_instance()

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                skodak Petr Skoda
                Reporter:
                andreabix Andrea Bicciolo
                Participants:
                Component watchers:
                Adrian Greeve, Mihail Geshoski, Peter Dias
              • Votes:
                0 Vote for this issue
                Watchers:
                0 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved:
                  Fix Release Date:
                  11/Jul/08