Forum


Leaving Content ID field blank causes SQL syntax error

brett vac
89%
Posts: 89
TF Learn
February 02, 2023

Hi, There is a minor bug in TF Learn. I noticed that under the content tab in Edit: Lessons the Content ID field now refers to Article ID and not pages. I have been setting this to 0 because I only want to display pages for content, not article ID However if I don't set the Article ID to 0 and instead leave it blank, I get a "Requested Page Cannot be Found" error when I try to view the lesson on the front end. As well as the following 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 'AND `state` = '1' LIMIT 1' at line 3

Joomla Fry
100%
Posts: 959
February 03, 2023

The pages can now directly linked to lessons while editing pages. Content ID refers to Joomla articles.

If you only want to display pages, you can delete all the sub form fields under the content tab (while editing the lesson). There is no need to leave blank or set 0.

brett vac
89%
Posts: 89
February 04, 2023

Got it. Thanks.

Login to Reply