ModuleUniversel Erreur getItems(): Field scope,value range

More
11 years 1 month ago #40539 by Ahmed
Salut

Dans le ModuleUniversel, quand je mets la valeur "fieldid##valeur1---valeur2" dans CUSTOM_FIELD_SCOPE
J'ai l'erreur suivante :
Code:
getItems(): SQL QUERY ERROR: Unknown column 'rel17' in 'where clause' SQL=SELECT i.id FROM hojqw_content AS i JOIN hojqw_flexicontent_items_ext AS ie on ie.item_id = i.id JOIN hojqw_flexicontent_types AS ty on ie.type_id = ty.id JOIN hojqw_flexicontent_cats_item_relations AS rel ON rel.itemid = i.id JOIN hojqw_categories AS c ON c.id = rel.catid JOIN hojqw_categories AS mc ON mc.id = i.catid JOIN hojqw_flexicontent_fields_item_relations AS rel17 ON rel17.item_id=i.id AND rel17.field_id = 17 WHERE c.published = 1 AND ( i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2013-10-02 18:52:13' ) AND ( i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2013-10-02 18:52:13' ) AND ty.access IN (0,1,1,2,3) AND mc.access IN (0,1,1,2,3) AND i.access IN (0,1,1,2,3) AND i.id <> 31 AND i.state IN ( 1, -5 ) AND c.id NOT IN (21) AND (rel17 >=valeur1) AND (rel17 <=valeur2) GROUP BY i.id LIMIT 0, 20

Merci de m'aider :)

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

More
11 years 1 month ago #40547 by ggppdk
Hello

this was already reported by other user ( www.flexicontent.org/forum/index ... =viewtopic )

this is fixed in r1781

Latest FLEXIcontent package download


-- 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 1 month ago #40549 by Ahmed

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

Moderators: vistamediajoomlacornerggppdk
Time to create page: 0.367 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