[Skip to main content](#vessel-content) # database error when I make a site copy. ## - **[chocovo](/forum/user/4491-chocovo "View chocovo's Profile")** - [![chocovo's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/4491-chocovo "View chocovo's Profile") Topic Author - [ Offline](/forum/user/4491-chocovo) Less More - Posts: 38 - Thank you received: 0 - - 14 years 9 months ago [\#35675](#35675) by [chocovo](/forum/user/4491-chocovo "View chocovo's Profile") *[database error when I make a site copy.](/forum/3-bug-report/35675-database-error-when-i-make-a-site-copy#35675 "Hello, I'm trying to make a copy of my hikashop site but when I import database I have the following message error: It seems to be something related with the affiliate program. Some idea about this problem. Regards")* was created by *[chocovo](/forum/user/4491-chocovo "View chocovo's Profile")* Hello, I'm trying to make a copy of my hikashop site but when I import database I have the following message error: Code: /*!50001 CREATE ALGORITHM=UNDEFINED *//*!50013 DEFINER=`xxxxxxxx`@`localhost` SQL SECURITY DEFINER *//*!50001 VIEW `tmsr_hikashop_click_view` AS select `a`.`user_id` AS `user_id`,sum(`b`.`click_partner_price`) AS `click_price` from (`tmsr_hikashop_user` `a` left join `tmsr_hikashop_click` `b` on(((`a`.`user_id` = `b`.`click_partner_id`) and ((case when (`a`.`user_currency_id` = 0) then 1 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` */; MySQL ha dicho: #1227 - Access denied; you need the SUPER privilege for this operation It seems to be something related with the affiliate program. Some idea about this problem. Regards Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMtYnVnLXJlcG9ydC8zNTY3NS1kYXRhYmFzZS1lcnJvci13aGVuLWktbWFrZS1hLXNpdGUtY29weT90bXBsPW1hcmtkb3du) 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") - [ Offline](/forum/user/63-nicolas) Less More - Posts: 86541 - Thank you received: 14304 - - 14 years 9 months ago [\#35681](#35681) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Re: database error when I make a site copy.](/forum/3-bug-report/35675-database-error-when-i-make-a-site-copy#35681 "Hello, I'm trying to make a copy of my hikashop site but when I import database I have the following message error: It seems to be something related with the affiliate program. Some idea about this problem. Regards")* Hi, That's because your mysql user on your new server does not have the permission to create views. You should either: 1. Export all the tables but the ones finishing by "_view" on your old server. That way, you won't have the problem when importing it. Views are not critical to the functioning of HikaShop. They are just used to display the statistics of affiliations. 2. Ask your new hosting to allow you to create views. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMtYnVnLXJlcG9ydC8zNTY3NS1kYXRhYmFzZS1lcnJvci13aGVuLWktbWFrZS1hLXNpdGUtY29weT90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[chocovo](/forum/user/4491-chocovo "View chocovo's Profile")** - [![chocovo's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/4491-chocovo "View chocovo's Profile") Topic Author - [ Offline](/forum/user/4491-chocovo) Less More - Posts: 38 - Thank you received: 0 - - 14 years 9 months ago [\#35843](#35843) by [chocovo](/forum/user/4491-chocovo "View chocovo's Profile") Replied by *[chocovo](/forum/user/4491-chocovo "View chocovo's Profile")* on topic *[Re: database error when I make a site copy.](/forum/3-bug-report/35675-database-error-when-i-make-a-site-copy#35843 "Hello, I'm trying to make a copy of my hikashop site but when I import database I have the following message error: It seems to be something related with the affiliate program. Some idea about this problem. Regards")* Hello Nicolas, > 1\. Export all the tables but the ones finishing by "\_view" on your old server. That way, you won't have the problem when importing it. Views are not critical to the functioning of HikaShop. They are just used to display the statistics of affiliations. Sorry for my bad english but I don't understand what you said in point 1. What does I have to do? Thanks for support. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMtYnVnLXJlcG9ydC8zNTY3NS1kYXRhYmFzZS1lcnJvci13aGVuLWktbWFrZS1hLXNpdGUtY29weT90bXBsPW1hcmtkb3du) 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") - [ Offline](/forum/user/63-nicolas) Less More - Posts: 86541 - Thank you received: 14304 - - 14 years 9 months ago [\#35844](#35844) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Re: database error when I make a site copy.](/forum/3-bug-report/35675-database-error-when-i-make-a-site-copy#35844 "Hello, I'm trying to make a copy of my hikashop site but when I import database I have the following message error: It seems to be something related with the affiliate program. Some idea about this problem. Regards")* When you export your database via phpmyadmin, make sure that you unselect the tables finishing with _view in their name. That's what I meant. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMtYnVnLXJlcG9ydC8zNTY3NS1kYXRhYmFzZS1lcnJvci13aGVuLWktbWFrZS1hLXNpdGUtY29weT90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[chocovo](/forum/user/4491-chocovo "View chocovo's Profile")** - [![chocovo's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/4491-chocovo "View chocovo's Profile") Topic Author - [ Offline](/forum/user/4491-chocovo) Less More - Posts: 38 - Thank you received: 0 - - 14 years 9 months ago [\#35847](#35847) by [chocovo](/forum/user/4491-chocovo "View chocovo's Profile") Replied by *[chocovo](/forum/user/4491-chocovo "View chocovo's Profile")* on topic *[Re: database error when I make a site copy.](/forum/3-bug-report/35675-database-error-when-i-make-a-site-copy#35847 "Hello, I'm trying to make a copy of my hikashop site but when I import database I have the following message error: It seems to be something related with the affiliate program. Some idea about this problem. Regards")* Ok Nicolas, thanks Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMtYnVnLXJlcG9ydC8zNTY3NS1kYXRhYmFzZS1lcnJvci13aGVuLWktbWFrZS1hLXNpdGUtY29weT90bXBsPW1hcmtkb3du) 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.051 seconds [Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org)