FLEXIcontent 2.3 + mod_flexicontent error

iamrobert
Topic Author
Offline
Platinum Member

10 years 6 months ago #51686 by iamrobert

FLEXIcontent 2.3 + mod_flexicontent error was created by iamrobert

Hi,

I have just downloaded 2.3 and am getting the following error.

Also - the pretty checkable doesn't seem to work - until after I save.

Code:

1054 - Unknown column 'rel.id' in 'order clause' SQL=SELECT  i.id  FROM xxx_flexicontent_items_tmp AS i JOIN xxx_flexicontent_items_ext AS ie on ie.item_id = i.id JOIN xxx_flexicontent_types AS ty on ie.type_id = ty.id JOIN xxx_flexicontent_cats_item_relations AS rel ON rel.itemid = i.id JOIN xxx_categories AS  c ON  c.id = rel.catid JOIN xxx_categories AS mc ON mc.id = i.catid WHERE c.published = 1 AND ( i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2014-12-22 11:40:33' ) AND ( i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2014-12-22 11:40:33' ) AND ty.access IN (0,1,1,5) AND mc.access IN (0,1,1,5) AND  i.access IN (0,1,1,5) AND i.id <> 16 AND i.state IN ( 1, -5 ) AND c.id IN (20)  GROUP BY i.id ORDER BY rel.catid, rel.ordering ASC, rel.id DESC , i.title ASC LIMIT 0, 20

Any ideas?

Thanks,

Robert

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

iamrobert
Topic Author
Offline
Platinum Member

10 years 6 months ago #51687 by iamrobert

Replied by iamrobert on topic FLEXIcontent 2.3 + mod_flexicontent error

OK - I downgraded to the 2.2.x branch and still got the same issue.

If I change the ordering from "Ordering in current category" to something else the problem resolves.

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

ggppdk
Offline
Administrator

10 years 6 months ago #51690 by ggppdk

Replied by ggppdk on topic FLEXIcontent 2.3 + mod_flexicontent error

Hello

the change was made to make most recent items appear first when they have the same ordering

in
components/com_flexicontent/flexicontent.helper.php
line:

Code:

$order_col	= $rel_as.'.catid, '.$rel_as.'.ordering ASC, '.$rel_as.'.id DESC';

should be:

Code:

$order_col	= $rel_as.'.catid, '.$rel_as.'.ordering ASC, '.$i_as.'.id DESC';

will commit fix

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

iamrobert
Topic Author
Offline
Platinum Member

10 years 6 months ago #51695 by iamrobert

Replied by iamrobert on topic FLEXIcontent 2.3 + mod_flexicontent error

Thanks.

Also is the left column removed as well for categories/fields etc.? Just not appearing.

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

ggppdk
Offline
Administrator

10 years 6 months ago #51703 by ggppdk

Replied by ggppdk on topic FLEXIcontent 2.3 + mod_flexicontent error

Hello

you mean left column in FLEXIcontent backend

this was converted to J3 toggle column

there should be an arrow at the left,

click the arrow to slide the column open

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