1054 - Error 1054

suge1w
Topic Author
Offline
Junior Member

11 years 2 months ago #46439 by suge1w

1054 - Error 1054 was created by suge1w

Hello guys,

Everything was working perfectly and then one day I tried to search on my site using RokAjaxSearch and I receive this error:

Error: 1054 - Unknown column 'f2.value' in 'order clause' SQL=SELECT i.id, i.title AS title, i.created, i.id AS fc_item_id, ie.search_index AS text, 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, CONCAT_WS( " / ", 'Content', c.title, i.title ) AS section, c.access as category_access, ty.access as type_access, 1 AS has_access FROM lad5m_content AS i JOIN lad5m_categories AS c ON c.id = i.catid JOIN lad5m_flexicontent_items_ext AS ie ON ie.item_id = i.id JOIN lad5m_flexicontent_types AS ty ON ie.type_id = ty.id WHERE 1 AND i.state IN (1,-5) AND c.published = 1 AND ( i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= UTC_TIMESTAMP() ) AND ( i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= UTC_TIMESTAMP() ) AND ty.access IN (0,1,1) AND c.access IN (0,1,1) AND i.access IN (0,1,1) AND i.id IN ( SELECT item_id FROM lad5m_flexicontent_items_ext AS ts WHERE MATCH (ts.search_index) AGAINST ('jack*' IN BOOLEAN MODE) ) GROUP BY i.id ORDER BY i.hits DESC, CAST(f2.value AS UNSIGNED) DESC, i.title LIMIT 0, 50

What could be the problem?

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

ggppdk
Offline
Administrator

11 years 2 months ago #46441 by ggppdk

Replied by ggppdk on topic 1054 - Error 1054

Hello

if i remember, this was fixed in v2.1.3 (r1857) or in v2.2.0 BETA

which FLEXIcontent version do you have (please always mention this and also the Joomla version)

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

micker
Offline
Administrator

11 years 2 months ago #46445 by micker

Replied by micker on topic 1054 - Error 1054

remplace it by advenced search module for flexicontent
globaly same function

FLEXIcontent is Free but involves a very big effort on our part.
Like the our support? (for a bug-free FC, despite being huge extension) Like the features? Like the ongoing development and future commitment to FLEXIcontent?
-- Add your voice to the FLEXIcontent JED listing reviews. Thanks![/size]

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