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

Moodle 2.0 SCORM package with MSSQL

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Major
    • Resolution: Duplicate
    • Affects Version/s: 2.0
    • Fix Version/s: None
    • Component/s: SCORM
    • Labels:
      None
    • Environment:
      Windows 2003, IIS, PHP, MSSQL 2005
    • Database:
      Microsoft SQL
    • Affected Branches:
      MOODLE_20_STABLE

      Description

      I uploaded a new SCORM package, then it redirects to the display and shows this error.

      Error reading from database
      More information about this error
      Debug info: The data types ntext and nvarchar are incompatible in the equal to operator.
      SELECT id,title FROM mdl_scorm_scoes WHERE scorm = ? AND organization = ? AND launch = ? ORDER BY id
      [array (
      0 => '1',
      1 => '',
      2 => '',
      )]
      Stack trace:

      • line 391 of \lib\dml\moodle_database.php: dml_read_exception thrown
      • line 247 of \lib\dml\mssql_native_moodle_database.php: call to moodle_database->query_end()
      • line 699 of \lib\dml\mssql_native_moodle_database.php: call to mssql_native_moodle_database->query_end()
      • line 728 of \lib\dml\mssql_native_moodle_database.php: call to mssql_native_moodle_database->get_recordset_sql()
      • line 1075 of \lib\dml\moodle_database.php: call to mssql_native_moodle_database->get_records_sql()
      • line 1024 of \lib\dml\moodle_database.php: call to moodle_database->get_records_select()
      • line 1115 of \lib\dml\moodle_database.php: call to moodle_database->get_records()
      • line 727 of \mod\scorm\locallib.php: call to moodle_database->get_records_menu()
      • line 89 of \mod\scorm\view.php: call to scorm_view_display()

      To work around it i changed the column dbo.[mdl_scorm_scoes].[launch] from ntext to nvarchar(4000)

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              danmarsden Dan Marsden
              Reporter:
              djeeg djeeg
              Tester:
              Nobody Nobody
              Participants:
              Component watchers:
              Dan Marsden, Matteo Scaramuccia, Adrian Greeve, Jake Dallimore, Mathew May, Mihail Geshoski, Peter Dias, Sujith Haridasan
              Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved: