Error 500 when sorting items

grabit
Topic Author
Offline
Platinum Member

11 years 8 months ago #33319 by grabit

Error 500 when sorting items was created 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.

ggppdk
Offline
Administrator

11 years 8 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.