Hi Guys,
I am trying to clean a cloned moodle server installation from all courses and reuse it for the upcoming year.
I am deleting manually the courses from past years but it is slow and sometimes it timeouts.
Has anyone any steps procedures on how to clean all data from a moodle server courses, /moodledata , DB
The current server is too big now it will go in archive and new data will be stored on the new server but we need to keep all the configs in place.
best regards,
Tim
Install moosh
Then use mooh's course-delete command:
https://moosh-online.com/commands/
course-delete
Delete course(s) with ID(s) given as argument(s).
Example 1: delete courses id 2,3 and 4.
moosh course-delete 2 3 4
'SoS', Ken
@shpetim aliaj - who's Tim?
2 persons in same thread but with similar (but causes could be different) makes is difficult ... on all.
In your case a course module ... something in that course is tied to a user. In debug shows an assignment?
So, go to troubled course and manually delete assignments ...
Know you want mass delete ... course and content in course, which moosh will do ... GUI mass delete is finding something moosh doesn't ... moosh does a course at a time.
'SoS', Ken
Well, that's 'special'! :\ and am stumpted.
Error clearly says trying to delete a module that is an assignment but can't be found.
Can you find that ID number in 'mdl_assignment' table?
How about 'mdl_course_modules'?
If moosh won't delete might have to resort to direct database manipulation of tables ... last resort!
Anyone else have an idea?
'SoS', Ken
Link about provides strange solution, but it works ... as you have already stated.
However ... vr 3.6.x ... bug fixes ended already (ended 11 November 2019). Wonder if an upgrade to supported version will fix?
'SoS', Ken
I see in one of error lines at top:
'plugin format_onetopic is not found'
https://moodle.org/plugins/pluginversions.php?plugin=format_onetopic
Now that you have upgraded to 3.8.x get the 3.8 version of onetopic.
You might have to manually re-install onetopic format to get by errors in deleting.
Also ... recycle bin ... in config of recycle bin have it display all the time so you can see the recyclebin link in course admin menus as well as somewhere in course categories. If you can still see this stubborn course go to it and check recyclebin link.
Allow listings and deletion of recyclebin backups.
'SoS', Ken
"i did it but still not working." ... did which? Reinstall of onetopic (missing) and setting recyclebin viewable?
Could we get a look at:
"data in 39 rows in the mdl_assign but there is no assignment on the course"
Well, since it failed once assignment may not show when looking at GUI of course ... that's a guess ... but if there are 39 rows associated with an assignment that had been in the course, sounds like failure happened before moosh or the routine it called to delete rows .... another guess.
And I saw something else ... require login ... one can use moosh commands with no sudo as apache user ... a -n ... which moosh will warn about. Have used the -n switch and moosh still performs ... the only thing with -n ... ownerships and permissions need be checked after running -n on some commands.
'SoS', Ken
Missed this ... just noticed in looking again ... :|
* line 951 of /mod/assign/submission/mahara/locallib.php: call to assign->get_instance()
* line 814 of /mod/assign/locallib.php: call to assign_submission_mahara->delete_instance()
Looks like you have mahara installed and using for assignment submissions?
https://moodle.org/plugins/pluginversions.php?plugin=assignsubmission_mahara
shows combat up to 3.6
Could explain the confusion with users when deleting a module from a course ... maybe!
'SoS', Ken
"Please can you hel out."
Yeah! That's am trying to do!!!!
Well, getting closer!
Now we see invalidcoursemodule but this time ...
/assign/submission/onlinetext/
Yes, online submissions of assignments is part of core so no plugins
to remove.
The course module is the assignment.
So looks like we are down to manipulation with DB.
mysql> show tables like '%assign%';
shows all tables related to assignments - quite a few of them.
Below assign in the one that should be active ... the tables with assignment are the old assignments.
| mdl_assign |
| mdl_assign_grades |
| mdl_assign_overrides |
| mdl_assign_plugin_config |
| mdl_assign_submission |
| mdl_assign_user_flags |
| mdl_assign_user_mapping |
| mdl_assignfeedback_comments |
| mdl_assignfeedback_editpdf_annot |
| mdl_assignfeedback_editpdf_cmnt |
| mdl_assignfeedback_editpdf_queue |
| mdl_assignfeedback_editpdf_quick |
| mdl_assignfeedback_editpdf_rot |
| mdl_assignfeedback_file |
| mdl_assignment |
| mdl_assignment_submissions |
| mdl_assignment_upgrade |
| mdl_assignsubmission_file |
| mdl_assignsubmission_onlinetext |
| mdl_role_allow_assign |
| mdl_role_assignments
One of them:
mdl_assignsubmission_onlinetext
mysql> explain mdl_assignsubmission_onlinetext;
+--------------+-------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+--------------+-------------+------+-----+---------+----------------+
| id | bigint(10) | NO | PRI | NULL | auto_increment |
| assignment | bigint(10) | NO | MUL | 0 | |
| submission | bigint(10) | NO | MUL | 0 | |
| onlinetext | longtext | YES | | NULL | |
| onlineformat | smallint(4) | NO | | 0 | |
+--------------+-------------+------+-----+---------+----------------+
select * from mdl_assignsubmission_onlinetext;
will show data for those.
Looks like (example):
+----+------------+------------+-------------------------------+--------------+
| id | assignment | submission | onlinetext | onlineformat |
+----+------------+------------+-------------------------------+--------------+
| 2 | 5 | 6 | <p>2nd after cropping<br></p> | 1 |
+----+------------+------------+-------------------------------+--------------+
The error doesn't tell us id nor assignment number does it?
Can you still access via Web that course and hold your mouse over any assignment
to view an ID number?
Since this is a sandbox site, do a mysqldump of DB so we don't loose what we've gained to this point, then drop the row(s) via mysql dlient. Try the moosh command again.
Course from hell, isn't it! :\ Am really keeping my fingers crossed for ya.
'SoS', Ken
| Category | Action |
|---|---|
| top | This category has been deleted because, after deleting the course, its questions weren't used any more. |
| Default for 20010-PSY3301-201920111 | This category has been deleted because, after deleting the course, its questions weren't used any more. |
And this goes on and on and on ...
Huh?
sudo -u apache /usr/local/bin/moosh course-list "fullname like '%%'"
Correction ... course(s) from hell!
You're gonna have to dig more ... otherwise this exchange becomes a 1 to 1 consulting. Open source software might be free, but it does not mean free support! I do have a 'life' and sites I support on a commercial scale, however.
'SoS', Ken
A couple of *last* items ... cause there is no curriclum/course for sites with problems such as yours ....
Rather than using the moosh command to delete courses one at time, create a list of course ID's to delete.
Issue command with those course id's ... all of them.
moosh command 5 568 1099 30 20033 341
IF it dies at 30 ... jot down that CID .... reissue beginning with 20033 341 and so on.
IF it dies at 341 ... jot down that CID ... reissue beginning with next CID.
Then you have a list of troubled courses that will take some additional slutheing.
There is a hidden admin tool you need to run ...
site/admin/tool/health/
It will probably find issues but it tells you what they are and provides a button for suggested resolution to the problem. Sometimes, the solution is an SQL query ... which you should have no problems running.
Fingers crossed ... things get fixed.
A module in a course could be anything ... a blog, a label, a quiz ... moosh doesn't report the module id number.
So more slutheing ... are there tables for 'modules'?
Check 'em out ... use explain to see structure ... a query selecting columns to see data. Focus on any course ID that might be in those tables that match your troubled course. And so on and so on ...
Come back here and blog about it ... for others who might have their own courses from hell ... do share back what worked ... and what didn't.
And continue making snapshots (DB dumps) after each and every one of your successes cause the next one might be the final nail in the coffin! When you save those dumps, name them with something to indicate a stage in your journey.
Remember to take the time to record info cause you will have to do all/any on your production server when you get brave enough to pull the trigger on that 'bad boy' ... and am going to assume, since you are working with a clone right now ... production will be a 'bad boy'.
Best of luck!
'SoS', Ken
Am not responding to the question, (how lucky are you?) but had a thought ...
You've moved all the courses to be culled into a category and have been painfully deleting them. No 2 have had the same issues ... each has had something unique.
If that is true, am wondering about courses not to be culled ... but reused/reset for next academic session. How 'healthy' are they? You are working on a clone of production yet had to update or re-install plugins (mahara/onetopic/) on clone in order to delete a course.
Even after you finish with culling, one could be looking at a very deep ice burg with other courses.
Are you sitting down? calm? Story ... there is a major uni on the west coast that avoided issues by starting a new fresh version of Moodle every year. That new server is whatever the latest/greatest version of Moodle exist at the time. They build the shell ... categories ... and setup users (asst. admins/managers) and then have teachers/managers (graduate assistants maybe) restore reset backups to new server or rebuild courses from scratch.
Read that they might do updates to that server ... not upgrades ... so the version of Moodle doesn't change ... just point release updates. Server is used up to the close of 2nd semester of summer. Then no new students ... etc. Those servers remain for X and teachers/former students can still access but in kinda a 'read only mode'.
New server cranked up just prior to close of that last academic session.
Not suggesting you adopt and follow that from this day forward, but ... might want to consider it given situation ... especially, if the courses you've not checked for health have issues.
2 cents!
'SoS', Ken
