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

Forums - Error reading from database

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 2.0
    • Fix Version/s: 2.0
    • Component/s: Forum
    • Labels:
      None
    • Environment:
      Microsoft Server 2008, PHP 5.3.1 , MSSQL, FreeTDS php driver, Moodle 2.0 Preview 2
    • Database:
      Microsoft SQL
    • Affected Branches:
      MOODLE_20_STABLE
    • Fixed Branches:
      MOODLE_20_STABLE

      Description

      I am able to create a new discussion in a forum but when i try and view that discussion i get Error Reading From Database. with Debugging turned up i get the following error message:

      Debug info: Operand type clash: ntext is incompatible with tinyint
      SELECT * FROM mdl20www_portfolio_instance WHERE visible = ? AND id NOT IN (
      SELECT instance FROM mdl20www_portfolio_instance_user
      WHERE userid = ? AND name = ? AND value = ?
      ) ORDER BY name
      [array (
      0 => 1,
      1 => '2',
      2 => 'visible',
      3 => 0,
      )]
      Stack trace:
      line 378 of \lib\dml\moodle_database.php: dml_read_exception thrown
      line 244 of \lib\dml\mssql_native_moodle_database.php: call to moodle_database->query_end()
      line 691 of \lib\dml\mssql_native_moodle_database.php: call to mssql_native_moodle_database->query_end()
      line 720 of \lib\dml\mssql_native_moodle_database.php: call to mssql_native_moodle_database->get_recordset_sql()
      line 516 of \lib\portfoliolib.php: call to mssql_native_moodle_database->get_records_sql()
      line 103 of \lib\portfoliolib.php: call to portfolio_instances()
      line 222 of C:\inetpub\Moodle20www\moodle\mod\forum\discuss.php: call to portfolio_add_button->__construct()

        Attachments

          Activity

            People

            • Assignee:
              stronk7 Eloy Lafuente (stronk7)
              Reporter:
              daniel.r Daniel Rathborne
              Tester:
              Nobody
              Participants:
              Component watchers:
              Andrew Nicols, Mathew May, Michael Hawkins, Shamim Rezaie, Simey Lameze
            • Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved:
                Fix Release Date:
                24/Nov/10