Cant access affiliate partners

-- HikaShop version -- : latest
-- Joomla version -- : 3.2.4
-- Browser(s) name and version -- : chrome & firefox
-- Error-message(debug-mod must be tuned on) -- : 'xxxxxxxx_hikashop_sale_view' is not VIEW SQL=CREATE OR REPLACE VIEW xxxxx_hikashop_sale_view AS SELECT a.user_id, SUM(b.order_partner_price) AS sale_price FROM xxxx_hikashop_user AS a LEFT JOIN xxxx_hikashop_order AS b ON a.user_id=b.order_partner_id AND (CASE WHEN a.user_currency_id=0 THEN 6 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;

Hi there,

When I go to access the partners in the backend I get the error. I asked hosting and they said it wasn't a permissions problem. I have testd it in both Firefox and chrome and it doesn't work on both. Our developer who is in another country, has tested it and it works fine for her in both chrome and firefox.

Thanks

Ah yes, my bad to copy/paste the wrong error after playing with the test DB. But strange enough I needed to delete the 'lead_view to get it all working. Wonder where that error / issue comes from.
The only difference between this and other sites is it running on MariaDB instead of MYSQLI.
Thanks for pointing me in the right direction.

Questions:
1. was it part of an older bug? Any way to avoid this?
2. can views always be deleted and automatically recreated?
3. The DB checks doesn't include view checks?