I installed and setup refine by taxonomy, i have 2 vocabs, each one is setup to be refined by the other. The block shows up offering to filter. Upon clicking no filtering is applied and an error is returned. This module did not work at all, I get errors like these:

user warning: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '35' at line 1 query: SELECT * FROM taxonomy_intro WHERE tid=103,35 in /pathtomysite/includes/database.mysql.inc on line 172.

user warning: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '35' at line 1 query: SELECT * FROM taxonomy_intro WHERE tid=108,35 in /pathtomysite/includes/database.mysql.inc on line 172.

All trouble shooting ideas welcome.

Comments

ethanre’s picture

ethanre commented
Title: SQL syntax MySQL server version Warning » nevermind
Assigned: Unassigned » ethanre
Category: bug » support
Priority: Critical » Minor
Status: Active » Closed (fixed)
ethanre’s picture

ethanre commented
Title: nevermind » SQL syntax MySQL server version Warning
Priority: Minor » Normal
Status: Closed (fixed) » Active

Sorry, issue is not closed.

Anybody else with the same 'you have an error in your SQL syntax' errors?

pfaocle’s picture

pfaocle
He/Him
Primary language English
commented
Assigned: ethanre » Unassigned
Status: Active » Postponed (maintainer needs more info)

Something to do with Taxonomy Intro, rather than this module? (I assume you taxonomy intro installed?)

pfaocle’s picture

pfaocle
He/Him
Primary language English
commented
Project: Refine by taxonomy » Taxonomy Introduction
Version: 5.x-0.1 » 5.x-1.0
Category: support » bug
Status: Postponed (maintainer needs more info) » Closed (duplicate)

Yep, looks like Taxonomy Introduction doesn't handle multiple terms passed to taxonomy listings. Marking as duplicate, please pursue a fix in that thread.

ethanre’s picture

ethanre commented

Thanks