Import on new server. Database problem

-- url of the page with the problem -- : www.abruzze.it
-- HikaShop version -- : 2.3.3
-- Joomla version -- : 3.3.3

HI!
I complete the development of my website using joomla and hikashp.
This site in on temporary server.
I have download all the site file and database and upload database and file on new server.
When i import database there is this error on one hikashop table:

CREATE ALGORITHM = UNDEFINED DEFINER = `italianlifedes`@`localhost` SQL SECURITY DEFINER VIEW `vvcat_hikashop_click_view` AS SELECT `a`.`user_id` AS `user_id` , SUM( `b`.`click_partner_price` ) AS `click_price`
FROM (

`vvcat_hikashop_user` `a`
LEFT JOIN `vvcat_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` ;

Messaggio di MySQL: Documentazione

#1227 - Access denied; you need (at least one of) the SUPER privilege(s) for this operation


My website is ok. All links in ok but when i click on a product (hikashop) i'm linking to the old website.
Why? How can I resolve it?
thanks.

Now the website is offline. To see it on new server go to www.abruzze.it/NUOVO_SITO/index.php

Hi,

You can remove the _view "tables" from your export before the import of the SQL file in order to avoid that error.
You can also make sure that your MySQL has enough privilege to be able to create these "tables" that are actually not tables but views.

i can remove and export db from old fb?
and what i import in new db?
I must recreate the view on the new db?

the table that i can't import i s vvcat_hikashop_click_view

Hi,

You don't need the views. It's not just hikashop_click_view but also hikashop_sale_view and hikashop_lead_view
You can just delete them in your old database and then do the migration again and it will work.

Ok thanks.
I'va remove the _view table and it's ok for the menu but if i click on product in hikashop module i ma linked to old website.
Www.abruzze.it , click on product in homepage to see The problem.
Thanks

Hi,

This indicates that you must have the old domain name in the "canonical URL" setting of your products. Edit them via the backend and check that option.