SH404SEF wrong redirect when intentionally using a wrong url

More
10 years 2 days ago #50610 by SteP
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

_________________________________________
MMC Edizioni - www.mmcedizioni.it
Website Developer & Graphics

Please Log in or Create an account to join the conversation.

More
10 years 1 day ago #50632 by ggppdk
Hello

the problem is not in the SQL statement, this code should not be reachable if item does not exist

you send a PM with super admin login to review why this code is reachable also include an example that shows the error

the issue should be related to using SH404SEF


-- Flexicontent is Free but involves a big effort on our part.
Like the our support? (for a bug-free FC, despite having a long list of functions) Like the features? Like the ongoing development and future commitment to FLEXIcontent?
-- Add your voice to the FLEXIcontent JED listing with a 5-star...

Please Log in or Create an account to join the conversation.

More
9 years 11 months ago #50671 by SteP
I have sent you a PM including the test-site logon data: to reproduce the issue, click any link, than delete one of the letters in the url and follow it.

_________________________________________
MMC Edizioni - www.mmcedizioni.it
Website Developer & Graphics

Please Log in or Create an account to join the conversation.

More
9 years 11 months ago #50838 by SteP
Did you get time to take a look to this question? I can't find a solution...
Regards

_________________________________________
MMC Edizioni - www.mmcedizioni.it
Website Developer & Graphics

Please Log in or Create an account to join the conversation.

More
9 years 11 months ago #50839 by SteP
Just a further information: after uninstalling flexicontent the problem disappeared: any wrong url is correctly sent to the sh404SEF custom 'error 404' page.
I had to unistall your component to get the site working normally. Is there a solution to this issue?
Thank you in advance
Regards

_________________________________________
MMC Edizioni - www.mmcedizioni.it
Website Developer & Graphics

Please Log in or Create an account to join the conversation.

More
9 years 11 months ago #50842 by ggppdk
Hello

the SH404SEF component has changed, our SH404SEF plugin probably needs updating,

updating plugin involves getting latest SH404SEF and testing with it (locally), will try to update it in FLEXIcontent v2.2.2

maybe some updates will be done in FLEXIcontent v2.2.1, that should be released next week

will try to test and include a fix for this
we have open a new bug in GitHub for v2.2.1:
github.com/FLEXIcontent/flexico ... /issues/64


-- Flexicontent is Free but involves a big effort on our part.
Like the our support? (for a bug-free FC, despite having a long list of functions) Like the features? Like the ongoing development and future commitment to FLEXIcontent?
-- Add your voice to the FLEXIcontent JED listing with a 5-star...

Please Log in or Create an account to join the conversation.

Moderators: vistamediajoomlacornerggppdk
Time to create page: 0.267 seconds
Save
Cookies user preferences
We use cookies to ensure you to get the best experience on our website. If you decline the use of cookies, this website may not function as expected.
Accept all
Decline all
Essential
These cookies are needed to make the website work correctly. You can not disable them.
Display
Accept
Analytics
Tools used to analyze the data to measure the effectiveness of a website and to understand how it works.
Google Analytics
Accept
Decline