jDiction Forum

Please login or register.

Login with username, password and session length
Advanced search  

News:

jDiction 2.2.0 released. http://jdiction.org/downloads

Author Topic: Search error  (Read 4471 times)

Finarfin

  • Full Member
  • ***
  • Posts: 119
    • View Profile
Search error
« on: February 21, 2013, 08:17:44 pm »

index.php/es/component/search/?searchword=hello&searchphrase=all&Itemid=141

500 - JDatabaseMySQLi::query: 1064 - 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 language in ('es-ES', '*')' at line 3 SQL=SELECT path, id, home, title,jdev_menu.id AS JD_MAGIC_KEY_1 FROM jdev_menu WHERE id= AND language in ('es-ES', '*')


How can I solve it, avoid it?
Logged

Harald Leithner

  • Administrator
  • Hero Member
  • *****
  • Posts: 1668
    • View Profile
Re: Search error
« Reply #1 on: February 21, 2013, 10:08:55 pm »

does this query work without jdiction?
Logged
Joomla 3.9.x Release Lead
Vote at JED

Finarfin

  • Full Member
  • ***
  • Posts: 119
    • View Profile
Re: Search error
« Reply #2 on: February 24, 2013, 02:57:38 pm »

Good question. I solved it partially, creating a menu entry with type "search results", and assigning its ID to the search module. I´ll have to check if this problem happens without jdiction ;)
Logged