News:

Looking for documentation? Take a look on our wiki

Main Menu

I have the follow error when i do the migration

Started by novasonic, February 28, 2012, 16:09:00 PM

Previous topic - Next topic

novasonic

I use  Jommla version 2.5.1  and virtuemart 2.0.2
I did the  14 steps of Milbo say in Topic: Migrate/Update from virtuemart 1 to virtuemart 2
But i don't understand, where i do something wrong.  When i use the migrate tools i have this error:
QuotevmError: port Orders db error Table 'mertindc_j25.dj5am_vm_orders' doesn't exist SQL=SELECT `o`.*, `op`.*, `o`.`order_number` as `vm1_order_number`, `o2`.`order_number` as `nr2` FROM `dj5am_vm_orders` as `o` LEFT OUTER JOIN `dj5am_vm_order_payment` as `op` ON `op`.`order_id` = `o`.`order_id` LEFT JOIN `dj5am_virtuemart_orders` as `o2` ON `o2`.`order_number` = `o`.`order_number` WHERE ISNULL (o2.order_number) LIMIT 0,9300
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,9300
NOTE : mertindc_j25 is a BD where i installed joomla 2.5
            mertindc_joom1 is a BD where i installed joomla 1.5 (this is the old)
Please can you help me. Thanks

novasonic

I don't understand why it says me "
Quotedb error Table 'mertindc_j25.dj5am_vm_orders' doesn't exist SQL=SELECT
"
yes i know it doesn't exist :-[, but 
Quotemertindc_j25.dj5am_virtuemart_orders
yes :D. Why don't do the migration there?

Milbo

It is looking for the old tables. They must be in the database
Should I fix your bug, please support the VirtueMart project and become a member
______________________________________
Extensions approved by the core team: http://extensions.virtuemart.net/

novasonic

sorry, i have 297 products, it can't migrate all product, why?

Milbo

Just do it as often as it is not done. It is resuming.
Should I fix your bug, please support the VirtueMart project and become a member
______________________________________
Extensions approved by the core team: http://extensions.virtuemart.net/

novasonic

#5
I did it, but only duplicate my products, i have this:
-product A
-product A
-product A
-product B
-product B
-product B
I used php myAdmin and i deleted all data from  virtuemart_products table and i went back administration of joomla. I did again the migration process (3 times) but i only marked products
and i only migrate products. And the result was the same:
It only migrate 60 products of 291.  :-[ :-[ :-[ :-[
Quote* Found prior migration process, resume migration maxScriptTime 143 maxMemoryLimit 1013
        * Archivos %s de media sincronizados en el directorio %s.
        * Archivos %s de media sincronizados en el directorio %s.
        * Archivos %s de media sincronizados en el directorio %s.
        * Archivos %s de media sincronizados en el directorio %s.
        * Looks everything worked correct, migrated 0 categories
        * No categories to import
        * Looks everything worked correct, migrated 0 manufacturer categories
        * Looks everything worked correct, migrated 0 manufacturers
        * Found 297 vm1 products to import
        * Worked on general migration for 1.3324937820435 seconds
        * 1
Info: Migration: 60 products processed

novasonic

I re-installed virtuemart and i have the same problem. I will wait for your help.

novasonic

I reinstalled and only  i have this error and only migrate 60 products of 297.
QuotevmError: Port Categories Xref unknow : ID 0
Any idea is useful.