Buy Now
Sign in

bug on join database of joomla users

teldrive , May 25 2021, 21:54
teldrive 587
May 25 2021, 21:54 #396553
i have a simple join relation between 2 joomla tables related to users
jos_user_usergroup_map (model1)
jos_users( model2)
maped by model1->user_id, to model2->id I think it's a bug because I have it working fine in CCv5
the bug is only is about it's just obtained first row
[0] => SELECT `usr`.`id` AS `usr.id`, `usr`.`name` AS `usr.name`, `usr`.`username` AS `usr.username`, `usr`.`email` AS `usr.email`, `usr`.`block` AS `usr.block` FROM `jos_user_usergroup_map` AS `map` LEFT JOIN `jos_users` AS `usr` ON `map`.`user_id` = `usr`.`id` LIMIT 100;
its very strange because if I use another tables, all works fine
jos_user_usergroup_map
jos_usergroups
[0] => SELECT `usr`.`id` AS `usr.id` FROM `jos_user_usergroup_map` AS `map` LEFT JOIN `jos_usergroups` AS `usr` ON `map`.`group_id` = `usr`.`id` LIMIT 100;
Teldrive