Error reading from database

Error reading from database

Calvin Bu - මගින්
Number of replies: 4

Hello All,

I am currently using Moodle v3.3.7 with MySQL v5.7.22 for database engine . When I migrate this Moodle environment into my new test/development that is using MySQL v8.0.17 as the database engine for the back-end, everything seem to work fine, except one course. It gave me the "Error reading from database" message.

Does Moodle v3.3.7 compatible with MySQL v8?

Thank you for your help!

Cal

ශ්‍රේණිගත කිරීම්වල සාමාන්යය: -
In reply to Calvin Bu

Re: Error reading from database

Howard Miller - මගින්
Core developers ගේ පින්තුරය Documentation writers ගේ පින්තුරය Particularly helpful Moodlers ගේ පින්තුරය Peer reviewers ගේ පින්තුරය Plugin developers ගේ පින්තුරය
More importantly.... support for the 3.3 branch ended completely over a year ago. Please upgrade.

Compatibility with early versions of MySQL 8 was added in 3.3.7 but you have a more recent version. I wouldn't be at all surprised if there are problems.
ශ්‍රේණිගත කිරීම්වල සාමාන්යය: -
In reply to Calvin Bu

Re: Error reading from database

Ken Task - මගින්
Particularly helpful Moodlers ගේ පින්තුරය

As long as you are 'out there' ... on the 'leading edge'  (vr 8.xx of MySQL) ... please turn on debugging all the to max ... attempt the troubled course backup again ... let's see what it says.

Share back.

You might be saving someone else from some headaches and a tracker submission. සිනහව

'SoS', Ken


ශ්‍රේණිගත කිරීම්වල සාමාන්යය: Useful (1)
In reply to Ken Task

Re: Error reading from database

Calvin Bu - මගින්
Thank you all for responding to my question.

After spending couple hours to troubleshoot the "Error database reading" issue with this course, I discovered that the "Checklist" plugin was the reason why this course was failing. Uninstall & then reinstall the "Checklist" plugin did not work.

I plan to go ahead to perform the upgrade from v3.3.7 to v3.6.6 tomorrow. Hopefully, the new Moodle version will correct the "Checklist" issue with the newer plugin.

Thanks,
Cal
ශ්‍රේණිගත කිරීම්වල සාමාන්යය: -
In reply to Calvin Bu

Re: Error reading from database

Visvanath Ratnaweera - මගින්
Particularly helpful Moodlers ගේ පින්තුරය Translators ගේ පින්තුරය
If you want to play safe, uninstall the plug-in, delete its source. Upgrade Moodle and then install the matching version of the plug-in.

Why do you go for 3.6? The current stable is 3.7. Don't have PHP 7.1? If it is the case you might want to go for the Release 3.5 (LTS), which is supported 12 months longer.
ශ්‍රේණිගත කිරීම්වල සාමාන්යය: -