I started building my website in Xampp and am uploading it to my x10hosting website. I have the files uploaded but I ran into an issue with importing the SQL file.
Here is the error I am receiving:
Here is the error I am receiving:
Error
SQL query:
CREATE ALGORITHM = UNDEFINED DEFINER = `root`@`localhost` SQL SECURITY DEFINER VIEW `joom_hikashop_click_view` AS SELECT `a`.`user_id` AS `user_id` , sum( `b`.`click_partner_price` ) AS `click_price`
FROM (
`joom_hikashop_user` `a`
LEFT JOIN `joom_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:
#1227 - Access denied; you need (at least one of) the SUPER privilege(s) for this operation