Forums / Developer / Search problem in my DB
John Mina
Monday 16 August 2004 12:44:24 am
Hi every one hope someone can help me with it as early as possible The problem : Simply whenever i search for any work, that should be in my articles or fodlers, the search engine return "0" matches
Steps tried to solve:i used the steps written at " http://ez.no/ez_publish/documentation/development/scripting/supplied_scripts/update_search_index " to rebuild the db table for search but not working either i runned it more than 4 times i mean this script but no changes at all
I made a new installation of EZ publsih , and used the empty db and tried to search , it is ok and searching fine , so i made sure my Kernel files are fine not messed up. but the DB is having somethign Wrong.
Scream to help:Pleasssssssssssssssssssssseeeeeeeeeeeeee Help
Note i am using : Exponential 3.3-3
Sincerely
Ole Morten Halvorsen
Monday 16 August 2004 7:49:48 am
John,
Have a look at this forum thread:http://www.ez.no/community/forum/install_configuration/all_searches_return_0_results
It might solve your problem.
Ole M.
Senior Software Engineer - Vision with Technology http://www.visionwt.com http://www.omh.cc http://www.twitter.com/omh eZ Certified Developer http://ez.no/certification/verify/358441 http://ez.no/certification/verify/272578
Monday 16 August 2004 8:22:43 am
hi Ole i do appreciate your help but unfortuantly it is not the same case in here here is my reply there " m y problem at : http://ez.no/community/forum/developer/search_problem_in_my_db/#msg65430 a bit similar but not the sameas when i set a new Exponential instalation to use the same DB , it is not having any problems.
I wonder what is the problem :( any help please "
please let me knwo if you have more ? iam reall ydesprate adn had a lot of work done to enter and organise 500 article in my website
Monday 16 August 2004 8:30:29 am
OleThis is the only Error i found in the debug
Error: eZTemplate @ design/news/override/templates/search.tpl:65[0] Aug 16 2004 18:31:57 No such attribute for array(1): wordChoose one of following: word
Else are warnings and Notices
What does this debug says to me , i don't really understand ?can you please help
Tuesday 17 August 2004 1:15:44 am
Make sure it is not a permission problem by trying to search logged in as the admin user.
If you have made your own article class or modified the default one make sure the "Searchable" checkbox is check in the class.
Tuesday 17 August 2004 7:43:12 am
Ole,I am , Unfortunatly, not able to search even under the admin user
:( Serious sad in here Also all , if not at least the articles classes havign the searchable fields turned to ON:(
Thursday 19 August 2004 3:12:50 am
Hi Ole How are you? PLease do you have any idea abotu what is wrong with my DB , or hgow to solve it? SincerelyJohn Mina
Thursday 19 August 2004 4:17:14 am
Hi John,
Sorry for the late reply.
A small list of things you should check: - Check for MySQL permissions (must be able to create temporary tables) - Check for user permissions in Exponential. Current user must be able to read the different classes. - Check that the word is not a "stop word". The Exponential search enigne don't display result if there is too many matches. If you try to search on "php" on ez.no you would get way to many results so the search will return nothing. - Check that the word you are searching for is actually in the search table.- Make sure the class is index by checking the "Searchable" checkbox in class edit.
If you have checked everything in that list I'm out of ideas. Maybe someone in the community have experienced the same problem and might help?
Marco Zinn
Saturday 28 August 2004 9:55:05 am
John, are you running MySQL 4? If so, see my post at http://ez.no/community/forum/install_configuration/site_copied_search_does_not_find_any_hitsYou need the privilege to create temporary tables.
Marco http://www.hyperroad-design.com
Sunday 19 September 2004 3:06:09 am
Hi Mrco,
so sorry for the delay in replying back, but unfortunatly my problem is not this , because when i first install the Ez version i have the search engine works, but when i move the db tables it doesn't work i wonder why ?