• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 745
  • Last Modified:

RokAjax Search Function

Hi

I have installed a RokAjax Search function or button on my website. However it is not working well - please see (http://a1telecomms.co.za/)

When i try search for something or try type in anything for that matter - it keeps search or spinning around as if its doing something but actually not, it has worked before in the past but i am not too sure why this is happening now.

How do i fix this issue??

TX
0
shaunwingin
Asked:
shaunwingin
  • 10
  • 9
2 Solutions
 
RobOwner (Aidellio)Commented:
0
 
RobOwner (Aidellio)Commented:
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
0
 
shaunwinginAuthor Commented:
Hi Tagit - Thanks for your feedback,i see you have identified that i have a SQL Query issue, how do i fix/resolve it??
0
Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

 
RobOwner (Aidellio)Commented:
Who handles the SQL queries? Sounds like its not you?  Could also be a database issue. You'll need to do some further digging
0
 
RobOwner (Aidellio)Commented:
I would start with what the query is and try running it on the database server via an interface such as phpMyAdmin or MySQL Workbench.  If that works then you'll need to look at the server etc etc until you can narrow it down.  At this stage it doesn't look to be anything to do with your ajax, javascript or webpage but rather the server and database.
0
 
shaunwinginAuthor Commented:
My server host has confirmed that the query & MySQL Workbench is fine - errors or error logs, so it cant be that......I have also updated RockAjax Search plugin to its latest version but still not working.
0
 
RobOwner (Aidellio)Commented:
I'm pretty sure it's your query.... this doesn't make sense:
WHERE (( LIKE '%%' OR LIKE '%%' OR LIKE '%%' OR i. LIKE '%%'))
0
 
shaunwinginAuthor Commented:
Where did you find that code??
0
 
RobOwner (Aidellio)Commented:
It's in the error. I've also posted the error above
0
 
shaunwinginAuthor Commented:
My normal default Search bubble that comes with Joomla is not working as well.
0
 
RobOwner (Aidellio)Commented:
Have you recently tried to update joomla? What have you changed? These kind of errors don't happen on their own.
0
 
shaunwinginAuthor Commented:
yes. I have updated Joomla & rokAjax Search plugin. Everything is up to date - that's why i am so puzzled why it is not working.

See attached.
Screenshot-1.png
Screenshot-2.png
0
 
shaunwinginAuthor Commented:
Is there maybe an alternative bubble that i can use that you perhaps know of?
0
 
RobOwner (Aidellio)Commented:
Sorry not off the top of my head but it does look like it's not compatible with that version of joomla. Can you confirm that?
0
 
shaunwinginAuthor Commented:
LOL - how?
0
 
RobOwner (Aidellio)Commented:
What version of joomla are you running? Says rokajax is compatible with 2.5 and 3.x
Have you contacted rokajax directly on this issue?
0
 
shaunwinginAuthor Commented:
I see what you mean. I am using version 3.2.0


Does RokAjax have a support forum platform?? Can i have think to it if you have it pls??
0
 
RobOwner (Aidellio)Commented:
0
 
shaunwinginAuthor Commented:
Thanks for your help mate.
0

Featured Post

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

  • 10
  • 9
Tackle projects and never again get stuck behind a technical roadblock.
Join Now