Wishlist 0 ¥0.00

How to Improve Search Results Page in Joomla 3.4

Beside website navigation, especially in large websites, search option is and always was very important part. Since many years Joomla improved many aspects of its core, but only adding Smart Search was the really big step move ahead. But many users still have question: How to improve searching in Joomla or How to improve search result page. I will try to answer to those customization question in current blog post.

Things You Need to Know

It is no secret that the standard search within Joomla 3.4+ still not have best appearance, normal user cannot control all available options, in particular, if site developer wants to hide something. Different Joomla 3 Templates feature different template files. Some include a override template file, which displays the search results. But in most cases they just add some extra CSS class, but final page still looks this same. And most people (clients) ask about how to hide specific elements.

Improving a Search Results Page

 search-joomla34-default

 I think you, like me, do not need all those searching filters. Let's hide some of them in Joomla 3.4. To create your own custom Search Page, based on default search component, you will need to create a Page template to include your search form and the information you want your users to see. Of course we do not suggest to edit Joomla core files, we use override system instead.

First, check if your current using template have such a folders inside: YourTemplateName\html\com_search\search  - if not, please create all of them.

Second, now you have to copy two files from \components\com_search\views\search\tmpl into new folder which you created a few second ago. I think coping even only "default_form.php"  file will help you customize result page. Inside that file you will find all filters, inluding: "Search for" and "Serach only".

search-code-in-joomla

Now you can using your basic HTML knownledge remove those parts which you do not need, whithout worries they will appear again after next Joomla 3.4+ update, it's fully safe. For my purposes I removed all those elements, also with Display Num. From the bottom section of code I left only Page counter which maybe useful, when Joomla will show more than 20 result items.

search3

Now search result is clean. But one "small" but importnat in my opinion element is missing I guess.

Highlight Search Terms

Highlight Search Terms does not come the default Joomla templates. I think that adding distinctive color for searching phrase will help users to find out in what context search term appears in the sentence on search results page. This part is very easy to do alone, all you have to do is add a extra CSS line into your template style file. In most cases those phrases wil get "hightlight" :

<span class="highlight">Joomla</span>

You can easy change font color or/and add background color or add underline, what you decide to do. Just use simple style, for example:

span.highlight {background: #9BCC56; color: #fff; padding:0 3px;}

Here is the final result:

search4

Of course use your own colors, style effects etc. I hope that quick tip helped you get a customized search result a little bit more than before.

Zero Results Found Page - How to reduce those cases

Probably your site do not have all topics and also people made mistakes in search bar. And as a result Joomla will present a prominent message indicating that nothing was found. However, there are ways to enhance even these pages with some useful information. First, if your website is fully based on English language you can use Smart Search instead of default, which better index content of site and may help improve search results or even during typing a words in search module.

Second idea, you can use search module based on Ajax Live Search, which can be used to create more user-friendly and interactive searches. When someone starts to type with the search field they will be presented with a drop-down box offering suggestions. Live search has many benefits compared to traditional searching, one of them is, of course, reducing a zero page results. On Joomla! Extension Directory you should find at least few of those modules, also free versions.

Third, you can replace the default Joomla Search Engine with something else, for example Google. The default code that Google gives you generates search results on the same page or frame. The downside to this is that if you placed the search box on your sidebar, search results would be displayed there too. Thankfully, it is very easy to display search results on a dedicated page. Also for this kind of search you will find ready modules. But remember about one fault of this method Joomla do not automatically sends notifications to Google with every new article and page update. So the Google search engines need time for index of whole content. It may take few weeks or more for search engines to revisit your site/blog and discover new content.

Four, if you site have PDF, RTF, DOC, XLS, ODT and others documents inside you can also make then search-able using addcional extension. JiFile (isapp.it) was designed to obtain an integrated tool in Joomla 3.x that allows the indexing of textual content of a document and research into them.

Search only here... 

Sometimes in result page you don't want to show all results from whole website, especially where some content should be protected/hidden from guests. In that case you can use free plugin  Improved Content Search  (offlajn.com)  which replace the default Joomla content search plugin with this extension, and you will get much more functionalities. You will be able to select the mode for category inclusion/exclusion, article inclusion/exclusion or limit for the search results.

search-index

 

Some people like Joomla search functionality, others needs improvements. If you fall into the latter group, I recommend you try one of the solutions detailed in this article, making for our clients easier to find the information presented on your web page.

1052 - Column 'title' in where clause is ambiguous

Hello world:) i need help.....
1052 - Column 'title' in where clause is ambiguous
when I use the search component, this message appears.
until two months ago it worked fine
Can someone help me?
thanks
t.Mariateresa
 
User avatar
garkell
Joomla! Apprentice
Joomla! Apprentice
Posts: 41
Joined: Mon Aug 31, 2009 9:32 pm
Location: Australia
Contact:

Re: 1052 - Column 'title' in where clause is ambiguous

Post by garkell » Mon Sep 11, 2017 1:01 am

Hi toybel,
This is because the where clause in the SQL statement is using a field called "title" and the complete SQL statement has more than one field with that name.
I'm guessing you are using a component/module/plugin with a search function?
What is it? You will probably need to go back to the author of the product being used. Cheers.
Glenn
 
toybel
Joomla! Apprentice
Joomla! Apprentice
Posts: 14
Joined: Tue Mar 13, 2007 9:50 am

Re: 1052 - Column 'title' in where clause is ambiguous

Post by toybel » Mon Sep 11, 2017 9:49 am

thanks for answer:)))
the extension rialto cause conflict with joomla component search

IPv6简介

IPv6作为下一代互联网的网络层协议,用它来取代IPv4主要是为了解决IPv4地址枯竭问题,同时它也在其他方面对于IPv4有许多改进。

现今的互联网络发展蓬勃,截至2018年1月,全球上网人数已达40.21亿,IPv4仅能提供约42.9亿个IP位置。虽然当前的网络地址转换及无类别域间路由等技术可延缓网络位置匮乏之现象,但为求解决根本问题,从1990年开始,互联网工程工作小组开始规划IPv4的下一代协议,并于1996年8月10日成为IETF的草案标准,最终IPv6在1998年12月由互联网工程工作小组以互联网标准规范(RFC 2460)的方式正式公布。

IPv6的计划是创建未来互联网扩展的基础,IPv6具有比IPv4大得多的编码地址空间。这是因为RFC 2373和RFC 2374定义的IPv6采用128位的二进制地址,而IPv4使用的是32位二进制。因此新增的地址空间支持2128(约3.4×1038)个地址,具体数量为340,282,366,920,938,463,463,374,607,431,768,211,456个,也可以说成1632个,因为32位地址每位可以取16个不同的值。

以地球人口70亿人计算,每人平均可分得约4.86×1028(486117667×1020)个IPv6地址。

IPv6地址的表达形式一般采用32个十六进制数。例如:2001:0db8:85a3:08d3:1319:8a2e:0370:7344是一个全局唯一的IPv6地址

Minifrontpage error: 0 - The image file does not exist.

I installed the module.
It all worked good, but on every article there was a default image.

So I added some pictures in my news-articles.
Although, the thumbnails stayed the same.
I tried to remove the default images with FTP from the folder /images/thumbnails/mod_minifrontpage

This resulted in the error that I have a fully blank page, only with the error "0 - The image file does not exist."
I have to disable the module, to see my website again.

Uninstalling and re-installing still gives me the same error

greetings
Seppe
 
 
Resolved

Accepted Answer

  •  
    Replied by admin on Monday, April 13 2020, 03:53 PM
    I think I found the reason of the error. It looks like the module doesn't work properly with image that contains spacing in its file name. It happens when you add the image directly using the wysiwyg editor, but it works properly when you use Intro image or Full Article Image to add image to the article.
    I'll try to fix it, but temporarily, if you want to to add image directly from editor, please remove spacing in the your image filename first.

     
     
    Please post rating at the Joomla! Extensions Directory - http://extensions.joomla.org/profile/profile/details/264
 
 
31 responses Add Yours

                               

  •  
     
    Replied by admin on Monday, April 13 2020, 01:54 PM · Hide· #1
    Could you let me know the URL of your site so I can take a look?
     
     
    Please post rating at the Joomla! Extensions Directory - http://extensions.joomla.org/profile/profile/details/264
  •  
     
    Replied by seppe155 on Monday, April 13 2020, 02:01 PM · Hide· #2
    I have created a superuser account for you
     
     
  •  
     
    Replied by admin on Monday, April 13 2020, 02:02 PM · Hide· #3
    Can you point me to the page where you publish the module?
     
     
    Please post rating at the Joomla! Extensions Directory - http://extensions.joomla.org/profile/profile/details/264
  •  
     
    Replied by seppe155 on Monday, April 13 2020, 02:17 PM · Hide· #4
    the forntpage. it should be above the yellow banner

    but when "published" the whole site is gone
     
     
  •  
     
    Replied by seppe155 on Monday, April 13 2020, 02:20 PM · Hide· #5
    Everything worked in the beginning.
    But I did the stupid thing to remove the thumbnails, hoping I could use my own
    since then, it crashes
     
     
  •  
     
    Replied by admin on Monday, April 13 2020, 02:23 PM · Hide· #6
    Ah I see. Can you check this folder manually (using ftp) :
    1
    /images/thumbnails/mod_minifrontpage
    if it doesn't exist, try to create it manually
     
     
    Please post rating at the Joomla! Extensions Directory - http://extensions.joomla.org/profile/profile/details/264
  •  
     
    Replied by seppe155 on Monday, April 13 2020, 02:25 PM · Hide· #7
    the folder exists
    already from the beginning of the installation. (see my opening post)

    I removed all the .jpg's inside of it.
    then it went wrong
     
     
  •  
     
    Replied by admin on Monday, April 13 2020, 02:30 PM · Hide· #8
    Hmm strange. Is it possible for you to provide a temporary ftp access ?
     
     
    Please post rating at the Joomla! Extensions Directory - http://extensions.joomla.org/profile/profile/details/264
  •  
     
    Replied by seppe155 on Monday, April 13 2020, 02:31 PM · Hide· #9
    yes, I will create in a second

    yes, it's very strange.
    It worked with the default installation
    but even uninstalling and re-installing to have the default again doesn't work
     
     
  •  
     
    Replied by seppe155 on Monday, April 13 2020, 02:38 PM · Hide· #10
    did you receive the FTP details?
     
     
  •  
     
    Replied by admin on Monday, April 13 2020, 02:44 PM · Hide· #11
    No, how did you add it? Simply add it using the Your site details tab below
     
     
    Please post rating at the Joomla! Extensions Directory - http://extensions.joomla.org/profile/profile/details/264
  •  
     
    Replied by seppe155 on Monday, April 13 2020, 02:45 PM · Hide· #12
    yes, I did that
    like I sended all the super-user details
     
     
  •  
     
    Replied by seppe155 on Monday, April 13 2020, 02:46 PM · Hide· #13
    here it is again for the FTP
     
     
  •  
     
    Replied by seppe155 on Monday, April 13 2020, 02:58 PM · Hide· #14
    When you enable the module, I now get:
    * plenty errors on my screen
    * in the admin-panel the text is resized
    * the textboxes are a lot smaller

    more and more modules and plugins are giving errors

    so I guess the best thing is to uninstall everything :)
     
     
  •  
     
    Replied by seppe155 on Monday, April 13 2020, 03:01 PM · Hide· #15
    aha

    there he is again :)
     
     
  •  
     
    Replied by admin on Monday, April 13 2020, 03:06 PM · Hide· #16
    When you enable the module, I now get:
    * plenty errors on my screen
    * in the admin-panel the text is resized
    * the textboxes are a lot smaller

    more and more modules and plugins are giving errors

    so I guess the best thing is to uninstall everything :)

    It because I changed the Error Reporting in the Global Configuration to Development level, to see the actual error message and you have some notice and deprecated message with plugins you have installed (bye bye generator and google analytics). I have switched it back the Error reporting to System Default to hide the notice messages.

    I have deleted the folder /images/thumbnails/mod_minifrontpage manually using ftp, then reinstalling the module. It looks like the module run properly now. Please have a look
     
     
    Please post rating at the Joomla! Extensions Directory - http://extensions.joomla.org/profile/profile/details/264
  •  
     
    Replied by seppe155 on Monday, April 13 2020, 03:08 PM · Hide· #17
    It worked for a second
    It had the default settings. I had 5 news-blocks.

    I changed it like I had it in the beginning, and there is the error again.....
     
     
  •  
     
    Replied by seppe155 on Monday, April 13 2020, 03:10 PM · Hide· #18
    when you change the "number of articles to show" from 5 to for example 12

    I want a grid of 4 x 3
    then it crashes again

    which he didn't do in the beginning
     
     
  •  
     
    Replied by seppe155 on Monday, April 13 2020, 03:13 PM · Hide· #19
    9 is now the maxium number of articles I can show
    I tried through FTP to add 12 thumbnails in total, but that doesn't work

    10 articles to show or above makes the plugin crash
     
     
  •  
     
    Replied by admin on Monday, April 13 2020, 03:17 PM · Hide· #20
    I think there's something wrong with the 12th articles. When I set the category to Nieuws Algement with article = 12, it show 1 item and didn't returned an error. Can you check what is the 12th articles and also can you try to add more articles?
     
     
    Please post rating at the Joomla! Extensions Directory - http://extensions.joomla.org/profile/profile/details/264
  •  
     
    Replied by seppe155 on Monday, April 13 2020, 03:20 PM · Hide· #21
    there are 12 articles to create the grid
    there are 3 different categories

    I added them all to the module

    the module is completly set now

    Only the number of articles to show is 10.
    If you change it to 12, you get the error
     
     
  •  
     
    Replied by admin on Monday, April 13 2020, 03:29 PM · Hide· #22
    It because of this article : 10-04-2020: nieuws-item 1
    I tried to unpublish the article and everything goes fine.
     
     
    Please post rating at the Joomla! Extensions Directory - http://extensions.joomla.org/profile/profile/details/264
  •  
     
    Replied by seppe155 on Monday, April 13 2020, 03:42 PM · Hide· #23
    Ok. I created a new article
    Now it seems to work again.

    For security, I will take a backup of the website :)

    thank you very much for the quick support
    I'm searching now how and where to change the defaul image to an image of the article
     
     
  •  
     
    Replied by seppe155 on Monday, April 13 2020, 05:20 PM · Hide· #24
    ok. thank you very much
    I will make sure I will rename all images

    Lets see what an "_" (underscore) does, instead of an image.
    I will search for the right solution

    thank you
     
     
  •  
     
    Replied by seppe155 on Tuesday, April 14 2020, 02:40 PM · Hide· #25
    Good afternoon

    We are back to the crash, after following your directions in the topic:
    https://www.templateplazza.com/forum/minifrontpage-not-generating-thumbnail
     
     
  •  
     
    Replied by seppe155 on Tuesday, April 14 2020, 02:44 PM · Hide· #26
    It has something to do with multiple categories
    because I use it on another another menu-item, with only 1 categorie, then it works

    But i found the categorie that is making trouble
    So I will search again, and keep you informed
     
     
  •  
     
    Replied by seppe155 on Tuesday, April 14 2020, 03:16 PM · Hide· #27
    there is 1 categorie that always causes the problem.
    I have no idea why.
    I will create a new category and new articles, and see what happens

    keep you informed!
     
     
  •  
     
    Replied by seppe155 on Tuesday, April 14 2020, 04:34 PM · Hide· #28
    update:

    I deleted the categorie
    I deleted all the articles concerning this categorie

    Created everything again from scratch, now it works
     
     
  •  
     
    Replied by admin on Tuesday, April 14 2020, 11:22 PM · Hide· #29
    Ok thank you for the confirmation. Please update me if crash happens again
     
     
    Please post rating at the Joomla! Extensions Directory - http://extensions.joomla.org/profile/profile/details/264
  •  
     
    Replied by mrvargo on Wednesday, April 22 2020, 12:14 PM · Hide· #30
    Hi. I have the exact same error - I have deleted the thumbnail directory and re-installed MFP but it still crashes the page.

    I don't create the articles but there are a large number of old images with spaces in the filenames which also caused problems with the old Latest News+ module.

    I've fixed by renaming several files but would be great to find a solution for this to prevent future errors.

    Thank you
     

About Us

Since 1996, our company has been focusing on domain name registration, web hosting, server hosting, website construction, e-commerce and other Internet services, and constantly practicing the concept of "providing enterprise-level solutions and providing personalized service support". As a Dell Authorized Solution Provider, we also provide hardware product solutions associated with the company's services.
 

Contact Us

Address: No. 2, Jingwu Road, Zhengzhou City, Henan Province

Phone: 0086-371-63520088 

QQ:76257322

Website: 800188.com

E-mail: This email address is being protected from spambots. You need JavaScript enabled to view it.