Tags view SQL error

More
11 years 4 months ago #37486 by victorio404
On J 1.5, FC 2.0.3 beta2 r1686 and 2.0.2 r1680 any tag view gives this error:
Code:
getData(): SQL QUERY ERROR: Unknown column 'rel.catid' in 'order clause' SQL=SELECT i.id, i.*, ie.*, CASE WHEN CHAR_LENGTH(i.alias) THEN CONCAT_WS(':', i.id, i.alias) ELSE i.id END as slug, CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as categoryslug FROM jos_content AS i JOIN jos_flexicontent_items_ext AS ie ON ie.item_id = i.id JOIN jos_flexicontent_tags_item_relations AS tag ON tag.itemid = i.id JOIN jos_flexicontent_types AS ty ON ie.type_id = ty.id JOIN jos_categories AS c ON c.id = i.catid LEFT JOIN jos_users AS u ON u.id = i.created_by LEFT JOIN jos_flexiaccess_acl AS gt ON ty.id = gt.axo AND gt.aco = "read" AND gt.axosection = "type" LEFT JOIN jos_flexiaccess_acl AS gc ON c.id = gc.axo AND gc.aco = "read" AND gc.axosection = "category" LEFT JOIN jos_flexiaccess_acl AS gi ON i.id = gi.axo AND gi.aco = "read" AND gi.axosection = "item" WHERE tag.tid = 14 AND i.sectionid = 6 AND (gt.aro IN ( 0,1 ) OR ty.access <= 2) AND (gc.aro IN ( 0,1 ) OR c.access <= 2) AND (gi.aro IN ( 0,1 ) OR i.access <= 2) GROUP BY i.id ORDER BY rel.catid, rel.ordering ASC, i.title LIMIT 0, 20
and below: "No items tagged items were found"

Please help

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

More
11 years 4 months ago #37504 by ggppdk
Replied by ggppdk on topic Tags view SQL error
Hello,
try change ordering in menu item, or in default configuration menu item, or tags cloud settings

i will test the J1.5 version to see which ordering is causing problem


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

More
11 years 4 months ago #37573 by victorio404
Replied by victorio404 on topic Tags view SQL error
Changing the ordering in the assigned menu item to Alphabetical did solved the problem. Thanks :)

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

More
11 years 4 months ago #37578 by ggppdk
Replied by ggppdk on topic Tags view SQL error
Hello,

the ordering that caused the problem was 'ordering attribute' , right?

i have made a fix for v2.0.3 (bug exists in J2.5 version too)


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