Topic doesnt exist when I try to delete it??! whu?

Topic doesnt exist when I try to delete it??! whu?

Dom London -
回帖数:4

error/moodle/sectionnotexist

I cant get anything more on this error. Moodle 3.7 I go to delete one of the unused topics and it says the topic doesnt exist.??

D
(And it doesnt delete the topic either - and the Moodle docs are empty on this one)

回复Dom London

Re: Topic doesnt exist when I try to delete it??! whu?

Ken Task -
Particularly helpful Moodlers的头像

First, backup your DB before anything suggested below!

3.7.0? or higher ... just released an update this week.

Can you make a backup of the course?

Hmmm ... might require access to DB for the Moodle.

mdl_course_sections table has
     id     bigint(10)     No     Primary     NULL     auto_increment
      course     bigint(10)     No     Indexed     0    
      section     bigint(10)     No     None     0    
      name     varchar(255)     Yes     None     NULL    
      summary     longtext     Yes     None     NULL    
      summaryformat     tinyint(2)     No     None     0    
      sequence     longtext     Yes     None     NULL    
      visible     tinyint(1)     No     None     1    
      availability     longtext     Yes     None     NULL    
      timemodified     bigint(10)     No     None     0

Query like:
select * from `mdl_course_sections` where `course` like "3"
where 3 above is your course ID.

has a visible column ... 1 means visible 0 means not visible.

Think I'd be cautious and remove the last row ... which would/should equate to the last section in a course.   Then view via browser.

'SoS', Ken


回复Ken Task

Re: Topic doesnt exist when I try to delete it??! whu?

Dom London -

Thanks Ken - I'll see if I can find someone with a degree or three in computer science!

回复Dom London

Re: Topic doesnt exist when I try to delete it??! whu?

Ken Task -
Particularly helpful Moodlers的头像

Well, Dom ... guess what?   I hold no degrees in Computer Science!  And running a Moodle doesn't take that sort of degree.   Have to put on different server admin hats from time to time.   At first it's scary, but if one takes it slow (the suggestion made, for example, to remove one row in the found set of records) one gains ground.

Do you have access to phpMyAdmin?  Many providers do offer that as a tool for their users.  You  could run the same query shown in a box in phpMyAdmin.

Come on Dom ... you are a teacher right?  We teacher's should never stop learning ... even in areas where we have no degrees! 微笑   Are we not asking students in our courses the same sort of thing every time they login to moodle ... learn something new?

However, after re-reading ... maybe what you want to do is simple set the number of topics that are visible in a course - not really delete them.   Assuming those topics have no content in them ...

Turn on editing   Go to course.  Edit settings. Look for an option of the number of topics to display.   Change and save.

If that's not it, turn on debugging.   Try to do whatever you do to get the error and let's see if there isn't more info about the issue.

'SoS', Ken