Author Topic: Migrate to Joomla 1.5 bringing VirtueMart along - Tutorial  (Read 43798 times)

FnF

  • Beginner
  • *
  • Posts: 16
Migrate to Joomla 1.5 bringing VirtueMart along - Tutorial
« on: September 18, 2009, 04:04:10 am »
Couple of things I'd like to mention here up front;

A- Do not delete your current 1.0.x installation of Joomla....yet.


B- You MUST have a minimum of Virtuemart 1.1.3 running correctly on your existing Joomla 1.0 site for the migration to be successful. So if need be, upgrade VM first.
It's as simple as uploading a file, and extracting to over write. When you log into your VM admin it notices the updates and runs the DB query bringing your install up to date.


C- You'll also need an SQL file to upload during the migration.
So you'll need to download the latest version of the Joomla Migrator found here and upload it to your current 1.0x site by using the component installer.


D- Your going to need some Virtuemart plugins for your new migrator in order for Virtuemart to accompany you on this journey. Virtuemart ETL Plugins can downloaded here.
They can be added to the Migrator by clicking Components > Migrator, and then clicking "add 3rd party plugins" from the bottom of the Migrator screen. This never did work for me.
      So I uploaded the zipped plugin package to administrator/components/com_migrator/plugins, and unzipped it there.


E- Now you can go back to your Joomla admin panel and click on components > Migrator, and then "list plugins" at the bottom to verify they are there.

If all is well, click back to get to the front page of the Migrator and click "Create Migration SQL File" from the bottom right.
It'll list the plugins again it's going to create the sql dump for, and at the bottom of the page now you'll see a "start migration" link. You can click that.
The migrator will create the file and go through a couple sequences, and when it's finished you'll be presented with a "MIGRATION COMPLETE" at the top of the page.
Dont be fooled, your migration is far from complete, but your sql file for the migration is complete. LOL. Click the "Download" button in the lower left, and you'll see your sql file listed. You may download it from there.
I suggest saving it to place you can readily find it later. You'll need it soon.


      F- Now you may log out of your old Joomla1.0.x, were done there.


----------------------------------------------------

And here we go. Migrating Joomla1.0 to 1.5X and bringing Virtuemart With.
The hype about migrating to J1.5 first and then upgrading to the latest from there seems to be nothing more then that, hype. I've done it from 1.0 to 1.5.12 with no problems.

      1- The first thing you want to do is download the latest version of Joomla here. You'll want the full package and not the upgrade.


      2- Create a new directory in your sites control panel and upload the zipped Joomla version you've just downloaded. Do not try to over write your existing 1.0 files with it by placing it in the same home directory.
      And yes you'll need to set up a new database for your new J1.5 site.


      3- As with any new Joomla install, extract the zipped file, and then visit the url of the directory you uploaded to, to run the installer.

            4- When you get to the installation step that asks for your site name, instead of adding that info, scroll down to the bottom, add the table prefix for your old joomla install which is most likely "jos_" without the quotes.
            Your old site encoding is most likely iso-8859-1, if not adjust that accordingly.
            Then click the browse button to upload the sql dump file you created earlier and downloaded from the Migrator component in your old joomla install.
            Finally put a check in the box stating this is a 1.0 migration script, and click "Upload and Execute"


If everything went as planned you'll be presented with a "Migration Successful, please press next to continue and it will ask you for your site name, email and password info again. Fill this out and click next.

Your Done...with the initial install anyway. :D
From here you can either visit your new site or go straight to the admin panel.
Don't be alarmed if you go straight to the site's front page and things seem a little off. Remember your just migrated to a whole new version and things are much different, plus you'll automatically be set up on a different template. You can adjust things, and add templates later. Right now lets get your Virtuemart content, products etc, working.

The sql dump file you uploaded added all your content from the old Joomla install, and with the Virtuemart plugins, your Virtuemart tables were added to the database.
Now we need to install Virtuemart so you and your viewers can access that content.
This Virtuemart installation process is going to be much different then your old one. So dont just hop over to Virtuemart downloads and think you can download it and install it with the handy component installer within Joomla, and be done.
This gets tricky, so take your time, and be thorough.

--------------------------------------------------

The Virtuemart Part (hey that rhymed!) 8)
Now visit Virtuemarts download page and download the "Complete Package for Joomla! 1.5".
This is not the typical VM package some of you may used to, so remember you cant upload it as it is. It's actually made up of several more zip files, and again this is where I think most of you are getting confused. Take your time.

1- Unzip the VM zip file to a new directory on your desktop so you can work with the many files within it. You'll notice a lot of goodies in there. Non of it is edible though.

2- Now the first file you'll need to deal with is the "com_virtuemart_1.1.3.j15.zip". You are SUPPOSE to be able to install this as a component through the installer of your new Joomla site, but not as you'd expect.
Inside the admin panel of your new Joomla install, under Extensions is where you install it from but uploading it as a package by using the first option there has been completely ignored by Firefox, and gives fits to Microsoft Internet Explorer.
So your best bet is to jump down to the "Install from directory" option.
Upload the zipped com_virtuemart_1.1.3.j15.zip file to the "tmp" directory of your new Joomla install with Cpanel or what ever you use to access your site files.
Now you can go back to the Admin panel > Extensions > Install/Uninstall, and list the path in the second option (install from directory) and click install.

When it's done it'll take you to a Welcome to Virtuemart panel.
Settle down, were just getting started.
From there be sure to click "Go Directly to Shop". Do not install sample data if you want your prior items to be migrated over.
Go to the the shop, click Admin > Configuration, and then Save. Some tutorials say you need to do this. I do not no if it's necessarily a requirement, but I did do it.

3- This next step is going to be the tough part for some of you. For some reason in all my failed attempts I was never able to actually get the content of my old Virtuemart, products, prices, users etc, to migrate over with the sql dump file.
I know the migrator sql dump creates the tables, so I wanted to make sure the right data was in the tables by exporting my own dump file.
To do that you can go through PHPMyAdmin.

Inside PHPMyAdmin, click the database on the right for your old Joomla install and then choose export from the tabs at the top.
Your presented with a list of tables within that database.
Highlight each of the tables within that list that begin with jos_vm_ by clicking them and holdin your Ctr or CTRL key.
It will be nearly half of them and it'll be the lower half.
Once they are highlighted scroll down and make sure SQL is ticked below the list of tables. Also place a tick under Structure where it reads, Add DROP TABLE / VIEW / PROCEDURE / FUNCTION and then click "GO" in the lower right hand corner.

The next page is your SQL query. Place your mouse inside the window with the text, holding the ctrl key and click A. This highlights all the text.

Now right click the highlighted text and choose copy from the menu that appears.

Now scroll back up and click the home button in the upper left corner.

From there click the database name for your NEW Joomla install.

Once that opens click SQL from the tabs near the top, and you'll be presented with an SQL window.

Click once in the window to get your flashing cursor, then right click and choose paste this time from the drop down menu that appears.

Then click "GO" from the lower right.

4- You can now log out of PHPMyAdmin. The content of your old Virtuemart tables has been copied to your new Joomla database.
Want to take a break? ...or should we keep going going? LOL Were almost done.

5- Now we go back to the admin section of your new Joomla site. Were going to install some more pieces of that so called Complete Virtuemart package you downloaded and unzipped to your desktop earlier.
Go to Admin > Extensions > Install/Uninstall
The rest of the uploads done through your admin panel will play nice with Firefox and M.I.E., so were going to use the first option in there which is "Upload Package File", from now on.

Click browse and find the file inside your unzipped VM Complete directory titled mod_virtuemart_1.1.3.j15.zip. It's going to be inside the modules directory of that unzipped VM package and along with about 12 other zip files, so take your time.
Then click upload and install.

6- Now you should go to Admin > Modules, and enable the Virtuemart Mod you just installed, by clicking the red X to the right of it in your module list.

7- Now you can go back to Admin > Extensions > Install/Uninstall, and in the same fashion as you just did, finish uploading and installing all the remaining files within the module directory of that VM complete package.
Be sure to go back and enable them when your finished with them all. As described in step 6

8- Once your done with that, done the same way, you can upload and install the two files found within the "Plugin" directory of the VM Complete package.

Your Done!

If everything went right, and it certainly should, your cart should now be fully functional as it was before, but with tons of new features and a whole lot easier to use.

You can now start to rearrange the modules and content on your sites front page to suit your needs, since it most likely will not be a replica of your old site, due to the fact that the templates will be different.

The only thing that may not have migrated over for you regarding your Virtuemart install would be the images. Meaning product images, category images etc. And those can easily be copied over with your Cpanel by copying the entire directory components/com_virtuemart/shop_image/product directory to your new install and over writing the existing one with your old one.
Just be sure to place it where it goes by following the same path.

Once you've finished tweaking your site and making all the adjustments needed to make it presentable, you can remove your old version by moving all the files to a different directory in case you find you need something later, and then moving the new install to it's directory.
You'll have to edit a couple paths in your config file to match, but it's easily done.

If this tutorial helps 1 person, I'll consider it time well spent to set down and type it out.
I fought with this migration for weeks before finally figuring it out, and personally I think the tutorials out there, what few of them there are, leave out too much information, that a lot of them are taking for granted folks know.

-->ADDENDUMS<--

** Virtuemart applications using PayPal payment methods

The PayPal information, (your PayPal address) doesn't seem to be following along with the migration. Most likely for security reasons. ???

Never the less, you will need to re edit your PayPal configuration once migrated. Which also includes removing the PayPal payment method from 'test mode'.
----------------------------------------------
** Some servers and some zip files may have a tendency to NOT retain their appropriate permissions when extracting.
Which means that if you upload a zip a file to overwrite while either doing your migration or when putting the finishing touches on your new 1.5.x site, you may find that all of a sudden your faced with server errors, or page denied etc.

Before you panic, and uninstall, or delete everything, there's a 98% chance that this is simply a permissions issue caused by the zip file you just extracted to overwrite, not retaining the proper permissions.

If you are running either Suphp or Suexec, or both, on your server or your host is, this is especially true.
Go in through an FTP program WinSCP or something similar to check or re-edit permissions. Dont rely on Cpanel or Plesk to show you the right permissions due to caching issues especially if you've just overwrote the files.
---------------------------------------------

PRO

  • Global Moderator
  • Super Hero
  • *
  • Posts: 10272
  • VirtueMart Version: 3+
Re: Migrate to Joomla 1.5 bringing VirtueMart along - Tutorial
« Reply #1 on: September 18, 2009, 13:48:43 pm »
Thanks FNF

The original tutorial can be found HERE
http://forum.joomla.org/viewtopic.php?f=430&t=419087&p=1770173


I asked FNF to post this over here. So he might answer specific questions in the original thread.

Dont blame his if he does not though. This is a very thorough tutorial.
I do NOT do development work for hire.

FnF

  • Beginner
  • *
  • Posts: 16
Re: Migrate to Joomla 1.5 bringing VirtueMart along - Tutorial
« Reply #2 on: September 19, 2009, 00:42:17 am »
N.P., I hope some folks find it helpful.

SparksArts

  • Jr. Member
  • **
  • Posts: 82
    • Sparks Arts
Re: Migrate to Joomla 1.5 bringing VirtueMart along - Tutorial
« Reply #3 on: October 14, 2009, 03:36:14 am »
This saved me a whole lot of wasted time. I kept getting stuck with the VirtueMart install deleting all my products/categories. Your fix in phpMyAdmin is what saved me. I would have never figured it out on my own.

Thank you!
Richard
Richard Sparks, Website Developer

ufo_hk

  • Jr. Member
  • **
  • Posts: 72
    • 4success Ltd
Re: Migrate to Joomla 1.5 bringing VirtueMart along - Tutorial
« Reply #4 on: November 01, 2009, 23:58:15 pm »
Thanks a great set of instructions which allowed me to upgrade a couple of VM sites including a 2000 product site.

A couple of points which I think need clarification in the original instructions:

1/ At the point where you upgrade VM from 1.0.15 to VM 1.1.0 the joomla data displayed in particular on the front page will be incorrect (VM content display is fine). However if you press on with the install (ignore content layout) when joomla is upgraded to 1.5.X content layout is corrected, although the menus had to be rebuilt.

2/ The instructions clearly indicate you need to upload the product images from the old site.
However in most cases you will want to also upload the content images for joomla content i.e. the root "images" and subfolders.

Also I have one recommendation, if the original site database is on Mysql4 where you can upgrade this to Mysql5 and ensure it is running correctly. As I noticed on a couple of other upgrades doing the migration which includes a upgrade in Mysql can cause other issues.

Again thanks for the migration instructions.

latristesse

  • Beginner
  • *
  • Posts: 23
Re: Migrate to Joomla 1.5 bringing VirtueMart along - Tutorial
« Reply #5 on: November 02, 2009, 01:35:46 am »
Do you think we need to upgrade our VM install to 1.1.4 from 1.1.3 to migrate as well or can we stay on 1.1.3 to save ourselves from the upgrade before migration?

PRO

  • Global Moderator
  • Super Hero
  • *
  • Posts: 10272
  • VirtueMart Version: 3+
Re: Migrate to Joomla 1.5 bringing VirtueMart along - Tutorial
« Reply #6 on: November 02, 2009, 01:44:47 am »
I would stick with 1.1.3 for the migration, and test after, and then when all is well

upgrade to 1.1.4

I do NOT do development work for hire.

Carlos Mateos

  • Beginner
  • *
  • Posts: 9
Re: Migrate to Joomla 1.5 bringing VirtueMart along - Tutorial
« Reply #7 on: November 02, 2009, 23:16:25 pm »
Hi!

I had a problem using this tutorial, my db is 12MB, and the systems, or my system only allows 6MB.

I have used the mtvmigrator succesfully, i recomend this component 100%. It has integrated the VM migration.

Carlos.

asiams

  • Beginner
  • *
  • Posts: 8
Re: Migrate to Joomla 1.5 bringing VirtueMart along - Tutorial
« Reply #8 on: November 28, 2009, 16:23:40 pm »
Quote
B- You MUST have Virtuemart 1.1.3 running correctly on your existing Joomla 1.0 site for the migration to be successful. So if need be, upgrade VM first.
It's as simple as uploading a file, and extracting to over write. When you log into your VM admin it notices the updates and runs the DB query bringing your install up to date.

Hello,

I have been following this instruction on migration. Above step was taken with easy. But after that, there are many problems like unable to click after a product was added to the cart.

I am using Joomla 1.0.15 with VM 1.0.15. I have downloaded VM1.1.3 for Joomla1.0 for manual installation. I have unzipped it and FTPed to the site to write over. I went to the admin site, deleted install.php and configuration was saved.

I thought everything went well, but some site effects began to take place.

I did not think this would cause the problem.

Here is my question:

After VM upgrade to 1.1.3 on the same Joomla 1.0.15, I was not able to find all of the modules listed on the installed module list. The same is true for the mambots.

How can I make sure all of the 13 modules and 3 mambots are installed right on the upgrade of VM1.1.3?

Thanks.

PRO

  • Global Moderator
  • Super Hero
  • *
  • Posts: 10272
  • VirtueMart Version: 3+
Re: Migrate to Joomla 1.5 bringing VirtueMart along - Tutorial
« Reply #9 on: November 28, 2009, 18:48:45 pm »
unable to click after a product was added to the cart.

what do you mean unable to click?
I do NOT do development work for hire.

asiams

  • Beginner
  • *
  • Posts: 8
Re: Migrate to Joomla 1.5 bringing VirtueMart along - Tutorial
« Reply #10 on: November 29, 2009, 00:09:19 am »
Sorry for the lack of explanation.

When I try to click the ajax box with options to continue to shop or go to cart, it just stays hanging on the screen without going anywhere. The Ajax box continues to show, but the scroll bar moves and other click area works so I can go to other clickable menu.

That is the phenomenon I experience.

Thanks

PRO

  • Global Moderator
  • Super Hero
  • *
  • Posts: 10272
  • VirtueMart Version: 3+
Re: Migrate to Joomla 1.5 bringing VirtueMart along - Tutorial
« Reply #11 on: November 29, 2009, 14:17:36 pm »
might be a template problem. A java conflict


There is also a setting in the java file that determinesz how many seconds the box stays there
I do NOT do development work for hire.

qme1ster

  • Full Member
  • ***
  • Posts: 276
Re: Migrate to Joomla 1.5 bringing VirtueMart along - Tutorial
« Reply #12 on: December 15, 2009, 20:27:24 pm »
Hi,

I'm trying to get hold of the Virtuemart ETL Plugin so I can perform a migration but the developer's site is down - can anyone help me out by forwarding me the plugin please ?

Also I note http://extensions.joomla.org/extensions/migration-a-conversion/migrator-extensions/7415 that the plugin has been tested on VM 1.1.3. Has anyone tried with VM1.1.4 ?

Thanks in advance.

qme1ster

  • Full Member
  • ***
  • Posts: 276
Re: Migrate to Joomla 1.5 bringing VirtueMart along - Tutorial
« Reply #13 on: December 16, 2009, 14:47:03 pm »
Can anyone help with supply of the ETL Plugins for Virtuemart ? The developer's site is still down.

asiams

  • Beginner
  • *
  • Posts: 8
Re: Migrate to Joomla 1.5 bringing VirtueMart along - Tutorial
« Reply #14 on: December 17, 2009, 10:30:46 am »
Hello FnF,

Quote
B- You MUST have Virtuemart 1.1.3 running correctly on your existing Joomla 1.0 site for the migration to be successful. So if need be, upgrade VM first.
It's as simple as uploading a file, and extracting to over write. When you log into your VM admin it notices the updates and runs the DB query bringing your install up to date.

I am following the steps. At above step, I copied all of the manual upgrade files to the copy site of current VM 1.0.15 on Jm1.0.15. Now after backend to virtuemart admin, DB was modified and the config was saved. After that, when I visited the site, all of the thumnails were not showing.

At this point, what should I do in order to show the thumnails?

Some people mentioned no to bother to make it work in Joomla 1.0.15 since it will not work with virtuemart 1.1.3 at all.

Can you help on this?

Thanks.