Error when attempting to copy Joomla database

-- HikaShop version -- : 4.7.4
-- Joomla version -- : 3.10.12
-- PHP version -- : 8.0.29
-- Browser(s) name and version -- : Chrome 114.0.5735.198
-- Error-message(debug-mod must be tuned on) -- : N/A

Hi,

I'm trying to copy my Joomla database in preparation for a J4 migration and it is failing due to insufficient permissions to execute the following SQL.

CREATE ALGORITHM=UNDEFINED DEFINER=`xxxxx`@`localhost` SQL SECURITY DEFINER VIEW `xxxxx`.`pwmku_hikashop_click_view` AS SELECT `a`.`user_id` AS `user_id`, sum(`b`.`click_partner_price`) AS `click_price` FROM (`pwmku_hikashop_user` `a` left join `pwmku_hikashop_click` `b` on(`a`.`user_id` = `b`.`click_partner_id` and case when `a`.`user_currency_id` = 0 then 6 else `a`.`user_currency_id` end = `b`.`click_partner_currency_id`)) WHERE `a`.`user_partner_activated` = 1 AND `b`.`click_partner_paid` = 0 GROUP BY `b`.`click_partner_id` ;

note: user details have been changed.

I'm working with my hosting provider to attempt to resolve the issue but I would like to know how important this VIEW is for the correct functioning of Hikashop and If you have any suggested solutions.

Any help is appreciated .

Rob

Thanks,

Can I also delete sale and lead views ?

Thanks Nicolas,

Problem is solved now.

FYI The affiliate plugin was not enabled and even after I uninstalled it the views were still in the database so I dropped them manually. The view also contained a user which was not assigned to the database so I suspect that they are leftovers from something that I have done in the past.

Table and Row counts matched identically straight after the copy so I am good to move on to the next step now.

Thanks again.

Rob