Welcome Guest, Not a member yet? Register   Sign In
dB join issue
#1

[eluser]old_guy[/eluser]
I'm calling get_custom_user_data
Code:
$select= array('uacc_status');
   $where= array('uacc_id'=>$user_id);
   $row= $this->flexi_auth->get_custom_user_data($select, $where)->row();
and getting the following error
Quote:Unknown column 'user_privileges.upriv_id' in 'field list'

SELECT `user_privileges`.`upriv_id`, `user_privileges`.`upriv_name`, `uacc_status` FROM (`user_accounts`) LEFT JOIN `user_groups` ON `user_accounts`.`uacc_group_fk` = `user_groups`.`ugrp_id` LEFT JOIN `user_profile` ON `user_accounts`.`uacc_id` = `user_profile`.`user_account_fk` WHERE `user_groups`.`ugrp_id` = '1' AND `user_privilege_users`.`upriv_users_uacc_fk` = '1' AND `uacc_id` = '1'

Any idea as to why this is occurring?
#2

[eluser]Eduard Stankovic[/eluser]
does column upriv_id exists in user_privilages table ?
#3

[eluser]old_guy[/eluser]
yes, all the referenced columns are in the tables but for some reason the join fails




Theme © iAndrew 2016 - Forum software by © MyBB