Application Form - 1.3.3 'CHAR NOT NULL column' error
- このフォーラムに新しいトピックを立てることはできません
- このフォーラムではゲスト投稿が禁止されています
luisdev
居住地: South Africa
投稿数: 22

After installing 1.3.3 of the mod_apply module on my Moodle 3.5.2 (Build: 20180910) test site I got this error message:
XMLDB has detected one CHAR NOT NULL column (date_format) 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 1733 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 131 of \lib\xmldb\xmldb_field.php: call to xmldb_field->setDefault()
• line 103 of \lib\xmldb\xmldb_field.php: call to xmldb_field->set_attributes()
• line 87 of \mod\apply\db\upgrade.php: call to xmldb_field->__construct()
• line 806 of \lib\upgradelib.php: call to xmldb_apply_upgrade()
• line 512 of \lib\upgradelib.php: call to upgrade_plugins_modules()
• line 1857 of \lib\upgradelib.php: call to upgrade_plugins()
• line 694 of \admin\index.php: call to upgrade_noncore()
2018100300: Success (0.21 seconds)
Success (0.66 seconds)
Does this mean there are any functionality regressions?
XMLDB has detected one CHAR NOT NULL column (date_format) 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 1733 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 131 of \lib\xmldb\xmldb_field.php: call to xmldb_field->setDefault()
• line 103 of \lib\xmldb\xmldb_field.php: call to xmldb_field->set_attributes()
• line 87 of \mod\apply\db\upgrade.php: call to xmldb_field->__construct()
• line 806 of \lib\upgradelib.php: call to xmldb_apply_upgrade()
• line 512 of \lib\upgradelib.php: call to upgrade_plugins_modules()
• line 1857 of \lib\upgradelib.php: call to upgrade_plugins()
• line 694 of \admin\index.php: call to upgrade_noncore()
2018100300: Success (0.21 seconds)
Success (0.66 seconds)
Does this mean there are any functionality regressions?
投票数:62
平均点:6.13
iseki
投稿数: 1581

Thank you for your bug reports.
I am constructing new test environment for 3.5.2 now
I am constructing new test environment for 3.5.2 now
投票数:82
平均点:3.90
iseki
投稿数: 1581

And ignoring this warning is okay
投票数:45
平均点:5.56
luisdev
居住地: South Africa
投稿数: 22

If it helps... My test Moodle site is running on Windows Server 2012 STD R2 64bit with IIS 8.5 and a SQS Server 2016 SP1 database. I connect Moodle/PHP to MSSQL via the 'sqlsrv' driver v5.3.0. PHP is version 7.0.31
投票数:52
平均点:5.58
iseki
投稿数: 1581

Hi,
I updated subversion repository (ver 1.3.4).
I'll update moodle plugin directory later.
I updated subversion repository (ver 1.3.4).
I'll update moodle plugin directory later.
投票数:53
平均点:6.04