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:
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?