Viewing 2 posts - 1 through 2 (of 2 total)
  • Author
    Posts
  • kdy4092 Friend
    #184112

    Hi,

    I saw that the Field Auto completion for location and category is working fine on your Demo site. However, it is not working on my website: http://allaboutjobs.com.au/demo/

    Please advise me to resolve this issue..cheers.

    David

    HeR0 Friend
    #480374

    Hi Kdy,

    Thank you for reporting.
    Please apply the following fix:

    1. Open file component/com_jajobboard/controllers/jajobalerts.php
    Find

    [PHP]$query = ‘SELECT `id`, `name` as `value` FROM #__’.$table.’ WHERE `language` IN(‘.$language.’) AND LOWER(name) LIKE ‘%’.strtolower($keyword).’%’ AND published = 1 ORDER BY `name`’ ; [/PHP]
    Replace to
    [PHP]$langCondition = ”;
    if($language){
    $langCondition = ‘ `language` IN(‘.$language.’) AND ‘;
    }
    $query = ‘SELECT `id`, `name` as `value` FROM #__’.$table.’ WHERE ‘.$langCondition.’ LOWER(name) LIKE ‘%’.strtolower($keyword).’%’ AND published = 1 ORDER BY `name`’ ; [/PHP]

    Regards

Viewing 2 posts - 1 through 2 (of 2 total)

This topic contains 2 replies, has 2 voices, and was last updated by  HeR0 11 years, 10 months ago.

We moved to new unified forum. Please post all new support queries in our New Forum