Affiliate Partner error

Hello sir,
I am configure whole site on my localhost also i ma getting this error . when i copy this sql query and run in my sql command then give a result to me . can you give me help for that ???????//

i ask two question on that but i am not getting better reply.

-- url of the page with the problem -- : montrealsalsaconvention.com/administrator
-- HikaShop version -- : HikaShop Business 2.2.2
-- Joomla version -- : Joomla! 3.0.4
-- PHP version -- : 5.3.24
-- Browser(s) name and version -- : google chrome 33.0.1750
-- Error-message(debug-mod must be tuned on) -- : 1347 'salsa123.zxnyw_hikashop_sale_view' is not VIEW SQL=CREATE OR REPLACE VIEW zxnyw_hikashop_sale_view AS SELECT a.user_id, SUM(b.order_partner_price) AS sale_price FROM zxnyw_hikashop_user AS a LEFT JOIN zxnyw_hikashop_order AS b ON a.user_id=b.order_partner_id AND (CASE WHEN a.user_currency_id=0 THEN 5 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;


When i am login in montrealsalsaconvention.com/administrator and open hikashop---> affiliates---> partners It Give me Error Like this Can you Help me plz ????

1347 'salsa123.zxnyw_hikashop_sale_view' is not VIEW SQL=CREATE OR REPLACE VIEW zxnyw_hikashop_sale_view AS SELECT a.user_id, SUM(b.order_partner_price) AS sale_price FROM zxnyw_hikashop_user AS a LEFT JOIN zxnyw_hikashop_order AS b ON a.user_id=b.order_partner_id AND (CASE WHEN a.user_currency_id=0 THEN 5 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;


Thank You
jitendra Goyal