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