News:

You may pay someone to create your store, or you visit our seminar and become a professional yourself with the silver certification

Main Menu

Migrate all virtuemart data from 2.6.6 to 3.0.7

Started by ballamart, April 22, 2015, 07:22:20 AM

Previous topic - Next topic

ballamart


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

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?
GJC Web Design
VirtueMart and Joomla Developers - php developers https://www.gjcwebdesign.com
VM4 AusPost Shipping Plugin - e-go Shipping Plugin - VM4 Postcode Shipping Plugin - Radius Shipping Plugin - VM4 NZ Post Shipping Plugin - AusPost Estimator
Samport Payment Plugin - EcomMerchant Payment Plugin - ccBill payment Plugin
VM2 Product Lock Extension - VM2 Preconfig Adresses Extension - TaxCloud USA Taxes Plugin - Virtuemart  Product Review Component
https://extensions.joomla.org/profile/profile/details/67210
Contact for any VirtueMart or Joomla development & customisation

ballamart

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?

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
GJC Web Design
VirtueMart and Joomla Developers - php developers https://www.gjcwebdesign.com
VM4 AusPost Shipping Plugin - e-go Shipping Plugin - VM4 Postcode Shipping Plugin - Radius Shipping Plugin - VM4 NZ Post Shipping Plugin - AusPost Estimator
Samport Payment Plugin - EcomMerchant Payment Plugin - ccBill payment Plugin
VM2 Product Lock Extension - VM2 Preconfig Adresses Extension - TaxCloud USA Taxes Plugin - Virtuemart  Product Review Component
https://extensions.joomla.org/profile/profile/details/67210
Contact for any VirtueMart or Joomla development & customisation

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?
GJC Web Design
VirtueMart and Joomla Developers - php developers https://www.gjcwebdesign.com
VM4 AusPost Shipping Plugin - e-go Shipping Plugin - VM4 Postcode Shipping Plugin - Radius Shipping Plugin - VM4 NZ Post Shipping Plugin - AusPost Estimator
Samport Payment Plugin - EcomMerchant Payment Plugin - ccBill payment Plugin
VM2 Product Lock Extension - VM2 Preconfig Adresses Extension - TaxCloud USA Taxes Plugin - Virtuemart  Product Review Component
https://extensions.joomla.org/profile/profile/details/67210
Contact for any VirtueMart or Joomla development & customisation

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.