I freshly installed Sellacious (beta_3) and found same errors as other people here. So created the two table who were missing (from other discussion), but still having the problem with the cache.
Searched further and this query does not seem to work (sql-error #1064 in the syntax):
SELECT COUNT(*)
FROM 'nbr96_sellacious_products' AS 'a'
LEFT JOIN ( SELECT GROUP_CONCAT(c.id
ORDER BY c.lft SEPARATOR ',') AS category_ids,GROUP_CONCAT(c.title
ORDER BY c.lft SEPARATOR '|:|') AS category_titles,pc.product_id
FROM 'nbr96_sellacious_categories' AS 'c'
LEFT JOIN 'nbr96_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, ss.store_name AS seller_store,IF (ss.state = 1
AND u.block = 0, 1, 0) AS seller_active,u.name AS seller_name, u.username AS seller_username, u.email AS seller_email,'CHF' AS seller_currency
FROM 'nbr96_sellacious_product_prices' AS 'pp'
LEFT JOIN 'nbr96_sellacious_sellers' AS 'ss'
ON ss.user_id = pp.seller_uid
INNER JOIN 'nbr96_users' AS 'u'
ON u.id = pp.seller_uid
LEFT JOIN 'nbr96_sellacious_profiles' AS 'su'
ON su.user_id = pp.seller_uid;
Can you look into this please?
Kind regards, H. Beyeler