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

Powered by eZ Publish™ CMS Open Source Web Content Management. Copyright © 1999-2014 eZ Systems AS (except where otherwise noted). All rights reserved.

eZ debug

Timing: Jan 18 2025 04:54:47
Script start
Timing: Jan 18 2025 04:54:47
Module start 'layout'
Timing: Jan 18 2025 04:54:47
Module start 'content'
Timing: Jan 18 2025 04:54:47
Module end 'content'
Timing: Jan 18 2025 04:54:47
Script end

Main resources:

Total runtime0.7723 sec
Peak memory usage4,096.0000 KB
Database Queries105

Timing points:

CheckpointStart (sec)Duration (sec)Memory at start (KB)Memory used (KB)
Script start 0.00000.0046 587.7813152.6094
Module start 'layout' 0.00460.0023 740.390639.3906
Module start 'content' 0.00690.7639 779.7813902.6094
Module end 'content' 0.77080.0014 1,682.390628.2031
Script end 0.7722  1,710.5938 

Time accumulators:

 Accumulator Duration (sec) Duration (%) Count Average (sec)
Ini load
Load cache0.00300.3833160.0002
Check MTime0.00120.1546160.0001
Mysql Total
Database connection0.00060.083810.0006
Mysqli_queries0.666886.34841050.0064
Looping result0.00120.14921030.0000
Template Total0.743596.320.3717
Template load0.00190.249920.0010
Template processing0.741596.022620.3708
Template load and register function0.00010.017810.0001
states
state_id_array0.00090.115910.0009
state_identifier_array0.00130.162820.0006
Override
Cache load0.00180.2378670.0000
Sytem overhead
Fetch class attribute can translate value0.00060.079780.0001
Fetch class attribute name0.00130.1710190.0001
XML
Image XML parsing0.00871.123380.0011
class_abstraction
Instantiating content class attribute0.00010.0073240.0000
General
dbfile0.00760.9825350.0002
String conversion0.00000.000840.0000
Note: percentages do not add up to 100% because some accumulators overlap

Templates used to render the page:

UsageRequested templateTemplateTemplate loadedEditOverride
1node/view/full.tplfull/forum_topic.tplextension/sevenx/design/simple/override/templates/full/forum_topic.tplEdit templateOverride template
15content/datatype/view/ezxmltext.tpl<No override>extension/community_design/design/suncana/templates/content/datatype/view/ezxmltext.tplEdit templateOverride template
11content/datatype/view/ezxmltags/line.tpl<No override>design/standard/templates/content/datatype/view/ezxmltags/line.tplEdit templateOverride template
21content/datatype/view/ezxmltags/paragraph.tpl<No override>extension/ezwebin/design/ezwebin/templates/content/datatype/view/ezxmltags/paragraph.tplEdit templateOverride template
9content/datatype/view/ezimage.tpl<No override>extension/sevenx/design/simple/templates/content/datatype/view/ezimage.tplEdit templateOverride template
1print_pagelayout.tpl<No override>extension/community/design/community/templates/print_pagelayout.tplEdit templateOverride template
 Number of times templates used: 58
 Number of unique templates used: 6

Time used to render debug report: 0.0001 secs