News:

Looking for documentation? Take a look on our wiki

Main Menu

A few DB migration issues

Started by Vorwaerts, February 07, 2012, 14:55:35 PM

Previous topic - Next topic

Vorwaerts

Hi,

Had some permission issues on selected VM folders so I began changing ownership and permission to get 99.9% working by destroying all security :-\

So far so good...

I followed this guide to the point: http://forum.virtuemart.net/index.php?topic=95236.0
but was unable to migrate a few DB tables (users and orders I believe).

Does anyone have any idea about how I possibly could get these data migrated through a workaround?

This is a Joomla 1.5.25 with VM 1.1.9 to VM 2.0.0 migration.
MySQL: 5.0.51a
PHP: 5.2.4-2ubuntu5.17


        Found prior migration process, resume migration maxScriptTime 47 maxMemoryLimit 89.6
        Synchronized 0 media for product in directory images/stories/virtuemart/product/
        Synchronized 0 media for category in directory images/stories/virtuemart/category/
        Synchronized 0 media for manufacturer in directory images/stories/virtuemart/manufacturer/
        Synchronized 0 media for vendor in directory images/stories/virtuemart/vendor/
        Processed 0 vm1 shoppergroups time: 1.90734863281E-5
        Looks everything worked correct, migrated 0 categories
        Looks everything worked correct, migrated 0 categories xref
        Looks everything worked correct, migrated 0 manufacturer categories
        Looks everything worked correct, migrated 0 manufacturers
        Found 12 vm1 products to import
        Worked on migration for 0.106600999832 seconds
        Migration finished

        vmError: port shoppers db error FUNCTION admin_financial.ISNULL does not exist SQL=SELECT `p`.*,`ui`.*,`svx`.*,`aug`.*,`ag`.*,`vmu`.virtuemart_user_id FROM jos_users AS `p` LEFT OUTER JOIN jos_vm_user_info AS `ui` ON `ui`.user_id = `p`.id LEFT OUTER JOIN jos_vm_shopper_vendor_xref AS `svx` ON `svx`.user_id = `p`.id LEFT OUTER JOIN jos_vm_auth_user_group AS `aug` ON `aug`.user_id = `p`.id LEFT OUTER JOIN jos_vm_auth_group AS `ag` ON `ag`.group_id = `aug`.group_id LEFT OUTER JOIN jos_virtuemart_vmusers AS `vmu` ON `vmu`.virtuemart_user_id = `p`.id WHERE ISNULL (`vmu`.virtuemart_user_id) LIMIT 0,7600
        vmError: port shoppers db error SELECT `p`.*,`ui`.*,`svx`.*,`aug`.*,`ag`.*,`vmu`.virtuemart_user_id FROM jos_users AS `p` LEFT OUTER JOIN jos_vm_user_info AS `ui` ON `ui`.user_id = `p`.id LEFT OUTER JOIN jos_vm_shopper_vendor_xref AS `svx` ON `svx`.user_id = `p`.id LEFT OUTER JOIN jos_vm_auth_user_group AS `aug` ON `aug`.user_id = `p`.id LEFT OUTER JOIN jos_vm_auth_group AS `ag` ON `ag`.group_id = `aug`.group_id LEFT OUTER JOIN jos_virtuemart_vmusers AS `vmu` ON `vmu`.virtuemart_user_id = `p`.id WHERE ISNULL (`vmu`.virtuemart_user_id) LIMIT 0,7600
        vmError: port ST addresses db error FUNCTION admin_financial.ISNULL does not exist SQL=SELECT `ui`.* FROM jos_vm_user_info as `ui` LEFT OUTER JOIN jos_virtuemart_userinfos as `vui` ON `vui`.`virtuemart_user_id` = `ui`.`user_id` WHERE `ui`.`address_type` = "ST" AND ISNULL (`vui`.`virtuemart_user_id`) LIMIT 0,7600
        vmError: port ST addresses db error SELECT `ui`.* FROM jos_vm_user_info as `ui` LEFT OUTER JOIN jos_virtuemart_userinfos as `vui` ON `vui`.`virtuemart_user_id` = `ui`.`user_id` WHERE `ui`.`address_type` = "ST" AND ISNULL (`vui`.`virtuemart_user_id`) LIMIT 0,7600
        vmError: port Orders db error FUNCTION admin_financial.ISNULL does not exist SQL=SELECT `o`.*, `op`.*, `o`.`order_number` as `vm1_order_number`, `o2`.`order_number` as `nr2` FROM `jos_vm_orders` as `o` LEFT OUTER JOIN `jos_vm_order_payment` as `op` ON `op`.`order_id` = `o`.`order_id` LEFT JOIN `jos_virtuemart_orders` as `o2` ON `o2`.`order_number` = `o`.`order_number` WHERE ISNULL (o2.order_number) LIMIT 0,7400
        vmError: port Orders db error SELECT `o`.*, `op`.*, `o`.`order_number` as `vm1_order_number`, `o2`.`order_number` as `nr2` FROM `jos_vm_orders` as `o` LEFT OUTER JOIN `jos_vm_order_payment` as `op` ON `op`.`order_id` = `o`.`order_id` LEFT JOIN `jos_virtuemart_orders` as `o2` ON `o2`.`order_number` = `o`.`order_number` WHERE ISNULL (o2.order_number) LIMIT 0,7400

info

        Info: Processed 0 vm1 users time: 3.09944152832E-6
        Info: Migration: 0 products processed
        Info: Migration: 0 orders processed

J! 1.5.25 | VM 1.1.9 | MySQL 5.0.51a | 5.2.4-2ubuntu5.17