text: Moodle in English: End of lesson does not link to HotPot
  End of lesson does not link to HotPot
  ◄ Could not insert record in database table
  quizport and qedoc ►
  by Larry Levenson - Wednesday, April 29, 2009, 9:55 AM
  OK, granted, I have spent too many hours in front of Moodle, but I can't get a lesson to link to a Hot Pot quiz. At the end of every lesson, the Continue button takes me to the grades, and then to the course page.
  I want the student to take a HotPot quiz at the end of each lesson. How do I enforce this?
  Re: End of lesson does not link to HotPot
  by Gordon Bateson - Wednesday, April 29, 2009, 6:16 PM
  did you you add your Hot Potatoes quiz to the Moodle course as a HotPot activity?
  If so, then I think the HotPot should appear in the list of "next" activities for the lesson. Did you see it there?
  You did all that already? OK, sorry, then could you set up a lesson and a HotPot on my server, like you have it set up on your server, so I can have a look:
  by Larry Levenson - Sunday, May 31, 2009, 10:38 PM
  I uploaded a sample Grants to You lesson as Topic 3, and set everything as it is on my server.
  When, as a student, I go through the Topic 3 lesson, I get a Display of grade.
  First of all, I don't want a grade displayed, as we are not grading this course.
  What I want is when a student completes a lesson, for him/her to automatically be taken to the HotPot Lesson Review.
  I'm sure there is SOMETHING I'm missing here. ..
  by Mary Cooch - Sunday, May 31, 2009, 11:26 PM
  When you set your Lesson up, if you set it to "practice lesson" then it doesn't appear in the gradebook and the students get no score.
  If you upload, as Gordon says, you hotpotato to the course then you get the option in the lesson set up page to "link" to that hotpotato file.
  Then when the student reaches the end of the lesson they will get a button "Go to(name of your hotpotato activity) "
  by Larry Levenson - Monday, June 1, 2009, 3:20 AM
  I used the option in the course to link to the HotPot exercise, the the link doesn't show up. And when the lesson is complete, the student is returned to the topic list.
  by Mary Cooch - Monday, June 1, 2009, 3:53 AM
  OK -well in the absence of Gordon (who by my calculations is probably asleep in Japan!) I expect it will be useful if you could make a lesson for him to have a look at. I tried to do what I think you have but I couldn't repeat your problem.
  1) upload a hotpotatoes activity to your Moodle course using Add an activity>Hotpotato quiz
  2) set up a Lesson module (set to Practice so there is no score)
  3 make your lesson including the final "end of lesson " page
  4) Update the lesson and where it says link to an activity, did you find your HotPotato quiz in there?
  5) And you saved the lesson again, tried it and on the end of lesson page you don't get the button to go to the Hotpotato quiz?
  by Gordon Bateson - Monday, June 1, 2009, 8:01 AM
  Hi Larry, Hi Mary,
  > When, as a student, I go through the Topic 3 lesson, I get a Display of grade.
  > First of all, I don't want a grade displayed, as we are not grading this course.
  You can prevent the show of grades if you disable grades on the course (Course -> Settings -> Show gradebook to students), but it seems that will force the student back to the course page once the lesson is finished, i.e. the "Next activity" feature of the Lesson module becomes ineffective.
  As Mary says, you can make the lesson a "practice" lesson. This prevents a grade being shown on the "End of Lssson". In fact, it removes the grade and the attempt data completely. Perhaps this is what you want.
  > What I want is when a student completes a lesson,
  > for him/her to automatically be taken to the HotPot Lesson Review.
  Unfortunately the Lesson module doesn't seem to work like this. If you want to use the "next activity" feature, the students must first view the "End of Lesson" page, which will have a button they can click to go to the next activity. In other words, it is not "automatic"
  However, you can do what you want to do if you use the QuizPort module. Yay!
  put the "homelessness" article into its own html file
  upload the file to Moodle
  create a new QuizPort activity
  Source file: the html file containing the article
  Show entry page: no
  Show exit page: no
  Next activity: select the HotPot
  click "Save and display" to create the QuizPort activity
  This new QuizPort activity will behave as you want: first display the article then when the students click "continue" move on automatically to the HotPot.
  Because QuizPort knows all about Hot Potatoes quizzes, you can add the HotPot quiz to the QuizPort activity too. Then you won't have the HotPot hanging around on the Course page.
  Conceptually, QuizPort can capture what you are trying to create much more elegantly than a Lesson + HotPot combination.
  by Larry Levenson - Monday, June 1, 2009, 9:05 AM
  Thanks, Gordon! I'll explore the QuizPort option and let you know what I come up with.
  by Gordon Bateson - Monday, June 1, 2009, 9:24 AM
  Oh, and by the way Larry, I forgot to say that I set up a sample QuizPort using your article
  Here is a link to the QuizPort I made:
  Homelessness - QuizPort
  by Larry Levenson - Tuesday, June 2, 2009, 12:12 AM
  When I create my first QuizPort instance, I uploaded an HTML file, added it to quizport, and then got this error message:
  Could not insert record in database table: quizport_units
  My actual table name is mdl_quizport_units. Is this the problem? Or is something else generating this error?
  by Gordon Bateson - Tuesday, June 2, 2009, 5:05 AM
  the name of the table is not the cause the error. No problem there.
  To find the cause of the error, we need to look at the raw error from the web server. You may be able to do this by switching you Moodle debugging level to "Developer" (Site Administration -> Server -> Debugging)
  Otherwise, please see if you can locate the error log for the web server. For Apache, the log is often called "error_log".
  by Larry Levenson - Tuesday, June 2, 2009, 11:22 AM
  Weird! Nothing in the error_log file that points to this problem. Changed to Developer debugging. . . when to creater a new Quizport and on saving get the same error:
  So close and yet so far! ;(
  by Gordon Bateson - Wednesday, June 3, 2009, 7:18 AM
  if we can't find the errors in the usual way, let's try some underground programming
  I am going to assume you are using a MySQL database. If you are using something else please let me know.
  open quizport/lib.php with your favorite text editor
  locate the following line (around line 325):
  if (! $unit->id = $DB->insert_record('quizport_units', $unit)) {
  insert the following line immediately after the above line:
  die('Hi Larry. The quizport_units record could not be added:<br />'.mysql_error());
  Now please try adding another QuizPort and let me know how you get on
  any joy? i.e. any progress
  by Gordon Bateson - Saturday, June 20, 2009, 4:30 PM
  I think your error is exactly the same as the one that Tom was getting.
  If so, then I'll bet my bottom dollar that if you download and install the latest QuizPort zip file, the error will disappear.