News:

Support the VirtueMart project and become a member

Main Menu

error after migration

Started by hout141, February 22, 2012, 21:44:56 PM

Previous topic - Next topic

hout141

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?

novasonic

I have the same error, can you fix it?

Milbo

ISNULL

is not anylonger in the 2.0.2 code. Please update
Should I fix your bug, please support the VirtueMart project and become a member
______________________________________
Extensions approved by the core team: http://extensions.virtuemart.net/

cecilia2330

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