[Skip to main content](#vessel-content) # Error when attempting to copy Joomla database ## - **[Mitrax](/forum/user/8602-mitrax "View Mitrax's Profile")** - [![Mitrax's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/8602-mitrax "View Mitrax's Profile") Topic Author - [ Offline](/forum/user/8602-mitrax) Less More - Posts: 76 - Thank you received: 5 - [](http://www.mitrax.com.au) - 3 years 3 months ago - 3 years 3 months ago [\#353747](#353747) by [Mitrax](/forum/user/8602-mitrax "View Mitrax's Profile") *[Error when attempting to copy Joomla database](/forum/25-install-update/906778-error-when-attempting-to-copy-joomla-database#353747 "-- 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")* was created by *[Mitrax](/forum/user/8602-mitrax "View Mitrax's Profile")* -- 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 --- MItrax Trading [ www.mitrax.com.au](http://www.mitrax.com.au) Last edit: 3 years 3 months ago by [Mitrax](/forum/user/8602-mitrax "View Mitrax's Profile"). Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzI1LWluc3RhbGwtdXBkYXRlLzkwNjc3OC1lcnJvci13aGVuLWF0dGVtcHRpbmctdG8tY29weS1qb29tbGEtZGF0YWJhc2U/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[nicolas](/forum/user/63-nicolas "View nicolas's Profile")** - [![nicolas's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar63.png?1793428657)](/forum/user/63-nicolas "View nicolas's Profile") - [ Away](/forum/user/63-nicolas) Less More - Posts: 86541 - Thank you received: 14304 - - 3 years 3 months ago [\#353749](#353749) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Error when attempting to copy Joomla database](/forum/25-install-update/906778-error-when-attempting-to-copy-joomla-database#353749 "-- 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. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzI1LWluc3RhbGwtdXBkYXRlLzkwNjc3OC1lcnJvci13aGVuLWF0dGVtcHRpbmctdG8tY29weS1qb29tbGEtZGF0YWJhc2U/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[Mitrax](/forum/user/8602-mitrax "View Mitrax's Profile")** - [![Mitrax's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/8602-mitrax "View Mitrax's Profile") Topic Author - [ Offline](/forum/user/8602-mitrax) Less More - Posts: 76 - Thank you received: 5 - [](http://www.mitrax.com.au) - 3 years 3 months ago [\#353783](#353783) by [Mitrax](/forum/user/8602-mitrax "View Mitrax's Profile") Replied by *[Mitrax](/forum/user/8602-mitrax "View Mitrax's Profile")* on topic *[Error when attempting to copy Joomla database](/forum/25-install-update/906778-error-when-attempting-to-copy-joomla-database#353783 "-- 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 ? --- MItrax Trading [ www.mitrax.com.au](http://www.mitrax.com.au) Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzI1LWluc3RhbGwtdXBkYXRlLzkwNjc3OC1lcnJvci13aGVuLWF0dGVtcHRpbmctdG8tY29weS1qb29tbGEtZGF0YWJhc2U/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[nicolas](/forum/user/63-nicolas "View nicolas's Profile")** - [![nicolas's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar63.png?1793428657)](/forum/user/63-nicolas "View nicolas's Profile") - [ Away](/forum/user/63-nicolas) Less More - Posts: 86541 - Thank you received: 14304 - - 3 years 3 months ago [\#353785](#353785) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Error when attempting to copy Joomla database](/forum/25-install-update/906778-error-when-attempting-to-copy-joomla-database#353785 "-- 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, Yes. It's the same. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzI1LWluc3RhbGwtdXBkYXRlLzkwNjc3OC1lcnJvci13aGVuLWF0dGVtcHRpbmctdG8tY29weS1qb29tbGEtZGF0YWJhc2U/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[Mitrax](/forum/user/8602-mitrax "View Mitrax's Profile")** - [![Mitrax's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/8602-mitrax "View Mitrax's Profile") Topic Author - [ Offline](/forum/user/8602-mitrax) Less More - Posts: 76 - Thank you received: 5 - [](http://www.mitrax.com.au) - 3 years 3 months ago [\#353792](#353792) by [Mitrax](/forum/user/8602-mitrax "View Mitrax's Profile") Replied by *[Mitrax](/forum/user/8602-mitrax "View Mitrax's Profile")* on topic *[Error when attempting to copy Joomla database](/forum/25-install-update/906778-error-when-attempting-to-copy-joomla-database#353792 "-- 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 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 --- MItrax Trading [ www.mitrax.com.au](http://www.mitrax.com.au) The following user(s) said Thank You: [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzI1LWluc3RhbGwtdXBkYXRlLzkwNjc3OC1lcnJvci13aGVuLWF0dGVtcHRpbmctdG8tY29weS1qb29tbGEtZGF0YWJhc2U/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. Board Categories HikaShop Install & Update Product & Category Display Content Creation Sales and Orders Orders management Reports & Statistics Customers Checkout Payment Methods Shipping Methods Import & Export (CSV, XLS…) Specific Features Affilation Taxes Wishlist Vote Carousel & Slider Mass Actions Filters & Search Discount & Coupon Feature Request Integrations Showcase General Talk about HikaShop Development HikaShop 3.0 Beta Translation Commercial Jobs HikaShop Components HikaMarket Market: Feature requests Market: How to? Market: Bug Report HikaSerial General talk about HikaSerial Serial: Bug Report Serial: How to? Support en Français de HikaSerial (French Support) HikaSubscription HikaAuction Auction: Feature requests Auction: How to? Auction: Bug report Hikashop around the world Support en Français (French Support) Russian FAQ. Курс выживания с Hikashop. Частые вопросы и о Расширения Hikashop Наши сайты на Hikashop 日本語版サポート(Japanese Support) Thai German Archives Bug Report How to? [](/forum/topics/feed/mode-topics?format=feed&type=rss) Time to create page: 0.056 seconds [Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org)