Import on new server. Database problem

  • Posts: 10
  • Thank you received: 0
10 years 9 months ago #176871

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

Please Log in or Create an account to join the conversation.

  • Posts: 10
  • Thank you received: 0
10 years 9 months ago #176872

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

Please Log in or Create an account to join the conversation.

  • Posts: 84220
  • Thank you received: 13672
  • MODERATOR
10 years 9 months ago #176896

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.

Please Log in or Create an account to join the conversation.

  • Posts: 10
  • Thank you received: 0
10 years 9 months ago #176966

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?

Please Log in or Create an account to join the conversation.

  • Posts: 10
  • Thank you received: 0
10 years 9 months ago #176967

the table that i can't import i s vvcat_hikashop_click_view

Please Log in or Create an account to join the conversation.

  • Posts: 84220
  • Thank you received: 13672
  • MODERATOR
10 years 9 months ago #176969

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.

Please Log in or Create an account to join the conversation.

  • Posts: 10
  • Thank you received: 0
10 years 9 months ago #177131

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

Please Log in or Create an account to join the conversation.

  • Posts: 84220
  • Thank you received: 13672
  • MODERATOR
10 years 9 months ago #177222

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.

Please Log in or Create an account to join the conversation.

Time to create page: 0.064 seconds
Powered by Kunena Forum