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

Syntax error in SQL during upgrade just after deleting some courses

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Trivial
    • Resolution: Fixed
    • Affects Version/s: 1.8
    • Fix Version/s: 1.8.1
    • Component/s: Administration
    • Labels:
      None
    • Database:
      PostgreSQL
    • Affected Branches:
      MOODLE_18_STABLE
    • Fixed Branches:
      MOODLE_18_STABLE

      Description

      I just updated to latest cvs 18_STABLE this morning and started getting errors. switched to a clean database and now I'm getting these errors on installation as well:

      ERROR: syntax error at or near "AND" at character 149

      SELECT * FROM mdl_role_assignments WHERE contextid = AND userid = 3

      • line 677 of lib/dmllib.php: call to debugging()
      • line 918 of lib/dmllib.php: call to get_recordset_sql()
      • line 1250 of calendar/lib.php: call to get_records_sql()
      • line 1046 of calendar/lib.php: call to calendar_get_default_courses()
      • line 68 of calendar/lib.php: call to calendar_session_vars()
      • line 17 of admin/settings/appearance.php: call to require_once()
      • line 2732 of lib/adminlib.php: call to include_once()
      • line 349 of backup/lib.php: call to admin_get_root()
      • line 382 of admin/index.php: call to upgrade_backup_db()

      They appeared on 'setting up core tables' as well as the setting up backup table screens. Attaching full screen dump.

        Attachments

          Activity

            People

            Assignee:
            dougiamas Martin Dougiamas
            Reporter:
            mjollnir Penny Leach
            Tester:
            Nobody
            Participants:
            Component watchers:
            Andrew Nicols, Jun Pataleta, Michael Hawkins, Shamim Rezaie, Simey Lameze
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved:
              Fix Release Date:
              11/Jun/07