VirtueMart Forum

VirtueMart 2 + 3 + 4 => Installation, Migration & Upgrade => Topic started by: novasonic on February 28, 2012, 16:09:00 PM

Title: I have the follow error when i do the migration
Post by: novasonic on February 28, 2012, 16:09:00 PM
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
Title: Re: I have the follow error when i do the migration
Post by: novasonic on February 28, 2012, 17:14:33 PM
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?
Title: Re: I have the follow error when i do the migration
Post by: Milbo on February 29, 2012, 01:02:54 AM
It is looking for the old tables. They must be in the database
Title: Re: I have the follow error when i do the migration
Post by: novasonic on February 29, 2012, 22:23:20 PM
sorry, i have 297 products, it can't migrate all product, why?
Title: Re: I have the follow error when i do the migration
Post by: Milbo on February 29, 2012, 22:51:05 PM
Just do it as often as it is not done. It is resuming.
Title: Re: I have the follow error when i do the migration
Post by: novasonic on March 01, 2012, 22:25:41 PM
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
Title: Re: I have the follow error when i do the migration
Post by: novasonic on March 06, 2012, 14:18:04 PM
I re-installed virtuemart and i have the same problem. I will wait for your help.
Title: Re: I have the follow error when i do the migration
Post by: novasonic on March 14, 2012, 15:40:51 PM
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.