J!Extensions Store™
Forum
Welcome, Guest
Please Login to access forum.
Re:Auto generated SQL query gets shortened on save (1 viewing) 
Go to bottom
TOPIC: Re:Auto generated SQL query gets shortened on save
#7403
Softonium Developments
Fresh Boarder
Posts: 2
User Offline
Auto generated SQL query gets shortened on save Karma: 0  
Hello,

I added the Kunena Topics predefined data source. This creates an Auto generated SQL query of length 534 chars. When the data source is saved, only the first 360 chars are saved.
This results in the wrong query being executed and thus wrong results shown in the sitemap.

Looking forward to your reply.
 
Logged Logged  
  The administrator has disabled public write access.
#7404
John Dagelmore
Admin
Posts: 3716
User Online Now
Re:Auto generated SQL query gets shortened on save Karma: 79  
Hello,

click the red button 'Regenerate SQL query' to restore the original query.

Looks like a Joomla issue dealing with special '<' character, Joomla strips out that characters everywhere.

As a workaround you can even change the following setting from '<=' to '='

The Joomla team is working to get this issue fixed probably in Joomla 3.7.4: https://github.com/joomla/joomla-cms/pull/16875

Best regards.
 
Logged Logged  
  The administrator has disabled public write access.
#7418
Softonium Developments
Fresh Boarder
Posts: 2
User Offline
Re:Auto generated SQL query gets shortened on save Karma: 0  
OK
Thank you for clearing this for me.

For now I'm manually inserting the SQL string in the corresponding table (and row)
 
Logged Logged  
  The administrator has disabled public write access.
Go to top