Hi there,
Just installed the newest version of Sellacious on my website and when I go to the back-end on Shop -> Product Catalogue & Inventory Manager, the following warning is shown:
Warning Unknown column 'p.type' in 'field list' SQL=SELECT a.*,cc.category_title,p.*,CASE p.type WHEN 'physical' THEN psp.flat_shipping WHEN 'package' THEN psk.flat_shipping END AS flat_shipping,CASE p.type WHEN 'physical' THEN psp.shipping_flat_fee WHEN 'package' THEN psk.shipping_flat_fee END AS shipping_flat_fee,psx.price_display, psx.stock, psx.over_stock, psx.stock + psx.over_stock AS stock_capacity, psx.state AS is_selling,CASE a.type WHEN 'physical' THEN psp.listing_type WHEN 'package' THEN psk.listing_type END AS listing_type,CASE a.type WHEN 'physical' THEN psp.item_condition WHEN 'package' THEN psk.item_condition END AS item_condition,CASE a.type WHEN 'physical' THEN psp.whats_in_box WHEN 'package' THEN psk.whats_in_box END AS whats_in_box,CASE a.type WHEN 'physical' THEN psp.return_days WHEN 'package' THEN psk.return_days END AS return_days,CASE a.type WHEN 'physical' THEN psp.return_tnc WHEN 'package' THEN psk.return_tnc END AS return_tnc,CASE a.type WHEN 'physical' THEN psp.exchange_days WHEN 'package' THEN psk.exchange_days END AS exchange_days,CASE a.type WHEN 'physical' THEN psp.exchange_tnc WHEN 'package' THEN psk.exchange_tnc END AS exchange_tnc,spl_categories,l.publish_up AS listing_publish_up, l.publish_down AS listing_publish_down, l.state AS listing_state FROM `#__sellacious_products` AS `a` LEFT JOIN ( SELECT GROUP_CONCAT(c.title ORDER BY c.lft SEPARATOR ', ') AS category_title,pc.product_id FROM `#__sellacious_categories` AS `c` LEFT JOIN `#__sellacious_product_categories` AS `pc` ON c.id = pc.category_id GROUP BY pc.product_id) AS cc ON cc.product_id = a.id LEFT JOIN ( SELECT pp.product_id, pp.seller_uid, pp.id AS price_id, pp.cost_price, pp.margin, pp.margin_type,pp.list_price, pp.calculated_price, pp.product_price, pp.product_price AS sales_price, pp.ovr_price, pp.is_fallback,ss.title AS seller_company,u.email AS seller_email,'BGN' AS seller_currency, su.mobile AS seller_mobile,IFNULL(fx.x_factor, '1.00') AS forex_rate FROM `#__sellacious_product_prices` AS `pp` LEFT JOIN `#__sellacious_sellers` AS `ss` ON ss.user_id = pp.seller_uid INNER JOIN `#__users` AS `u` ON u.id = pp.seller_uid LEFT JOIN `#__sellacious_profiles` AS `su` ON su.user_id = pp.seller_uid LEFT JOIN #__sellacious_forex AS fx ON fx.x_from = 'BGN' AND fx.x_to = 'BGN' AND fx.state = 1 WHERE pp.is_fallback = 1) AS p ON p.product_id = a.id LEFT JOIN `#__sellacious_product_sellers` AS `psx` ON psx.product_id = p.product_id AND psx.seller_uid = p.seller_uid LEFT JOIN `#__sellacious_physical_sellers` AS `psp` ON psp.psx_id = psx.id LEFT JOIN `#__sellacious_package_sellers` AS `psk` ON psk.psx_id = psx.id LEFT JOIN ( SELECT l.seller_uid, l.product_id,GROUP_CONCAT(l.category_id) AS spl_categories FROM `#__sellacious_seller_listing` AS `l` WHERE l.category_id > 0 AND l.publish_up != '0000-00-00 00:00:00' AND l.publish_down != '0000-00-00 00:00:00' AND l.publish_up < '2016-11-01 21:39:05' AND l.publish_down > '2016-11-01 21:39:05' AND l.state = 1 GROUP BY l.seller_uid, l.product_id) AS spl ON spl.product_id = a.id AND spl.seller_uid = p.seller_uid LEFT JOIN ( SELECT l.seller_uid, l.product_id,l.publish_up, l.publish_down, l.state FROM `#__sellacious_seller_listing` AS `l` WHERE l.category_id = 0 AND l.publish_up != '0000-00-00 00:00:00' AND l.publish_down != '0000-00-00 00:00:00' AND l.publish_up < '2016-11-01 21:39:05' AND l.publish_down > '2016-11-01 21:39:05' AND l.state = 1 GROUP BY l.seller_uid, l.product_id) AS l ON l.product_id = a.id AND l.seller_uid = p.seller_uid WHERE (a.state = 1 OR a.state = 0) ORDER BY l.publish_up DESC LIMIT 20
Thank you in advance for the support.
Kindest regards,
Kristiana