Move Hikashop installation from 2.5 joomla to 3.2

  • Posts: 36
  • Thank you received: 1
11 years 4 months ago #145204

-- url of the page with the problem -- : www.christiantete-eshop.gr
-- HikaShop version -- : 2.2.3
-- Joomla version -- : 2.5.18
-- PHP version -- : 5.3.28
-- Browser(s) name and version -- : Chrome 33.0.1750.117
-- Error-message(debug-mod must be tuned on) -- : Error_message

Hello,
I want to move my Hikashop database and all modefided files to a new joomla 3.2 installation.
I tried lot of times and methods to upgrade joomla from 2.5 to 3.2 and I can't make it work.
So I want to move hikashop to the new joomla installation.

Last edit: 11 years 4 months ago by billkarv.

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

  • Posts: 84079
  • Thank you received: 13636
  • MODERATOR
11 years 4 months ago #145256

Hi,

There is nothing to do for HikaShop for the migration. Simply update joomla to 3.2 and HikaShop will still work the same on the website.

If you want to move it to another installation, make sure that you have the same version of HikaShop installed on both, then go in phpmyadmin, export all the hikashop tables from the old database and import them to the new database after deleting the HikaShop tables there. You'll also want to copy the files in media/com_hikashop from the old to the new website via FTP.

The following user(s) said Thank You: billkarv, jmbgreen

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

  • Posts: 36
  • Thank you received: 1
11 years 4 months ago #145275

Thank you so much. I 'll try this. It seems to be so easy. :D

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

  • Posts: 36
  • Thank you received: 1
11 years 4 months ago #145326

I 've applied the 2nd solution. I 've copied the database tables and the com_hikashop folder and everything works fine.

Thank you once more Nicolas.

Last edit: 11 years 4 months ago by billkarv.

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

  • Posts: 36
  • Thank you received: 1
11 years 4 months ago #147404

I copied database tables and media/com_hikashop folder but the settings on the new installation of joomla resets automatically and I am loosing all of my settings. No shipping method is set, no payment method etc... The customers and all the other thinks are OK.

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

  • Posts: 26256
  • Thank you received: 4041
  • MODERATOR
11 years 4 months ago #147406

Hi,

The shipping configurations are stored in the table "hikashop_shipping", the payment configurations in "hikashop_payment" etc.

Regards,

Jerome - Obsidev.com
HikaMarket & HikaSerial developer / HikaShop core dev team.

Also helping the HikaShop support team when having some time or couldn't sleep.
By the way, do not send me private message, use the "contact us" form instead.

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

  • Posts: 36
  • Thank you received: 1
11 years 4 months ago #147547

Thanks Jerome for your answer. I copied these tables and I have all of my shipping and payment methods but in the settings is auto applying some kind of reset to my settings and is all unpublished etc, etc... And I have to do that work from the begining. I am loosing time on that. Thank you...

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

  • Posts: 84079
  • Thank you received: 13636
  • MODERATOR
11 years 4 months ago #147556

The main settings of HikaShop are in the hikashop_config table. So you would have to copy that table too if you want them back.

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

  • Posts: 15
  • Thank you received: 1
10 years 8 months ago #176537

Nicolas,

I am preparing to do the same task, importing from a 2.5 site to 3.3. Looking at the 2.5 database the tables have a jos_ prefix and in 3.3.6 the prefix I believe can be a random configuration. Is it important to align the prefixes before importing the tables? If so, is it as simple as renaming the exported table?
Example:
jos_hikashop_category to tthn_hikashop_category and then importing the table.

Gr3

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

  • Posts: 26256
  • Thank you received: 4041
  • MODERATOR
10 years 8 months ago #176548

Hi,

You can export the tables and rename them in the SQL file.
You can copy the "jos" tables and export them.
You can import the tables in the new database and then rename them.

You have several possibilies to achieve it ; but yes, it is important that the imported tables have the same prefix that the rest of your joomla 3 tables.

Regards,

Jerome - Obsidev.com
HikaMarket & HikaSerial developer / HikaShop core dev team.

Also helping the HikaShop support team when having some time or couldn't sleep.
By the way, do not send me private message, use the "contact us" form instead.
The following user(s) said Thank You: iamgr3

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

  • Posts: 15
  • Thank you received: 1
10 years 8 months ago #176840

Thank you!

It took some work, but everything came over great. Here were the steps if anyone want to know. Feel free to correct anything that could be done better.
1. Made sure current verison of hikashop was in place both sites
2. Exported all hikashop tables as one file in MySql
3. In sql file, replaced name of the table name with new one
4. In sql file, did a find/replace on all "jos_" and replaced with new "xxx_" saved the file
5. In Mysql dropped all Hikashop tables (would have been nice to know the sql statement that would have dropped them all with one command)
6. Imported new modified sql file into database.

Gr3

The following user(s) said Thank You: curlz

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

Time to create page: 0.090 seconds
Powered by Kunena Forum