+- CodeIgniter Forums (https://forum.codeigniter.com)
+-- Forum: Using CodeIgniter (https://forum.codeigniter.com/forumdisplay.php?fid=5)
+--- Forum: General Help (https://forum.codeigniter.com/forumdisplay.php?fid=24)
+--- Thread: Active Query bug? (/showthread.php?tid=72152)
Active Query bug? - fabby - 11-12-2018
PHP Code:
Error Number: 1052
Column 'id' in field list is ambiguous
SELECT `id`, `s_cities`.`id` as `source_city_id`, `d_cities`.`id` as `destination_city_id`, `jobs_raw`.* FROM `jobs_raw` LEFT JOIN `cities` as `s_cities` ON `s_cities`.`realName`=`jobs_raw`.`source_city` LEFT JOIN `cities` as `d_cities` ON `d_cities`.`realName`=`jobs_raw`.`destination_city` WHERE `jobs_raw`.`id` = '38567'
PHP Code:
$this->db->select('s_cities.id as source_city_id, d_cities.id as destination_city_id, jobs_raw.*');
$this->db->join('cities as s_cities', 's_cities.realName=jobs_raw.source_city', 'left');
$this->db->join('cities as d_cities', 'd_cities.realName=jobs_raw.destination_city', 'left');
$this->db->where('jobs_raw.id', $id);
$this->db->get('jobs_raw')->row();
Notice the Select `id`in the first code block. Its an error that should not happen since that selection is not made in the code. Yet this error shows up. But the funny thing is here that doing this on a different codeigniter install of mine makes it work flawless. Same database, same versions. Latest 3.X
RE: Active Query bug? - Pertti - 11-13-2018
Check rest of your queries - this very well may be when you have done $this->db->select('id') somewhere else, but not executed query with $this->db->get(...);
You could try adding $this->db->reset_query() right before your $this->db->select('s_cities.id as source_city_id, d_cities.id as destination_city_id, jobs_raw.*') to make sure.
RE: Active Query bug? - php_rocs - 11-13-2018
@fabby,
I agree with Pertti. If you are still getting the error after that then you can also take your generated sql and try to run it directly in MySQL. If you get the same error then there may be something wrong with the way you constructed your query.