VirtueMart Forum

VirtueMart 2 + 3 + 4 => Installation, Migration & Upgrade => Topic started by: ballamart on April 22, 2015, 07:22:20 AM

Title: Migrate all virtuemart data from 2.6.6 to 3.0.7
Post by: ballamart on April 22, 2015, 07:22:20 AM
Hi, am new to the forum, and also of virtuemart.
i use joomla for many years and now I'm working on the redesign of a website and I need to move the data from the site in
{ joomla (2.5.20) vm (2.6.6)} -- to--> { joomla (3.4.1)  vm  (3.0.7)}
you can tell me a good extension to make this type of work?
thanks a lot
Title: Re: Migrate all virtuemart data from 2.6.6 to 3.0.7
Post by: GJC Web Design on April 22, 2015, 09:01:02 AM
do u mean move the data to an existing J3/VM3 site or migrate the J2.5/VM2.6 to J3/VM3?

The 2nd is (relatively simple) upgrades with all the normal warnings and provisos..

Title: Re: Migrate all virtuemart data from 2.6.6 to 3.0.7
Post by: ballamart on April 22, 2015, 09:32:56 AM
Hi and thanks to reply me, the first one I prefer.
Title: Re: Migrate all virtuemart data from 2.6.6 to 3.0.7
Post by: GJC Web Design on April 22, 2015, 10:30:47 AM
that is by far the more difficult

I know you can just replace the VM DB tables and then run the tables updater in the vm tools - but do step by step

but first you have to get the Joomla users into it -- there are extensions for that

Think it would be far easier to do the 2nd
Title: Re: Migrate all virtuemart data from 2.6.6 to 3.0.7
Post by: ballamart on April 22, 2015, 10:39:46 AM
hi,
i sow some extensions that do this, I prefer use this method maybe it's more easy then replace the DB table.
can you advice me about the extensions you wrote me?
thanks a lot
Title: Re: Migrate all virtuemart data from 2.6.6 to 3.0.7
Post by: GJC Web Design on April 22, 2015, 10:43:14 AM
no idea - I don't use this method - too many things to go wrong
Title: Re: Migrate all virtuemart data from 2.6.6 to 3.0.7
Post by: ballamart on April 22, 2015, 11:09:48 AM
would you be so kind as to tell me some links tips to do this you wrote?

"I know you can just replace the VM DB tables and then run the tables updater in the vm tools - but do step by step

but first you have to get the Joomla users into it -- there are extensions for that"

thanks a lot
Title: Re: Migrate all virtuemart data from 2.6.6 to 3.0.7
Post by: GJC Web Design on April 22, 2015, 12:03:16 PM
I'm sorry - but if u need links to how to do this - I really don't think you should be messing in the database....

why don't u just clone the old one- upgrade-- make it look like the J3 one u have?
Title: Re: Migrate all virtuemart data from 2.6.6 to 3.0.7
Post by: jjk on April 22, 2015, 12:28:36 PM
@ballamart
I would suggest the following steps:
1. backup your site (with akeeba backup) and maybe also export your database with phpMyAdmin and download both to your local PC, so you have both available in case something goes wrong. It is a good idea to install a copy of your live site on your local PC using an xampp version which uses the same php version you have on your live site server: https://www.apachefriends.org/de/index.html and test the upgrade on your local PC first.
2. update Joomla 2.5.20 to the version 2.5.28
3. update VirtueMart to version 3.0.8 (it is still compatible with Joomla 2.5.x, but Joomla 3..4.1 is not compatible with VM 2.6.x.)
4. upgrade Joomla 2.5.28 to Joomla 3.4.1 using the steps described here: http://forum.joomla.org/viewtopic.php?t=793171
Title: Re: Migrate all virtuemart data from 2.6.6 to 3.0.7
Post by: ballamart on April 23, 2015, 11:05:34 AM
hi jjk
I did exactly as you told me
Now I have everything updated
now I have to install the template I purchased, this is the problem, it has too much extension!
I have to upload them step by step
I hope to finish soon
thank you both
Title: Re: Migrate all virtuemart data from 2.6.6 to 3.0.7
Post by: jjk on April 23, 2015, 15:20:59 PM
Quote from: ballamart on April 23, 2015, 11:05:34 AM
now I have to install the template I purchased, this is the problem, it has too much extension!
Sounds scaring. Be cautious! There are a few "feature ladden" templates which create a lot of problems.
Title: Re: Migrate all virtuemart data from 2.6.6 to 3.0.7
Post by: stawebnice on April 23, 2015, 15:21:33 PM
Hi,

I use https://www.daycounts.com/shop/virtuemart-3/virtuemart-2-migrator.htm to migrate Virtuemart and Joomla! It's quite easy.
If you only want to migrate database and images, I can do it for you (PM me). But you will need a Joomla 3  Virtuemart 3 compatible template.
Title: Re: Migrate all virtuemart data from 2.6.6 to 3.0.7
Post by: ballamart on April 26, 2015, 17:37:51 PM
@stawebnice
I'm using that plugin, after install fullpackage template I try to migrate, this is the screenshot:
(http://www.risorsedigrafica.it/migrate-error.png)
Title: Re: Migrate all virtuemart data from 2.6.6 to 3.0.7
Post by: ballamart on April 26, 2015, 17:56:27 PM
now I've got just this:
Custom fields
Plugin vmcustom/customfieldsforall could not be found
Custom field customfieldsforall was created but you need to configure it manually
...
(http://www.risorsedigrafica.it/migrate-error-02.png)

how can I fix it?
thanks a lot
Title: Re: Migrate all virtuemart data from 2.6.6 to 3.0.7
Post by: jenkinhill on April 26, 2015, 18:45:18 PM
If you bought the migrator through extensions.virtuemart.net  then you can ask for support from the developer by ticket - http://extensions.virtuemart.net/support-updates

If you bought it through Daycounts' website  then support is by ticket at https://www.daycounts.com/support/new-ticket
Title: Re: Migrate all virtuemart data from 2.6.6 to 3.0.7
Post by: ballamart on April 26, 2015, 19:02:19 PM
@jenkinhill
hi, thanks i'll do.
Title: Re: Migrate all virtuemart data from 2.6.6 to 3.0.7
Post by: stawebnice on April 26, 2015, 21:24:17 PM
Hi Ballamart,

yes,please use Daycounts support. I have migrated en eshop with custom fields from 3rd party plugin too (you use Breakdesigns.net Customfieldsforall),for some third party plugin they have addons, but not for custom fields, as I checked now.
I have migrated custom fields  by Myext.eu and they also are not working now on VM3 even with the new version of Customfield  plugin by them, so their support is solving it.
Title: Re: Migrate all virtuemart data from 2.6.6 to 3.0.7
Post by: ballamart on April 27, 2015, 14:06:57 PM
hi,
I have started to do step by step right
joomla 2.5.22 --> 2.5.28
Vm 2.6.6 -- 2.6.17
If i upgrade Vm to the 2.9.9 the custom field doesn't works enymore, so I sent a request of detail to the developers of Customfieldsforall plugin
For the rest of what you advise me to do?
step directly to the version of joomla 3.4.1 and VM 3.0.7?
Thanks
Title: Re: Migrate all virtuemart data from 2.6.6 to 3.0.7
Post by: ballamart on April 27, 2015, 22:02:01 PM
I still have a problem.
I'm using a flatastic template that is compatible with joomla 3.4.1 and VM 3.0.7 (installing by fullpackage with sample data)
I upgrade the plugins I need to migrate the custom field
I'm using a daycount migrate
I've got this error after migrate:

1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '47) and (`virtuemart_vendor_id` = "1" OR `shared`="1") AND published = "1" ORDER' at line 2 SQL=SELECT `virtuemart_currency_id`,`currency_symbol`,`currency_code_3`,CONCAT_WS(" ",`currency_name`) as currency_txt FROM `l4698_virtuemart_currencies` WHERE `virtuemart_currency_id` IN (,47) and (`virtuemart_vendor_id` = "1" OR `shared`="1") AND published = "1" ORDER BY `ordering`,`currency_name`

this error does not appear if I change template like beez3
:'(

Title: Re: Migrate all virtuemart data from 2.6.6 to 3.0.7
Post by: GJC Web Design on April 27, 2015, 23:50:19 PM
Quotethis error does not appear if I change template like beez3

that's your answer then - it is in the template somewhere
the error BTW is the comma

WHERE `virtuemart_currency_id` IN (,47) and

has the template got a module that isn't displayed in Beez?
Title: Re: Migrate all virtuemart data from 2.6.6 to 3.0.7
Post by: ballamart on April 28, 2015, 00:42:25 AM
hello @GJC Web Design

Quotehas the template got a module that isn't displayed in Beez?

english is not my language are very sorry for this, you can give me an example?
I think the problem is not only the template but also the migration, I also riscontroato this error:

1146 Table 'full01.l4698_virtuemart_custom_plg_customsforall_values' doesn't exist SQL=SELECT * FROM `l4698_virtuemart_custom_plg_customsforall_values` WHERE virtuemart_custom_id=40 ORDER BY ordering ASC

the migration component made something wrong!
Have you ever used this migration tool?
Title: Re: Migrate all virtuemart data from 2.6.6 to 3.0.7
Post by: GJC Web Design on April 28, 2015, 14:34:04 PM
how can it be the tables/migration when the error isn#t on Beez??????

something on your template is making a broken sql call -- I showed you the error
it isn't on Beez
Title: Re: Migrate all virtuemart data from 2.6.6 to 3.0.7
Post by: ballamart on April 28, 2015, 19:42:39 PM
yes I think so,
I have taken the way of the update of the joomla and VM version and not the data migration, because I've seen too many problems.
although I will continue a parallel project to understand how to fix errors about migration.
this is another error I've got:
Table 'full01.l4698_virtuemart_custom_plg_customsforall_values' doesn't exist SQL=SELECT * FROM `l4698_virtuemart_custom_plg_customsforall_values` WHERE virtuemart_custom_id=8 ORDER BY ordering ASC
and perhaps I understood what is due
Title: Re: Migrate all virtuemart data from 2.6.6 to 3.0.7
Post by: GJC Web Design on April 28, 2015, 21:09:48 PM
well - it is self explanatory.. do u read the errors?

Table 'full01.l4698_virtuemart_custom_plg_customsforall_values' doesn't exist

so what does that suggest to you?
Title: Re: Migrate all virtuemart data from 2.6.6 to 3.0.7
Post by: ZoBabe on May 01, 2015, 01:46:41 AM
I've nothing but problems with one button upgrades from John last 2.5 to 3 involving virtuemart.  Looks fine at first but then things start acting up, and I have to go back an do a migration anyway.
  I'd recommend VM Updater by daycounts.com.