Error finding or creating section structures for this course!

Error finding or creating section structures for this course!

by Williams Castillo -
Number of replies: 12
Error finding or creating section structures for this course

Hi, I'm trying to create a new course.. I did what I think I'm suposed to do in order to create a  new course... I've created 5 courses so far and this one is giving me a headache...

I'd create a new social-based course and everything seems to be OK.. I'd choose the assigned teacher and still everything seems to be OK... But when I try to enter into it, I get the error copied above.

The asociated URL for question is the next one (the second course):

http://mystamps.net/nadia/cursos/course/category.php?id=2

Any idea?

Average of ratings: -
In reply to Williams Castillo

Re: Error finding or creating section structures for this course!

by Williams Castillo -

OMG... dead.gifdead.gifdead.gifdead.gifdead.gif

The problem seems to be worst than what I though... dead.gifdead.gifdead.gif

Now, I get the same error when I try to enter to any of the courses...

Any helping hand??? please!!!

Average of ratings: -
In reply to Williams Castillo

Re: Error finding or creating section structures for this course!

by Williams Castillo -

Ok... Just a few tips I've found...

I was playing with the backup/restore utility this afternoon... Everything went fine..

I backed a course up (ID 8), and I restore it as a new course (new ID 9)... and then I deleted this new course (i was just testing).

Now, I'm inside the data directory of moodle and I found that the directory and files of the course 9 (the one I though I deleted) are still there...

However... No matter what course I try to get into, I get the error... In course/view.php I see it is generated in the following lines:

if (! $sections = get_all_sections($course->id) ) { // Try again
   error("Error finding or creating section structures for this course");
}

I think it could help anyhow.

Average of ratings: -
In reply to Williams Castillo

Re: Error finding or creating section structures for this course!

by Williams Castillo -

Sorry for dumping out all my stemps.. But I think it is not a moodle-related problem... I get the following error when I try to execute a query in MySQL

Error

MySQL said: Can't open file: 'mdl_course_sections.MYI'. (errno: 145).

Query: SELECT * FROM mdl_course_sections LIMIT 1

This table seems to exist but can't be accesed... Perhaps the problem is in my hosting provider... sad

Average of ratings: -
In reply to Williams Castillo

Re: Error finding or creating section structures for this course!

by Eloy Lafuente (stronk7) -
Picture of Core developers Picture of Documentation writers Picture of Moodle HQ Picture of Particularly helpful Moodlers Picture of Peer reviewers Picture of Plugin developers Picture of Testers
That problems seems to happen when the course cannot find any section of your course in DB.

Are all your "no working" courses in "social" format?

Can you send me the contents of your "course_sections" table ? No, why ?

And the id,shortname and format fields from your "course" table ? No, why ?

Uhm, the problem could be there !!

Ciao, Eloy.
Average of ratings: -
In reply to Eloy Lafuente (stronk7)

Re: Error finding or creating section structures for this course!

by Williams Castillo -
Thanks Eloy... Yeah... It seems to be a problem with my hosting provider... At least I think so... What do you think about it, based on my previous post?
Average of ratings: -
In reply to Williams Castillo

Re: Error finding or creating section structures for this course!

by Eloy Lafuente (stronk7) -
Picture of Core developers Picture of Documentation writers Picture of Moodle HQ Picture of Particularly helpful Moodlers Picture of Peer reviewers Picture of Plugin developers Picture of Testers
I don't know if this can help you. It's about "repairing" corrupted tables (with error 145):

http://forums.alwayswebhosting.com/archive/topic/1564.html

Ciao. smile

Note: Ohh, this discussion is like a real chat, 6 messages in 5 minutes !! wink
Average of ratings: -
In reply to Eloy Lafuente (stronk7)

Re: Error finding or creating section structures for this course!

by Williams Castillo -

Checking out.

Thanks for the tip! I'll let you know if this story has a happy end.. smile

You're right, this is a chat... I think I'm suffering my first Moodle-ache... smile

Average of ratings: -
In reply to Eloy Lafuente (stronk7)

Re: Error finding or creating section structures for this course!

by Williams Castillo -

Oh man! You are a genius!!! Thank you very very much!

From now and on, I declare myself an Eloy fan! jejeje

Serious... Thank you very much.. The problem is solved...

Kindest greetings from Venezuela,

Will

Average of ratings: -
In reply to Williams Castillo

Re: Error finding or creating section structures for this course!

by Eloy Lafuente (stronk7) -
Picture of Core developers Picture of Documentation writers Picture of Moodle HQ Picture of Particularly helpful Moodlers Picture of Peer reviewers Picture of Plugin developers Picture of Testers
Google did the hard work !!

Finally one comment (recommendation).

Backup your files and backup your database at regular intervals !!
End of chat. Going to bed.....smile wink smile
Average of ratings: -
In reply to Williams Castillo

Re: Error finding or creating section structures for this course!

by Williams Castillo -

Yes... It is a problem with my hosting provider.. although I don't know if it was caused because of Moodle.

Even the phpMyAdmin does not show the cell where the number of records should be ¿the table is a little messed up).

I've forwared the problem to support...

Thanks anyway.. If you have further comments regarding the inner cause of this problem, please, let me know.

Thanks in advance,

Will

Average of ratings: -
In reply to Williams Castillo

Re: Error finding or creating section structures for this course!

by Eric Swanson -

Having the same problem using 1.21 on a shared environment.

Does the link above with a solution still work or can someone post what worked to fix the problem. Will start searching now. Argh!  lol

   mdl_course_modules    Browse  Select  Insert  Properties  Drop  Empty  48   MyISAM      4.5 KB 
   mdl_course_sections    Browse  Select  Insert  Properties  Drop  Empty  in use 
   mdl_dialogue    Browse  Select  Insert  Properties  Drop  Empty  1   MyISAM      2.0 KB  
   mdl_course_sections has in use instead of MyISAM

Can't open file: 'mdl_course_sections.MYI'. (errno: 145)

Error

SQL-query : 

SHOW KEYS FROM `mdl_course_sections`

MySQL said: 

Can't open file: 'mdl_course_sections.MYI'. (errno: 145)

Back

Average of ratings: -
In reply to Eric Swanson

Re: Error finding or creating section structures for this course!

by Eric Swanson -

Ran a REPAIR TABLE command in phpMyAdmin and all appears ok. Whew!

REPAIR TABLE mdl_course_sections 

Average of ratings: -