re-hosting my site SQL error on HS table import

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 `jos_hikashop_click_view`
--
DROP TABLE IF EXISTS `jos_hikashop_click_view`;

CREATE ALGORITHM=UNDEFINED DEFINER=`tisjdnfe_9041879`@`localhost` SQL SECURITY DEFINER VIEW `jos_hikashop_click_view` AS select `a`.`user_id` AS `user_id`,sum(`b`.`click_partner_price`) AS `click_price` from (`jos_hikashop_user` `a` left join `jos_hikashop_click` `b` on(((`a`.`user_id` = `b`.`click_partner_id`) and ((case when (`a`.`user_currency_id` = 0) then 2 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`;

Also same story for `jos_hikashop_lead_view` and `jos_hikashop_sale_view`.

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 :

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