-
Bug
-
Resolution: Fixed
-
Major
-
1.9
-
None
-
Oracle
-
MOODLE_19_STABLE
-
MOODLE_19_STABLE
Under Oracle, SQL statements like "SELECT fields1, fields2" with no "FROM table" are invalid and produce a "FROM keyword not found where expected" error. This is most obvious when the cron task performs its stats collection. The solution is to select from the dummy 'DUAL' table in statements affected.
Attached is my workaround patch I'm using for the moment, which is probably only useful to locate the problematic statements until an official solution is implemented. Perhaps a function like the one below could be added to dmllib to get around this in a compatible manner?
function sql_null_from() {
global $CFG;
switch ($CFG->dbfamily)
}