Details
-
Type:
Bug
-
Status:
Closed
-
Priority:
Major
-
Resolution: Cannot Reproduce
-
Affects Version/s: 2.0
-
Fix Version/s: None
-
Component/s: Blog
-
Labels:None
-
Affected Branches:MOODLE_20_STABLE
Description
This may be postgres only:
Exception: blog/simpletest/testbloglib.php / ? bloglib_test / ? test_overrides
Unexpected exception of type [dml_read_exception] with message [Error reading from database] in [/fs2/www/html/tjh238/moodle_head/lib/dml/moodle_database.php line 362]
Error string: dmlreadexception from error - Error reading from database
ERROR: invalid input syntax for integer: ""
SELECT * FROM mh_context WHERE contextlevel = $1 AND instanceid = $2
[array (
0 => 50,
1 => false,
)]
Since MySQL probably treats an empty string as the integer 0. Anyway, needs to be fixed.
I have just encountered this same issue during a upgrade from moodle 1.97 to 2.0 preview 1