Forum

At the moment, for evaluation, we are using the Free Version.

As we add Questions to courses, we get the Error 1064 with following Message: YOU HAVE AN ERROR IN YOUR SQL SYNTAX; CHECK THE MANUAL THAT CORRESPONDS TO YOUR MARIADB SERVER VERSION FOR THE RIGHT SYNTAX TO USE NEAR ''' ORDER BY RAND() LIMIT 1' AT LINE 3

Any suggestions?

Thanks,

Chris

Hello

Thank you for informing the issue. We need some more details to resolve this.

Where this error is coming? frontend or backend? And what is type of question?

Please enable debug mode from the global configuration It will provide specific location from where the error is coming.

Thank you

Hi,

In Course overview, after clicking the button which directs you to the questions/quiz, we get the error message.

debug mode is activated but no information on error site 

sorry: error is coming in frontend

Unfortunately, we are not able to reproduce this error at our end.

Please provide login credentials to mail@techfry.com, so that we can investigate the issue further.

Thank you

same here!

i changed the line 162 in the "/components/com_tflearn/src/Model/TestModel.php"

$conditions = array('lesson_id', 'lesson_id IN (' .  implode(',', $lesson_ids) . ')');

BTW.. i also had to change the line 19 in the "default_lesson.php" (different error)

$incomplete_icon = $this->cparams->get('path_incomplete_icon', 'fa-regular fa-square');

Greetings, Jens

thank, Jens! Will check it right now

halleluja! jens, your changes fixed it! Thanks for your help!

what kind of error fiexed you second line of code?

bugs over bugs :-/

1. checking your score will result in error 500: LAYOUT „DEFAULT_QUESTION_TYPE“ NICHT GEFUNDEN.

2. correct answer give feedback: Correct Attemps: 1 / Score: 100 / Precentage: 50% <-- why 50% ?

3. After completing you'll be redirected to cours overview, not you path.

Point 2. Was missconfiguration. solved it

Hey Chris... deine anderen Fehler tauchen bei mir nicht auf. Die zweite Zeile in meinem Post fügt eine (bei mir) fehlende Klammer hinzu die zu einem Fehler geführt hat. 

@TechFry will you fix this in next Updates? 

Yes, all these issues will be fixed in the next update.

Nice. Thank you for the good work. 

Is it possible to be moved to a different page after successfully passing a quiz than after failing? Currently i do this with another lesson with restricted access. But that seems a bit complicated.