Error finding or creating section structures for this course!

Error finding or creating section structures for this course!

autor Williams Castillo -
Počet odpovědí: 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?

Průměr hodnocení: -
V odpovědi na Williams Castillo

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

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

Průměr hodnocení: -
V odpovědi na Williams Castillo

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

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

Průměr hodnocení: -
V odpovědi na Williams Castillo

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

autor 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... mrzutost

Průměr hodnocení: -
V odpovědi na Williams Castillo

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

autor Eloy Lafuente (stronk7) -
Obrázek: Core developers Obrázek: Documentation writers Obrázek: Moodle HQ Obrázek: Particularly helpful Moodlers Obrázek: Peer reviewers Obrázek: Plugin developers Obrázek: 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.
Průměr hodnocení: -
V odpovědi na Eloy Lafuente (stronk7)

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

autor 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?
Průměr hodnocení: -
V odpovědi na Williams Castillo

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

autor Eloy Lafuente (stronk7) -
Obrázek: Core developers Obrázek: Documentation writers Obrázek: Moodle HQ Obrázek: Particularly helpful Moodlers Obrázek: Peer reviewers Obrázek: Plugin developers Obrázek: 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. úsměv

Note: Ohh, this discussion is like a real chat, 6 messages in 5 minutes !! mrknout
Průměr hodnocení: -
V odpovědi na Eloy Lafuente (stronk7)

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

autor Williams Castillo -

Checking out.

Thanks for the tip! I'll let you know if this story has a happy end.. úsměv

You're right, this is a chat... I think I'm suffering my first Moodle-ache... úsměv

Průměr hodnocení: -
V odpovědi na Eloy Lafuente (stronk7)

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

autor 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

Průměr hodnocení: -
V odpovědi na Williams Castillo

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

autor 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

Průměr hodnocení: -
V odpovědi na Williams Castillo

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

autor 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

Průměr hodnocení: -
V odpovědi na Eric Swanson

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

autor Eric Swanson -

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

REPAIR TABLE mdl_course_sections 

Průměr hodnocení: -