Not Found Any Word Error

Not Found Any Word Error

by Joseph Nemeth -
Number of replies: 5

Hopefully someone can figure this one out...

I am running 1.9.3 and I had games installed and working. However, I downloaded and installed the most current version of the module. (I was having trouble with Millionaire repeating questions multiple times in one game and thought that a new version might have corrected that issue.) Now, whenever I create a new game activity I get the 'Not Found Any Word' error when I attempt to run the game.

I have a bank of quiz questions set up and I have the game set to access those questions - in fact it's set up exactly the way it was before I downloaded the newest version....I've tried it in different courses with different questions too with the same result.

Any ideas would be greatly appreciated......


Thanks

Average of ratings: -
In reply to Joseph Nemeth

Re: Not Found Any Word Error

by Vasilis Daloukas -
Picture of Particularly helpful Moodlers Picture of Plugin developers
If you use the question as input instead of quiz the problem persist?
Try to enable the debug messages.
Average of ratings: -
In reply to Vasilis Daloukas

Re: Not Found Any Word Error

by Joseph Nemeth -

Yes, I get the same result regardless of the source of the questions.

Here is what I get with debug on:

Ambiguous column name 'id'.

SELECT mdl_question.id as id,mdl_question.id as id FROM mdl_question WHERE category=72 AND qtype='multichoice' AND mdl_question.hidden=0 ORDER BY id
  • line 686 of lib\dmllib.php: call to debugging()
  • line 966 of lib\dmllib.php: call to get_recordset_sql()
  • line 236 of mod\game\locallib.php: call to get_records_sql()
  • line 301 of mod\game\millionaire\play.php: call to game_question_selectrandom()
  • line 252 of mod\game\millionaire\play.php: call to game_millionaire_SelectQuestion()
  • line 79 of mod\game\millionaire\play.php: call to game_millionaire_ShowNextQuestion()
  • line 35 of mod\game\millionaire\play.php: call to game_millionaire_play()
  • line 117 of mod\game\attempt.php: call to game_millionaire_continue()
  • line 85 of mod\game\attempt.php: call to game_create()


Not found any word
Stack trace:
  • line 1662 of lib\deprecatedlib.php: call to debugging()
  • line 304 of mod\game\millionaire\play.php: call to error()
  • line 252 of mod\game\millionaire\play.php: call to game_millionaire_SelectQuestion()
  • line 79 of mod\game\millionaire\play.php: call to game_millionaire_ShowNextQuestion()
  • line 35 of mod\game\millionaire\play.php: call to game_millionaire_play()
  • line 117 of mod\game\attempt.php: call to game_millionaire_continue()
  • line 85 of mod\game\attempt.php: call to game_create()

Thanks for your help...

Average of ratings: -
In reply to Joseph Nemeth

Re: Re: Not Found Any Word Error

by Vasilis Daloukas -
Picture of Particularly helpful Moodlers Picture of Plugin developers
Use the attached locallib.php.
I include this fix in the module Game.
Which database do you use?
Average of ratings: Useful (1)
In reply to Vasilis Daloukas

Re: Re: Not Found Any Word Error

by Joseph Nemeth -

Thanks for the patch - that works perfectly!

We're using MS SQL 2005.

Average of ratings: -
In reply to Vasilis Daloukas

This forum post has been removed

The content of this forum post has been removed and can no longer be accessed.