-
Bug
-
Resolution: Duplicate
-
Major
-
None
-
1.9
-
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.
- duplicates
-
MDL-13861 lib/statslib SQL errors under Oracle
-
- Closed
-