getData(): SQL QUERY ERROR:

More
11 years 4 months ago #37649 by aquariumv
anyone know what i can do to fix this error? i have also attached a screenshot.

getData(): SQL QUERY ERROR:
Unknown column 'i.version' in 'having clause' SQL=SELECT SQL_CALC_FOUND_ROWS i.id , t.name AS type_name, rel.ordering as catsordering , CASE WHEN i.state IN (1,-5) THEN 0 ELSE (CASE WHEN i.state IN (0,-3,-4) THEN 1 ELSE (CASE WHEN i.state IN (2) THEN 2 ELSE (CASE WHEN i.state IN (-2) THEN 3 ELSE 4 END) END) END) END as state_order FROM ingv2_content AS i LEFT JOIN ingv2_flexicontent_versions AS fv ON i.id=fv.item_id JOIN ingv2_flexicontent_items_ext AS ie ON ie.item_id = i.id JOIN ingv2_flexicontent_cats_item_relations AS rel ON rel.itemid = i.id JOIN ingv2_flexicontent_types AS t ON t.id = ie.type_id JOIN ingv2_categories AS c ON c.id = i.catid LEFT JOIN ingv2_users AS u ON u.id = i.checked_out LEFT JOIN ingv2_viewlevels as level ON level.id=i.access LEFT JOIN ingv2_usergroups AS g ON g.id = i.access LEFT JOIN ingv2_categories AS cat ON i.catid=cat.id AND cat.extension='com_content' WHERE (cat.lft > '0' AND cat.rgt < '191') AND cat.extension = 'com_content' AND i.state IN (0,-3,-4) GROUP BY i.id HAVING i.version<>MAX(fv.version_id) ORDER BY i.catid, state_order, ie.language, i.ordering ASC, i.id ASC LIMIT 0, 20

[attachment=0:ftcqoeon]<!-- ia0 -->error.png<!-- ia0 -->[/attachment:ftcqoeon]
Attachments:

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

More
11 years 4 months ago #37651 by ggppdk
Replied by ggppdk on topic getData(): SQL QUERY ERROR:
Hello,

this error occurs when you try to view the item
'Revised :: Published, waiting for version reviewal'

items (=items that have been modified and their new document version must be approved by a user with publish privilege)

You do not mention the above by we can see it from the picture, by state filter and by the message itself

-- a fix is already implemented for upcoming v2.0.3 ... to be available in a week or less


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