Hi,
I've installed Sellacious and try to access to the store page of any seller (?view=store&id=XXX), but i can't.
Instead of, a bug alert me as fellowing :
Warning
Unknown column 'fx.x_factor' in 'order clause' SQL=SELECT a.* FROM ( SELECT a.id, a.title, a.type, a.local_sku, a.manufacturer_sku, a.manufacturer_id, a.features, a.introtext,a.description, a.metakey, a.metadesc, a.ordering, a.tags, a.params,a.variant_id, a.variant_title, a.variant_sku, a.variant_description, a.variant_features,pp.price_id, pp.seller_uid, pp.qty_min, pp.qty_max, pp.is_fallback, pp.cost_price, pp.margin,pp.margin_type, pp.list_price, pp.calculated_price, pp.ovr_price, pp.product_price, pp.price_display,pp.client_catid, pp.listing_type, pp.item_condition,'1' AS flat_shipping, '20.00' AS shipping_flat_fee,pp.shipping_country, pp.shipping_state, pp.shipping_district, pp.shipping_zip, pp.whats_in_box,pp.return_days, pp.return_tnc, pp.exchange_days, pp.exchange_tnc, pp.seller_company, pp.seller_code,pp.seller_name, seller_username, pp.seller_email, pp.seller_mobile,pp.product_stock, pp.product_over_stock, pp.stock_reserved, pp.stock_sold,'USD' AS seller_currency,'1' AS forex_rate,IFNULL(vs.price_mod, 0) AS price_mod,IFNULL(vs.price_mod_perc, 0) AS price_mod_perc,IF(IFNULL(vs.price_mod_perc, 0), pp.product_price * IFNULL(vs.price_mod, 0) / 100.0, IFNULL(vs.price_mod, 0)) AS variant_price,IF(IFNULL(vs.price_mod_perc, 0), pp.product_price * IFNULL(vs.price_mod, 0) / 100.0, IFNULL(vs.price_mod, 0)) + pp.product_price AS sales_price,IFNULL(vs.stock, IF(a.variant_id, 0, pp.product_stock)) AS stock,IFNULL(vs.over_stock, IF(a.variant_id, 0, pp.product_over_stock)) AS over_stock,IFNULL(vs.stock, IF(a.variant_id, 0, pp.product_stock)) + IFNULL(vs.over_stock, IF(a.variant_id, 0, pp.product_over_stock)) AS stock_capacity,spl.spl_listing_catid, spl.spl_listing_date, spl.spl_listing_params, spl.spl_listing_ordering,null AS variant_count,null AS seller_count FROM `#__sellacious_products_cache` AS `a` INNER JOIN ( SELECT pp.price_id, pp.product_id, pp.seller_uid, pp.qty_min, pp.qty_max, pp.cost_price,pp.margin, pp.margin_type, pp.list_price, pp.calculated_price, pp.ovr_price, pp.is_fallback,pp.product_price, pp.price_display, pp.listing_type, pp.item_condition,'1' AS flat_shipping, '20.00' AS shipping_flat_fee,pp.shipping_country, pp.shipping_state, pp.shipping_district, pp.shipping_zip,pp.whats_in_box, pp.return_days, pp.return_tnc, pp.exchange_days, pp.exchange_tnc,pp.seller_company, pp.seller_code, pp.seller_name, pp.seller_username, pp.seller_email,pp.client_catid, pp.seller_mobile,pp.seller_currency,psx.stock AS product_stock,psx.over_stock AS product_over_stock,psx.stock_reserved, psx.stock_sold,psx.stock + psx.over_stock AS stock_capacity FROM `#__sellacious_prices_cache` AS `pp` LEFT JOIN `#__sellacious_product_sellers` AS `psx` ON psx.product_id = pp.product_id AND psx.seller_uid = pp.seller_uid WHERE (pp.client_catid = 0 OR pp.client_catid IS NULL OR pp.client_catid = 0) AND (pp.is_fallback = 1 OR ((pp.sdate <= '2017-04-02' OR pp.sdate = '0000-00-00 00:00:00') AND (pp.edate >= '2017-04-02' OR pp.edate = '0000-00-00 00:00:00'))) AND pp.seller_uid = 622 ORDER BY pp.price_display ASC, pp.product_price = 0 ASC, pp.product_price ASC, pp.is_fallback ASC) AS pp ON pp.product_id = a.id INNER JOIN ( SELECT l.seller_uid, l.product_id 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 < '2017-04-02 17:32:28' AND l.publish_down > '2017-04-02 17:32:28' AND l.state = 1 AND l.seller_uid = 622 GROUP BY l.seller_uid, l.product_id) AS pl ON a.id = pl.product_id AND pp.seller_uid = pl.seller_uid LEFT JOIN `#__sellacious_variant_sellers` AS `vs` ON vs.variant_id = a.variant_id AND vs.seller_uid = pp.seller_uid LEFT JOIN ( SELECT l.seller_uid, l.product_id,l.category_id AS spl_listing_catid, l.subscription_date AS spl_listing_date,c.params AS spl_listing_params, c.lft AS spl_listing_ordering FROM `#__sellacious_seller_listing` AS `l` INNER JOIN `#__sellacious_splcategories` AS `c` ON c.id = l.category_id 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 < '2017-04-02 17:32:28' AND l.publish_down > '2017-04-02 17:32:28' AND l.seller_uid = 622 AND l.state = 1 AND c.state = 1 GROUP BY l.seller_uid, l.product_id ORDER BY c.lft ASC) AS spl ON a.id = spl.product_id AND pp.seller_uid = spl.seller_uid WHERE ((a.id IN ('1') AND a.variant_id = 0) OR (a.id IN ('1') AND 1)) GROUP BY a.id,a.variant_id,pp.seller_uid ORDER BY spl.spl_listing_catid IS NULL, price_display, sales_price = 0, sales_price * fx.x_factor, stock_capacity DESC ) AS `a` ORDER BY spl_listing_catid IS NULL, price_display, sales_price = 0, sales_price * forex_rate, stock_capacity DESC LIMIT 20 Unknown column 'fx.x_factor' in 'order clause' SQL=SELECT COUNT(*) FROM ( SELECT a.id, a.title, a.type, a.local_sku, a.manufacturer_sku, a.manufacturer_id, a.features, a.introtext,a.description, a.metakey, a.metadesc, a.ordering, a.tags, a.params,a.variant_id, a.variant_title, a.variant_sku, a.variant_description, a.variant_features,pp.price_id, pp.seller_uid, pp.qty_min, pp.qty_max, pp.is_fallback, pp.cost_price, pp.margin,pp.margin_type, pp.list_price, pp.calculated_price, pp.ovr_price, pp.product_price, pp.price_display,pp.client_catid, pp.listing_type, pp.item_condition,'1' AS flat_shipping, '20.00' AS shipping_flat_fee,pp.shipping_country, pp.shipping_state, pp.shipping_district, pp.shipping_zip, pp.whats_in_box,pp.return_days, pp.return_tnc, pp.exchange_days, pp.exchange_tnc, pp.seller_company, pp.seller_code,pp.seller_name, seller_username, pp.seller_email, pp.seller_mobile,pp.product_stock, pp.product_over_stock, pp.stock_reserved, pp.stock_sold,'USD' AS seller_currency,'1' AS forex_rate,IFNULL(vs.price_mod, 0) AS price_mod,IFNULL(vs.price_mod_perc, 0) AS price_mod_perc,IF(IFNULL(vs.price_mod_perc, 0), pp.product_price * IFNULL(vs.price_mod, 0) / 100.0, IFNULL(vs.price_mod, 0)) AS variant_price,IF(IFNULL(vs.price_mod_perc, 0), pp.product_price * IFNULL(vs.price_mod, 0) / 100.0, IFNULL(vs.price_mod, 0)) + pp.product_price AS sales_price,IFNULL(vs.stock, IF(a.variant_id, 0, pp.product_stock)) AS stock,IFNULL(vs.over_stock, IF(a.variant_id, 0, pp.product_over_stock)) AS over_stock,IFNULL(vs.stock, IF(a.variant_id, 0, pp.product_stock)) + IFNULL(vs.over_stock, IF(a.variant_id, 0, pp.product_over_stock)) AS stock_capacity,spl.spl_listing_catid, spl.spl_listing_date, spl.spl_listing_params, spl.spl_listing_ordering,null AS variant_count,null AS seller_count FROM `#__sellacious_products_cache` AS `a` INNER JOIN ( SELECT pp.price_id, pp.product_id, pp.seller_uid, pp.qty_min, pp.qty_max, pp.cost_price,pp.margin, pp.margin_type, pp.list_price, pp.calculated_price, pp.ovr_price, pp.is_fallback,pp.product_price, pp.price_display, pp.listing_type, pp.item_condition,'1' AS flat_shipping, '20.00' AS shipping_flat_fee,pp.shipping_country, pp.shipping_state, pp.shipping_district, pp.shipping_zip,pp.whats_in_box, pp.return_days, pp.return_tnc, pp.exchange_days, pp.exchange_tnc,pp.seller_company, pp.seller_code, pp.seller_name, pp.seller_username, pp.seller_email,pp.client_catid, pp.seller_mobile,pp.seller_currency,psx.stock AS product_stock,psx.over_stock AS product_over_stock,psx.stock_reserved, psx.stock_sold,psx.stock + psx.over_stock AS stock_capacity FROM `#__sellacious_prices_cache` AS `pp` LEFT JOIN `#__sellacious_product_sellers` AS `psx` ON psx.product_id = pp.product_id AND psx.seller_uid = pp.seller_uid WHERE (pp.client_catid = 0 OR pp.client_catid IS NULL OR pp.client_catid = 0) AND (pp.is_fallback = 1 OR ((pp.sdate <= '2017-04-02' OR pp.sdate = '0000-00-00 00:00:00') AND (pp.edate >= '2017-04-02' OR pp.edate = '0000-00-00 00:00:00'))) AND pp.seller_uid = 622 ORDER BY pp.price_display ASC, pp.product_price = 0 ASC, pp.product_price ASC, pp.is_fallback ASC) AS pp ON pp.product_id = a.id INNER JOIN ( SELECT l.seller_uid, l.product_id 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 < '2017-04-02 17:32:28' AND l.publish_down > '2017-04-02 17:32:28' AND l.state = 1 AND l.seller_uid = 622 GROUP BY l.seller_uid, l.product_id) AS pl ON a.id = pl.product_id AND pp.seller_uid = pl.seller_uid LEFT JOIN `#__sellacious_variant_sellers` AS `vs` ON vs.variant_id = a.variant_id AND vs.seller_uid = pp.seller_uid LEFT JOIN ( SELECT l.seller_uid, l.product_id,l.category_id AS spl_listing_catid, l.subscription_date AS spl_listing_date,c.params AS spl_listing_params, c.lft AS spl_listing_ordering FROM `#__sellacious_seller_listing` AS `l` INNER JOIN `#__sellacious_splcategories` AS `c` ON c.id = l.category_id 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 < '2017-04-02 17:32:28' AND l.publish_down > '2017-04-02 17:32:28' AND l.seller_uid = 622 AND l.state = 1 AND c.state = 1 GROUP BY l.seller_uid, l.product_id ORDER BY c.lft ASC) AS spl ON a.id = spl.product_id AND pp.seller_uid = spl.seller_uid WHERE ((a.id IN ('1') AND a.variant_id = 0) OR (a.id IN ('1') AND 1)) GROUP BY a.id,a.variant_id,pp.seller_uid ORDER BY spl.spl_listing_catid IS NULL, price_display, sales_price = 0, sales_price * fx.x_factor, stock_capacity DESC ) AS `a`
Thanks for your help,
Best regards
Wolfrie