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

Unable to add fields to database activity. Error reading from databse.

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Critical
    • Resolution: Fixed
    • Affects Version/s: 2.0
    • Fix Version/s: 2.0
    • Labels:
      None
    • Environment:
      Windows XP, local install using XAMPP, Moodle 2.0 Preview 4+ (Build: 20100921)
      Mysql 5.1.49
      PHP 5.3.3
    • Database:
      MySQL
    • Affected Branches:
      MOODLE_20_STABLE
    • Fixed Branches:
      MOODLE_20_STABLE

      Description

      On attempt to add fields to a new database, I get the following error.

      Error reading from database

      More information about this error
      Debug info: Unknown column 'Date' in 'where clause'
      SELECT * FROM mdl_data_fields df
      WHERE LOWER(df.name) LIKE LOWER(Date) COLLATE utf8_bin ESCAPE '
      ' AND df.dataid = ? LIMIT 0, 1
      [array (
      0 => '3',
      )]
      Stack trace:

      • line 391 of \lib\dml\moodle_database.php: dml_read_exception thrown
      • line 691 of \lib\dml\mysqli_native_moodle_database.php: call to moodle_database->query_end()
      • line 1540 of \lib\dml\moodle_database.php: call to mysqli_native_moodle_database->get_recordset_sql()
      • line 1615 of \mod\data\lib.php: call to moodle_database->record_exists_sql()
      • line 105 of \mod\data\field.php: call to data_fieldname_exists()

        Attachments

          Activity

            People

            Assignee:
            skodak Petr Skoda
            Reporter:
            gsisson Glenn Sisson
            Tester:
            Nobody
            Participants:
            Component watchers:
            Adrian Greeve, Jake Dallimore, Mathew May, Mihail Geshoski, Peter Dias
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

              Dates

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