jfquestiaux
Well-Known Member
Tested with GitHub version 627.
When you try to add a second join to a list, or to edit an existing (single) one (like going from "left join" to "inner join"), you get this error :
1054 Unknown column 'table_join_alias' in 'field list' SQL=UPDATE `og6a1_fabrik_joins` SET `list_id`='49',`element_id`='0',`join_from_table`='invoices',`table_join`='purchases',`table_key`='id',`table_join_key`='invoice_id',`join_type`='inner',`group_id`='130',`table_join_alias`='purchases' WHERE `id`='360'
And indeed, there is no "table_join_alias" column in the #__fabrik_joins table, hence the error.
I think that gives also an error in the frontend as this list, having two joins set before the recent updates, shows a MySQL error when you try to display it, reported an alleged unknown column.
When you try to add a second join to a list, or to edit an existing (single) one (like going from "left join" to "inner join"), you get this error :
1054 Unknown column 'table_join_alias' in 'field list' SQL=UPDATE `og6a1_fabrik_joins` SET `list_id`='49',`element_id`='0',`join_from_table`='invoices',`table_join`='purchases',`table_key`='id',`table_join_key`='invoice_id',`join_type`='inner',`group_id`='130',`table_join_alias`='purchases' WHERE `id`='360'
And indeed, there is no "table_join_alias" column in the #__fabrik_joins table, hence the error.
I think that gives also an error in the frontend as this list, having two joins set before the recent updates, shows a MySQL error when you try to display it, reported an alleged unknown column.