After enabling Relevance module I'm geting error
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 ' (IF(td.vid = 124, , (IF(td.vid = 87, , (IF(td.vid = 88, , (IF(td.vid = 89, , (I' at line 1 query: SELECT n.nid, n.title, (count(*) * (IF(td.vid = 1, 8, (IF(td.vid = 3, 9, (IF(td.vid = 86, , (IF(td.vid = 124, , (IF(td.vid = 87, , (IF(td.vid = 88, , (IF(td.vid = 89, , (IF(td.vid = 90, , (IF(td.vid = 91, , (IF(td.vid = 92, , (IF(td.vid = 93, , (IF(td.vid = 125, , (IF(td.vid = 94, , (IF(td.vid = 95, , (IF(td.vid = 96, , (IF(td.vid = 97, , (IF(td.vid = 98, , (IF(td.vid = 99, , (IF(td.vid = 100, , (IF(td.vid = 101, , (IF(td.vid = 102, , (IF(td.vid = 103, , (IF(td.vid = 126, , (IF(td.vid = 104, , (IF(td.vid = 105, , (IF(td.vid = 106, , (IF(td.vid = 107, , (IF(td.vid = 108, , (IF(td.vid = 109, , (IF(td.vid = 127, , (IF(td.vid = 110, , (IF(td.vid = 111, , (IF(td.vid = 112, , (IF(td.vid = 113, , (IF(td.vid = 114, , (IF(td.vid = 115, , (IF(td.vid = 116, , (IF(td.vid = 117, , (IF(td.vid = 118, , (IF(td.vid = 119, , (IF(td.vid = 120, , (IF(td.vid = 121, , (IF(td.vid = 122, , (IF(td.vid = 123, , 10)))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))) * (IF(n.created BETWEEN 1238424603 AND 1238424603, 4, (IF(n.created BETWEEN 1238424603 AND 1238424603, 2, 1))))) AS relevance FROM node n, term_node tn, term_data td WHERE n.nid <> 253 AND td.tid = tn.tid AND tn.nid = n.nid AND tn.tid in (SELECT tn.tid FROM term_node tn WHERE tn.nid = 253) AND td.vid IN (1,3,86,124,87,88,89,90,91,92,93,125,94,95,96,97,98,99,100,101,102,103,126,104,105,106,107,108,109,127,110,111,112,113,114,115,116,117,118,119,120,121,122,123,4) GROUP BY n.nid ORDER BY relevance DESC,n.nid DESC LIMIT 7 in \htdocs\sites\all\modules\relevance\relevance.module on line 199
Any suggestions ?
Comments
Comment #1
fernao commentedHi there, thanks for reporting!
I've just commited form validation on admin. I think that the reason of the error was enabling itens with invalid factor values.
I'm preparing a new release with this and another bug fixes.
Comment #2
fernao commented