You'll have to check error logs of the server hosting the moodle and share back what you find there. Otherwise, it's anyone's guess cause 'error writing to database' could indicate many problems.
Suggest turning on debugging in Moodle to see if you can get more information.
'SoS', Ken
The problem is that the site is trying to insert a 68-character long string:
8 => 'EG07vXC02AIKfsIJd0PskfF7ql0vygjRPGuzxPVNPA3C33GuGvJYnZtcNk3j4yoILYtc',
into a 64-character wide column:
| Field | Type | Null | Key | Default | Extra |
+-------------------+--------------+------+-----+---------+----------------+
| privatetoken | varchar(64) | YES | | NULL | |
Before Moodle 3.8 privatetoken was an MD5 hash which is 32 characters long. From Moodle 3.8 onwards it generates a 64-character long string in lib/externallib.php:external_generate_token():
$newtoken->privatetoken = random_string(64);
$DB->insert_record('external_tokens', $newtoken);
Which version of Moodle is this? Can you check the above line hasn't been changed?
hi, many thanks for your help.
1. checked my moodle site version, it's 3.82+ (Build: 20200312).
2. table column in mysql as follows, may i know what should i do? thanks.
Please also check the the source code file lib/externallib.php so see if the token length in the function external_generate_token() has been changed. It's probably line 777:
776 // Generate the private token, it must be transmitted only via https.
777 $newtoken->privatetoken = random_string(64);
778 $DB->insert_record('external_tokens', $newtoken);
What does it say in your file, is it 64?
