FC v2.2.0 r1895 BETA sql error sorting by Translation Group

leonel.oliveira
Topic Author
Offline
Junior Member

11 years 1 month ago #46777 by leonel.oliveira

FC v2.2.0 r1895 BETA sql error sorting by Translation Group was created by leonel.oliveira

Hello,

I am using Flexicontent version 2.2.0 r1895.

When sorting flexicontent items by "Translation Group" I get the following sql error:

Code:

1054 Unknown column 'i.lang_parent_id' in 'order clause' SQL=SELECT SQL_CALC_FOUND_ROWS i.id , t.name AS type_name, rel.ordering as catsordering FROM hyt12_flexicontent_items_tmp AS i JOIN hyt12_categories AS c ON c.id = i.catid LEFT JOIN hyt12_flexicontent_cats_item_relations AS rel ON rel.itemid = i.id LEFT JOIN hyt12_flexicontent_types AS t ON t.id = i.type_id LEFT JOIN hyt12_viewlevels AS level ON level.id=i.access LEFT JOIN hyt12_categories AS cat ON i.catid=cat.id AND cat.extension='com_content' WHERE (cat.lft > '0' AND cat.rgt < '51') AND cat.extension = 'com_content' AND (rel.catid IN (26) OR c.id IN (26)) AND i.state <> -2 AND i.state <> 2 GROUP BY i.id ORDER BY i.lang_parent_id asc LIMIT 0, 20

I would appreciate any help on the matter.

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

ggppdk
Offline
Administrator

11 years 1 month ago #46779 by ggppdk

Replied by ggppdk on topic FC v2.2.0 r1895 BETA sql error sorting by Translation Group

Hello

will fix in next v2.2.0 BETA package, i ll post link here too

Regards

-- 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.