When logging into Moodle we get the following error (don't mind the Danish. It just says "Error when writing to the database" - Moodle generic message):
Fejl ved skrivning til database (Data too long for column 'sid' at row 1 INSERT INTO mdl_auth_oidc_sid (userid,sid,timecreated) VALUES(?,?,?) [array ( 0 => '9', 1 => 'xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx.xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx', 2 => 1783342718, )]) (Data too long for column 'sid' at row 1 INSERT INTO mdl_auth_oidc_sid (userid,sid,timecreated) VALUES(?,?,?) [array ( 0 => '9', 1 => 'xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx.xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx', 2 => 1783342718, )])
When I look at the install.xml, I can see that the field length of sid is only 36. Moodle has a length of 128 characters and I believe the specifications has no max length.
I think you are able to just widen the length to 128 characters (Moodle standard) and then it would work or even to 256 to be sure.
Install.xml - Line 68
|
<FIELD NAME="sid" TYPE="char" LENGTH="36" NOTNULL="true" SEQUENCE="false"/> |
Expand the sid field in the upgrade.php
When logging into Moodle we get the following error (don't mind the Danish. It just says "Error when writing to the database" - Moodle generic message):
When I look at the install.xml, I can see that the field length of sid is only 36. Moodle has a length of 128 characters and I believe the specifications has no max length.
I think you are able to just widen the length to 128 characters (Moodle standard) and then it would work or even to 256 to be sure.
Install.xml - Line 68
o365-moodle/auth/oidc/db/install.xml
Line 68 in cfa4b0f
Expand the sid field in the upgrade.php