After 1.8.4+ -> 1.9+ upgrade: Unit tests report errors, grader not working correctly

After 1.8.4+ -> 1.9+ upgrade: Unit tests report errors, grader not working correctly

by Martin O'Mahony -
Number of replies: 3
I'm afraid I will need your help. Today I upgraded our Moodle system from 1.8.4+ to 1.9+ following these guidelines: http://docs.moodle.org/en/Upgrade

The update process reported no problems, but when I looked at my students' grades in the gradebook I noticed no totals were calculated (http://moodle.org/mod/forum/discuss.php?d=93296#p412123).

Now I tried the unit tests. And I am horrified by what I see (excerpts below). I clearly need assistance. Please help! What can I do now?


Moodle unit tests: ALL

Fail: lib/grade/simpletest/testgradegrades.php / grade_grade_test / test_grade_grade_insert /
Expected false, got [Boolean: true] at [/srv/www/htdocs/moodle/lib/grade/simpletest/testgradegrades.php line 75]
Fail: lib/grade/simpletest/testgradegrades.php / grade_grade_test / test_grade_grade_insert /
Expected false, got [Boolean: true] at [/srv/www/htdocs/moodle/lib/grade/simpletest/testgradegrades.php line 76]
Fail: lib/grade/simpletest/testgradeitem.php / grade_item_test / test_grade_item_is_calculated /
Equal expectation fails at character 20 with [= ##gi8366## + 30 + ##gi8366## - ##gi8366##] and [= ##gi8366## + 30 + item id 0 - item id 0] at [/srv/www/htdocs/moodle/lib/grade/simpletest/testgradeitem.php line 468]
Fail: lib/grade/simpletest/testgradeitem.php / grade_item_test / test_grade_item_get_calculation /
at [/srv/www/htdocs/moodle/lib/grade/simpletest/testgradeitem.php line 490]
Fail: lib/grade/simpletest/testgradeitem.php / grade_item_test / test_grade_item_compute /
Equal expectation fails because [Integer: 60] differs from [NULL] by 60 at [/srv/www/htdocs/moodle/lib/grade/simpletest/testgradeitem.php line 508]
Fail: lib/grade/simpletest/testgradeitem.php / grade_item_test / test_grade_item_compute /
Equal expectation fails because [Integer: 70] differs from [NULL] by 70 at [/srv/www/htdocs/moodle/lib/grade/simpletest/testgradeitem.php line 510]
Fail: lib/grade/simpletest/testgradeitem.php / grade_item_test / test_grade_item_compute /
Equal expectation fails because [Integer: 100] differs from [NULL] by 100 at [/srv/www/htdocs/moodle/lib/grade/simpletest/testgradeitem.php line 512]
Fail: lib/simpletest/testbackuplib.php / backuplib_test / test_backup_copy_user_files /
at [/srv/www/htdocs/moodle/lib/simpletest/testbackuplib.php line 106]
Fail: lib/simpletest/testbackuplib.php / backuplib_test / test_backup_copy_user_files /
at [/srv/www/htdocs/moodle/lib/simpletest/testbackuplib.php line 114]
Fail: lib/simpletest/testbackuplib.php / backuplib_test / test_backup_copy_user_files /
at [/srv/www/htdocs/moodle/lib/simpletest/testbackuplib.php line 114]
Fail: lib/simpletest/testbackuplib.php / backuplib_test / test_backup_copy_user_files /
at [/srv/www/htdocs/moodle/lib/simpletest/testbackuplib.php line 114]
Fail: lib/simpletest/testbackuplib.php / backuplib_test / test_backup_copy_user_files /
at [/srv/www/htdocs/moodle/lib/simpletest/testbackuplib.php line 114]

SQL ERROR: . STATEMENT: CREATE TABLE mdl_unittest_table (id SERIAL,textfield VARCHAR(255) DEFAULT 'Default',numberfield INTEGER DEFAULT 57082);

SQL ERROR: . STATEMENT:

SQL ERROR: . STATEMENT:

SQL ERROR: . STATEMENT:

SQL ERROR: . STATEMENT:

SQL ERROR: . STATEMENT:

SQL ERROR: . STATEMENT: DROP TABLE mdl_unittest_table;

SQL ERROR: . STATEMENT: CREATE TABLE mdl_unittest_table (id SERIAL,textfield VARCHAR(255) DEFAULT 'Default',numberfield INTEGER DEFAULT 57082);

SQL ERROR: . STATEMENT:

SQL ERROR: . STATEMENT:

SQL ERROR: . STATEMENT:

SQL ERROR: . STATEMENT:

SQL ERROR: . STATEMENT:

Fail: lib/simpletest/testdmllib.php / datalib_test / test_record_exists /
at [/srv/www/htdocs/moodle/lib/simpletest/testdmllib.php line 57]
Fail: lib/simpletest/testdmllib.php / datalib_test / test_record_exists /
at [/srv/www/htdocs/moodle/lib/simpletest/testdmllib.php line 59]

SQL ERROR: . STATEMENT: DROP TABLE mdl_unittest_table;

SQL ERROR: . STATEMENT: CREATE TABLE mdl_unittest_table (id SERIAL,textfield VARCHAR(255) DEFAULT 'Default',numberfield INTEGER DEFAULT 57082);

SQL ERROR: . STATEMENT:

SQL ERROR: . STATEMENT:

SQL ERROR: . STATEMENT:

SQL ERROR: . STATEMENT:

SQL ERROR: . STATEMENT:

Fail: lib/simpletest/testdmllib.php / datalib_test / test_record_exists_select /
at [/srv/www/htdocs/moodle/lib/simpletest/testdmllib.php line 63]
Fail: lib/simpletest/testdmllib.php / datalib_test / test_record_exists_select /
at [/srv/www/htdocs/moodle/lib/simpletest/testdmllib.php line 65]

SQL ERROR: . STATEMENT: DROP TABLE mdl_unittest_table;

SQL ERROR: . STATEMENT: CREATE TABLE mdl_unittest_table (id SERIAL,textfield VARCHAR(255) DEFAULT 'Default',numberfield INTEGER DEFAULT 57082);

SQL ERROR: . STATEMENT:

SQL ERROR: . STATEMENT:

SQL ERROR: . STATEMENT:

SQL ERROR: . STATEMENT:

SQL ERROR: . STATEMENT:

Fail: lib/simpletest/testdmllib.php / datalib_test / test_record_exists_sql /
at [/srv/www/htdocs/moodle/lib/simpletest/testdmllib.php line 70]
Fail: lib/simpletest/testdmllib.php / datalib_test / test_record_exists_sql /
at [/srv/www/htdocs/moodle/lib/simpletest/testdmllib.php line 72]

SQL ERROR: . STATEMENT: DROP TABLE mdl_unittest_table;

SQL ERROR: . STATEMENT: CREATE TABLE mdl_unittest_table (id SERIAL,textfield VARCHAR(255) DEFAULT 'Default',numberfield INTEGER DEFAULT 57082);

SQL ERROR: . STATEMENT:

SQL ERROR: . STATEMENT:

SQL ERROR: . STATEMENT:

SQL ERROR: . STATEMENT:

SQL ERROR: . STATEMENT:

Fail: lib/simpletest/testdmllib.php / datalib_test / test_get_record /
Actual object does not have all the same fields with the same values as the expected object (id, textfield, numberfield). at [/srv/www/htdocs/moodle/lib/simpletest/testdmllib.php line 78]
Fail: lib/simpletest/testdmllib.php / datalib_test / test_get_record /
Actual object does not have all the same fields with the same values as the expected object (id, textfield, numberfield). at [/srv/www/htdocs/moodle/lib/simpletest/testdmllib.php line 79]
Fail: lib/simpletest/testdmllib.php / datalib_test / test_get_record /
Actual object does not have all the same fields with the same values as the expected object (id, textfield). at [/srv/www/htdocs/moodle/lib/simpletest/testdmllib.php line 80]
Fail: lib/simpletest/testdmllib.php / datalib_test / test_get_record /
Error in debug mode. at [/srv/www/htdocs/moodle/lib/simpletest/testdmllib.php line 98]
Fail: lib/simpletest/testdmllib.php / datalib_test / test_get_record /
Actual object does not have all the same fields with the same values as the expected object (id, textfield). at [/srv/www/htdocs/moodle/lib/simpletest/testdmllib.php line 107]
Fail: lib/simpletest/testdmllib.php / datalib_test / test_get_record /
Actual object does not have all the same fields with the same values as the expected object (textfield, numberfield). at [/srv/www/htdocs/moodle/lib/simpletest/testdmllib.php line 113]

SQL ERROR: . STATEMENT: DROP TABLE mdl_unittest_table;

SQL ERROR: . STATEMENT: CREATE TABLE mdl_unittest_table (id SERIAL,textfield VARCHAR(255) DEFAULT 'Default',numberfield INTEGER DEFAULT 57082);

SQL ERROR: . STATEMENT:

SQL ERROR: . STATEMENT:

SQL ERROR: . STATEMENT:

SQL ERROR: . STATEMENT:

SQL ERROR: . STATEMENT:

Fail: lib/simpletest/testdmllib.php / datalib_test / test_get_record_sql /
Actual object does not have all the same fields with the same values as the expected object (id, textfield, numberfield). at [/srv/www/htdocs/moodle/lib/simpletest/testdmllib.php line 123]
Fail: lib/simpletest/testdmllib.php / datalib_test / test_get_record_sql /
Error in debug mode. at [/srv/www/htdocs/moodle/lib/simpletest/testdmllib.php line 140]

SQL ERROR: . STATEMENT: DROP TABLE mdl_unittest_table;

SQL ERROR: . STATEMENT: CREATE TABLE mdl_unittest_table (id SERIAL,textfield VARCHAR(255) DEFAULT 'Default',numberfield INTEGER DEFAULT 57082);

SQL ERROR: . STATEMENT:

SQL ERROR: . STATEMENT:

SQL ERROR: . STATEMENT:

SQL ERROR: . STATEMENT:

SQL ERROR: . STATEMENT:

Fail: lib/simpletest/testdmllib.php / datalib_test / test_get_record_select /
id > 1 AND id < 3 at [/srv/www/htdocs/moodle/lib/simpletest/testdmllib.php line 156]
Fail: lib/simpletest/testdmllib.php / datalib_test / test_get_record_select /
Error in debug mode. at [/srv/www/htdocs/moodle/lib/simpletest/testdmllib.php line 174]
Fail: lib/simpletest/testdmllib.php / datalib_test / test_get_record_select /
Actual object does not have all the same fields with the same values as the expected object (id, textfield). at [/srv/www/htdocs/moodle/lib/simpletest/testdmllib.php line 183]

SQL ERROR: . STATEMENT: DROP TABLE mdl_unittest_table;

SQL ERROR: . STATEMENT: CREATE TABLE mdl_unittest_table (id SERIAL,textfield VARCHAR(255) DEFAULT 'Default',numberfield INTEGER DEFAULT 57082);

SQL ERROR: . STATEMENT:

SQL ERROR: . STATEMENT:

SQL ERROR: . STATEMENT:

SQL ERROR: . STATEMENT:

SQL ERROR: . STATEMENT:

Fail: lib/simpletest/testdmllib.php / datalib_test / test_get_field /
Equal expectation fails as [Boolean: false] does not match [Integer: 101] at [/srv/www/htdocs/moodle/lib/simpletest/testdmllib.php line 191]
Fail: lib/simpletest/testdmllib.php / datalib_test / test_get_field /
Equal expectation fails as [Boolean: false] does not match [String: toad] at [/srv/www/htdocs/moodle/lib/simpletest/testdmllib.php line 192]
Fail: lib/simpletest/testdmllib.php / datalib_test / test_get_field /
Equal expectation fails as [Boolean: false] does not match [Integer: 104] at [/srv/www/htdocs/moodle/lib/simpletest/testdmllib.php line 193]
Fail: lib/simpletest/testdmllib.php / datalib_test / test_get_field /
Equal expectation fails as [Boolean: false] does not match [Integer: 108] at [/srv/www/htdocs/moodle/lib/simpletest/testdmllib.php line 194]
Fail: lib/simpletest/testdmllib.php / datalib_test / test_get_field /
[Boolean: false] should be null at [/srv/www/htdocs/moodle/lib/simpletest/testdmllib.php line 195]

SQL ERROR: . STATEMENT: DROP TABLE mdl_unittest_table;

SQL ERROR: . STATEMENT: CREATE TABLE mdl_unittest_table (id SERIAL,textfield VARCHAR(255) DEFAULT 'Default',numberfield INTEGER DEFAULT 57082);

SQL ERROR: . STATEMENT:

SQL ERROR: . STATEMENT:

SQL ERROR: . STATEMENT:

SQL ERROR: . STATEMENT:

SQL ERROR: . STATEMENT:

Fail: lib/simpletest/testdmllib.php / datalib_test / test_get_field_select /
Equal expectation fails as [Boolean: false] does not match [Integer: 101] at [/srv/www/htdocs/moodle/lib/simpletest/testdmllib.php line 199]

SQL ERROR: . STATEMENT: DROP TABLE mdl_unittest_table;

SQL ERROR: . STATEMENT: CREATE TABLE mdl_unittest_table (id SERIAL,textfield VARCHAR(255) DEFAULT 'Default',numberfield INTEGER DEFAULT 57082);

SQL ERROR: . STATEMENT:

SQL ERROR: . STATEMENT:

SQL ERROR: . STATEMENT:

SQL ERROR: . STATEMENT:

SQL ERROR: . STATEMENT:

Fail: lib/simpletest/testdmllib.php / datalib_test / test_get_field_sql /
Equal expectation fails as [Boolean: false] does not match [Integer: 101] at [/srv/www/htdocs/moodle/lib/simpletest/testdmllib.php line 204]

SQL ERROR: . STATEMENT: DROP TABLE mdl_unittest_table;

SQL ERROR: . STATEMENT: CREATE TABLE mdl_unittest_table (id SERIAL,textfield VARCHAR(255) DEFAULT 'Default',numberfield INTEGER DEFAULT 57082);

SQL ERROR: . STATEMENT:

SQL ERROR: . STATEMENT:

SQL ERROR: . STATEMENT:

SQL ERROR: . STATEMENT:

SQL ERROR: . STATEMENT:

Fail: lib/simpletest/testdmllib.php / datalib_test / test_set_field /
Equal expectation fails as [Boolean: false] does not match [Integer: 12345] at [/srv/www/htdocs/moodle/lib/simpletest/testdmllib.php line 209]
Fail: lib/simpletest/testdmllib.php / datalib_test / test_set_field /
Equal expectation fails as [Boolean: false] does not match [String: newvalue] at [/srv/www/htdocs/moodle/lib/simpletest/testdmllib.php line 212]
Fail: lib/simpletest/testdmllib.php / datalib_test / test_set_field /
Equal expectation fails as [Boolean: false] does not match [Integer: -1] at [/srv/www/htdocs/moodle/lib/simpletest/testdmllib.php line 215]
Fail: lib/simpletest/testdmllib.php / datalib_test / test_set_field /
[Boolean: false] should be null at [/srv/www/htdocs/moodle/lib/simpletest/testdmllib.php line 218]

SQL ERROR: . STATEMENT: DROP TABLE mdl_unittest_table;

SQL ERROR: . STATEMENT: CREATE TABLE mdl_unittest_table (id SERIAL,textfield VARCHAR(255) DEFAULT 'Default',numberfield INTEGER DEFAULT 57082);

SQL ERROR: . STATEMENT:

SQL ERROR: . STATEMENT:

SQL ERROR: . STATEMENT:

SQL ERROR: . STATEMENT:

SQL ERROR: . STATEMENT:

Fail: lib/simpletest/testdmllib.php / datalib_test / test_delete_records /
Equal expectation fails because [Integer: 0] differs from [Integer: 5] by 5 at [/srv/www/htdocs/moodle/lib/simpletest/testdmllib.php line 223]
Fail: lib/simpletest/testdmllib.php / datalib_test / test_delete_records /
Equal expectation fails because [Integer: 0] differs from [Integer: 4] by 4 at [/srv/www/htdocs/moodle/lib/simpletest/testdmllib.php line 225]
Fail: lib/simpletest/testdmllib.php / datalib_test / test_delete_records /
Equal expectation fails because [Integer: 0] differs from [Integer: 2] by 2 at [/srv/www/htdocs/moodle/lib/simpletest/testdmllib.php line 227]
Fail: lib/simpletest/testdmllib.php / datalib_test / test_delete_records /
Equal expectation fails because [Integer: 0] differs from [Integer: 1] by 1 at [/srv/www/htdocs/moodle/lib/simpletest/testdmllib.php line 229]

SQL ERROR: . STATEMENT: DROP TABLE mdl_unittest_table;

SQL ERROR: . STATEMENT: CREATE TABLE mdl_unittest_table (id SERIAL,textfield VARCHAR(255) DEFAULT 'Default',numberfield INTEGER DEFAULT 57082);

SQL ERROR: . STATEMENT:

SQL ERROR: . STATEMENT:

SQL ERROR: . STATEMENT:

SQL ERROR: . STATEMENT:

SQL ERROR: . STATEMENT:

Fail: lib/simpletest/testdmllib.php / datalib_test / test_delete_records2 /
Equal expectation fails because [Integer: 0] differs from [Integer: 4] by 4 at [/srv/www/htdocs/moodle/lib/simpletest/testdmllib.php line 234]

SQL ERROR: . STATEMENT: DROP TABLE mdl_unittest_table;

SQL ERROR: . STATEMENT: CREATE TABLE mdl_unittest_table (id SERIAL,textfield VARCHAR(255) DEFAULT 'Default',numberfield INTEGER DEFAULT 57082);

SQL ERROR: . STATEMENT:

SQL ERROR: . STATEMENT:

SQL ERROR: . STATEMENT:

SQL ERROR: . STATEMENT:

SQL ERROR: . STATEMENT:

Fail: lib/simpletest/testdmllib.php / datalib_test / test_delete_records_select /
Equal expectation fails because [Integer: 0] differs from [Integer: 2] by 2 at [/srv/www/htdocs/moodle/lib/simpletest/testdmllib.php line 241]

SQL ERROR: . STATEMENT: DROP TABLE mdl_unittest_table;

SQL ERROR: . STATEMENT: CREATE TABLE mdl_unittest_table (id SERIAL,textfield VARCHAR(255) DEFAULT 'Default',numberfield INTEGER DEFAULT 57082);

SQL ERROR: . STATEMENT:

SQL ERROR: . STATEMENT:

SQL ERROR: . STATEMENT:

SQL ERROR: . STATEMENT:

SQL ERROR: . STATEMENT:

Fail: lib/simpletest/testdmllib.php / datalib_test / test_update_record /
at [/srv/www/htdocs/moodle/lib/simpletest/testdmllib.php line 254]
Fail: lib/simpletest/testdmllib.php / datalib_test / test_update_record /
Simple update (Actual object does not have all the same fields with the same values as the expected object (id, textfield, numberfield).) at [/srv/www/htdocs/moodle/lib/simpletest/testdmllib.php line 255]
Fail: lib/simpletest/testdmllib.php / datalib_test / test_update_record /
at [/srv/www/htdocs/moodle/lib/simpletest/testdmllib.php line 261]
Fail: lib/simpletest/testdmllib.php / datalib_test / test_update_record /
Simple update (Actual object does not have all the same fields with the same values as the expected object (id, numberfield, textfield).) at [/srv/www/htdocs/moodle/lib/simpletest/testdmllib.php line 263]
Fail: lib/simpletest/testdmllib.php / datalib_test / test_update_record /
at [/srv/www/htdocs/moodle/lib/simpletest/testdmllib.php line 270]
Fail: lib/simpletest/testdmllib.php / datalib_test / test_update_record /
Simple update (Actual object does not have all the same fields with the same values as the expected object (id, numberfield).) at [/srv/www/htdocs/moodle/lib/simpletest/testdmllib.php line 271]

SQL ERROR: . STATEMENT: DROP TABLE mdl_unittest_table;

SQL ERROR: . STATEMENT: CREATE TABLE mdl_unittest_table (id SERIAL,textfield VARCHAR(255) DEFAULT 'Default',numberfield INTEGER DEFAULT 57082);

SQL ERROR: . STATEMENT:

SQL ERROR: . STATEMENT:

SQL ERROR: . STATEMENT:

SQL ERROR: . STATEMENT:

SQL ERROR: . STATEMENT:

Fail: lib/simpletest/testdmllib.php / datalib_test / test_insert_record /
Equal expectation fails as [Boolean: false] does not match [Integer: 6] at [/srv/www/htdocs/moodle/lib/simpletest/testdmllib.php line 283]
Fail: lib/simpletest/testdmllib.php / datalib_test / test_insert_record /
Simple insert with returnid (Actual object does not have all the same fields with the same values as the expected object (textfield, numberfield, id).) at [/srv/www/htdocs/moodle/lib/simpletest/testdmllib.php line 285]
Fail: lib/simpletest/testdmllib.php / datalib_test / test_insert_record /
Equal expectation fails as [Boolean: false] does not match [Boolean: true] at [/srv/www/htdocs/moodle/lib/simpletest/testdmllib.php line 291]
Fail: lib/simpletest/testdmllib.php / datalib_test / test_insert_record /
Simple insert without returnid (Actual object does not have all the same fields with the same values as the expected object (textfield, numberfield, id).) at [/srv/www/htdocs/moodle/lib/simpletest/testdmllib.php line 293]
Fail: lib/simpletest/testdmllib.php / datalib_test / test_insert_record /
Equal expectation fails as [Boolean: false] does not match [Integer: 8] at [/srv/www/htdocs/moodle/lib/simpletest/testdmllib.php line 298]
Fail: lib/simpletest/testdmllib.php / datalib_test / test_insert_record /
Insert with missing columns - should get defaults (Actual object does not have all the same fields with the same values as the expected object (textfield, id, numberfield).) at [/srv/www/htdocs/moodle/lib/simpletest/testdmllib.php line 302]
Fail: lib/simpletest/testdmllib.php / datalib_test / test_insert_record /
Equal expectation fails as [Boolean: false] does not match [Integer: 9] at [/srv/www/htdocs/moodle/lib/simpletest/testdmllib.php line 309]
Fail:
Average of ratings: -
In reply to Martin O'Mahony

Re: After 1.8.4+ -> 1.9+ upgrade: Unit tests report errors, grader not working correctly

by Martin O'Mahony -
For fear of losing data I rolled back our Moodle system to version 1.8.4+ last night by restoring the backups from this afternoon. By the way, I did all this on a productive system (i.e. real students and real grades).

Now, with the former version restored I tried the unit tests again and had an unexpected result:

Fail: lib/simpletest/testdmllib.php / ► datalib_test / ► test_insert_record / ► Insert bad data - error should have been printed. This is known not to work on MySQL. at [/srv/www/htdocs/moodle/lib/simpletest/testdmllib.php line 286] Starting digest processing...
Cleaned old digest records
Fail: question/type/numerical/simpletest/testquestiontype.php / ► / ► Bad GroupTest [/srv/www/htdocs/moodle/question/type/numerical/simpletest/testquestiontype.php] with error [Creating default object from empty value]

Does the second fail message have anything to do with the 1.9 upgrade not working?

How can I fix this error?

As aforementioned, this is a productive system with more than 300 users. I guess I'm close to panic...

In reply to Martin O'Mahony

Re: After 1.8.4+ -> 1.9+ upgrade: Unit tests report errors, grader not working correctly

by Han Gao -

I have the same problem, only for me, i have a fresh install.

In reply to Martin O'Mahony

Re: After 1.8.4+ -> 1.9+ upgrade: Unit tests report errors, grader not working correctly

by Ralf Lebowski -

Hi,


same goes for me after a new installation on Solaris_9:

-------8><------------------

Moodle unit tests: ALL

Fail: lib/grade/simpletest/testgradeitem.php / grade_item_test / test_grade_item_is_calculated /
Equal expectation fails at character 20 with [= ##gi9084## + 30 + ##gi9084## - ##gi9084##] and [= ##gi9084## + 30 + item id 0 - item id 0] at [/data2/moodle/mymoodle/lib/grade/simpletest/testgradeitem.php line 468]
Fail: lib/grade/simpletest/testgradeitem.php / grade_item_test / test_grade_item_get_calculation /
at [/data2/moodle/mymoodle/lib/grade/simpletest/testgradeitem.php line 490]
Fail: lib/grade/simpletest/testgradeitem.php / grade_item_test / test_grade_item_compute /
Equal expectation fails because [Integer: 60] differs from [NULL] by 60 at [/data2/moodle/mymoodle/lib/grade/simpletest/testgradeitem.php line 508]
Fail: lib/grade/simpletest/testgradeitem.php / grade_item_test / test_grade_item_compute /
Equal expectation fails because [Integer: 70] differs from [NULL] by 70 at [/data2/moodle/mymoodle/lib/grade/simpletest/testgradeitem.php line 510]
Fail: lib/grade/simpletest/testgradeitem.php / grade_item_test / test_grade_item_compute /
Equal expectation fails because [Integer: 100] differs from [NULL] by 100 at [/data2/moodle/mymoodle/lib/grade/simpletest/testgradeitem.php line 512]
Fail: lib/simpletest/slowtestcode.php / slow_code_test / test_php_syntax /
Cannot test PHP syntax because PHP is not on the path. at [/data2/moodle/mymoodle/lib/simpletest/slowtestcode.php line 32]
Fail: lib/simpletest/testbackuplib.php / backuplib_test / test_backup_copy_user_files /
at [/data2/moodle/mymoodle/lib/simpletest/testbackuplib.php line 106]
Fail: lib/simpletest/testbackuplib.php / backuplib_test / test_backup_copy_user_files /
at [/data2/moodle/mymoodle/lib/simpletest/testbackuplib.php line 114]
Fail: lib/simpletest/testbackuplib.php / backuplib_test / test_backup_copy_user_files /
at [/data2/moodle/mymoodle/lib/simpletest/testbackuplib.php line 114]
Fail: lib/simpletest/testbackuplib.php / backuplib_test / test_backup_copy_user_files /
at [/data2/moodle/mymoodle/lib/simpletest/testbackuplib.php line 114]
Fail: lib/simpletest/testbackuplib.php / backuplib_test / test_backup_copy_user_files /
at [/data2/moodle/mymoodle/lib/simpletest/testbackuplib.php line 114]

SQL ERROR: . STATEMENT: CREATE TABLE mdl_unittest_table (id SERIAL,textfield VARCHAR(255) DEFAULT 'Default',numberfield INTEGER DEFAULT 57082);

SQL ERROR: . STATEMENT:

SQL ERROR: . STATEMENT:

SQL ERROR: . STATEMENT:

SQL ERROR: . STATEMENT:

SQL ERROR: . STATEMENT:

SQL ERROR: . STATEMENT: DROP TABLE mdl_unittest_table;

SQL ERROR: . STATEMENT: CREATE TABLE mdl_unittest_table (id SERIAL,textfield VARCHAR(255) DEFAULT 'Default',numberfield INTEGER DEFAULT 57082);

SQL ERROR: . STATEMENT:

SQL ERROR: . STATEMENT:

SQL ERROR: . STATEMENT:

SQL ERROR: . STATEMENT:

SQL ERROR: . STATEMENT:

Fail: lib/simpletest/testdmllib.php / datalib_test / test_record_exists /
at [/data2/moodle/mymoodle/lib/simpletest/testdmllib.php line 57]
Fail: lib/simpletest/testdmllib.php / datalib_test / test_record_exists /
at [/data2/moodle/mymoodle/lib/simpletest/testdmllib.php line 59]

SQL ERROR: . STATEMENT: DROP TABLE mdl_unittest_table;

SQL ERROR: . STATEMENT: CREATE TABLE mdl_unittest_table (id SERIAL,textfield VARCHAR(255) DEFAULT 'Default',numberfield INTEGER DEFAULT 57082);

SQL ERROR: . STATEMENT:

SQL ERROR: . STATEMENT:

SQL ERROR: . STATEMENT:

SQL ERROR: . STATEMENT:

SQL ERROR: . STATEMENT:

Fail: lib/simpletest/testdmllib.php / datalib_test / test_record_exists_select /
at [/data2/moodle/mymoodle/lib/simpletest/testdmllib.php line 63]
Fail: lib/simpletest/testdmllib.php / datalib_test / test_record_exists_select /
at [/data2/moodle/mymoodle/lib/simpletest/testdmllib.php line 65]

SQL ERROR: . STATEMENT: DROP TABLE mdl_unittest_table;

SQL ERROR: . STATEMENT: CREATE TABLE mdl_unittest_table (id SERIAL,textfield VARCHAR(255) DEFAULT 'Default',numberfield INTEGER DEFAULT 57082);

SQL ERROR: . STATEMENT:

SQL ERROR: . STATEMENT:

SQL ERROR: . STATEMENT:

SQL ERROR: . STATEMENT:

SQL ERROR: . STATEMENT:

Fail: lib/simpletest/testdmllib.php / datalib_test / test_record_exists_sql /
at [/data2/moodle/mymoodle/lib/simpletest/testdmllib.php line 70]
Fail: lib/simpletest/testdmllib.php / datalib_test / test_record_exists_sql /
at [/data2/moodle/mymoodle/lib/simpletest/testdmllib.php line 72]

SQL ERROR: . STATEMENT: DROP TABLE mdl_unittest_table;

SQL ERROR: . STATEMENT: CREATE TABLE mdl_unittest_table (id SERIAL,textfield VARCHAR(255) DEFAULT 'Default',numberfield INTEGER DEFAULT 57082);

SQL ERROR: . STATEMENT:

SQL ERROR: . STATEMENT:

SQL ERROR: . STATEMENT:

SQL ERROR: . STATEMENT:

SQL ERROR: . STATEMENT:

Fail: lib/simpletest/testdmllib.php / datalib_test / test_get_record /
Actual object does not have all the same fields with the same values as the expected object (id, textfield, numberfield). at [/data2/moodle/mymoodle/lib/simpletest/testdmllib.php line 78]
Fail: lib/simpletest/testdmllib.php / datalib_test / test_get_record /
Actual object does not have all the same fields with the same values as the expected object (id, textfield, numberfield). at [/data2/moodle/mymoodle/lib/simpletest/testdmllib.php line 79]
Fail: lib/simpletest/testdmllib.php / datalib_test / test_get_record /
Actual object does not have all the same fields with the same values as the expected object (id, textfield). at [/data2/moodle/mymoodle/lib/simpletest/testdmllib.php line 80]
Fail: lib/simpletest/testdmllib.php / datalib_test / test_get_record /
Error in debug mode. at [/data2/moodle/mymoodle/lib/simpletest/testdmllib.php line 98]
Fail: lib/simpletest/testdmllib.php / datalib_test / test_get_record /
Actual object does not have all the same fields with the same values as the expected object (id, textfield). at [/data2/moodle/mymoodle/lib/simpletest/testdmllib.php line 107]
Fail: lib/simpletest/testdmllib.php / datalib_test / test_get_record /
Actual object does not have all the same fields with the same values as the expected object (textfield, numberfield). at [/data2/moodle/mymoodle/lib/simpletest/testdmllib.php line 113]

SQL ERROR: . STATEMENT: DROP TABLE mdl_unittest_table;

SQL ERROR: . STATEMENT: CREATE TABLE mdl_unittest_table (id SERIAL,textfield VARCHAR(255) DEFAULT 'Default',numberfield INTEGER DEFAULT 57082);

SQL ERROR: . STATEMENT:

SQL ERROR: . STATEMENT:

SQL ERROR: . STATEMENT:

SQL ERROR: . STATEMENT:

SQL ERROR: . STATEMENT:

Fail: lib/simpletest/testdmllib.php / datalib_test / test_get_record_sql /
Actual object does not have all the same fields with the same values as the expected object (id, textfield, numberfield). at [/data2/moodle/mymoodle/lib/simpletest/testdmllib.php line 123]
Fail: lib/simpletest/testdmllib.php / datalib_test / test_get_record_sql /
Error in debug mode. at [/data2/moodle/mymoodle/lib/simpletest/testdmllib.php line 140]

SQL ERROR: . STATEMENT: DROP TABLE mdl_unittest_table;

SQL ERROR: . STATEMENT: CREATE TABLE mdl_unittest_table (id SERIAL,textfield VARCHAR(255) DEFAULT 'Default',numberfield INTEGER DEFAULT 57082);

SQL ERROR: . STATEMENT:

SQL ERROR: . STATEMENT:

SQL ERROR: . STATEMENT:

SQL ERROR: . STATEMENT:

SQL ERROR: . STATEMENT:

Fail: lib/simpletest/testdmllib.php / datalib_test / test_get_record_select /
id > 1 AND id < 3 at [/data2/moodle/mymoodle/lib/simpletest/testdmllib.php line 156]
Fail: lib/simpletest/testdmllib.php / datalib_test / test_get_record_select /
Error in debug mode. at [/data2/moodle/mymoodle/lib/simpletest/testdmllib.php line 174]
Fail: lib/simpletest/testdmllib.php / datalib_test / test_get_record_select /
Actual object does not have all the same fields with the same values as the expected object (id, textfield). at [/data2/moodle/mymoodle/lib/simpletest/testdmllib.php line 183]

SQL ERROR: . STATEMENT: DROP TABLE mdl_unittest_table;

SQL ERROR: . STATEMENT: CREATE TABLE mdl_unittest_table (id SERIAL,textfield VARCHAR(255) DEFAULT 'Default',numberfield INTEGER DEFAULT 57082);

SQL ERROR: . STATEMENT:

SQL ERROR: . STATEMENT:

SQL ERROR: . STATEMENT:

SQL ERROR: . STATEMENT:

SQL ERROR: . STATEMENT:

Fail: lib/simpletest/testdmllib.php / datalib_test / test_get_field /
Equal expectation fails as [Boolean: false] does not match [Integer: 101] at [/data2/moodle/mymoodle/lib/simpletest/testdmllib.php line 191]
Fail: lib/simpletest/testdmllib.php / datalib_test / test_get_field /
Equal expectation fails as [Boolean: false] does not match [String: toad] at [/data2/moodle/mymoodle/lib/simpletest/testdmllib.php line 192]
Fail: lib/simpletest/testdmllib.php / datalib_test / test_get_field /
Equal expectation fails as [Boolean: false] does not match [Integer: 104] at [/data2/moodle/mymoodle/lib/simpletest/testdmllib.php line 193]
Fail: lib/simpletest/testdmllib.php / datalib_test / test_get_field /
Equal expectation fails as [Boolean: false] does not match [Integer: 108] at [/data2/moodle/mymoodle/lib/simpletest/testdmllib.php line 194]
Fail: lib/simpletest/testdmllib.php / datalib_test / test_get_field /
[Boolean: false] should be null at [/data2/moodle/mymoodle/lib/simpletest/testdmllib.php line 195]

SQL ERROR: . STATEMENT: DROP TABLE mdl_unittest_table;

SQL ERROR: . STATEMENT: CREATE TABLE mdl_unittest_table (id SERIAL,textfield VARCHAR(255) DEFAULT 'Default',numberfield INTEGER DEFAULT 57082);

SQL ERROR: . STATEMENT:

SQL ERROR: . STATEMENT:

SQL ERROR: . STATEMENT:

SQL ERROR: . STATEMENT:

SQL ERROR: . STATEMENT:

Fail: lib/simpletest/testdmllib.php / datalib_test / test_get_field_select /
Equal expectation fails as [Boolean: false] does not match [Integer: 101] at [/data2/moodle/mymoodle/lib/simpletest/testdmllib.php line 199]

SQL ERROR: . STATEMENT: DROP TABLE mdl_unittest_table;

SQL ERROR: . STATEMENT: CREATE TABLE mdl_unittest_table (id SERIAL,textfield VARCHAR(255) DEFAULT 'Default',numberfield INTEGER DEFAULT 57082);

SQL ERROR: . STATEMENT:

SQL ERROR: . STATEMENT:

SQL ERROR: . STATEMENT:

SQL ERROR: . STATEMENT:

SQL ERROR: . STATEMENT:

Fail: lib/simpletest/testdmllib.php / datalib_test / test_get_field_sql /
Equal expectation fails as [Boolean: false] does not match [Integer: 101] at [/data2/moodle/mymoodle/lib/simpletest/testdmllib.php line 204]

SQL ERROR: . STATEMENT: DROP TABLE mdl_unittest_table;

SQL ERROR: . STATEMENT: CREATE TABLE mdl_unittest_table (id SERIAL,textfield VARCHAR(255) DEFAULT 'Default',numberfield INTEGER DEFAULT 57082);

SQL ERROR: . STATEMENT:

SQL ERROR: . STATEMENT:

SQL ERROR: . STATEMENT:

SQL ERROR: . STATEMENT:

SQL ERROR: . STATEMENT:

Fail: lib/simpletest/testdmllib.php / datalib_test / test_set_field /
Equal expectation fails as [Boolean: false] does not match [Integer: 12345] at [/data2/moodle/mymoodle/lib/simpletest/testdmllib.php line 209]
Fail: lib/simpletest/testdmllib.php / datalib_test / test_set_field /
Equal expectation fails as [Boolean: false] does not match [String: newvalue] at [/data2/moodle/mymoodle/lib/simpletest/testdmllib.php line 212]
Fail: lib/simpletest/testdmllib.php / datalib_test / test_set_field /
Equal expectation fails as [Boolean: false] does not match [Integer: -1] at [/data2/moodle/mymoodle/lib/simpletest/testdmllib.php line 215]
Fail: lib/simpletest/testdmllib.php / datalib_test / test_set_field /
[Boolean: false] should be null at [/data2/moodle/mymoodle/lib/simpletest/testdmllib.php line 218]

SQL ERROR: . STATEMENT: DROP TABLE mdl_unittest_table;

SQL ERROR: . STATEMENT: CREATE TABLE mdl_unittest_table (id SERIAL,textfield VARCHAR(255) DEFAULT 'Default',numberfield INTEGER DEFAULT 57082);

SQL ERROR: . STATEMENT:

SQL ERROR: . STATEMENT:

SQL ERROR: . STATEMENT:

SQL ERROR: . STATEMENT:

SQL ERROR: . STATEMENT:

Fail: lib/simpletest/testdmllib.php / datalib_test / test_delete_records /
Equal expectation fails because [Integer: 0] differs from [Integer: 5] by 5 at [/data2/moodle/mymoodle/lib/simpletest/testdmllib.php line 223]
Fail: lib/simpletest/testdmllib.php / datalib_test / test_delete_records /
Equal expectation fails because [Integer: 0] differs from [Integer: 4] by 4 at [/data2/moodle/mymoodle/lib/simpletest/testdmllib.php line 225]
Fail: lib/simpletest/testdmllib.php / datalib_test / test_delete_records /
Equal expectation fails because [Integer: 0] differs from [Integer: 2] by 2 at [/data2/moodle/mymoodle/lib/simpletest/testdmllib.php line 227]
Fail: lib/simpletest/testdmllib.php / datalib_test / test_delete_records /
Equal expectation fails because [Integer: 0] differs from [Integer: 1] by 1 at [/data2/moodle/mymoodle/lib/simpletest/testdmllib.php line 229]

SQL ERROR: . STATEMENT: DROP TABLE mdl_unittest_table;

SQL ERROR: . STATEMENT: CREATE TABLE mdl_unittest_table (id SERIAL,textfield VARCHAR(255) DEFAULT 'Default',numberfield INTEGER DEFAULT 57082);

SQL ERROR: . STATEMENT:

SQL ERROR: . STATEMENT:

SQL ERROR: . STATEMENT:

SQL ERROR: . STATEMENT:

SQL ERROR: . STATEMENT:

Fail: lib/simpletest/testdmllib.php / datalib_test / test_delete_records2 /
Equal expectation fails because [Integer: 0] differs from [Integer: 4] by 4 at [/data2/moodle/mymoodle/lib/simpletest/testdmllib.php line 234]

SQL ERROR: . STATEMENT: DROP TABLE mdl_unittest_table;

SQL ERROR: . STATEMENT: CREATE TABLE mdl_unittest_table (id SERIAL,textfield VARCHAR(255) DEFAULT 'Default',numberfield INTEGER DEFAULT 57082);

SQL ERROR: . STATEMENT:

SQL ERROR: . STATEMENT:

SQL ERROR: . STATEMENT:

SQL ERROR: . STATEMENT:

SQL ERROR: . STATEMENT:

Fail: lib/simpletest/testdmllib.php / datalib_test / test_delete_records_select /
Equal expectation fails because [Integer: 0] differs from [Integer: 2] by 2 at [/data2/moodle/mymoodle/lib/simpletest/testdmllib.php line 241]

SQL ERROR: . STATEMENT: DROP TABLE mdl_unittest_table;

SQL ERROR: . STATEMENT: CREATE TABLE mdl_unittest_table (id SERIAL,textfield VARCHAR(255) DEFAULT 'Default',numberfield INTEGER DEFAULT 57082);

SQL ERROR: . STATEMENT:

SQL ERROR: . STATEMENT:

SQL ERROR: . STATEMENT:

SQL ERROR: . STATEMENT:

SQL ERROR: . STATEMENT:

Fail: lib/simpletest/testdmllib.php / datalib_test / test_update_record /
at [/data2/moodle/mymoodle/lib/simpletest/testdmllib.php line 254]
Fail: lib/simpletest/testdmllib.php / datalib_test / test_update_record /
Simple update (Actual object does not have all the same fields with the same values as the expected object (id, textfield, numberfield).) at [/data2/moodle/mymoodle/lib/simpletest/testdmllib.php line 255]
Fail: lib/simpletest/testdmllib.php / datalib_test / test_update_record /
at [/data2/moodle/mymoodle/lib/simpletest/testdmllib.php line 261]
Fail: lib/simpletest/testdmllib.php / datalib_test / test_update_record /
Simple update (Actual object does not have all the same fields with the same values as the expected object (id, numberfield, textfield).) at [/data2/moodle/mymoodle/lib/simpletest/testdmllib.php line 263]
Fail: lib/simpletest/testdmllib.php / datalib_test / test_update_record /
at [/data2/moodle/mymoodle/lib/simpletest/testdmllib.php line 270]
Fail: lib/simpletest/testdmllib.php / datalib_test / test_update_record /
Simple update (Actual object does not have all the same fields with the same values as the expected object (id, numberfield).) at [/data2/moodle/mymoodle/lib/simpletest/testdmllib.php line 271]

SQL ERROR: . STATEMENT: DROP TABLE mdl_unittest_table;

SQL ERROR: . STATEMENT: CREATE TABLE mdl_unittest_table (id SERIAL,textfield VARCHAR(255) DEFAULT 'Default',numberfield INTEGER DEFAULT 57082);

SQL ERROR: . STATEMENT:

SQL ERROR: . STATEMENT:

SQL ERROR: . STATEMENT:

SQL ERROR: . STATEMENT:

SQL ERROR: . STATEMENT:

Fail: lib/simpletest/testdmllib.php / datalib_test / test_insert_record /
Equal expectation fails as [Boolean: false] does not match [Integer: 6] at [/data2/moodle/mymoodle/lib/simpletest/testdmllib.php line 283]
Fail: lib/simpletest/testdmllib.php / datalib_test / test_insert_record /
Simple insert with returnid (Actual object does not have all the same fields with the same values as the expected object (textfield, numberfield, id).) at [/data2/moodle/mymoodle/lib/simpletest/testdmllib.php line 285]
Fail: lib/simpletest/testdmllib.php / datalib_test / test_insert_record /
Equal expectation fails as [Boolean: false] does not match [Boolean: true] at [/data2/moodle/mymoodle/lib/simpletest/testdmllib.php line 291]
Fail: lib/simpletest/testdmllib.php / datalib_test / test_insert_record /
Simple insert without returnid (Actual object does not have all the same fields with the same values as the expected object (textfield, numberfield, id).) at [/data2/moodle/mymoodle/lib/simpletest/testdmllib.php line 293]
Fail: lib/simpletest/testdmllib.php / datalib_test / test_insert_record /
Equal expectation fails as [Boolean: false] does not match [Integer: 8] at [/data2/moodle/mymoodle/lib/simpletest/testdmllib.php line 298]
Fail: lib/simpletest/testdmllib.php / datalib_test / test_insert_record /
Insert with missing columns - should get defaults (Actual object does not have all the same fields with the same values as the expected object (textfield, id, numberfield).) at [/data2/moodle/mymoodle/lib/simpletest/testdmllib.php line 302]
Fail: lib/simpletest/testdmllib.php / datalib_test / test_insert_record /
Equal expectation fails as [Boolean: false] does not match [Integer: 9] at [/data2/moodle/mymoodle/lib/simpletest/testdmllib.php line 309]
Fail: lib/simpletest/testdmllib.php / datalib_test / test_insert_record /
Insert with extra columns - should be ingnored (Actual object does not have all the same fields with the same values as the expected object (textfield, numberfield, id).) at [/data2/moodle/mymoodle/lib/simpletest/testdmllib.php line 312]
Fail: lib/simpletest/testdmllib.php / datalib_test / test_insert_record /
Equal expectation fails as [Boolean: false] does not match [Integer: 10] at [/data2/moodle/mymoodle/lib/simpletest/testdmllib.php line 318]