Error finding or creating section structures for this course!

Error finding or creating section structures for this course!

Williams Castillo -
Колькасьць адказаў: 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?

Сярэдняе рэйтынгаў: -
У адказ на Williams Castillo

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

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

Сярэдняе рэйтынгаў: -
У адказ на Williams Castillo

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

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.

Сярэдняе рэйтынгаў: -
У адказ на Williams Castillo

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

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... журбота

Сярэдняе рэйтынгаў: -
У адказ на Williams Castillo

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

Eloy Lafuente (stronk7) -
Выява Core developers Выява Documentation writers Выява Moodle HQ Выява Particularly helpful Moodlers Выява Peer reviewers Выява Plugin developers Выява 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.
Сярэдняе рэйтынгаў: -
У адказ на Eloy Lafuente (stronk7)

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

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?
Сярэдняе рэйтынгаў: -
У адказ на Williams Castillo

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

Eloy Lafuente (stronk7) -
Выява Core developers Выява Documentation writers Выява Moodle HQ Выява Particularly helpful Moodlers Выява Peer reviewers Выява Plugin developers Выява 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. усьмешка

Note: Ohh, this discussion is like a real chat, 6 messages in 5 minutes !! падморгваньне
Сярэдняе рэйтынгаў: -
У адказ на Eloy Lafuente (stronk7)

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

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

Сярэдняе рэйтынгаў: -
У адказ на Williams Castillo

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

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

Сярэдняе рэйтынгаў: -
У адказ на Williams Castillo

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

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

Сярэдняе рэйтынгаў: -