Hogash Support Forums

  • SUPPORT FORUMS
  • Documentation
    • Kallyas WordPress Theme
    • Vauss Template HTML
    • Kallyas Template HTML
  • Register

The Support Forums have now moved to MyHogash Customer Dashboard.

We're shutting down this support forums in favor of our newly launched Hogash Studio Customer Dashboard, where you can manage your purchases, activate your Kallyas copy, get updates and announcements.

To create a new support ticket, please head over to the Customer Dashboard - Support Tickets.

If you already created new support topics in the last few days, they will be solved here, however we're restricting creating new topics.

Search on forums

SQL error 1064 when using the Search bar, please help

Forum ⁄ Forums ⁄ Joomla ⁄ Ekho Template for Joomla ⁄ SQL error 1064 when using the Search bar, please help

Forum › Forums › Joomla › Ekho Template for Joomla › SQL error 1064 when using the Search bar, please help

This topic is: resolved
Viewing 5 posts - 1 through 5 (of 5 total)
  • Author
    Posts
  • October 4, 2015 at 4:36 pm #213867
    preones
    Participant
    Post count: 27

    Hello Hogash technical support team,

    Could please someone help me to fix the SQL error 1064 that it’s shown when using the Search bar from my website. My clients and I are unable to use it.

    STR:
    1. Go to website: http://sanabox.co/index.php/fi/
    2. Click on the search bar -> type any word, e.g. Price
    3. Press the search button

    Current results: The below SQL error is shown:
    You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘AND published=1’ at line 1 SQL=SELECT id FROM lmki4_k2_tags WHERE LOWER(name) LIKE AND published=1

    NOTE: The search bar has the tagHAKU…

    If it’s needed I can provide my account details to Hogash’s technical support team.

    Thank you for any help you can provide.

    thanks,
    José

    October 5, 2015 at 12:08 am #213874
    Ionut
    Participant
    Post count: 3702

    Hello,
    This is not an issue from our theme. Is an issue from joomla plugin (maybe) . From your error i thing is from K2 tag.

    try to modify HAKU in haku.

    October 5, 2015 at 6:33 am #213879
    preones
    Participant
    Post count: 27

    Hello Lonut,

    I tried removing the box text of the search bar but that didn’t work.

    In addition, I have noticed that the error is happening when searching words with 3 or more characters, as a matters of facts the error is not shown when I search a word or 1 or 2 characters, e.g. “Pr”.

    I have tried to fix this error but all my attempts have been unsuccessful.

    Could you please help me Lonut, I would really appreciate your help.

    Thanks,
    José

    October 5, 2015 at 6:54 am #213880
    preones
    Participant
    Post count: 27

    Hello Ionut,

    You were right, the problem is not in the template, the problem is with the plugin: K2.

    I have found the solution to issue in this forum: http://www.joomlaworks.net/forum/k2-en/39005-mysql-error-on-use-joomla-search-module#135949. After following Lefteris’s steps my problem was resolved.

    Thanks for all the help.

    thanks,
    José

    October 5, 2015 at 10:57 am #213937
    Ionut
    Participant
    Post count: 3702

    With welcome.

  • Author
    Posts
Viewing 5 posts - 1 through 5 (of 5 total)

Ticket is closed.

SUPPORT SCHEDULE

Online on Weekdays,
From Monday to Friday,
8AM - 6PM ( GMT 00:00 ) [convert time]

Offline in Weekends.

LOG IN

Lost Password

OUR THEMES & TEMPLATES

© Copyright 2010 - 2016 hogash.com