XMLDB has detected one CHAR NOT NULL

XMLDB has detected one CHAR NOT NULL

oleh Christophe Coussement -
Jumlah balasan: 2

Seen in client's Moodle 4.0 :

XMLDB has detected one CHAR NOT NULL column (urlggb) with '' (empty string) as DEFAULT value. This type of columns must have one meaningful DEFAULT declared or none (NULL). XMLDB have fixed it automatically changing it to none (NULL). The process will continue ok and proper defaults will be created accordingly with each DB requirements. Please fix it in source (XML and/or upgrade script) to avoid this message to be displayed.
  • line 1696 of /lib/datalib.php: call to debugging()
  • line 352 of /lib/xmldb/xmldb_object.php: call to xmldb_debug()
  • line 255 of /lib/xmldb/xmldb_field.php: call to xmldb_object->debug()
  • line 359 of /lib/xmldb/xmldb_field.php: call to xmldb_field->setDefault()
  • line 543 of /lib/xmldb/xmldb_table.php: call to xmldb_field->arr2xmldb_field()
  • line 276 of /lib/xmldb/xmldb_structure.php: call to xmldb_table->arr2xmldb_table()
  • line 172 of /lib/xmldb/xmldb_file.php: call to xmldb_structure->arr2xmldb_structure()
  • line 153 of /lib/xmldb/xmldb_file.php: call to xmldb_file->arr2xmldb_structure()
  • line 938 of /lib/ddl/database_manager.php: call to xmldb_file->loadXMLStructure()
  • line 69 of /lib/classes/check/performance/dbschema.php: call to database_manager->get_install_xml_schema()
  • line 111 of /lib/classes/check/table.php: call to core\check\performance\dbschema->get_result()
  • line 44 of /report/performance/index.php: call to core\check\table->render()
This was supposed to be solved sinds version 1.9 (https://tracker.moodle.org/browse/MDL-7354)!

Any clue why it's coming back and what could trigger it? Other 4.0 installations do not have this problem...

Rata-rata penilaian: -
Sebagai balasan Christophe Coussement

Re: XMLDB has detected one CHAR NOT NULL

oleh Leon Stringer -
Gambar dari Core developers Gambar dari Particularly helpful Moodlers

It looks like this is a bug in the GeoGebra plugin: #68 Installation throws notice. It appears to be fixed in the latest version of the plugin.

Rata-rata penilaian:Useful (2)