fbpx
  Wednesday, 02 November 2016
  2 Replies
  2.9K Visits
  Subscribe
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
Hi Kristina,

Thanks for reporting the bug.
Very rare error in cache module of sellacious.

Kindly make this change or PM me the FTP access I can do it for you.

File: sellacious/components/com_sellacious/models/products.php
Line: 276 and 277

Old text: CASE p.type
Change to: CASE a.type


-Abhishek
7 years ago
·
#104
HI Abhishek,

Everything is working now, thank you!

Kindest regards,
Kristiana
  • Page :
  • 1
There are no replies made for this post yet.
Be one of the first to reply to this post!
  • +1 (408) 821-8283
  • Email hello@sellacious.com