steerCMSSearch bug?

0 views
Skip to first unread message

jkowens

unread,
Feb 22, 2008, 4:31:14 PM2/22/08
to Steer CMS Users
I just installed the alpha launch package and I'm very impressed! The
only issue I'm having is that I can't search. It looks like the search
query string that is being generated is invalid. Is anyone else having
this problem?

jkowens

unread,
Feb 23, 2008, 3:18:05 PM2/23/08
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
Reply all
Reply to author
Forward
0 new messages