-
Bug
-
Resolution: Fixed
-
Major
-
1.9
-
None
-
Microsoft SQL
-
MOODLE_19_STABLE
-
MOODLE_18_STABLE, MOODLE_19_STABLE, MOODLE_20_STABLE
I don't know if this is specific to the mssql_n driver, but I can reproduce it with the following:
$enroldb = ADONewConnection($CFG->dbtype);
$enroldb->Connect($CFG->dbhost, $CFG->dbuser, $CFG->dbpass, $CFG->dbname, true);
$enroldb->SetFetchMode(ADODB_FETCH_ASSOC);
$enroldb->execute('set ansi_nulls on;
set ansi_warnings on;
set ansi_padding on;
set concat_null_yields_null on;');
// then examine the contents of
$enroldb->execute('select * from mdl_config')->getArray();
Fields that show up as being '' from tsql and MSSQL Server Management Express are NULL in the script.
This causes a problem upgrading to 1.9 because the admin page keeps on thinking that their are new configuration settings.
- has been marked as being related by
-
MDL-14725 last m19 never dispose new settings page in MSSQL
- Closed