When I login into my site
I got following error.
How to add version number in the configuration table using cpanel?
My thanks in advance.
Error page tells you that you need to edit a table in the DB and how to check
version.php file of code for the value to use in the mdl_config table.
CPanel can be used to see the contents of the version.php file.
But it doesn't have a mysql tool ... for that think you'll have to use
phpMyAdmin. Is there a button in cPanel to phpMyAdmin?
https://www.hostdime.com/kb/display/HR/MySQL
but can't find info on phpMyAdmin
Suggest contacting provider help desk to inquire further about tools to actually edit tables in DB - which am almost certain they will advise against, but in this case doesn't look you have an option.
The bigger question ... how did this happen?
'spirit of sharing', Ken
Thank you for your answering my question.
I don't know how it happened.
cpanel has option phpmyadmin.
Can you please tell me how to correct this using phpmyadmin?
I am ready to reinstall moodle 3.6 freshly?
But before that can I take the backup of the course ( no user, I have uploaded only one course only)?
Your answers are valuable to me.
The error did give you directions as to how to correct the error.
Don't use phpmyadmin myself so this is from memory of something I don't use on a daily basis.
In PHPMyAdmin, select the db for moode, then select the mdl_config table. In the display of that table think you'll see little pen icons next to each row in that table. Click then pen for the 'version' column. And in the box, insert the version number you found in the version.php file of the code.
Don't think you can make a backup of any course you have until you fix the problem with the table.
Am assuming part of the fee you pay hosting provider is support. Suggest you provide your helpdesk folks info about the error and how Moodle shows fixing it.
Comment: things like this do NOT happen all by themselves. Since you have only one course, you might be learning a valuable lesson ... unfortunately, the hard way. :|
Now if helpdesk won't help or can't, and you still can't figure it out, suggest placing an 'ad' in Moodle jobs.
https://moodle.org/mod/data/view.php?d=54
Good Luck!
'spirit of sharing', Ken
Thank you Mr.Ken Task.
I have corrected using phpmyadmin, as directed by you.
Can you please tell me, How to prevent these errors in future?
Feel free to rate the posting that helped as 'useful' ... that's another way to say 'thanks'!
Glad you have fixed!
How to prevent? To answer that, one would have to know how it happened in the first place - exactly!
Venturing a guess however ... an upgrade was attempted/triggered and immediately cancelled which stopped the entry of the version in the table. IF that guess was true ...
https://docs.moodle.org/36/en/Upgrading
Am a 'fan' of using command line (git+scripts) for updates to code or upgrades to higher versions. Takes minutes and less prone to human error, IMHO.
How to do that with your site is a future exercise for you. Hmmm ... that 'assignment' perfect for setting up a development clone of your production site for learning git and update/upgrade via command line.
'spirit of sharing', Ken