Hi,
I need some help.
Any idea how to find out what is Array.id? because I never table name as "Array".
getData:Unknown column 'Array.id' in 'field list' SQL=SELECT SQL_CALC_FOUND_ROWS DISTINCT `city`.`id` AS `city___id`, `city`.`id` AS `city___id_raw`, `city`.`date_time` AS `city___date_time`, `city`.`date_time` AS `city___date_time_raw`, `city`.`name` AS `city___name`, `city`.`name` AS `city___name_raw`, `city`.`Country` AS `city___Country_raw`, `ytc_country`.`name` AS `city___Country`, `city`.`Description` AS `city___Description`, `city`.`Description` AS `city___Description_raw`, `city`.`Province_State` AS `city___Province_State`, `city`.`Province_State` AS `city___Province_State_raw`, `city`.`Population` AS `city___Population`, `city`.`Population` AS `city___Population_raw`, `city`.`CityCode` AS `city___CityCode`, `city`.`CityCode` AS `city___CityCode_raw`, Array.`id` AS `___id`, Array.`id` AS `___id_raw`, Array.`parent_id` AS `___parent_id`, Array.`parent_id` AS `___parent_id_raw`, Array.`Photo` AS `___Photo`, Array.`Photo` AS `___Photo_raw`, Array.`caption` AS `___caption`, Array.`caption` AS `___caption_raw`, `city`.`id` AS slug , `city`.`id` AS `__pk_val` FROM `city` LEFT JOIN `ytc_country` AS `ytc_country` ON `ytc_country`.`id` = `city`.`Country` WHERE `city`.`id` IN (3,2,1) ORDER BY `city`.`name` ASC
regards
I need some help.
Any idea how to find out what is Array.id? because I never table name as "Array".
getData:Unknown column 'Array.id' in 'field list' SQL=SELECT SQL_CALC_FOUND_ROWS DISTINCT `city`.`id` AS `city___id`, `city`.`id` AS `city___id_raw`, `city`.`date_time` AS `city___date_time`, `city`.`date_time` AS `city___date_time_raw`, `city`.`name` AS `city___name`, `city`.`name` AS `city___name_raw`, `city`.`Country` AS `city___Country_raw`, `ytc_country`.`name` AS `city___Country`, `city`.`Description` AS `city___Description`, `city`.`Description` AS `city___Description_raw`, `city`.`Province_State` AS `city___Province_State`, `city`.`Province_State` AS `city___Province_State_raw`, `city`.`Population` AS `city___Population`, `city`.`Population` AS `city___Population_raw`, `city`.`CityCode` AS `city___CityCode`, `city`.`CityCode` AS `city___CityCode_raw`, Array.`id` AS `___id`, Array.`id` AS `___id_raw`, Array.`parent_id` AS `___parent_id`, Array.`parent_id` AS `___parent_id_raw`, Array.`Photo` AS `___Photo`, Array.`Photo` AS `___Photo_raw`, Array.`caption` AS `___caption`, Array.`caption` AS `___caption_raw`, `city`.`id` AS slug , `city`.`id` AS `__pk_val` FROM `city` LEFT JOIN `ytc_country` AS `ytc_country` ON `ytc_country`.`id` = `city`.`Country` WHERE `city`.`id` IN (3,2,1) ORDER BY `city`.`name` ASC
regards