[SOLVED] Images not migrating

[je134]

Hello,

I've donde the migrating process and it worked great!! Thanks for this amasing piece of software you developed.

So, when I finished the migrating process (I already copied the images to the new folder images/stories/virtuemart/products) i tried to sync the media files but they won't show up in back nor frontend. When I hit the sync button again I get this message:

Code Select Expand

Found prior migration process, resume migration maxScriptTime 23999 maxMemoryLimit 358.4
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.
Todos los archivos sincronizados 0

When I go to a product detail no images show up and no media files are there.

Any idea how I can fix this? I assume where is a sql script I can run to insert the images to the new db?

Thank you guys.

[PRO]

additional images dont migrate

AND, when you go into vmart admin product, do you see iimages?

[je134]

I don't have additional images and no, i don't see the images in admin product. I've attached an image of what I get in admin product.

[attachment cleanup by admin]

[PRO]

OOOO, you have to do the images in the folder BEFORE you migrate.

Backup the site with akeeba.

THEN, empty the product, and category tables.

also empty
virtuemart_migration_oldtonew_ids

THen do the migration again.


ONLY EMPTY THE _virtuemart    product and category tables.

do not empty _vm


OLD virtuemart tables use  _vm    and they are needed for the migration

[je134]

Did the process again and it worked!!!!! Thank you very much!!

[GooRu]

Thanks worked great for me as well/

[douby02]

Hello,

I leave the community because I know now the same problem with the migration of VM.

Virtuemart version 1.1.6 to 2.0.0.

I did the update via the migration tool Virtuemart.

Everything is imported without any problems, apart from images that do not import.

After many unsuccessful test, I noticed that the table "virtuemart_product_media" not responding properly.

I tested on two different sites is still the same result.

Note that I'm local.

The first site contains over 5000 products and the second just over 500.

I repeated several times that BanquetTables.pro said, but it does not solve my problem.

PS: I do not have special characters in the image name.

Could someone help me?

Thank you in advance to anyone who wants to help me on the subject.

[douby02]

For information is the message at the end of migration:

        Found prior migration process, resume migration maxScriptTime 1439 maxMemoryLimit 89.6
        Migrator store medias COM_VIRTUEMART_URL_NOT_VALID
        Synchronized 0 media for product in directory images/stories/virtuemart/product/
        Synchronized 0 media for category in directory images/stories/virtuemart/category/
        Synchronized 0 media for manufacturer in directory images/stories/virtuemart/manufacturer/
        Synchronized 0 media for vendor in directory images/stories/virtuemart/vendor/
        Processed 0 vm1 shoppergroups time: 6.0796737670898E-5
        Looks everything worked correct, migrated 0 categories
        Looks everything worked correct, migrated 0 categories xref
        Looks everything worked correct, migrated 0 manufacturer categories
        Looks everything worked correct, migrated 0 manufacturers
        Found 50 vm1 products to import
        Found 50 vm1 products to import
        Found 50 vm1 products to import
        ...
        Worked on migration for 601.56039404869 seconds
        Migration finished

Apparently there would have one or more invalid URL:

Migrator media store COM_VIRTUEMART_URL_NOT_VALID

I think the system can not find the images because it does not look to the right place.

Anyone have information on the subject?

[lipes]

Its possible to someone do one exemple video of that migration process with some tool like http://camstudio.org/ http://download.cnet.com/windows/video-capture-software/?  And next... adding the video on youtube, vimeo, or etc ?

It will be more easy to all if we could see "step by step" all the migration process from VM 1.9 to VM 2.0. We also get less questions in forum about that
thanks

[PRO]

here is one I found with a simple search
http://www.youtube.com/watch?v=W5utvww9DLQ

[lipes]

nice! Many Thanks BanquetTables.pro ! only misses the audio instructions... but its ok.   

[PRO]

http://www.csvimproved.com/


csv improved is out now, so what you have problems with migrating can be done with csv improved.

AS long as you have a live site, and a development site you are working with.

[lipes]

Thanks again Banquet.
CSV Improved it's a nice solution.. I've read their website months ago and recognise their good job...
But my problem its biggest... i haven't enough money to spend with an small store of my dads.. Besides that my country lives in a big crises so i can afford some modules, plugs and components... The solution: I have to prefer the traditional method of going to the sql admin and try to find and make that transition by the my mind, keybord and mouse.. eheh

[milosmilos]

if, like I was, you're halfway trough the migration and you don't want to redo it.

Here's a solution to link the new media entry's via the old vm tables:
Replace the "

" with your own prefix


Products:
INSERT INTO 
_virtuemart_product_medias
SELECT null, a.virtuemart_product_id, virtuemart_media_id,1
FROM `
_virtuemart_products` a
INNER JOIN `
_vm_product` b ON a.product_sku= b.product_sku
INNER JOIN `
_virtuemart_medias` c ON c.`file_title` = b.`product_full_image`

Categories:
INSERT INTO 
_virtuemart_category_medias
SELECT null, a.virtuemart_category_id, virtuemart_media_id,1
FROM `
_virtuemart_categories_nl_nl` a
INNER JOIN `
_vm_category` b ON a.category_name= b.category_name
INNER JOIN `
_virtuemart_medias` c ON c.`file_title` = b.`category_full_image`

[Milbo]

      Migrator media store COM_VIRTUEMART_URL_NOT_VALID

Code Select Expand


      if(strpos($this->file_url,'..')!==false){
      $ok = false;
      vmError(JText::sprintf('COM_VIRTUEMART_URL_NOT_VALID',$this->file_url ) );
      }

That means that your url has a .. in it and is therefore blocked, because this is something hackers do.



And to milosmilos and prolipes. The migrator is working well, but one line makes still trouble in mysql5.0, so maybe the reason is that your database is outdated. And we successfully ported shops with 20k products and images, with users, orders.