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

eZ debug

Timing: Jan 18 2025 02:02:06
Script start
Timing: Jan 18 2025 02:02:06
Module start 'content'
Timing: Jan 18 2025 02:02:06
Module end 'content'
Timing: Jan 18 2025 02:02:06
Script end

Main resources:

Total runtime0.2448 sec
Peak memory usage4,096.0000 KB
Database Queries141

Timing points:

CheckpointStart (sec)Duration (sec)Memory at start (KB)Memory used (KB)
Script start 0.00000.0066 588.6406180.8594
Module start 'content' 0.00660.0053 769.5000113.7813
Module end 'content' 0.01190.2327 883.2813542.0859
Script end 0.2447  1,425.3672 

Time accumulators:

 Accumulator Duration (sec) Duration (%) Count Average (sec)
Ini load
Load cache0.00421.7133200.0002
Check MTime0.00170.6910200.0001
Mysql Total
Database connection0.00110.429810.0011
Mysqli_queries0.190677.87981410.0014
Looping result0.00150.62511390.0000
Template Total0.232394.910.2323
Template load0.00070.289610.0007
Template processing0.231694.615110.2316
Override
Cache load0.00050.197310.0005
Sytem overhead
Fetch class attribute can translate value0.00060.234110.0006
XML
Image XML parsing0.00040.165110.0004
General
dbfile0.00441.8163200.0002
String conversion0.00000.002130.0000
Note: percentages do not add up to 100% because some accumulators overlap

CSS/JS files loaded with "ezjscPacker" during request:

CacheTypePacklevelSourceFiles
CSS0extension/community/design/community/stylesheets/ext/jquery.autocomplete.css
extension/community_design/design/suncana/stylesheets/scrollbars.css
extension/community_design/design/suncana/stylesheets/tabs.css
extension/community_design/design/suncana/stylesheets/roadmap.css
extension/community_design/design/suncana/stylesheets/content.css
extension/community_design/design/suncana/stylesheets/star-rating.css
extension/community_design/design/suncana/stylesheets/syntax_and_custom_tags.css
extension/community_design/design/suncana/stylesheets/buttons.css
extension/community_design/design/suncana/stylesheets/tweetbox.css
extension/community_design/design/suncana/stylesheets/jquery.fancybox-1.3.4.css
extension/bcsmoothgallery/design/standard/stylesheets/magnific-popup.css
extension/sevenx/design/simple/stylesheets/star_rating.css
extension/sevenx/design/simple/stylesheets/libs/fontawesome/css/all.min.css
extension/sevenx/design/simple/stylesheets/main.v02.css
extension/sevenx/design/simple/stylesheets/main.v02.res.css
JS0extension/ezjscore/design/standard/lib/yui/3.17.2/build/yui/yui-min.js
extension/ezjscore/design/standard/javascript/jquery-3.7.0.min.js
extension/community_design/design/suncana/javascript/jquery.ui.core.min.js
extension/community_design/design/suncana/javascript/jquery.ui.widget.min.js
extension/community_design/design/suncana/javascript/jquery.easing.1.3.js
extension/community_design/design/suncana/javascript/jquery.ui.tabs.js
extension/community_design/design/suncana/javascript/jquery.hoverIntent.min.js
extension/community_design/design/suncana/javascript/jquery.popmenu.js
extension/community_design/design/suncana/javascript/jScrollPane.js
extension/community_design/design/suncana/javascript/jquery.mousewheel.js
extension/community_design/design/suncana/javascript/jquery.cycle.all.js
extension/sevenx/design/simple/javascript/jquery.scrollTo.js
extension/community_design/design/suncana/javascript/jquery.cookie.js
extension/community_design/design/suncana/javascript/ezstarrating_jquery.js
extension/community_design/design/suncana/javascript/jquery.initboxes.js
extension/community_design/design/suncana/javascript/app.js
extension/community_design/design/suncana/javascript/twitterwidget.js
extension/community_design/design/suncana/javascript/community.js
extension/community_design/design/suncana/javascript/roadmap.js
extension/community_design/design/suncana/javascript/ez.js
extension/community_design/design/suncana/javascript/ezshareevents.js
extension/sevenx/design/simple/javascript/main.js

Templates used to render the page:

UsageRequested templateTemplateTemplate loadedEditOverride
1pagelayout.tpl<No override>extension/sevenx/design/simple/templates/pagelayout.tplEdit templateOverride template
 Number of times templates used: 1
 Number of unique templates used: 1

Time used to render debug report: 0.0001 secs