CodeIgniter Forums
Active Query bug? - Printable Version

+- CodeIgniter Forums (https://forum.codeigniter.com)
+-- Forum: Using CodeIgniter (https://forum.codeigniter.com/forum-5.html)
+--- Forum: General Help (https://forum.codeigniter.com/forum-24.html)
+--- Thread: Active Query bug? (/thread-72152.html)



Active Query bug? - fabby - 11-12-2018

PHP Code:
Error Number1052

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_rawLEFT JOIN `cities` as `s_citiesON `s_cities`.`realName`=`jobs_raw`.`source_cityLEFT JOIN `cities` as `d_citiesON `d_cities`.`realName`=`jobs_raw`.`destination_cityWHERE `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.