Affiliate Partners Gives Error

Hi,

My entire cart seems to be working good after Business update and Joomla 3.3.6. However, under Affilliate/ Partners I get a 1347 error page. All other parts of Affiliates seems to work fine.

Here is the error:

1347 'citysur_joomKen.jos_hikashop_sale_view' is not VIEW SQL=CREATE OR REPLACE VIEW jos_hikashop_sale_view AS SELECT a.user_id, SUM(b.order_partner_price) AS sale_price FROM jos_hikashop_user AS a LEFT JOIN jos_hikashop_order AS b ON a.user_id=b.order_partner_id AND (CASE WHEN a.user_currency_id=0 THEN 2 ELSE a.user_currency_id END)=b.order_partner_currency_id WHERE a.user_partner_activated=1 AND b.order_partner_paid=0 AND b.order_type='sale' AND b.order_status IN ('confirmed','shipped') GROUP BY b.order_partner_id;

For anyone else that ends up with this issue, refer to this post for the fix, it worked for me:

www.hikashop.com/forum/affilation/870713...urgently-need-t.html