VirtueMart Forum

VirtueMart 2 + 3 + 4 => Installation, Migration & Upgrade => Topic started by: hout141 on February 22, 2012, 21:44:56 PM

Title: error after migration
Post by: hout141 on February 22, 2012, 21:44:56 PM
After migration to VM2 I get the following messages:

Found prior migration process, resume migration maxScriptTime 239 maxMemoryLimit 89.6
0 media gesynchroniseerd voor product in map images/stories/virtuemart/product/
0 media gesynchroniseerd voor category in map images/stories/virtuemart/category/
0 media gesynchroniseerd voor manufacturer in map images/stories/virtuemart/manufacturer/
0 media gesynchroniseerd voor vendor in map images/stories/virtuemart/vendor/
Looks everything worked correct, migrated 0 manufacturer categories
Looks everything worked correct, migrated 0 manufacturers
_productPorter Table 'Rotation_shop.hout_vm_product' doesn't exist SQL=SELECT * FROM hout_vm_product AS `p` LEFT JOIN hout_vm_product_price ON hout_vm_product_price.product_id = `p`.product_id LEFT JOIN hout_vm_product_mf_xref ON hout_vm_product_mf_xref.product_id = `p`.product_id LIMIT 0,8000
Worked on migration for 0.370307922363 seconds
Migration finished
Info: No Shoppergroup table found for migration
Info: No vm_category table found for migration
Info: Migration: 0 orders processed
vmError: port Orders db error Table 'Rotation_shop.hout_vm_orders' doesn't exist SQL=SELECT `o`.*, `op`.*, `o`.`order_number` as `vm1_order_number`, `o2`.`order_number` as `nr2` FROM `hout_vm_orders` as `o` LEFT OUTER JOIN `hout_vm_order_payment` as `op` ON `op`.`order_id` = `o`.`order_id` LEFT JOIN `hout_virtuemart_orders` as `o2` ON `o2`.`order_number` = `o`.`order_number` WHERE ISNULL (o2.order_number) LIMIT 0,8000
vmError: port Orders db error SELECT `o`.*, `op`.*, `o`.`order_number` as `vm1_order_number`, `o2`.`order_number` as `nr2` FROM `#__vm_orders` as `o` LEFT OUTER JOIN `#__vm_order_payment` as `op` ON `op`.`order_id` = `o`.`order_id` LEFT JOIN `#__virtuemart_orders` as `o2` ON `o2`.`order_number` = `o`.`order_number` WHERE ISNULL (o2.order_number) LIMIT 0,8000

I am a newbe here and I do not know what went wrong.
My problem is that after the migration product categories can not be created or changes.
Who can help me?
Title: Re: error after migration
Post by: novasonic on February 28, 2012, 21:19:36 PM
I have the same error, can you fix it?
Title: Re: error after migration
Post by: Milbo on February 29, 2012, 00:59:55 AM
ISNULL

is not anylonger in the 2.0.2 code. Please update
Title: Re: error after migration
Post by: cecilia2330 on March 27, 2012, 18:31:52 PM
Im use 2.0.2 virtuemart , but it still show the error message
Anyone can help me?

vmError: port Orders db error Table 'premium_new.jos_vm_orders' doesn't 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 (o2.order_number) IS NULL LIMIT 0,17300
vmError: port Orders db error SELECT `o`.*, `op`.*, `o`.`order_number` as `vm1_order_number`, `o2`.`order_number` as `nr2` FROM `#__vm_orders` as `o` LEFT OUTER JOIN `#__vm_order_payment` as `op` ON `op`.`order_id` = `o`.`order_id` LEFT JOIN `#__virtuemart_orders` as `o2` ON `o2`.`order_number` = `o`.`order_number` WHERE (o2.order_number) IS NULL LIMIT 0,17300


Thanks!
Cecilia