Forums / Setup & design / Problem for Search in Database

Problem for Search in Database

Author Message

Leandro Alves

Tuesday 06 July 2004 9:03:06 am

Hi!!!

I am having several problems with the search operator, it does't work fine!!! :(

<b>One of its:</b>
I created a new class called "Member" with the attributes Full Name(Text line), Occupation(Text line) and Picture (image) and set the roles... after I created the following members:

- Eder Silva Trevisoli
- Janaina A Padoveze
- Leandro D Alves

In my template, I have this code to search:

<div id="searchbox">
<form action={"/content/search/"|ezurl} method="get">
<input class="searchtext" type="text" size="10" name="SearchText" id="Search" value="" />
<input class="searchbutton" name="SearchButton" type="submit" value="Search" />
</form>
</div>

I haven't created a override template for search.tpl yet, I'm using the standard template.

<b>Cases:</b>

1. If I search for "Leandro" <b>or</b> "D" <b>or</b> "Alves", this return the message:
<b>Search for "One of above" returned 1 matches"</b>

2. If I search for "Eder" <b>or</b> "Silva" it <b>doesn't work</b>:
<b>No results were found when searching for "One of above"</b>

<b>But</b> If I search for "Trevisoli" it <b>work</b>:
<b>Search for "One of above" returned 1 matches"</b>

3. And with "Janaina" it doesn't work too, but with "Padoveze" it work!

<b>Other problem</b>

If I have a article's name im my database <b>with accent</b> and looking for this word <b>without accent</b>, the search return <b>ALL</b> objects of my site (All article, All forders, ALL images...)

Example:

Article's name: O que é Política?

If I search for <b>"Politica"</b> this return:

Users Anonymous User Guest accounts Administrator users Editors Administrator User Media Anonymous Users

And ALL others objects!!!

<b>What Can I do to resolve my problem?</b>
<b>Is there anything to do in my Database, in my eZ???</b>

My database is with a lot of things (articles, folders, images, files)

I performed the runcronjobs.php script but nothing happened!!! :(

Thanks a lot!
Leandro

eZ debug

Timing: Jan 19 2025 20:12:53
Script start
Timing: Jan 19 2025 20:12:53
Module start 'content'
Timing: Jan 19 2025 20:12:54
Module end 'content'
Timing: Jan 19 2025 20:12:54
Script end

Main resources:

Total runtime0.6758 sec
Peak memory usage4,096.0000 KB
Database Queries183

Timing points:

CheckpointStart (sec)Duration (sec)Memory at start (KB)Memory used (KB)
Script start 0.00000.0056 588.9688180.8359
Module start 'content' 0.00560.5542 769.8047426.1953
Module end 'content' 0.55980.1159 1,196.0000333.8203
Script end 0.6757  1,529.8203 

Time accumulators:

 Accumulator Duration (sec) Duration (%) Count Average (sec)
Ini load
Load cache0.00410.6070210.0002
Check MTime0.00160.2376210.0001
Mysql Total
Database connection0.00070.096610.0007
Mysqli_queries0.615191.01691830.0034
Looping result0.00160.23231810.0000
Template Total0.652196.520.3261
Template load0.00200.293420.0010
Template processing0.650196.206820.3251
Template load and register function0.00020.032010.0002
states
state_id_array0.00090.128710.0009
state_identifier_array0.00070.100220.0003
Override
Cache load0.00160.2324340.0000
Sytem overhead
Fetch class attribute can translate value0.00140.210320.0007
Fetch class attribute name0.00080.114010.0008
XML
Image XML parsing0.00040.061020.0002
class_abstraction
Instantiating content class attribute0.00000.000610.0000
General
dbfile0.00410.6060210.0002
String conversion0.00000.000630.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
1node/view/full.tplfull/forum_topic.tplextension/sevenx/design/simple/override/templates/full/forum_topic.tplEdit templateOverride template
1content/datatype/view/ezxmltext.tpl<No override>extension/community_design/design/suncana/templates/content/datatype/view/ezxmltext.tplEdit templateOverride template
9content/datatype/view/ezxmltags/paragraph.tpl<No override>extension/ezwebin/design/ezwebin/templates/content/datatype/view/ezxmltags/paragraph.tplEdit templateOverride template
7content/datatype/view/ezxmltags/line.tpl<No override>design/standard/templates/content/datatype/view/ezxmltags/line.tplEdit templateOverride template
1content/datatype/view/ezxmltags/literal.tpl<No override>extension/community/design/standard/templates/content/datatype/view/ezxmltags/literal.tplEdit templateOverride template
1pagelayout.tpl<No override>extension/sevenx/design/simple/templates/pagelayout.tplEdit templateOverride template
 Number of times templates used: 20
 Number of unique templates used: 6

Time used to render debug report: 0.0001 secs