Come together with the global Drupal community in Rotterdam, 28 Sept – 1 Oct 2026. Sessions, contribution, connection, and Early Bird savings until 8 June.this occured after enabling the CRE engine first, which worked, and then trying to enable the node recommendation module:
user warning: Unknown column 'r.tag' in 'where clause' query: SELECT d.content_id1 as 'content_id',sum(d.sum+d.count)/sum(d.count)+80 as 'score',n.title FROM cre_similarity_matrix d,node n WHERE d.content_type1='node' AND n.nid=d.content_id1 AND n.uid <> 1 AND r.tag = 'vote' AND n.created >= 1170144000 GROUP BY d.content_id1 ORDER BY score DESC in C:\apache2triad\htdocs\drupal-5.1\includes\database.mysql.inc on line 172.
query failed node_recommendation_cre_query
FWIW, I have the following modules installed: Userpoints, Frontpage, CCK, Views, Voting API & Fivestar, and Leech
I will try CRE again on a fresh install and see if it works (the lack of reported errors leads me to believe that others are not experiencing the same problem).
| Comment | File | Size | Author |
|---|---|---|---|
| #1 | node_rec.patch | 617 bytes | Scott Reynolds |
Comments
Comment #1
Scott Reynolds commentedApply this patch should work for now. Coming out with a nicer fix in a couple of days
Comment #2
nirad commentedI never was able to get that to work, but their may have been problems with the database as I had experimented with a lot of things in that installation of Drupal. CRE works fine on a fresh install.
btw, i am posting a feature request regarding CRE and categories. (It might be easy to do with the API)
Comment #3
hickory commented