Link to home
Start Free TrialLog in
Avatar of Shaun Wingrin
Shaun WingrinFlag for South Africa

asked on

Search Mulfunction on Website

Hi

I have a search function on my website & it is currently not working correctly but instead it gives me an error message (See below), what can i do to restore its functionality to work again?? I do not know whether the problem lies with my server or with Joomla applications. My website is (a1telecomms.co.za) & operating on Joomla version 3.2.1

Error: 0 - SQL=SELECT CONCAT_WS(': ', i.alias, i.issue_summary) AS title, CASE WHEN CHAR_LENGTH(i.resolution_summary) THEN CONCAT_WS(': ', i.issue_description, i.resolution_summary) ELSE i.issue_description END AS text, i.created_on AS created,p.title AS section, i.id as slug, '2' AS browsernav FROM hq74m_it_issues AS i INNER JOIN hq74m_it_projects AS p ON p.id = i.related_project_id WHERE (( LIKE '%%' OR LIKE '%%' OR LIKE '%%' OR i. LIKE '%%')) AND i.state = 1 AND i.public = 1 ORDER BY DESC LIMIT 0, 50

You may not be able to visit this page because of:

1.an out-of-date bookmark/favourite
2.a search engine that has an out-of-date listing for this site
3.a mistyped address
4.you have no access to this page
5.The requested resource was not found.
6.An error has occurred while processing your request.
¿ Home
Avatar of Carl Tawn
Carl Tawn
Flag of United Kingdom of Great Britain and Northern Ireland image

It looks like an issue with a query on the MySQL server. Do you have access to the database directly, are you able to alter the queries/procedures?
ASKER CERTIFIED SOLUTION
Avatar of snoyes_jw
snoyes_jw
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Shaun Wingrin

ASKER

Snowyes_jw: How do i set this "WHERE (( LIKE '%%' OR LIKE '%%' OR LIKE '%%' OR i. LIKE '%%'))"??

Carl_Tawn - yes i do have access to the database, what can i do on that side to make this work?
That clause is what your query already has, and it's wrong. LIKE takes two arguments. There needs to be something on the left side of each LIKE:
fieldName LIKE '%%'
or
'somestring' LIKE '%%'

The error is that the query just has LIKE '%%'.
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Try disabling the "smart search" plugin if you have  enabled it.
if that works then read this link on how to configure the smart search before you re-enable it.
as you have to run an indexer first.

http://docs.joomla.org/Smart_Search_quickstart_guide
Thanks!