Search module only returns news items - Version 1.0:

[brettkan]

Hi all - great app and am really enjoying building an XHTML  site with it - but just hit a snag I cant find answers for - I am using the latest (today) download Version 1.0: and cant get the search to return results other than the news (tried rebuilding etc).

Also wondering how to get rid of the name="cntnt01moduleform-1" attribute of the form  for XHTML strict? (also wouldn't mind adding some javascript to hide the "Enter Search..." when the input box is focused) ,. Where is the form built?

cheers
brett
(Apache/1.3.29 (Win32) PHP/4.3.3) (local testing server)

[brettkan]

I would really appreciate it if anyone has any ideas why the search doesn't work fully on my installation - search is essential to any site and without it i have to abandon this CMS.
Anyone have experience with other search modules in 1.0?
Loving it until now...

cheers

[Ted]

Do you have any way of looking at your database?  phpmyadmin or maybe a bit savvy around mysql?

[brettkan]

Hi Ted - sure I have a copy of phpmyadmin running on this testing server - can produce a dump if it helps (cant help how that sounds) - a little bit savvy around mysql -
point me to the table....

and thanks a ton for getting back to me

cheers
brett

[Ted]

No problem.

Check out cms_module_search_index.  Do you see anything in there that isn't related to News?  I'm just trying narrow down what part of the system it's breaking down on (indexing or displaying).

[brettkan]

No- the column module_name only refers to news - and extra_attr also stays the same as article

module_name        content_id        extra_attr        word        count
News    12    article    inspections    1
News    12    article    audits    1
News    12    article    reviews    1
News    12    article    focused    1

it looks pretty much like that all the way down

I just tried uninstalling> deleting and then coping the latest search (folder) into the module folder- and then reindexing - no joy. The search index was dropped from the database ok after uninstall and built again as above

cheers

[rogerm]

Hi,

I just put up a related post at:
http://forum.cmsmadesimple.org/index.ph ... 936.0.html .

Search feature not working properly for me either.

Heres the strange content of my "cms_module_search_index" table from phpMyAdmin. Notice that when reading down the word column, the text seems to form a sentance (!):

module_name  content_id  extra_attr  word  count
Search 15 template navigation 1
Search 16 template navigation 1
Search 17 template navigation 1
Search 17 template news 1
Search 15 content cmsms 4
Search 15 content home 4
Search 15 content congratulations 1
Search 15 content now 2
Search 15 content fully 1
Search 15 content functional 1
Search 15 content installation 3
Search 15 content cms 6
Search 15 content made 6
Search 15 content simple 6
Search 15 content almost 1
Search 15 content ready 1
Search 15 content start 1
Search 15 content building 1
Search 15 content site 5
Search 15 content first 1
Search 15 content thing 1
Search 15 content though 1
Search 15 content should 1
Search 15 content click 2
Search 15 content check 1
Search 15 content requires 1
Search 15 content database 1
Search 15 content upgrade 1
Search 15 content confirmed 1
Search 15 content date
Search 55 content america 1
Search 55 content native 1
Search 55 content american 1
Search 55 content artists 1
Search 55 content details 1
Search 55 content initiative 1
Search 55 content inc 1
Search 55 content second 1
Search 55 content avenue 1
Search 55 content tel 1
Search 55 content email 1
Search 18 template navigation 2
Search 18 template sub 1
News 1 article news 5
News 1 article module 3
News 1 article installed 3
News 1 article exciting 1
News 1 article article 2
News 1 article using 1
News 1 article summary 1
News 1 article field 1
News 1 article therefore 1
News 1 article link 1
News 1 article read 2
News 1 article can 1
News 1 article click 1
News 1 article heading 1

Roger M

[brettkan]

I tried again with a fresh install of 1.01 and got the same result - I was wondering if developing on a local windows server and dumping data from phpmyadmin to an online linux server has any baring on the problem, neither searches work , but the problem may be carried over from the data dump from windows phpmyadmin

[Piratos]

Try Reindex of all Content in Admin search  or module pisearch 1.52

[brettkan]

That may help rogerm -

but I get 890 inserts from 13 news items all including the module_name 'News' (after a clear cache and reindex search)

CREATE TABLE `cms_module_search_index` (
  `module_name` varchar(100) default NULL,
  `content_id` int(11) default NULL,
  `extra_attr` varchar(100) default NULL,
  `word` varchar(255) default NULL,
  `count` int(11) default NULL,
  KEY `module_name` (`module_name`),
  KEY `content_id` (`content_id`),
  KEY `extra_attr` (`extra_attr`),
  KEY `count` (`count`)
) TYPE=MyISAM;

--
-- Dumping data for table `cms_module_search_index`
--

INSERT INTO `cms_module_search_index` VALUES ('News', 4, 'article', 'presenting', 1);
INSERT INTO `cms_module_search_index` VALUES ('News', 4, 'article', 'award', 5);
INSERT INTO `cms_module_search_index` VALUES ('News', 4, 'article', 'top', 1);
INSERT INTO `cms_module_search_index` VALUES ('News', 4, 'article', 'celebrity', 1);

and on to line 925---

INSERT INTO `cms_module_search_index` VALUES ('News', 13, 'article', 'ever', 1);
INSERT INTO `cms_module_search_index` VALUES ('News', 13, 'article', 'photos', 1);
INSERT INTO `cms_module_search_index` VALUES ('News', 13, 'article', 'can', 1);
INSERT INTO `cms_module_search_index` VALUES ('News', 13, 'article', 'viewed', 1);
INSERT INTO `cms_module_search_index` VALUES ('News', 13, 'article', 'online', 1);
--end

Perhaps i should install pisearch and try that - ..

[calguy1000]

just something simple.... check to make sure isn't in your template or content.

[Piratos]

If you are using fckeditor you must put it in the content in the source view, because fck makes a Tag from it.

But than - you can never see this in the normal view and if you forget it . no search results (that it with pisearch too).

[brettkan]

If you are using fckeditor you must put it in the content in the source view, because fck makes a Tag from it.

But than - you can never see this in the normal view and if you forget it . no search results (that it with pisearch too).

Thanks for that - but no sign of 'NotSearchable' in the text of the sql file

[millo]

Hi

Don't know if you're still having probs with this. I've just posted something here:

http://forum.cmsmadesimple.org/index.ph ... 936.0.html

Could it be your templates are not set to utf-8 (or perhaps in your case they need to be set to something other)?

HTH