getting error when i'm using join in datatable

hermawanramadhan / CodeIgniter4-DataTables

MIT License

92 stars 38 forks source link

getting error when i'm using join in datatable #14

Closed pateldrishti closed 2 years ago

pateldrishti commented 2 years ago

Getting Error : Unknown column 'tbl_`tbl_add_new_feedback.id' in 'field list

How to reproduce error : 1) I have used following join query $this->db->table('add_new_feedback')->select('add_new_feedback.id as replay_id ,title,status,roadmap.id as roadmap_id ,roadmap.value as status_name')->join('roadmap','roadmap.id = add_new_feedback.status','LEFT'); 2) For rest of the code i followed this link

3) My db settings looks like this

hermawanramadhan commented 2 years ago

please install new version 0.5.3. that's bug come when using DBPrefix, this bug gone on new version.. Thanks for reporting clearly.