News:

Support the VirtueMart project and become a member

Main Menu

Not all products migrated from 1.1.9 to 2.0.24c - [SOLVED]

Started by resor, November 27, 2013, 16:07:00 PM

Previous topic - Next topic

resor

Hello,

I have problem like in subject.
I don't know why but not all products are migrated.
I have 766 products in 1.1.9 db table
but after using button Migrate in admin of VM i got several errors: vmError: You are not an administrator or the correct vendor, storing of product cancelled
and finally I got only 679 products in 2.0.24c.
I have tried to find out differences between imported and not imported products and cant find one, but every time these are the same products.

I have noticed too that in #_virtuemart_products table I have all 766 products but in localised one (mine: #_virtuemart_products_pl_pl) there are only 679 products.

Every time I try to import I use button clear vm tables and next reset do default. After that I've got proper vendor set up.
In shop I have few  categories and one vendor.

Has anyone any idea what I'am doing wrong ?

My log from importing:


        Start with a new migration process and setup log maxScriptTime 239 maxMemoryLimit 498
        Zsynchronizowano 1712 media dla product w katalogu images/stories/virtuemart/product/
        Zsynchronizowano 5 media dla category w katalogu images/stories/virtuemart/category/
        Zsynchronizowano 2 media dla manufacturer w katalogu images/stories/virtuemart/manufacturer/
        Zsynchronizowano 2 media dla vendor w katalogu images/stories/virtuemart/vendor/
        Zsynchronizowano 0 media dla forSale w katalogu /home/jrytel/var/www/vmfiles/
        Processed 3 vm1 shoppergroups time: 0.00288510322570801
        Looks everything worked correct, migrated 12 categories
        Looks everything worked correct, migrated 12 categories xref
        Looks everything worked correct, migrated 1 manufacturer categories
        Looks everything worked correct, migrated 1 manufacturers
        Worked on migration for 15.906555891037 seconds
        Migration finished




        Plik tmpForThumb_phpr7PT1d musi mieć podany typ MIME.
        Plik tmpForThumb_phpsS5q0N musi mieć podany typ MIME.
        Plik tmpForThumb_phpriLTCr musi mieć podany typ MIME.
        Plik tmpForThumb_phpIqgs8E musi mieć podany typ MIME.
        Plik tmpForThumb_phpje3g0s musi mieć podany typ MIME.
        Plik tmpForThumb_phpA98f3W musi mieć podany typ MIME.
        Plik tmpForThumb_phpSlwDHG musi mieć podany typ MIME.
        Plik tmpForThumb_phpBw4iX1 musi mieć podany typ MIME.
        Plik tmpForThumb_phpdw3hAf musi mieć podany typ MIME.
        Plik tmpForThumb_phpnvgD8j musi mieć podany typ MIME.
        Plik tmpForThumb_phpteCjVb musi mieć podany typ MIME.
        Plik tmpForThumb_phpNEoqWM musi mieć podany typ MIME.
        Plik tmpForThumb_php3arpiq musi mieć podany typ MIME.
        Plik tmpForThumb_php9YVHGG musi mieć podany typ MIME.
        Plik tmpForThumb_php94Z5E4 musi mieć podany typ MIME.
        Plik tmpForThumb_php3p20CA musi mieć podany typ MIME.
        Plik tmpForThumb_phpN7FiDM musi mieć podany typ MIME.
        Plik tmpForThumb_phpCvYwh8 musi mieć podany typ MIME.
        Plik tmpForThumb_phpoDILlX musi mieć podany typ MIME.
        Plik manufacturersample musi mieć podany typ MIME.
        Userfield declaration [delimiter_bankaccount] [bank_account_holder] [bank_account_nr] [bank_sort_code] [bank_name] [bank_account_type] [bank_iban] [extra_field_1] [extra_field_2] [extra_field_3] [extra_field_4] [extra_field_5] Migrated
        port shoppers take 0 vm1 entries for migration
        Processed 0 vm1 users time: 2.14576721191406E-6
        port ST addresses take 0 vm1 entries for migration
        vendor 1 Stored
        port Products take 766 vm1 entries for migration


vmError: You are not an administrator or the correct vendor, storing of product cancelled
..... // many of these
vmError: You are not an administrator or the correct vendor, storing of product cancelled
Max messages reached

resor

Hello again,
I'am thinking that I'm closer to find out what is the issue here.

I'm guessing that this is 'slug' problem. My shop is a catalogue and there are products with the same name. In migrating process slug is generated from name with addition of current date. This generated name isn't unique and slug has to be unique .... and record is not inserted. Slug is inserted into localized table thats why I'm missing some records form this table.

Need to check it.

Regards
ResoR

resor

Hello,

Finally problem solved !! - mods can close this one

Issue was : When migrating several products with the same name slug is generated wrong.

I have changed in VmTable class (administrator/components/com_virtuemart/helpers/vmtable.php) method checkCreateUnique near line 599:

$posNbr = strrpos($this->$name,'-');
//$existingNbr = (int)substr($this->$name,$posNbr);
$existingNbr = (int)substr($this->$name,$posNbr+1);
$existingNbr++;
//$this->$name = substr($this->$name,0,-$posNbr) . '-' . $existingNbr;
$this->$name = substr($this->$name,0,$posNbr) . '-' . $existingNbr;

commented are old lines.

Now I have all products migrated .. i suppose this is a little bug.

regards
ResoR