feegleweb/oc-octoshoplite-plugin

create new item doesn't work when used with Microsoft SQL Server

tschallacka opened this issue · 0 comments

nest_left is added twice in the order by clause.

SQLSTATE[42000]: [Microsoft][ODBC Driver 11 for SQL Server][SQL Server]A column has been specified more than once in the order by list. Columns in the order by list must be unique. (SQL: select [feegleweb_octoshop_categories].*, [feegleweb_octoshop_prod_cat].[product_id] as [pivot_product_id], [feegleweb_octoshop_prod_cat].[category_id] as [pivot_category_id] from [feegleweb_octoshop_categories] left join [feegleweb_octoshop_prod_cat] on [feegleweb_octoshop_categories].[id] = [feegleweb_octoshop_prod_cat].[category_id] where (exists (select * from [deferred_bindings] where slave_id = feegleweb_octoshop_categories.id and [master_field] = categories and [master_type] = Feegleweb\OctoshopLite\Models\Product and [session_key] = 4wmSVdu06OV4B1zk6RldBIs9dHsitMv7nHjEdrIX and [is_bind] = 1)) and not exists (select * from [deferred_bindings] where slave_id = feegleweb_octoshop_categories.id and [master_field] = categories and [master_type] = Feegleweb\OctoshopLite\Models\Product and [session_key] = 4wmSVdu06OV4B1zk6RldBIs9dHsitMv7nHjEdrIX and [is_bind] = 0 and id > isnull((select max(id) from deferred_bindings where slave_id = feegleweb_octoshop_categories.id and master_field = categories and master_type = Feegleweb\OctoshopLite\Models\Product and session_key = 4wmSVdu06OV4B1zk6RldBIs9dHsitMv7nHjEdrIX and is_bind = 1 ), 0)) order by [nest_left] asc, [id] desc, [nest_left] asc)