I'm testing a new website, using J 3.3.6, latest stable FC and latest sh404SEF component...
All is working smoothly with website-generated urls, so apparently there are no problems when navigating the site normally (I have my urls ending with .html, and it works too)
But if I try to mispell a url, I get a strange error message...
Let's say that my website-generated (& correct) url is http://<domain-name>/content/landing-page.html
If I type it manually, but deleting one of the letters in the url before the .html extension (for example, deleting the 'l' of 'landing' and typing "http://<domain-name>/content/anding-page.html"), I get a url requesting me to authenticate to the website to see the page: after authenticating (as superuser), I get a 1064 error, saying this:
Code:
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'WHERE fi.published = 1 GROUP BY fi.id ORDER BY ftrel.ordering, fi.ordering, fi.n' at line 1 SQL=SELECT fi.*, CASE WHEN fi.access IN (0,1,1,2,3,6) THEN 1 ELSE 0 END AS has_access FROM j3iter_flexicontent_fields AS fi LEFT JOIN j3iter_flexicontent_fields_type_relations AS ftrel ON ftrel.field_id = fi.id AND ftrel.type_id = WHERE fi.published = 1 GROUP BY fi.id ORDER BY ftrel.ordering, fi.ordering, fi.name
You can note that the SELECT has an error in "...AND ftrel.type_id = WHERE...": there is NO VALUE after "ftrel.type_id = " !
What's going wrong?
Any suggestion will be appreciated
Thank you in advance