Details
-
Type:
Bug
-
Status:
Closed
-
Priority:
Major
-
Resolution: Duplicate
-
Affects Version/s: 1.9
-
Fix Version/s: None
-
Component/s: Administration
-
Labels:None
-
Environment:Moodle 1.9+ (20080327)
Oracle 10.2
Apache 2.2.4
Windows 2003 server
PHP 5.2.5
-
Database:Oracle
-
Affected Branches:MOODLE_19_STABLE
Description
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.
Issue Links
| This issue duplicates: | ||||
| MDL-13861 | lib/statslib SQL errors under Oracle |
|
|
|
Hi, this was fixed some weeks ago by
MDL-13861. Should be working ok now.MDL-13861. Should be working ok now.