Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people, just like you, are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
Solved

RokAjax Search Function

Posted on 2013-10-30
19
718 Views
Last Modified: 2013-11-12
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
Comment
Question by:shaunwingin
  • 10
  • 9
19 Comments
 
LVL 43

Assisted Solution

by:Rob
Rob earned 500 total points
ID: 39613334
0
 
LVL 43

Expert Comment

by:Rob
ID: 39613335
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
 

Author Comment

by:shaunwingin
ID: 39613689
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
Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 
LVL 43

Expert Comment

by:Rob
ID: 39615235
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
 
LVL 43

Expert Comment

by:Rob
ID: 39615986
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
 

Author Comment

by:shaunwingin
ID: 39629609
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
 
LVL 43

Expert Comment

by:Rob
ID: 39629867
I'm pretty sure it's your query.... this doesn't make sense:
WHERE (( LIKE '%%' OR LIKE '%%' OR LIKE '%%' OR i. LIKE '%%'))
0
 

Author Comment

by:shaunwingin
ID: 39630324
Where did you find that code??
0
 
LVL 43

Expert Comment

by:Rob
ID: 39631499
It's in the error. I've also posted the error above
0
 

Author Comment

by:shaunwingin
ID: 39633008
My normal default Search bubble that comes with Joomla is not working as well.
0
 
LVL 43

Expert Comment

by:Rob
ID: 39633019
Have you recently tried to update joomla? What have you changed? These kind of errors don't happen on their own.
0
 

Author Comment

by:shaunwingin
ID: 39633043
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
 

Author Comment

by:shaunwingin
ID: 39633044
Is there maybe an alternative bubble that i can use that you perhaps know of?
0
 
LVL 43

Expert Comment

by:Rob
ID: 39633073
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
 

Author Comment

by:shaunwingin
ID: 39633151
LOL - how?
0
 
LVL 43

Expert Comment

by:Rob
ID: 39633170
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
 

Author Comment

by:shaunwingin
ID: 39638081
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
 
LVL 43

Accepted Solution

by:
Rob earned 500 total points
ID: 39638347
0
 

Author Closing Comment

by:shaunwingin
ID: 39640951
Thanks for your help mate.
0

Featured Post

Networking for the Cloud Era

Join Microsoft and Riverbed for a discussion and demonstration of enhancements to SteelConnect:
-One-click orchestration and cloud connectivity in Azure environments
-Tight integration of SD-WAN and WAN optimization capabilities
-Scalability and resiliency equal to a data center

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Remove third quote mark from widget 6 28
SlickNav Menu Plugin Not appearing on mobile 6 53
Botom of page is wrong color 5 17
Changing Two Areas of a Page 5 25
This is a how to build your own CSS3 slideshow and when I say CSS3 I mean just CSS with no javascript in sight! There a few examples online of how to do this but most just show you an example without any explanation, others make it more complicat…
When writing CSS, there are a few simple rules that will make your life easier.    1. Using ‘* {box-sizing:border-box;}’. Using this will wrap all your elements in a nice little compact box-model that will give you the width you want, like so... …
In this tutorial viewers will learn how add a full-size background image to a webpage using CSS3. Create a new HTML document with an internal stylesheet.: In CSS, define the html element to have a background image. Use a high resolution image.: In t…
In this tutorial viewers will learn how to style elements, such a divs, with a "drop shadow" effect using the CSS box-shadow property Start with a normal styled element, such as a div.: In the element's style, type the box shadow property: "box-shad…

765 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question