Images did not migrate

[binary]

Hello:

When migrating our virtuemart 1.1.9 DB to VM 2.0 RC2, the image locations did not migrate to the new RC2 DB.  I copied the images to the proper images directory however when I go to edit the product and look at the product image tab, there is no URL or file name listed for all our product images.

How can I go about migrating the product images to our database short of reinstall and remigrating the data again?

Thanks.. we have 3000+ products so this is very important that we do it automatically.  I am great with SQL so if there is a way to cleanly do it through SQL queries please let me know.

[PRO]

you have to click migrate many times.
especially with 3000 products.

I have 350 products and know I had to do it atleast 4 times

[binary]

Thank you for your reply.  Migrating a second time won't harm anything?

[PRO]

no, you should read the messages that occur after.

Normally, it tells you to migrate again

[binary]

I have tried to migrate multiple times, and about 20% of the images finally appeared.  But after about 10 times trying to migrate, I'm not getting any more images appearing.  Any other suggestions?

Thank you for your help so far..

[PRO]

any special characters in the filenames etc? what language?

[binary]

Thank your for your reply.

No special characters in filenames.  Filenames are hexidecimal numbers followed by .jpg

Language is English.

[binary]

I am receiving some warnings in the migration though:

slug was not unique in table #__virtuemart_products, added random number: product-one1189641421
slug was not unique in table #__virtuemart_products, added random number: product-two1025202362
slug was not unique in table #__virtuemart_products, added random number: product-three1350490027
slug was not unique in table #__virtuemart_products, added random number: product-four783368690
..
etc..
..


I renamed the original product names to product-one, product-two, etc for demostration purposes in the forum..

[PRO]

is dynamic thumbnails turned on?

both small and large images are not there?

[binary]

Yes, dynamic thumbnails are turned on, and small and large images not there for 75% of the products. It just gives me this for the image "http://ourdomain.com/components/com_virtuemart/assets/images/vmgeneral/noimage.gif"

What is the best way to dump all the products and try again?  Maybe something is messed.

[PRO]

backup the site.

THEN, emty all the virtuemart tables

NOT vm_  then go again.

OLD vmart tables start with   _vm
NEW, vmart tables start with _virtuemart

[binary]

Thanks.  And where should the images be?  Should the images be copied to the new images directory where VM2 wants them, or will the migration transfer them from the old shop_images directory where VM1 wanted them?

If the migration tool does not find the physical image file, does it still migrate the image name/path for the products in the database?

[PRO]

MOVE them to new standard joomla images folder

virtuemart. Just like it says in the configuration. Dont use old folders.

I am receiving some warnings in the migration though:

slug was not unique in table #__virtuemart_products, added random number: product-one1189641421
slug was not unique in table #__virtuemart_products, added random number: product-two1025202362
slug was not unique in table #__virtuemart_products, added random number: product-three1350490027
slug was not unique in table #__virtuemart_products, added random number: product-four783368690
..
etc..
..
I renamed the original product names to product-one, product-two, etc for demostration purposes in the forum..

'slug" is the alias for the SEF url. They have to be unique