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

Moodle 2.0 SCORM package with MSSQL

    XMLWordPrintable

Details

    • Bug
    • Status: Closed
    • Major
    • Resolution: Duplicate
    • 2.0
    • None
    • SCORM
    • None
    • Windows 2003, IIS, PHP, MSSQL 2005
    • Microsoft SQL
    • 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

              danmarsden Dan Marsden
              djeeg djeeg
              Nobody Nobody
              Dan Marsden, Matteo Scaramuccia, Ilya Tregubov, Kevin Percy, Mathew May, Mihail Geshoski, Shamim Rezaie
              Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: