Migrate all virtuemart data from 2.6.6 to 3.0.7

[ballamart]

@jenkinhill
hi, thanks i'll do.

[stawebnice]

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.

[ballamart]

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

[ballamart]

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

[GJC Web Design]

this 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?

[ballamart]

hello @GJC Web Design

has 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?

[GJC Web Design]

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

[ballamart]

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

[GJC Web Design]

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?

[ZoBabe]

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.