Problem with pagination when managing serials in fron end

-- HikaShop version -- : 2.6.4
-- HikaSerial version -- : 1.10.4
-- Joomla version -- : 3.6.5
-- PHP version -- : 5.6

Hi,

I'm using HikaMarket multi-vendor together with Hikaserial and I have found a problem when a vendor is managing his serials from the front end.

The problem occurs when clicking a product stats icon in the serialsmarket/packs view (the front end packs view) to navigate from this view into the serialsmarket/stats view (the front end view that shows the serial numbers for a particular product).

The problem starts to happen when there is pagination in the packs view and you go into the second page. For pagination to happen thre needs to be over 20 products linked with different packs. Once you into the second page, every time I click the stats icon to navigate from the packs view into the stats view I get the following SQL error:

Unknown column 'pack.pack_id' in 'order clause' SQL=SELECT serial.*, hk_order.order_id FROM #__hikaserial_serial AS serial INNER JOIN #__hikashop_order AS hk_order ON serial.serial_order_id = hk_order.order_parent_id INNER JOIN #__hikashop_order_product AS hk_order_product ON hk_order_product.order_product_id = serial.serial_order_product_id WHERE (serial.serial_pack_id = 9) AND (hk_order.order_type = 'subsale') AND (hk_order.order_vendor_id = 4) AND (hk_order_product.product_id = 30) ORDER BY pack.pack_id ASC

Thank you, that fixes the problem.

Since this is a core hack I assume it will be added to the next versions of Hikaserial, right?