VirtueMart Forum

VirtueMart 2 + 3 + 4 => Installation, Migration & Upgrade => Topic started by: webbie65 on August 16, 2012, 17:26:11 PM

Title: Not all products are integrated - error max script time
Post by: webbie65 on August 16, 2012, 17:26:11 PM
Maybe you can help me:

I have 13.000 products which i want to migrate from joomla 1.5 to joomla 2.5.
the database works very fine, everything is in it, but when i want to migrate the
data into the programm stops always at 500 products. I have this error:

Quote

        vmdebug self::$_jpConfig->lang de_de
        vmdebug vmTime: loadConfig db no: 0.0051100254058838
        Found prior migration process, resume migration maxScriptTime 239999 maxMemoryLimit 12786
        vmdebug Migrating Products, free ram left 12781 so limit chunk to 1000
        vmdebug $limit
        Worked on general migration for 10742.098927975 seconds
        1
        vmdebug self::$_jpConfig->lang de_de
        vmdebug vmTime: loadConfig db no: 0.73197507858276

Maybe it is possible to put the max script time and also the memory limit higher?
Can you tell me, where i can find this , in which file? At now, I work local with xampp,
so it might be possible, to change the parameters.

Thank you very much!
Title: Re: Not all products are integrated - error max script time
Post by: jenkinhill on August 17, 2012, 12:04:24 PM
You change the limits in your php.ini file.
Title: Re: Not all products are integrated - error max script time
Post by: webbie65 on August 19, 2012, 17:56:16 PM
Maybe you can tell me exactly, which parameters must be change???
The changes i made, seems as not right, look at the code below:

Quote
        vmdebug self::$_jpConfig->lang de_de
        vmdebug vmTime: loadConfig db no: 0.0051329135894775
        Found prior migration process, resume migration maxScriptTime 239999 maxMemoryLimit 1279986
        vmdebug Migrating Products, free ram left 1279981 so limit chunk to 1000
        vmdebug $limit
        Worked on general migration for 11372.816137075 seconds
        1
        vmdebug self::$_jpConfig->lang de_de
        vmdebug vmTime: loadConfig db no: 0.8516800403595

I changed
memory_limit = 1280000M
max_input_time = 6000000
max_execution_time = 300000

Isn't that enough maybe or the wrong parameters???
I really dont know!

Thank you for your help!
Title: Re: Not all products are integrated - error max script time
Post by: Milbo on August 20, 2012, 13:34:46 PM
just repeat it. It is resuming "Found prior migration process, resume migration"
Title: Re: Not all products are integrated - error max script time
Post by: webbie65 on August 21, 2012, 10:27:17 AM
No, that cant be, it was already a repeating!
With the same result as before, just 500 articles, not more.
There must be still something wrong with the settings, but i am not shure,
which parameter i can change.

Best regards from germany, webbie
Title: Re: Not all products are integrated - error max script time
Post by: Milbo on August 21, 2012, 13:14:23 PM
Then you make 500 articles per step. This is usually 1 minute or so.
Title: Re: Not all products are integrated - error max script time
Post by: webbie65 on August 21, 2012, 16:08:56 PM
And where, do you think, should i tell my programm to load only 500 products?
Title: Re: Not all products are integrated - error max script time
Post by: Joe Bourque on December 12, 2012, 06:28:06 AM
Milbo,

I have am having problems too, I have 12,00 products in VM1 and when I run the migration I don't get over 1000 products in VM2. I have tried to rerun the migration multiple times and the number of products don't increase.

Am I missing something?

Thanks in advance.
Joe
Title: Re: Not all products are integrated - error max script time
Post by: Joe Bourque on January 10, 2013, 17:27:33 PM
Can I please get some help with this? I'm still able to migrate all my products I have tried everything and it will not bring in all products it stops at 1000
Title: Re: Not all products are integrated - error max script time
Post by: Milbo on January 11, 2013, 10:57:12 AM
Hmm I should add a button, so that you can delete the migration process. Looks like you had some hickup.
Title: Re: Not all products are integrated - error max script time
Post by: Joe Bourque on January 11, 2013, 16:07:53 PM
Quote from: Milbo on January 11, 2013, 10:57:12 AM
Hmm I should add a button, so that you can delete the migration process. Looks like you had some hickup.

Milbo is there way to to clear that manually?

Thanks in advance
Joe
Title: Re: Not all products are integrated - error max script time
Post by: axcelia on January 14, 2013, 12:53:32 PM
I have the same problem. I have been repeating the migration continually so far I have 2169 migrated but the number has stopped going up now and I'm missing around 400 products. Everything else has come across ok.

Edit: Ok after half an hour of repeated clicking I have got to 2191 products migrated but most clicks nothing gets imported across.


Update: Ok I managed to sort this out so no worries.
Title: Re: Not all products are integrated - error max script time
Post by: Joe Bourque on February 21, 2013, 15:57:48 PM
Can someone give a status how to fix this I have a client I need to migrate that has been waiting months :( any help would be appreciated.

Joe
Title: Re: Not all products are integrated - error max script time
Post by: axcelia on February 26, 2013, 12:04:07 PM
The way I did it was to keep clicking the import until they were all moved across. It took ages mind you but it does get there in the end.
One thing I found useful was to only select one section at a time e.g do users only first e.t.c. I kept clicking import and kept an eye on the Virtuemart Shoppers page until the number of shoppers matched the old version of Virtuemart and so on.

By the way to clear the migration table manually I think it is the table #_virtuemart_migration_oldtonew_ids you need to clear. It was awhile ago I did this though so I'm not 100% sure, but I do remember having to clear the migration table manually.

Another thing you can try is to type a larger number into "Server settings of max execution time" that seemed to help for me (I edited my php.ini settings first though).
Title: Re: Not all products are integrated - error max script time
Post by: Joe Bourque on March 11, 2013, 19:41:33 PM
Thanks axcelia I have been trying this too but no luck.

I just uninstalled and blew away Virtuemart and installed 2.18 and still NO LUCK I have 12k products to migrate and I can't get them to move into virtuement 2.0.

Can someone on the Virtuemart team give me some assistance with this problem I would be extremely grateful

Joe
Title: Re: Not all products are integrated - error max script time
Post by: antitranspiratie on March 14, 2013, 17:57:42 PM
I believe it also depends on the server speed and capacity. I also have to migrate about 20K products soon, hopefuly with no errors...

__________________