About The Page About Updating VM 2 to 3...

[ren3784]

I read your sticky post about How to Update VM2 to 3, and it sends me to this page: http://docs.virtuemart.net/tutorials/installation-migration-upgrade/198-upgrade-virtuemart-2-to-virtuemart-3.html

However, I am not seeing any instructions. All I want are the products, categories and manufacturers to be moved over to VM3, but the only instruction on that that page seems to be this:

VirtueMart 3 uses a slightly changed database layout of VM2. The database conversion is done automatically by the installer. The native customfields (except the stockable plugin) are automatically converted to the new system.

That doesn't help at all, what is 'the installer'? I'm missing something here, please direct me to the steps, because when I go to the migration area in my Virtuemart installation, it shows what's in the attached image.

And if I click Migrate anyway, I get errors like below:

Code Select Expand

An error has occurred.

    1146 Table 'miagemma_joom3.m1fvc_vm_product' doesn't exist SQL=SELECT *,`p`.product_id as product_id FROM `m1fvc_vm_product` AS `p` LEFT JOIN `m1fvc_vm_product_mf_xref` ON `m1fvc_vm_product_mf_xref`.`product_id` = `p`.`product_id` WHERE (`p`.product_id) IS NOT NULL GROUP BY `p`.product_id ORDER BY `p`.product_parent_id LIMIT 0,1000

What exactly do I do?

[attachment cleanup by admin]

[GJC Web Design]

to update from Vm2 to Vm3 - as long as your template is compatible and the VM extensions u want to use are available - is download http://dev.virtuemart.net/attachments/download/887/com_virtuemart.3.0.2_extract_first.zip
unzip
and install the two files via the normal Joomla extensions installer
Do on a clone of the site first

[ren3784]

So VM 3 works on Joomla 1.5? Or do I have to slowly upgrade Joomla piece by piece?

What you're saying sounds like I will have a clone of my site, where VM 2.0.8e is already installed, and then on top of that, I have to install VM 3 in that same Joomla installation. So there will be two VirtueMarts installed and enabled at the same time? I'm not looking for an update really, just the transfer of products.

I have Joomla 3 already installed separately and my template working fine. VirtueMart 3.0.2 is installed on it as well. Is there no way to transfer products, manufacturers and categories (no need for orders) from VM2 to VM3?

How about this: Is there a database query available I can use that can convert or copy table items from the old VM to the new one? I can do that, it sounds much simpler to me.

[Matt_Ginn]

If you're just looking to transfer everything to the new site, check out http://www.csvimproved.com/en/

[GJC Web Design]

So VM 3 works on Joomla 1.5? Or do I have to slowly upgrade Joomla piece by piece?

who said that? Of course not.. works on J2.5 though

transfer of products etc to a SEPARATE VM3 from VM2 - a search would have found you..-> http://forum.virtuemart.net/index.php?topic=127335.msg436794#msg436794

[ren3784]

Ah thank you! A slight variation on that works great. Transferring products through the database for VM 2.0.8e on Joomla 1.5 to VM 3.0.2 on Joomla 3.3.6.

1. Export these tables (because I needed the manufacturers too) from my Joomla 1.5 or 2.5 database where VM2.0.8e is installed:

jos_virtuemart_categories
jos_virtuemart_categories_en_gb (and any other lang tables)
jos_virtuemart_category_categories
jos_virtuemart_category_medias
jos_virtuemart_manufacturercategories
jos_virtuemart_manufacturercategories_en_gb
jos_virtuemart_manufacturers
jos_virtuemart_manufacturer_en_gb
jos_virtuemart_manufacturer_medias
jos_virtuemart_medias
jos_virtuemart_products
jos_virtuemart_products_en_gb  (and any other lang tables)
jos_virtuemart_product_categories
jos_virtuemart_product_customfields
jos_virtuemart_product_manufacturers
jos_virtuemart_product_medias
jos_virtuemart_product_prices
jos_virtuemart_product_relations

2. Make sure when I export, I choose Custom, select the specific tables and then check off "Add DROP TABLE / VIEW / PROCEDURE / FUNCTION statement". For some reason, I kept getting errors without that. Maybe some people don't have to use that option. Idk.

3. Then open the .sql file, find the prefixes jos_ and replace them all with my current Joomla 3 prefixes, for example ng125_.

4. Go to my Joomla 3 database where VM 3.0.2 is installed, DROP these tables:

ng125_virtuemart_categories
ng125_virtuemart_categories_en_gb (and any other lang tables)
ng125_virtuemart_category_categories
ng125_virtuemart_category_medias
ng125_virtuemart_manufacturercategories
ng125_virtuemart_manufacturercategories_en_gb
ng125_virtuemart_manufacturers
ng125_virtuemart_manufacturer_en_gb
ng125_virtuemart_manufacturer_medias
ng125_virtuemart_medias
ng125_virtuemart_products
ng125_virtuemart_products_en_gb  (and any other lang tables)
ng125_virtuemart_product_categories
ng125_virtuemart_product_customfields
ng125_virtuemart_product_manufacturers
ng125_virtuemart_product_medias
ng125_virtuemart_product_prices
ng125_virtuemart_product_relations

5. Go to Import at the top and import the .sql file I edited. Yay.

6. Go to my Joomla 3 installation to Configuration » Tools » DB Tools (ensuring that Enable database Update tools in checked in Configuration » Shop ) and click Install or if necessary update tables .

7. Check the products, manufacturers and categories and everything is there. I have to now upload my images again. I'll do it through FTP and/or manually.

Thank you very much again! I hope this helps someone.

[GJC Web Design]

Just to add - if you just ftp your images to the correct folder they are all properly assigned.. DON'T use the VM image importer
If u do then all your image assignments are broken

if u do make this mistake then re-import ng125_virtuemart_product_medias etc