Forums / General / Searching

Searching

Author Message

Kaiko Kaur

Monday 12 May 2003 10:29:07 pm

What can be wrong if Search give no results at all. I know there is quite a lot of these words what I search for. It is no working with my templates nor with admin templates.
I use most usual Article datatype everywhere. Body is not filled and only intro is used. But Intro is marked as 'Searchable'.

So... I have no more ideas why it is not working. Have you? If you have, pleas share those with me. Thanks.

Tony Wood

Tuesday 13 May 2003 4:15:10 am

Try this
http://ez.no/developer/ez_publish_3/documentation/ez_publish_3/typical_problems_and_solutions/i_need_to_reindex_my_site_for_search
It will re-index the site as this may be the problem.

Tony Wood : twitter.com/tonywood
Vision with Technology
Experts in eZ Publish consulting & development

Power to the Editor!

Free eZ Training : http://www.VisionWT.com/training
eZ Future Podcast : http://www.VisionWT.com/eZ-Future

Tony Wood

Tuesday 13 May 2003 4:22:14 am

Just a note, I have only needed to do this a couple of times, in the normal running of eZp this is automatic..

Tony Wood : twitter.com/tonywood
Vision with Technology
Experts in eZ Publish consulting & development

Power to the Editor!

Free eZ Training : http://www.VisionWT.com/training
eZ Future Podcast : http://www.VisionWT.com/eZ-Future

Kaiko Kaur

Wednesday 14 May 2003 3:58:13 am

kaiko@hostname:~/ezpublish> php -C update/common/scripts/updatesearchindex.php
Starting object re-indexing

Fatal error: Call to a member function on a non-object in /usr/local/apache/htdocs/update/common/scripts/updatesearchindex.php on line 83
Fatal error: eZ publish did not finish it's request
The execution of eZ publish was abruptly ended.

-----
I'm quite confused! Can this be somehow my own mistake?

Tony Wood

Wednesday 14 May 2003 4:49:55 am

What version are you running?

Tony Wood : twitter.com/tonywood
Vision with Technology
Experts in eZ Publish consulting & development

Power to the Editor!

Free eZ Training : http://www.VisionWT.com/training
eZ Future Podcast : http://www.VisionWT.com/eZ-Future

Kaiko Kaur

Wednesday 14 May 2003 6:02:11 am

3.0-2
I changed my version from 3.0-1 to 3.0-2 changing just directorys (kernel, lib, sdk, etc). So, it can be my mistake even I don't belive it now.

Tony Wood

Wednesday 14 May 2003 6:23:04 am

Your on the right version... I might be a database problem... Is this database an upgrade from RC1 or RC2?

Tony Wood : twitter.com/tonywood
Vision with Technology
Experts in eZ Publish consulting & development

Power to the Editor!

Free eZ Training : http://www.VisionWT.com/training
eZ Future Podcast : http://www.VisionWT.com/eZ-Future

Tony Wood

Wednesday 14 May 2003 6:23:49 am

Try running this routine on the test install from eZ and then you can check it isn't you version of PHP or env etc.

Tony Wood : twitter.com/tonywood
Vision with Technology
Experts in eZ Publish consulting & development

Power to the Editor!

Free eZ Training : http://www.VisionWT.com/training
eZ Future Podcast : http://www.VisionWT.com/eZ-Future

Anders Jensen-Urstad

Sunday 08 June 2003 10:59:55 am

Did you solve this? I also had problems with ezsearch not returning anything at all (MySQL 4.0.12), so I turned on debug and found out that mysql access was being denied when it tried to execute a 'create temporary table' command. Running mysql_fix_privilege_tables made the problem go away.

Reiner Fischer

Tuesday 23 September 2003 4:36:40 am

Hello,

the URL http://ez.no/developer/ez_publish_3/documentation/ez_publish_3/typical_problems_and_solutions/i_need_to_reindex_my_site_for_search

does not seem to exist anymore.
Could you please help with anoter ULR?

Brian Lack

Saturday 13 March 2004 7:53:24 am

I also get mysql access denied when it tried to execute a 'create temporary table' command. Where is this mysql_fix_privilege_tables script? I can't find it. I am worried that my ISP does not allow temporary tables at all.

Bruce Morrison

Monday 15 March 2004 12:21:52 am

Hi Reiner

Try http://ez.no/ez_publish/documentation/configuration/troubleshooting/i_need_to_reindex_my_site_for_search

(A site search of "reindex search" would have found this ;)

Cheers
Bruce

My Blog: http://www.stuffandcontent.com/
Follow me on twitter: http://twitter.com/brucemorrison
Consolidated eZ Publish Feed : http://friendfeed.com/rooms/ez-publish

Bruce Morrison

Monday 15 March 2004 12:27:45 am

Hi Brian

The CREATE TEMPORARY TABLES privilege was added in MySQL 4.0.2. In version 3 series the CREATE privilege was enough to allow the for the creation of temporary tables and for search to work.

You will need to get your hosting provider to add this privilege. (This should not be a problem for them as you will already have the ability to create normal tables.)

Cheers
Bruce

My Blog: http://www.stuffandcontent.com/
Follow me on twitter: http://twitter.com/brucemorrison
Consolidated eZ Publish Feed : http://friendfeed.com/rooms/ez-publish

liu spider

Monday 15 March 2004 3:50:11 pm

yes, I asked my host provider to add these privileges to my mysql account.

http://liucougar.scim-im.org
SCIM Input Method Platform
http://scim.sf.net
SJSD Online Editor
http://sf.net/projects/sjsd

Dirk Bensel

Thursday 16 December 2004 2:25:46 am

I have had the same Problem.
I'm using Suse Linux, Confixx3, Apache2, MySQL

MySQL user priveleges are the right hint, but i wasnt able to change them, i didnt have enough knowledge in mysql commands.

My solution:
I use the root Account for the mysql database

---
ROCK ON
Dirk