Update J 2.5 HS 2.2.1 to J 3.3 HS 2.3.5

  • Posts: 47
  • Thank you received: 0
10 years 7 months ago #186400

-- url of the page with the problem -- : www.volkan-watches.com
-- HikaShop version -- : 2.3.5
-- Joomla version -- : 3.2
-- PHP version -- : 5.3
-- Browser(s) name and version -- : Chrome

Hi,

I update a Joomla 2.5 with Hikashop 2.2.1 to Joomla 3.3 Hikashop 2.3.5

Do you have a documentation on how to do this?

I updated the site but now must export part of the DB such as Users and Orders from the old site that were created while updating the site and importing them to the new site.

If you could tell me which tables I have to export / import that would be helpful thank you.

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

  • Posts: 13201
  • Thank you received: 2322
10 years 7 months ago #186401

Hi,

The best thing will be to update the HikaShop version on the J2.5 in order to have the last one and all the new tables/columns.
Then backup, and export all the HikaShop tables, and the Joomla user, usergroup etc tables too.

Finally import all the tables in the J3.3.

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

  • Posts: 47
  • Thank you received: 0
10 years 7 months ago #186643

Hi,

I just did that and get the following error:

Fehler
SQL-Befehl:




--
-- Daten für Tabelle `volk_hikashop_address`
--

INSERT INTO `volk_hikashop_address` (`address_id`, `address_user_id`, `address_title`, `address_firstname`, `address_middle_name`, `address_lastname`, `address_company`, `address_street`, `address_post_code`, `address_city`, `address_telephone`, `address_telephone2`, `address_fax`, `address_state`, `address_country`, `address_published`, `address_vat`, `address_default`, `address_street2`) VALUES
(1, 2, 'Mr', 'Sven', NULL, 'Grossenbacher', NULL, 'Sorondongo 4', '35560', 'Tinajo', '34696518278', NULL, NULL, 'state_Las_Palmas_3513', 'country_Spain_195', 1, NULL, 1, ''),
(14, 18, 'Mr', 'Sven', NULL, 'Grossenbacher', NULL, 'Sorondongo 4', '35560', 'Palo Alto', '34696518278', NULL, NULL, 'state_California_4265', 'country_United_States_of_America_223', 1, NULL, 1, ''),
(5, 10, 'Mr', 'Evelyn', NULL, 'McLoughlin', NULL, '74 Tullyvoheen', '0000', 'Clifden', '0871151295', NULL, NULL, 'state_Gaillimh_1827', 'country_Ireland_103', 1, NULL, 1, '[...]
MySQL meldet: Dokumentation

#1062 - Duplicate entry '1' for key 'PRIMARY'


Any idea?

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

  • Posts: 47
  • Thank you received: 0
10 years 7 months ago #186644

Hi again,

When dumping the tables I needed to tick the box: DROP TABLE / VIEW / PROCEDURE / FUNCTION / EVENT / TRIGGER-.....

works now thanks.

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

Time to create page: 0.056 seconds
Powered by Kunena Forum