BUGS: Manage group (select active or hidden)
If you go to groups, manage, select from first dropdown, either hidden or active, mysql error, and loading spinner remains forever.
Query:
SELECT COUNT(*) FROM `bx_groups_data` AS `td` LEFT JOIN `sys_profiles` AS `tp` ON `td`.`id`=`tp`.`content_id` AND `tp`.`type`='bx_groups' LEFT JOIN `sys_accounts` AS `ta` ON `tp`.`account_id`=`ta`.`id` WHERE 1 AND `tp`.`account_id`=1 AND `status`='active'
Mysql error:
Column 'status' in where clause is ambiguous
collation_connection:
utf8mb4_unicode_ci
And for hidden
Database error in ...
Query:
SELECT COUNT(*) FROM `bx_groups_data` AS `td` LEFT JOIN `sys_profiles` AS `tp` ON `td`.`id`=`tp`.`content_id` AND `tp`.`type`='bx_groups' LEFT JOIN `sys_accounts` AS `ta` ON `tp`.`account_id`=`ta`.`id` WHERE 1 AND `tp`.`account_id`=1 AND `status`='hidden'
Mysql error:
Column 'status' in where clause is ambiguous
collation_connection:
utf8mb4_unicode_ci
Latest UNA.
Please fix 😁👍
Replies (4)
-
If I read those correctly it's because in the SQL you don't specify which 'status', it should be td.status, right? Something like that 😁👍
-
Same error for events...
Called script: /grid.php
Query: SELECT COUNT(*) FROM `bx_events_data` AS `td` LEFT JOIN `sys_profiles` AS `tp` ON `td`.`id`=`tp`.`content_id` AND `tp`.`type`='bx_events' LEFT JOIN `sys_accounts` AS `ta` ON `tp`.`account_id`=`ta`.`id` WHERE 1 AND `tp`.`account_id`=1 AND `status`='hidden' Mysql error: Column 'status' in where clause is ambiguous collation_connection: utf8mb4_unicode_ciI'm imagining this will happen across all modules that use this query syntax.
-
Has this been acknowledged as a bug in 14 A3?
-
thank you for the report and your investigation: