Hi All,
I have been using moodle since last year.
Initially I installed moodle 3.3 and later on upgraded it to moodle 3.4.
Now i would like to upgrade my site to Moodle 3.5, but when I try to upgrade, it gives me some errors informing me that some tables are missing in the old version.
So, I took backups of the databases of Moodle 3.4 and as well as Moodle 3.5 and when I check, I found out that the following tables are missing from Moodle 3.4.
mdl_analytics_indicator_calc,
mdl_analytics_models,
mdl_analytics_models_log,
mdl_analytics_predict_samples,
mdl_analytics_prediction_actions,
mdl_analytics_predictions,
mdl_analytics_train_samples,
mdl_analytics_used_analysables,
mdl_analytics_used_files
mdl_ltiservice_gradebookservices,
mdl_message_conversation_members,
mdl_message_conversations,
mdl_message_popup_notifications,
mdl_message_user_actions,
mdl_messages,
mdl_notifications,
mdl_quiz_slot_tags,
mdl_role_allow_view,
mdl_search_index_requests,
mdl_search_simpledb_index,
mdl_tool_dataprivacy_category,
mdl_tool_dataprivacy_contextlist,
mdl_tool_dataprivacy_ctxexpired,
mdl_tool_dataprivacy_ctxinstance,
mdl_tool_dataprivacy_ctxlevel,
mdl_tool_dataprivacy_ctxlst_ctx,
mdl_tool_dataprivacy_purpose,
mdl_tool_dataprivacy_request,
mdl_tool_dataprivacy_rqst_ctxlst,
mdl_tool_policy,
mdl_tool_policy_acceptances,
mdl_tool_policy_versions.
Also some of the tables in the previous version (Moodle 3.4) are removed.
mdl_message_working,
mdl_workshop_assessments_old,
mdl_workshop_comments_old,
mdl_workshop_elements_old,
mdl_workshop_grades_old,
mdl_workshop_old,
mdl_workshop_rubrics_old,
mdl_workshop_stockcomments_old,
mdl_workshop_submissions_old.
After realising about the missing tables I restored them and I was able to upgrade the site successfully.
After the upgrade I checked the database again and found that all the new tables and the old tables are there.
I looked for an explanation in the forum and any other related sites but couldn't find anything related to my issue.
My questions are,
Is it okay if I keep all those tables in the databse?
Wont it be a problem in future upgrades?
Have I done anything wrong during the upgrading process to get something like above?
Can anyone help me with this?
It would be a great help for me if I get any solution for this.
Thank you,
Nuwani.