conditional dropdown values error
-
The conditional fields doesn’t work for me (keeps spinning). After some debugging I found that the ajax function throws the following error :
<div id=”error”><p class=”wpdberror”>Erreur de la base de données WordPress : [You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '-type_term_relationship ON (ff_posts.ID = produit-type_term_relationship.object_' at line 6]<br />
</p></div>
SELECT COUNT( DISTINCT ff_posts.ID ) as term_count, terms.term_id as term_id, terms.name as term_name, terms.slug as term_slug, term_taxonomy.taxonomy as taxonomy
FROM ff_posts
INNER JOIN ff_term_relationships AS term_relationships
ON ff_posts.ID = term_relationships.object_id
INNER JOIN ff_term_taxonomy AS term_taxonomy USING( term_taxonomy_id )
INNER JOIN ff_terms AS terms USING( term_id ) LEFT JOIN ff_term_relationships as produit-type_term_relationship ON (ff_posts.ID = produit-type_term_relationship.object_id) LEFT JOIN ff_term_relationships as produit-marque_term_relationship ON (ff_posts.ID = produit-marque_term_relationship.object_id) WHERE ff_posts.post_type = 'produit' AND ff_posts.post_status = 'publish' AND ( produit-type_term_relationship.term_taxonomy_id IN (81) ) AND ( produit-marque_term_relationship.term_taxonomy_id IN (80) ) AND terms.term_id IN (99,61,80,81,62,100,86,63,64,97,90,89,98,69,77,79,87,85,84,67,82,91,102,94,93,96,104,101,83,65,105,74,95,103,68,92)
GROUP BY terms.term_id
HAVING term_count > 0
ORDER BY term_count DESC
LIMIT 1000
Any ideas ?
The page I need help with: [log in to see the link]
- The topic ‘conditional dropdown values error’ is closed to new replies.