Error in opening the Affiliate page

-- HikaShop version -- : 2.3.4
-- Joomla version -- : 3.3.6
-- PHP version -- : 5.4
-- Browser(s) name and version -- : Chome
-- Error-message(debug-mod must be tuned on) -- : exception 'RuntimeException' with message ''isog_test.igd3f_hikashop_sale_view' is not VIEW SQL=CREATE OR REPLACE VIEW igd3f_hikashop_sale_view AS SELECT a.user_id, SUM(b.order_partner_price) AS sale_price FROM igd3f_hikashop_user AS a LEFT JOIN igd3f_hikashop_order AS b ON a.user_id=b.order_partner_id AND (CASE WHEN a.user_currency_id=0 THEN 1 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;' in /var/www/vhosts/golfgeheimen.nl/test.golfgeheimen.nl/libraries/joomla/database/driver/mysqli.php:606 Stack trace: #0 /var/www/vhosts/golfgeheimen.nl/test.golfgeheimen.nl/libraries/joomla/database/database.php(35): JDatabaseDriverMysqli->execute() #1 /var/www/vhosts/golfgeheimen.nl/test.golfgeheimen.nl/administrator/components/com_hikashop/views/user/view.html.php(75): JDatabase->query() #2 /var/www/vhosts/golfgeheimen.nl/test.golfgeheimen.nl/administrator/components/com_hikashop/views/user/view.html.php(22): UserViewUser->listing() #3 /var/www/vhosts/golfgeheimen.nl/test.golfgeheimen.nl/libraries/legacy/controller/legacy.php(693): UserViewUser->display() #4 /var/www/vhosts/golfgeheimen.nl/test.golfgeheimen.nl/administrator/components/com_hikashop/helpers/helper.php(1480): JControllerLegacy->display() #5 /var/www/vhosts/golfgeheimen.nl/test.golfgeheimen.nl/administrator/components/com_hikashop/helpers/helper.php(1216): hikashopController->display() #6 /var/www/vhosts/golfgeheimen.nl/test.golfgeheimen.nl/libraries/legacy/controller/legacy.php(730): hikashopController->listing() #7 /var/www/vhosts/golfgeheimen.nl/test.golfgeheimen.nl/administrator/components/com_hikashop/helpers/helper.php(1461): JControllerLegacy->execute('listing') #8 /var/www/vhosts/golfgeheimen.nl/test.golfgeheimen.nl/administrator/components/com_hikashop/hikashop.php(54): hikashopController->execute('listing') #9 /var/www/vhosts/golfgeheimen.nl/test.golfgeheimen.nl/libraries/cms/component/helper.php(352): require_once('/var/www/vhosts...') #10 /var/www/vhosts/golfgeheimen.nl/test.golfgeheimen.nl/libraries/cms/component/helper.php(332): JComponentHelper::executeComponent('/var/www/vhosts...') #11 /var/www/vhosts/golfgeheimen.nl/test.golfgeheimen.nl/libraries/cms/application/administrator.php(98): JComponentHelper::renderComponent('com_hikashop') #12 /var/www/vhosts/golfgeheimen.nl/test.golfgeheimen.nl/libraries/cms/application/administrator.php(159): JApplicationAdministrator->dispatch() #13 /var/www/vhosts/golfgeheimen.nl/test.golfgeheimen.nl/libraries/cms/application/cms.php(251): JApplicationAdministrator->doExecute() #14 /var/www/vhosts/golfgeheimen.nl/test.golfgeheimen.nl/administrator/index.php(42): JApplicationCms->execute() #15 {main}

Anyone an idea what is going wrong here?
It happens while opening the affiliate page in the backend. No issue on other sites so it seems something very specific.

hikashop_sale_view table is there and was empty.

The main thing I see is that the tabels are not all the same type. Some are innoDB and most are MYISAM.This setup is already pretty old and started with Hikashop 1.x so maybe something left from the start?

Is this something that should be fixed?