Error 500 when sorting items

More
11 years 9 months ago #33319 by grabit
HI,

I am using J1.5.26 and just upgraded FC to 1.5.6 RC9b (r1601).

After upgrade, I tried to sort (flexicontent order type) one item list in one category without subcategory.

The response is an error 500 with that message:

Unknown column 'ie.language' in 'field list' SQL=SELECT rel.itemid, rel.ordering, i.state, ie.language FROM jos_flexicontent_cats_item_relations AS rel JOIN jos_content AS i ON i.id=rel.itemid WHERE rel.ordering >= 0 AND rel.itemid = 319


This website is monolingual.

Here is a link to the front-end: www.lumiere-imaging.fr

Any suggestions, should I go back to an older version of FC?

An Apple a days keeps the doctor away

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

More
11 years 9 months ago #33338 by ggppdk
Replied by ggppdk on topic Error 500 when sorting items

Thanks for the bug report
, here is a quick fix:
-- Replace 2 occurences in administator/com_flexicontent/models/items.php
of
... 'SELECT rel.itemid, rel.ordering, i.state, ie.language'
with
Code:
... 'SELECT rel.itemid, rel.ordering, i.state' . ((FLEXI_FISH || FLEXI_J16GE) ? ' , ie.language' : '')


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