jDiction Forum

English => Install & Configure jDiction => Topic started by: Finarfin on February 21, 2013, 08:17:44 pm

Title: Search error
Post by: Finarfin 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?

Title: Re: Search error
Post by: Harald Leithner on February 21, 2013, 10:08:55 pm

does this query work without jdiction?

Title: Re: Search error
Post by: Finarfin 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 ;)