Hi,
After lots of problems I today deleted my moodle 2.0 install and the associated databases etc. Now I have created a new database and reinstalled 2.0. The very first thing I did was run the 'functional db' test, which previously flagged 3 fails and an exception. It has done exactly the same. This time the install is new (5 minutes old) and doesn't have any courses or users to think about. The test output was:
Running tests on: Current database (native/mysqli)
Fail:
lib/
dml/
simpletest/
testdml.php / ► dml_test
/ ► test_unique_index_collation_trouble
Unique index is accent insensitive, this may cause problems for non-ascii languages. This is usually caused by accent insensitive default collation. at [/home/bca19560/public_html/insegnanti-inglese.com/moodle/lib/dml/simpletest/testdml.php line 2769]
Exception:
lib/
dml/
simpletest/
testdml.php / ► dml_test
/ ► test_unique_index_collation_trouble
Unexpected exception of type [dml_write_exception] with message [Error writing to database] in [/home/bca19560/public_html/insegnanti-inglese.com/moodle/lib/dml/moodle_database.php line 394]
Debug info:
Duplicate entry 'aäa' for key 'mdl_unittabl_nam_uix'
INSERT INTO mdl_unit_table (name) VALUES(?)
[array (
0 => 'aäa',
)]
- line 843 of /lib/dml/mysqli_native_moodle_database.php: call to moodle_database->query_end()
- line 885 of /lib/dml/mysqli_native_moodle_database.php: call to mysqli_native_moodle_database->insert_record_raw()
- line 2763 of /lib/dml/simpletest/testdml.php: call to mysqli_native_moodle_database->insert_record()
- line ... of ...
Fail:
lib/
dml/
simpletest/
testdml.php / ► dml_test
/ ► test_sql_binary_equal
SQL operator "=" is expected to be accent sensitive at [/home/bca19560/public_html/insegnanti-inglese.com/moodle/lib/dml/simpletest/testdml.php line 2797]
Fail:
lib/
dml/
simpletest/
testdml.php / ► dml_test
/ ► test_sql_binary_equal
SQL operator "=" is expected to be case sensitive at [/home/bca19560/public_html/insegnanti-inglese.com/moodle/lib/dml/simpletest/testdml.php line 2800]
2/2 test cases complete: 962 passes, 3 fails and 1 exceptions.