Public Forums 71,145 posts

[suyogdixit Friend suyogdixitJoin date: December 2014Posts: 2Downloads:0Uploads:0]

#203486

When i create a filter module not save and move to administrator page. Please solve the problem it’s urgent

[suyogdixit Friend suyogdixitJoin date: December 2014Posts: 2Downloads:0Uploads:0]

#558572

When i create a filter module then i save but the don’t save and move to administrator page.

[Luna Garden Moderator Luna GardenJoin date: July 2011Posts: 2617Downloads:80Uploads:96 Thanks: 78 Thanked: 453 times in 425 posts]

#558849

Hi,

I have checked on your site and see that you have too much extra field. To solve this issue, please follow this thread for the solution: http://www.joomlart.com/forums/topic/jak2-extra-fields-filter-and-search-module-stopped-saving-updates-in-the-backend/#post-546287

[tasos26t Friend tasos26tJoin date: May 2013Posts: 4Downloads:2Uploads:1]

#877068

Hi All,

i have make a k2 extra field which is multi select and using it as a select drop down at the front end , while filtering data from the front end its not showing the exact result its showing the extra data also.

I have print the query and got the below query.

SELECT DISTINCT i., CASE WHEN i.modified = 0 THEN i.created ELSE i.modified END as lastChanged, c.name as categoryname,c.id as categoryid, c.alias as categoryalias, c.params as categoryparams FROM #__k2_items as i RIGHT JOIN #__k2_categories AS c ON c.id = i.catid WHERE i.published = 1 AND i.access IN(1,1,5) AND i.trash = 0 AND c.published = 1 AND c.access IN(1,1,5) AND c.trash = 0 AND c.language IN (‘en-GB’,’‘) AND i.language IN (‘en-GB’,’‘) AND ( i.publish_up = ‘0000-00-00 00:00:00’ OR i.publish_up <= ‘2016-02-05 06:52:01’ ) AND ( i.publish_down = ‘0000-00-00 00:00:00’ OR i.publish_down >= ‘2016-02-05 06:52:01’ ) AND i.catid IN (88) AND (i.extra_fields REGEXP ‘{"id":"69","value":[^{]"18"’) ORDER BY c.ordering, i.ordering

I have analyze the above query and got the fields is passing here *‘{"id":"69","value":[^{]"18"’)** , but not getting the proper result please help.

Thanks
Sujit

[Luna Garden Moderator Luna GardenJoin date: July 2011Posts: 2617Downloads:80Uploads:96 Thanks: 78 Thanked: 453 times in 425 posts]

#883093

Hi Sujit,

We need the info of your site to check the problem. Please send me the URL, admin account of your site thru private reply

[Author]

Posts