Site icon Albany Pats

#1305 – FUNCTION xxx.x does not exist [closed]

I have made the example MySQL so you can see the actual problems. While I am expecting to have Jamie Foxx, Christoph Waltz in the 2 names result it gives much more. Even though it is written the exact same way as it was in the SQL example where it returns the names correctly. :/

 SELECT `company`.`id`, 
        `company`.`title` AS name, 
        `company`.`favicon`, 
        `company`.`image`, 
        `company`.`slug`, 
        `company`.`languages_site`, 
        `company`.`domain`, 
        `company`.`status`, 
        `company`.`id_relation`, 
        `company`.`active_site`, 
        `company`.`address`, 
        `company`.`number`,
        `company`.`complement`, 
        `company`.`district`, 
        `company`.`city`,
        `company`.`state`, 
        `company`.`id_country`, 
        `country`.`name` as country, 
        `company`.`phone`, 
        `company`.`email`, 
        `company`.`color_site`, 
        `company`.`size_site`, 
        `company`.`show_live`, 
        `company`.`radio_frequencia`, 
        `company`.`radio_link`, 
        `company`.`video_nome`, 
        `company`.`video_link`, 
        `company`.`mult_video`, 
        `company`.`mult_podcast`, 
        `company`.`mult_journal`, 
        `company`.`mult_magazine`, 
        `company`.`mult_document`, 
        `company`.`mult_photo`, 
        `company`.`analytics`, 
        `company`.`google_webmaster`, 
        `company`.`email_member`, 
        `company`.`email_contact`, 
        `company`.`donation_introduction`,
        `company`.`donation_text`,
        `company`.`gmt`, 
        `company`.`presence_view`, 
        `company`.`active_newsletter`, 
        `company`.`active_world`, 
        `lang`.`code` AS language_main, 
         x(lat_long) AS latitude,
         y(lat_long) AS longitude 
FROM (`ez_info` AS company) 
INNER JOIN `ez_language` AS lang ON `company`.`language_main` = `lang`.`id` 
LEFT JOIN `ez_country_description` AS country ON `country`.`id_country` = `company`.`id_country` 
and country.id_language = lang.id
WHERE `company`.`domain` = 'https://testing-server.co.in/signis/'

My Results is : #1305 – FUNCTION Si_2016.x does not exist

Exit mobile version