Forum


Error 1064

Chris
7%
Posts: 7
TF Learn
July 11, 2024

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

Joomla Fry
100%
Posts: 935
July 11, 2024

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

 

Chris
7%
Posts: 7
July 11, 2024

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 

Chris
7%
Posts: 7
July 11, 2024

sorry: error is coming in frontend

Joomla Fry
100%
Posts: 935
July 11, 2024

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

Jens Kretzschmar
3%
Posts: 3
July 12, 2024

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

Chris
7%
Posts: 7
July 12, 2024

thank, Jens! Will check it right now

Chris
7%
Posts: 7
July 12, 2024

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

what kind of error fiexed you second line of code?

Chris
7%
Posts: 7
July 12, 2024

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.

Chris
7%
Posts: 7
July 12, 2024

Point 2. Was missconfiguration. solved it

Jens Kretzschmar
3%
Posts: 3
July 15, 2024

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? 

Joomla Fry
100%
Posts: 935
July 15, 2024

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

Jens Kretzschmar
3%
Posts: 3
July 16, 2024

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.

Login to Reply