Error finding or creating section structures for this course!

Error finding or creating section structures for this course!

door Williams Castillo -
Aantal antwoorden: 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?

Gemiddelde van de beoordelingen:  -
Als antwoord op Williams Castillo

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

door 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!!!

Gemiddelde van de beoordelingen:  -
Als antwoord op Williams Castillo

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

door 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.

Gemiddelde van de beoordelingen:  -
Als antwoord op Williams Castillo

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

door 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... droevig

Gemiddelde van de beoordelingen:  -
Als antwoord op Williams Castillo

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

door Eloy Lafuente (stronk7) -
Foto van Core developers Foto van Documentation writers Foto van Moodle HQ Foto van Particularly helpful Moodlers Foto van Peer reviewers Foto van Plugin developers Foto van 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.
Gemiddelde van de beoordelingen:  -
Als antwoord op Eloy Lafuente (stronk7)

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

door 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?
Gemiddelde van de beoordelingen:  -
Als antwoord op Williams Castillo

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

door Eloy Lafuente (stronk7) -
Foto van Core developers Foto van Documentation writers Foto van Moodle HQ Foto van Particularly helpful Moodlers Foto van Peer reviewers Foto van Plugin developers Foto van 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. glimlach

Note: Ohh, this discussion is like a real chat, 6 messages in 5 minutes !! knipoog
Gemiddelde van de beoordelingen:  -
Als antwoord op Eloy Lafuente (stronk7)

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

door Williams Castillo -

Checking out.

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

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

Gemiddelde van de beoordelingen:  -
Als antwoord op Eloy Lafuente (stronk7)

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

door 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

Gemiddelde van de beoordelingen:  -
Als antwoord op Williams Castillo

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

door Eloy Lafuente (stronk7) -
Foto van Core developers Foto van Documentation writers Foto van Moodle HQ Foto van Particularly helpful Moodlers Foto van Peer reviewers Foto van Plugin developers Foto van 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.....glimlach knipoog glimlach
Gemiddelde van de beoordelingen:  -
Als antwoord op Williams Castillo

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

door 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

Gemiddelde van de beoordelingen:  -
Als antwoord op Williams Castillo

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

door 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

Gemiddelde van de beoordelingen:  -
Als antwoord op Eric Swanson

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

door Eric Swanson -

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

REPAIR TABLE mdl_course_sections 

Gemiddelde van de beoordelingen:  -