Forums / Developer / Search problem in my DB

Search problem in my DB

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 ?