Hi,
I have two visible courses in my moodle interface.
However, when the autobackup was executed, the log recorded 3 courses.
So I checked the mdl_course table and it actually has three courses.
However, when the autobackup was executed, the log recorded 3 courses.
So I checked the mdl_course table and it actually has three courses.
id | category | sortorder | fullname | shortname | idnumber | summary | summaryformat | format | showgrades | newsitems | startdate | enddate | relativedatesmode | marker | maxbytes | legacyfiles | showreports | visible | visibleold | groupmode | groupmodeforce | defaultgroupingid | lang | calendartype | theme | timecreated | timemodified | requested | enablecompletion | completionnotify | cacherev |
1 | 0 | 1 | Course 1 | Course 1 | <p>Course 1</p> | 0 | site | 1 | 3 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 1,4E+09 | 1,44E+09 | 0 | 0 | 0 | 1,58E+09 | ||||
9 | 2 | 10001 | Course 2 | Course 2 | <p>Course 2</p> | 1 | topics | 1 | 5 | 1,24E+09 | 0 | 0 | 0 | 0 | 2 | 0 | 1 | 1 | 0 | 0 | 0 | 1,24E+09 | 1,58E+09 | 0 | 0 | 0 | 1,59E+09 | ||||
10 | 2 | 10002 | Course 3 | Course 3 | <p>Course 3</p> | 1 | topics | 1 | 5 | 1,44E+09 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 1,44E+09 | 1,58E+09 | 0 | 0 | 0 | 1,59E+09 |
Is it because the course 1 category is 0?
Why this happened and how can I delete Course 1 and all its content from mysql and ftp?
I'm using Moodle 3.8+ (Build: 20191129)