jkowens
unread,Feb 23, 2008, 3:18:05 PM2/23/08Sign in to reply to author
Sign in to forward
You do not have permission to delete messages in this group
Either email addresses are anonymous for this group or you need the view member email addresses permission to view the original message
to Steer CMS Users
More specifically, here is the sql that gets generated when I search
for the word "general". Notice how there is an missing OR between the
following conditions:
steercms_search_words.MODEL = 'steerCMSCalendarEvent'
steercms_search_words.MODEL = 'steerCMSCoreNodePublic'
SELECT DISTINCT steercms_search_words.MODEL_ID AS model_id,
steercms_search_words.MODEL AS model, COUNT(*) AS nb,
SUM(steercms_search_words.WEIGHT) AS total_weight FROM
steercms_search_words LEFT JOIN tagging ON
steercms_search_words.MODEL_ID = tagging.TAGGABLE_ID AND
steercms_search_words.MODEL = tagging.TAGGABLE_MODEL LEFT JOIN tag ON
tagging.TAG_ID = tag.ID WHERE ( steercms_search_words.CULTURE = 'en'
AND steercms_search_words.NAME = 'gener' OR tag.NAME = 'general' ) AND
( steercms_search_words.MODEL = 'steerCMSBlogPost' OR
steercms_search_words.MODEL = 'steerCMSCalendarEvent'
steercms_search_words.MODEL = 'steerCMSCoreNodePublic' ) GROUP BY
model, model_id ORDER BY total_weight DESC
I am running PHP 5.2.5 on Windows XP.
Thanks,
Jordan