[Skip to main content](#vessel-content) # MySQL problem after transfer to a new domain ## - **[gasoline](/forum/user/6454-gasoline "View gasoline's Profile")** - [![gasoline's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar6454.jpg)](/forum/user/6454-gasoline "View gasoline's Profile") Topic Author - [ Offline](/forum/user/6454-gasoline) - Still searching ... Less More - Posts: 247 - Thank you received: 9 - - - - [](https://gasoline.nl) - 14 years 5 months ago - 14 years 5 months ago [\#49551](#49551) by [gasoline](/forum/user/6454-gasoline "View gasoline's Profile") *[MySQL problem after transfer to a new domain](/forum/2-general-talk-about-hikashop/49551-mysql-problem-after-transfer-to-a-new-domain#49551 "I'm moving a Joomla site with Hikashop to a new domain. After import of the old dbase to the new domain area I get this error message: I can see that f.e. the table xxxx_hikashop_click_view is not there in the new environment. What is going wrong. I don't get it?")* was created by *[gasoline](/forum/user/6454-gasoline "View gasoline's Profile")* I'm moving a Joomla site with Hikashop to a new domain. After import of the old dbase to the new domain area I get this error message: Code: Error SQL query: Documentation CREATE ALGORITHM = UNDEFINED DEFINER = `yongo_sarah`@`localhost` SQL SECURITY DEFINER VIEW `xxxx_hikashop_click_view` AS SELECT `a`.`user_id` AS `user_id` , sum( `b`.`click_partner_price` ) AS `click_price` FROM ( `xxxx_hikashop_user` `a` LEFT JOIN `xxxx_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 said: Documentation #1227 - Access denied; you need the SUPER privilege for this operation I can see that f.e. the table xxxx_hikashop_click_view is not there in the new environment. What is going wrong. I don't get it? --- I'll keep on trying! Last edit: 14 years 5 months ago by [gasoline](/forum/user/6454-gasoline "View gasoline's Profile"). Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzItZ2VuZXJhbC10YWxrLWFib3V0LWhpa2FzaG9wLzQ5NTUxLW15c3FsLXByb2JsZW0tYWZ0ZXItdHJhbnNmZXItdG8tYS1uZXctZG9tYWluP3RtcGw9bWFya2Rvd24=) 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: 86320 - Thank you received: 14279 - - 14 years 5 months ago [\#49608](#49608) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Re: MySQL problem after transfer to a new domain](/forum/2-general-talk-about-hikashop/49551-mysql-problem-after-transfer-to-a-new-domain#49608 "I'm moving a Joomla site with Hikashop to a new domain. After import of the old dbase to the new domain area I get this error message: I can see that f.e. the table xxxx_hikashop_click_view is not there in the new environment. What is going wrong. I don't get it?")* The problem is written here: Access denied; you need the SUPER privilege for this operation Your hosting company does not allow you to create views. Just remove the view tables from the mysql export and run the import and you won't have the problem. These views are only used for the calculations of affiliate fees on some screens. If they aren't there, you won't get the calculations everywhere, but you will still be able to use the affiliate system. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzItZ2VuZXJhbC10YWxrLWFib3V0LWhpa2FzaG9wLzQ5NTUxLW15c3FsLXByb2JsZW0tYWZ0ZXItdHJhbnNmZXItdG8tYS1uZXctZG9tYWluP3RtcGw9bWFya2Rvd24=) 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.076 seconds [Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org) [](#top)