[Skip to main content](#vessel-content)

#   re-hosting my site SQL error on HS table import

##

- **[cpreen](/forum/user/604-cpreen "View cpreen's Profile")**
- [![cpreen's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/604-cpreen "View cpreen's Profile") Topic Author
- [ Offline](/forum/user/604-cpreen)

Less More

- Posts: 98
- Thank you received: 3
-
-

13 years 3 months ago [\#117252](#117252) by [cpreen](/forum/user/604-cpreen "View cpreen's Profile")  *[re-hosting my site SQL error on HS table import](/forum/25-install-update/860692-re-hosting-my-site-sql-error-on-hs-table-import#117252 "Hi,  I've been trying to set up my site on a new host and come across a problem I've never seen before. I exported my database as SQL using phpMyAdmin and imported to the DB on the new host again with phpMyAdmin. The import process gave the following error:  &quot; Access denied: you need the SUPER priviledge for this operation&quot;  Here the SQL that caused the problem:  -- Structure for view &#96;jos&#95;hikashop&#95;click&#95;view&#96; -- DROP TABLE IF EXISTS &#96;jos&#95;hikashop&#95;click&#95;view&#96;;  CREATE ALGORITHM=UNDEFINED DEFINER=&#96;tisjdnfe&#95;9041879&#96;@&#96;localhost&#96; SQL SECURITY DEFINER VIEW &#96;jos&#95;hikashop&#95;click&#95;view&#96; AS select &#96;a&#96;.&#96;user&#95;id&#96; AS &#96;user&#95;id&#96;,sum(&#96;b&#96;.&#96;click&#95;partner&#95;price&#96;) AS &#96;click&#95;price&#96; from (&#96;jos&#95;hikashop&#95;user&#96; &#96;a&#96; left join &#96;jos&#95;hikashop&#95;click&#96; &#96;b&#96; on(((&#96;a&#96;.&#96;user&#95;id&#96; = &#96;b&#96;.&#96;click&#95;partner&#95;id&#96;) and ((case when (&#96;a&#96;.&#96;user&#95;currency&#95;id&#96; = 0) then 2 else &#96;a&#96;.&#96;user&#95;currency&#95;id&#96; end) = &#96;b&#96;.&#96;click&#95;partner&#95;currency&#95;id&#96;)))) where ((&#96;a&#96;.&#96;user&#95;partner&#95;activated&#96; = 1) and (&#96;b&#96;.&#96;click&#95;partner&#95;paid&#96; = 0)) group by &#96;b&#96;.&#96;click&#95;partner&#95;id&#96;;  Also same story for &#96;jos&#95;hikashop&#95;lead&#95;view&#96; and &#96;jos&#95;hikashop&#95;sale&#95;view&#96;.  When I checked these tables the actual data in them is the same on both hosts. I'm not so familiar with SQL that I fully understand what this statement does, but it looks as though it installs a piece of code which runs when the DB is modified - correct? So my question is will HS function correctly on the new host given that this error occurred?  I can't seem to set SUPER privilege so I'm puzzled by the error and not sure what if anything needs doing. Can you enlighten me?  Conrad")* was created by *[cpreen](/forum/user/604-cpreen "View cpreen's Profile")*

Hi,

I've been trying to set up my site on a new host and come across a problem I've never seen before. I exported my database as SQL using phpMyAdmin and imported to the DB on the new host again with phpMyAdmin. The import process gave the following error:

" Access denied: you need the SUPER priviledge for this operation"

Here the SQL that caused the problem:

-- Structure for view &#96;jos_hikashop_click_view&#96;
--
DROP TABLE IF EXISTS &#96;jos_hikashop_click_view&#96;;

CREATE ALGORITHM=UNDEFINED DEFINER=&#96;tisjdnfe_9041879&#96;@&#96;localhost&#96; SQL SECURITY DEFINER VIEW &#96;jos_hikashop_click_view&#96; AS select &#96;a&#96;.&#96;user_id&#96; AS &#96;user_id&#96;,sum(&#96;b&#96;.&#96;click_partner_price&#96;) AS &#96;click_price&#96; from (&#96;jos_hikashop_user&#96; &#96;a&#96; left join &#96;jos_hikashop_click&#96; &#96;b&#96; on(((&#96;a&#96;.&#96;user_id&#96; = &#96;b&#96;.&#96;click_partner_id&#96;) and ((case when (&#96;a&#96;.&#96;user_currency_id&#96; = 0) then 2 else &#96;a&#96;.&#96;user_currency_id&#96; end) = &#96;b&#96;.&#96;click_partner_currency_id&#96;)))) where ((&#96;a&#96;.&#96;user_partner_activated&#96; = 1) and (&#96;b&#96;.&#96;click_partner_paid&#96; = 0)) group by &#96;b&#96;.&#96;click_partner_id&#96;;

Also same story for &#96;jos_hikashop_lead_view&#96; and &#96;jos_hikashop_sale_view&#96;.

When I checked these tables the actual data in them is the same on both hosts. I'm not so familiar with SQL that I fully understand what this statement does, but it looks as though it installs a piece of code which runs when the DB is modified - correct? So my question is will HS function correctly on the new host given that this error occurred?

I can't seem to set SUPER privilege so I'm puzzled by the error and not sure what if anything needs doing. Can you enlighten me?

Conrad

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzI1LWluc3RhbGwtdXBkYXRlLzg2MDY5Mi1yZS1ob3N0aW5nLW15LXNpdGUtc3FsLWVycm9yLW9uLWhzLXRhYmxlLWltcG9ydD90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation.

- **[Mohamed Thelji](/forum/user/6861-mohamed-thelji "View Mohamed Thelji's Profile")**
- [![Mohamed Thelji's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar6861.png)](/forum/user/6861-mohamed-thelji "View Mohamed Thelji's Profile")
- [ Offline](/forum/user/6861-mohamed-thelji)

Less More

- Posts: 12953
- Thank you received: 1778
-
-
-

13 years 3 months ago -  13 years 3 months ago [\#117278](#117278) by [Mohamed Thelji](/forum/user/6861-mohamed-thelji "View Mohamed Thelji's Profile")  Replied by *[Mohamed Thelji](/forum/user/6861-mohamed-thelji "View Mohamed Thelji's Profile")* on topic *[re-hosting my site SQL error on HS table import](/forum/25-install-update/860692-re-hosting-my-site-sql-error-on-hs-table-import#117278 "Hi,  I've been trying to set up my site on a new host and come across a problem I've never seen before. I exported my database as SQL using phpMyAdmin and imported to the DB on the new host again with phpMyAdmin. The import process gave the following error:  &quot; Access denied: you need the SUPER priviledge for this operation&quot;  Here the SQL that caused the problem:  -- Structure for view &#96;jos&#95;hikashop&#95;click&#95;view&#96; -- DROP TABLE IF EXISTS &#96;jos&#95;hikashop&#95;click&#95;view&#96;;  CREATE ALGORITHM=UNDEFINED DEFINER=&#96;tisjdnfe&#95;9041879&#96;@&#96;localhost&#96; SQL SECURITY DEFINER VIEW &#96;jos&#95;hikashop&#95;click&#95;view&#96; AS select &#96;a&#96;.&#96;user&#95;id&#96; AS &#96;user&#95;id&#96;,sum(&#96;b&#96;.&#96;click&#95;partner&#95;price&#96;) AS &#96;click&#95;price&#96; from (&#96;jos&#95;hikashop&#95;user&#96; &#96;a&#96; left join &#96;jos&#95;hikashop&#95;click&#96; &#96;b&#96; on(((&#96;a&#96;.&#96;user&#95;id&#96; = &#96;b&#96;.&#96;click&#95;partner&#95;id&#96;) and ((case when (&#96;a&#96;.&#96;user&#95;currency&#95;id&#96; = 0) then 2 else &#96;a&#96;.&#96;user&#95;currency&#95;id&#96; end) = &#96;b&#96;.&#96;click&#95;partner&#95;currency&#95;id&#96;)))) where ((&#96;a&#96;.&#96;user&#95;partner&#95;activated&#96; = 1) and (&#96;b&#96;.&#96;click&#95;partner&#95;paid&#96; = 0)) group by &#96;b&#96;.&#96;click&#95;partner&#95;id&#96;;  Also same story for &#96;jos&#95;hikashop&#95;lead&#95;view&#96; and &#96;jos&#95;hikashop&#95;sale&#95;view&#96;.  When I checked these tables the actual data in them is the same on both hosts. I'm not so familiar with SQL that I fully understand what this statement does, but it looks as though it installs a piece of code which runs when the DB is modified - correct? So my question is will HS function correctly on the new host given that this error occurred?  I can't seem to set SUPER privilege so I'm puzzled by the error and not sure what if anything needs doing. Can you enlighten me?  Conrad")*

Hi,

I think that you'll maybe find some answer [ there](http://www.hikashop.com/forum/2-general-talk-about-hikashop/49551-mysql-problem-after-transfer-to-a-new-domain.html) :

> 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.

If you can't resolve your "SUPER priviledge" error another solution will maybe be to :
- Choose the right tables and to only import the good database table like "hikashop_order" and "hikashop_order_product" for your previous orders
- Import your products through a CSV file that you exported through your old website

Last edit: 13 years 3 months ago by [Mohamed Thelji](/forum/user/6861-mohamed-thelji "View Mohamed Thelji's Profile").

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzI1LWluc3RhbGwtdXBkYXRlLzg2MDY5Mi1yZS1ob3N0aW5nLW15LXNpdGUtc3FsLWVycm9yLW9uLWhzLXRhYmxlLWltcG9ydD90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation.

Board Categories HikaShop Install &amp; Update Product &amp; Category Display Content Creation Sales and Orders Orders management Reports &amp; Statistics Customers Checkout Payment Methods Shipping Methods Import &amp; Export (CSV, XLS…) Specific Features Affilation Taxes Wishlist Vote Carousel &amp; Slider Mass Actions Filters &amp; Search Discount &amp; 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.040 seconds

[Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org)
