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

Hi,

The view is created by HikaShop to generate the statistics for the affiliate fees.
You can delete it, it's not a problem. The system can automatically recreate it on the new database (provided it will have the rights to do so).
If you don't use the affiliate system in HikaShop, you can disable the affiliate plugin in the Joomla plugins manager, and it won't even need to recreate the view.

Thanks,

Can I also delete sale and lead views ?

Hi,

Yes. It's the same.

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