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

Upgrade fails from 2.2.9+ to 2.5 (database error)

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Fixed
    • Icon: Minor Minor
    • 2.5.1
    • 2.5, 2.6
    • Installation
    • None

      I have an ubuntu server with php 5.3.10 and Mysql 5.5.31. I tried upgrading from moodle version 2.2.9+ to Moodle 2.5 i get a database error. when i checked the logs i found this:

      Default exception handler: \xce\xa3\xcf\x86\xce\xac\xce\xbb\xce\xbc\xce\xb1 \xce\xb1\xce\xbd\xce\xac\xce\xb3\xce\xbd\xcf\x89\xcf\x83\xce\xb7\xcf\x82 \xce\xb1\xcf\x80\xcf\x8c \xcf\x84\xce\xb7 \xce\xb2\xce\xac\xcf\x83\xce\xb7 \xce\xb4\xce\xb5\xce\xb4\xce\xbf\xce\xbc\xce\xad\xce\xbd\xcf\x89\xce\xbd
      Debug: BIGINT UNSIGNED value is out of range in '(`DBNAME`.`f`.`active` * '1')'
      SELECT active.filter, fc.name, fc.value
               FROM (SELECT f.filter, MAX(f.sortorder) AS sortorder
                   FROM mdl_filter_active f
                   JOIN mdl_context ctx ON f.contextid = ctx.id
                   WHERE ctx.id IN (1)
                   GROUP BY filter
                   HAVING MAX(f.active * ctx.depth) > -MIN(f.active * ctx.depth)
               ) active
               LEFT JOIN mdl_filter_config fc ON fc.filter = active.filter AND fc.contextid = 1
               ORDER BY active.sortorder
      [array (
      )]
      Error code: dmlreadexception
      * line 423 of /lib/dml/moodle_database.php: dml_read_exception thrown
      * line 942 of /lib/dml/mysqli_native_moodle_database.php: call to moodle_database->query_end()
      * line 888 of /lib/filterlib.php: call to mysqli_native_moodle_database->get_recordset_sql()
      * line 118 of /lib/filterlib.php: call to filter_get_active_in_context()
      * line 179 of /lib/filterlib.php: call to filter_manager->load_filters()
      * line 253 of /lib/filterlib.php: call to filter_manager->get_text_filters()
      * line 1318 of /lib/weblib.php: call to filter_manager->setup_page_for_filters()
      * line 1073 of /lib/pagelib.php: call to format_string()
      * line 252 of /admin/index.php: call to moodle_page->set_title()
      

            skodak Petr Skoda
            chrodos Christos Rodosthenous
            Sam Hemelryk Sam Hemelryk
            Eloy Lafuente (stronk7) Eloy Lafuente (stronk7)
            Votes:
            0 Vote for this issue
            Watchers:
            4 Start watching this issue

              Created:
              Updated:
              Resolved:

                Error rendering 'clockify-timesheets-time-tracking-reports:timer-sidebar'. Please contact your Jira administrators.