Hika shop Affiliate Partner error..urgently need t

-- HikaShop version -- : 2.3.2
-- Joomla version -- : 3.2.3
-- Error-message(debug-mod must be tuned on) -- : An error has occurred.
1347 'fghjh_fgfh.kb7ao_hikashop_sale_view' is not VIEW SQL=CREATE OR REPLACE VIEW................

An error has occurred.
1347 'fghjh_fgfh.kb7ao_hikashop_sale_view' is not VIEW SQL=CREATE OR REPLACE VIEW................

Hi,

Please delete your table "fghjh_fgfh.kb7ao_hikashop_sale_view" in order to let HikaShop recreate it, as a view and not as a table.

Regards,

Hi
I have deleted this table fghjh_fgfh.kb7ao_hikashop_sale_view

Now getting this error
fghjh_fgfh.kb7ao_hikashop_lead_view' is not VIEW SQL=CREATE OR REPLACE VIEW kb7ao_hikashop_lead_view AS SELECT a.user_id, SUM(b.user_partner_price) AS lead_price FROM kb7ao_hikashop_user AS a LEFT JOIN kb7ao_hikashop_user AS b ON a.user_id=b.user_partner_id AND (CASE WHEN a.user_currency_id=0 THEN 6 ELSE a.user_currency_id END)=b.user_partner_currency_id WHERE a.user_partner_activated=1 AND b.user_partner_paid=0 GROUP BY b.user_partner_id;

Could you help me out why is this happening?

Hi,

Delete also kb7ao_hikashop_lead_view and kb7ao_hikashop_click_view

It should then be ok.

It's happening because you must have transferred/restored the website with a script which didn't handle views correctly and broke them.