Forum


Database Error when attempting to export "explain" column

Guest
51%
Posts: 51
  • TF Learn
May 25, 2021

I am using the "export" option from the TF Learn component to save my questions. However if I select the "explain" column I get this error:

1064 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 'explain FROM `#__tfl_questions`' at line 1

Choosing the other columns cause no problems; only attempting to export the 'explain' column generates this error.

Joomla Fry
100%
Posts: 1076
May 26, 2021

Thank you for informing about the error. "Explain" is reserved keyword in MySQL, so it is causing problems.

This error will be solved in the next update in about two days.

Login to Reply