[Skip to main content](#vessel-content) # Import on new server. Database problem ## - **[spinosimarketing](/forum/user/31240-spinosimarketing "View spinosimarketing's Profile")** - [![spinosimarketing's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/31240-spinosimarketing "View spinosimarketing's Profile") Topic Author - [ Offline](/forum/user/31240-spinosimarketing) Less More - Posts: 10 - Thank you received: 0 - - 12 years 3 days ago [\#176871](#176871) by [spinosimarketing](/forum/user/31240-spinosimarketing "View spinosimarketing's Profile") *[Import on new server. Database problem](/forum/25-install-update/872576-import-on-new-server-database-problem#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.")* was created by *[spinosimarketing](/forum/user/31240-spinosimarketing "View spinosimarketing's Profile")* -- url of the page with the problem -- : [ www.abruzze.it](http://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](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzI1LWluc3RhbGwtdXBkYXRlLzg3MjU3Ni1pbXBvcnQtb24tbmV3LXNlcnZlci1kYXRhYmFzZS1wcm9ibGVtP3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[spinosimarketing](/forum/user/31240-spinosimarketing "View spinosimarketing's Profile")** - [![spinosimarketing's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/31240-spinosimarketing "View spinosimarketing's Profile") Topic Author - [ Offline](/forum/user/31240-spinosimarketing) Less More - Posts: 10 - Thank you received: 0 - - 12 years 3 days ago [\#176872](#176872) by [spinosimarketing](/forum/user/31240-spinosimarketing "View spinosimarketing's Profile") Replied by *[spinosimarketing](/forum/user/31240-spinosimarketing "View spinosimarketing's Profile")* on topic *[Import on new server. Database problem](/forum/25-install-update/872576-import-on-new-server-database-problem#176872 "-- 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](http://www.abruzze.it/NUOVO_SITO/index.php) Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzI1LWluc3RhbGwtdXBkYXRlLzg3MjU3Ni1pbXBvcnQtb24tbmV3LXNlcnZlci1kYXRhYmFzZS1wcm9ibGVtP3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[nicolas](/forum/user/63-nicolas "View nicolas's Profile")** - [![nicolas's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar63.png)](/forum/user/63-nicolas "View nicolas's Profile") - [ Away](/forum/user/63-nicolas) Less More - Posts: 86292 - Thank you received: 14271 - - 12 years 2 days ago [\#176896](#176896) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Import on new server. Database problem](/forum/25-install-update/872576-import-on-new-server-database-problem#176896 "-- 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.")* 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](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzI1LWluc3RhbGwtdXBkYXRlLzg3MjU3Ni1pbXBvcnQtb24tbmV3LXNlcnZlci1kYXRhYmFzZS1wcm9ibGVtP3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[spinosimarketing](/forum/user/31240-spinosimarketing "View spinosimarketing's Profile")** - [![spinosimarketing's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/31240-spinosimarketing "View spinosimarketing's Profile") Topic Author - [ Offline](/forum/user/31240-spinosimarketing) Less More - Posts: 10 - Thank you received: 0 - - 12 years 2 days ago [\#176966](#176966) by [spinosimarketing](/forum/user/31240-spinosimarketing "View spinosimarketing's Profile") Replied by *[spinosimarketing](/forum/user/31240-spinosimarketing "View spinosimarketing's Profile")* on topic *[Import on new server. Database problem](/forum/25-install-update/872576-import-on-new-server-database-problem#176966 "-- 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.")* 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](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzI1LWluc3RhbGwtdXBkYXRlLzg3MjU3Ni1pbXBvcnQtb24tbmV3LXNlcnZlci1kYXRhYmFzZS1wcm9ibGVtP3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[spinosimarketing](/forum/user/31240-spinosimarketing "View spinosimarketing's Profile")** - [![spinosimarketing's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/31240-spinosimarketing "View spinosimarketing's Profile") Topic Author - [ Offline](/forum/user/31240-spinosimarketing) Less More - Posts: 10 - Thank you received: 0 - - 12 years 2 days ago [\#176967](#176967) by [spinosimarketing](/forum/user/31240-spinosimarketing "View spinosimarketing's Profile") Replied by *[spinosimarketing](/forum/user/31240-spinosimarketing "View spinosimarketing's Profile")* on topic *[Import on new server. Database problem](/forum/25-install-update/872576-import-on-new-server-database-problem#176967 "-- 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.")* the table that i can't import i s vvcat_hikashop_click_view Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzI1LWluc3RhbGwtdXBkYXRlLzg3MjU3Ni1pbXBvcnQtb24tbmV3LXNlcnZlci1kYXRhYmFzZS1wcm9ibGVtP3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[nicolas](/forum/user/63-nicolas "View nicolas's Profile")** - [![nicolas's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar63.png)](/forum/user/63-nicolas "View nicolas's Profile") - [ Away](/forum/user/63-nicolas) Less More - Posts: 86292 - Thank you received: 14271 - - 12 years 1 day ago [\#176969](#176969) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Import on new server. Database problem](/forum/25-install-update/872576-import-on-new-server-database-problem#176969 "-- 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.")* 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](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzI1LWluc3RhbGwtdXBkYXRlLzg3MjU3Ni1pbXBvcnQtb24tbmV3LXNlcnZlci1kYXRhYmFzZS1wcm9ibGVtP3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[spinosimarketing](/forum/user/31240-spinosimarketing "View spinosimarketing's Profile")** - [![spinosimarketing's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/31240-spinosimarketing "View spinosimarketing's Profile") Topic Author - [ Offline](/forum/user/31240-spinosimarketing) Less More - Posts: 10 - Thank you received: 0 - - 12 years 10 hours ago [\#177131](#177131) by [spinosimarketing](/forum/user/31240-spinosimarketing "View spinosimarketing's Profile") Replied by *[spinosimarketing](/forum/user/31240-spinosimarketing "View spinosimarketing's Profile")* on topic *[Import on new server. Database problem](/forum/25-install-update/872576-import-on-new-server-database-problem#177131 "-- 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.")* 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](http://Www.abruzze.it), click on product in homepage to see The problem. Thanks Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzI1LWluc3RhbGwtdXBkYXRlLzg3MjU3Ni1pbXBvcnQtb24tbmV3LXNlcnZlci1kYXRhYmFzZS1wcm9ibGVtP3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[nicolas](/forum/user/63-nicolas "View nicolas's Profile")** - [![nicolas's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar63.png)](/forum/user/63-nicolas "View nicolas's Profile") - [ Away](/forum/user/63-nicolas) Less More - Posts: 86292 - Thank you received: 14271 - - 11 years 11 months ago [\#177222](#177222) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Import on new server. Database problem](/forum/25-install-update/872576-import-on-new-server-database-problem#177222 "-- 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.")* 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](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzI1LWluc3RhbGwtdXBkYXRlLzg3MjU3Ni1pbXBvcnQtb24tbmV3LXNlcnZlci1kYXRhYmFzZS1wcm9ibGVtP3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. Board Categories HikaShop- Install & Update- Product & Category Display- Content Creation- Sales and Orders- - Orders management- - Reports & Statistics- Customers- Checkout- Payment Methods- Shipping Methods- Import & Export (CSV, XLS…)- Specific Features- - Affilation- - Taxes- - Wishlist- - Vote- - Carousel & Slider- - Mass Actions- - Filters & Search- - Discount & Coupon- - Feature Request- Integrations- Showcase- General Talk about HikaShop- Development- - HikaShop 3.0 Beta- Translation- Commercial Jobs HikaShop Components- HikaMarket- - Market: Feature requests- - Market: How to?- - Market: Bug Report- HikaSerial- - General talk about HikaSerial- - Serial: Bug Report- - Serial: How to?- - Support en Français de HikaSerial (French Support)- - HikaSubscription- HikaAuction- - Auction: Feature requests- - Auction: How to?- - Auction: Bug report Hikashop around the world- Support en Français (French Support)- Russian- - FAQ. Курс выживания с Hikashop. Частые вопросы и о- - Расширения Hikashop- - Наши сайты на Hikashop- 日本語版サポート(Japanese Support)- Thai- German Archives- Bug Report- How to? [](/forum/topics/feed/mode-topics?format=feed&type=rss) Time to create page: 0.254 seconds [Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org) [](#top)