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 ?

eZ debug

Timing: Jan 20 2025 01:07:48
Script start
Timing: Jan 20 2025 01:07:48
Module start 'content'
Timing: Jan 20 2025 01:07:48
Module end 'content'
Timing: Jan 20 2025 01:07:48
Script end

Main resources:

Total runtime0.1676 sec
Peak memory usage2,048.0000 KB
Database Queries141

Timing points:

CheckpointStart (sec)Duration (sec)Memory at start (KB)Memory used (KB)
Script start 0.00000.0052 588.9453180.8438
Module start 'content' 0.00520.0057 769.7891105.8516
Module end 'content' 0.01090.1567 875.6406535.2500
Script end 0.1676  1,410.8906 

Time accumulators:

 Accumulator Duration (sec) Duration (%) Count Average (sec)
Ini load
Load cache0.00342.0224200.0002
Check MTime0.00130.7684200.0001
Mysql Total
Database connection0.00070.423510.0007
Mysqli_queries0.117069.80751410.0008
Looping result0.00160.92741390.0000
Template Total0.156393.210.1563
Template load0.00090.518410.0009
Template processing0.155492.716910.1554
Override
Cache load0.00060.350110.0006
Sytem overhead
Fetch class attribute can translate value0.00080.498710.0008
XML
Image XML parsing0.00020.130710.0002
General
dbfile0.00885.2531200.0004
String conversion0.00000.003730.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