Application Form - 1.3.3 'CHAR NOT NULL column' error
- You cannot open a new topic into this forum
- Guests cannot post into this forum
luisdev
From: South Africa
Posts: 22
From: South Africa
Posts: 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?
Votes:57
Average:6.32
iseki
Posts: 1581
Posts: 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
Votes:67
Average:3.73
iseki
Posts: 1581
Posts: 1581
And ignoring this warning is okay
Votes:42
Average:5.24
luisdev
From: South Africa
Posts: 22
From: South Africa
Posts: 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
Votes:38
Average:5.00
Previous post
-
Next post
|
Parent
-
No child
|
Posted on 2018/10/11 9:53
iseki
Posts: 1581
Posts: 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.
Votes:45
Average:6.22
