Uhhhh ... thought you had gotten BBB upgraded and were working on character set/collaton?
Oh ... well ...
*** Did you install MySQLTuner and run it? ***
As a test, successfully installed a fresh copy of the same version of BBB to a 3.4 via command line admin/cli/upgrade.php
mysql Ver 14.14 Distrib 5.7.23
2 tables ... the one below has the 'welcome' field ... * is calling your attention to a row .... not something in table or that MySQL did.
mysql> explain mdl_bigbluebuttonbn;
+---------------+--------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+---------------+--------------+------+-----+---------+----------------+
| id | bigint(10) | NO | PRI | NULL | auto_increment |
| course | bigint(10) | NO | | 0 | |
| name | varchar(255) | NO | | | |
| intro | longtext | YES | | NULL | |
| introformat | smallint(4) | NO | | 1 | |
| meetingid | varchar(256) | YES | | NULL | |
| moderatorpass | varchar(255) | NO | | | |
| viewerpass | varchar(255) | NO | | | |
| wait | tinyint(1) | NO | | 0 | |
| record | tinyint(1) | NO | | 0 | |
| tagging | tinyint(1) | NO | | 0 | |
* | welcome | longtext | YES | | NULL | |
| voicebridge | mediumint(5) | NO | | 0 | |
| openingtime | bigint(10) | NO | | 0 | |
| closingtime | bigint(10) | NO | | 0 | |
| timecreated | bigint(10) | NO | | 0 | |
| timemodified | bigint(10) | NO | | 0 | |
| presentation | longtext | YES | | NULL | |
| participants | longtext | YES | | NULL | |
| userlimit | smallint(3) | NO | | 0 | |
+---------------+--------------+------+-----+---------+----------------+
20 rows in set (0.00 sec)
Again, the Type is 'longtext'
In the install.xml
<FIELD NAME="welcome" TYPE="text" NOTNULL="false" SEQUENCE="false"/>
In the upgrade.php file there is this section:
//// Change welcome, allow null
$field = new xmldb_field('welcome');
$field->set_attributes(XMLDB_TYPE_TEXT, null, null, null, null, null, null, null, 'type');
if( $dbman->field_exists($table, $field) ) {
$dbman->change_field_notnull($table, $field, $continue=true, $feedback=true);
}
Note the comment ... change welcome to allow null.
In a fresh install the explain on that table for welcome column does have
allow nulls yes and the default value is NULL
Since I'd rather not step through setting it up, how about you check what data there is in that table, welcome and the attributes of that table ... mdl_bigbluebuttonbn
'spirit of sharing', Ken