Forums / Developer / Search problem in my DB

Search problem in my DB

Next topic

Author	Message
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 John Mina Note i am using : EzPublish 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
John Mina	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 same as when i set a new ezpublish 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
John Mina	Monday 16 August 2004 8:30:29 am Ole This 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): word Choose 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
Ole Morten Halvorsen	Tuesday 17 August 2004 1:15:44 am John, 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. 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
John Mina	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 :(
John Mina	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? Sincerely John Mina
Ole Morten Halvorsen	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 eZ publish. Current user must be able to read the different classes. - Check that the word is not a "stop word". The eZ publish 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? 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
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_hits You need the privilege to create temporary tables. Marco http://www.hyperroad-design.com
John Mina	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 ?