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

When cron.php is run it errors out gathering statistics - ORACLE.

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Duplicate
    • Icon: Major Major
    • None
    • 1.9
    • Administration
    • None
    • Moodle 1.9+ (20080327)
      Oracle 10.2
      Apache 2.2.4
      Windows 2003 server
      PHP 5.2.5
    • Oracle
    • MOODLE_19_STABLE

      When I turn on debugging and then run cron.php I get the following error message when running statistics.

      Running daily statistics gathering, starting at 1206601200:
      <div class="notifytiny" style="text-align:center">ORA-00904: "COURSEID": invalid identifier<br /><br />INSERT INTO mtstats_user_daily (stattype, timeend, courseid, userid, statsreads)

      SELECT 'logins' AS stattype, 1206687600 AS timeend, 1 AS courseid,
      l.userid, count(l.id) AS statsreads
      FROM mtlog l
      WHERE action = 'login' AND l.time >= 1206601200 AND l.time < 1206687600
      GROUP BY stattype, timeend, courseid, userid
      HAVING count(l.id) > 0<ul style="text-align:left"><li>line 103 of lib\dmllib.php: call to debugging()</li><li>line 162 of lib\statslib.php: call to execute_sql()</li><li>line 467 of admin\cron.php: call to stats_cron_daily()</li></ul></div>
      ...error occured, completed 0 days of statistics.

            stronk7 Eloy Lafuente (stronk7)
            jskarren Scott Karren (Inactive)
            Tim Hunt Tim Hunt
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

              Created:
              Updated:
              Resolved:

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