Shaun Wingrin
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_s ummary) 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
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_s
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
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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?
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 '%%'.
fieldName LIKE '%%'
or
'somestring' LIKE '%%'
The error is that the query just has LIKE '%%'.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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
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
ASKER
Thanks!