fbpx
  Sunday, 02 April 2017
  7 Replies
  2K Visits
  Subscribe
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
Hi Wolfrie,

Thanks for posting in support forums. Could you please provide me more details around it? If you have this installation online somewhere, Please provide us with the URL so that we can check this out.

Thanks,
Ankit A.
Team Sellacious
Hi Wolfrie,

Would you be able to provide me with the FTP and Sellacious access to fix it? Please send it as a direct message.
6 years ago
·
#256
Hi Ankit,

I send you directly all my codes yesterday ; did you receive them ?

Best regards,
Wolfrie
Hi Wolfrie,

I haven't. I have just sent you a direct message so that you can reply to it.
Hi Wolfrie,

The links should be working fine. Please check.
6 years ago
·
#264
Hi Ankit
Yes, it works !
Thanks +
  • 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