Hi,
- I have already buy Data Migration pro 3.1.5 ( work with magento 2.2.5), we run migrate, it can migrate some field but with visibility and status they are null http://prntscr.com/kd9tjq. We have already check in eav_attribute table the attribute_id = 97( status), = 99 ( visibility) and we check in catalog_product_entity_int with attribute id = 97 and 99 they are null
- Please tell me how to fix this?
Thanks
16 answers
Hi there,
we run migrate, it can migrate some field but with visibility and status they are null http://prntscr.com/kd9tjq. We have already check in eav_attribute table the attribute_id = 97( status), = 99 ( visibility) and we check in catalog_product_entity_int with attribute id = 97 and 99 they are null
What is the version of your Magento 1? It seems your M1 database has a special setting on the attributes ‘visibility’ and ‘status’ which are not the default settings of Magento core).
I need a closer look to debug further, please provide me the following credentials:
- Admin URL of your M2 instance
- Admin and SSH credentials of your M2 instance
- Let me know the path of your Magento 2 web root folder
- phpMyadmin credentials of your M1 and M2 databases.
I will help to check further and get back to you then.
PS. Please make sure you mark your reply as a private reply, then you’re safe to provide your site credentials here. Only you and our technical team can access.
Regards,
Mall.
Hi,
What is the version of your Magento 1?
=> magento 1.9.3.7
It seems your M1 database has a special setting on the attributes ‘visibility’ and ‘status’ which are not the default settings of Magento core).
=> i see they are default setting http://prntscr.com/kdekws
-Now we are doing a test on localhost. Can you please tell me some case which you think that’s cause and we will check more by ourself first
Thanks
Hi there,
-Now we are doing a test on localhost. Can you please tell me some case which you think that’s cause and we will check more by ourself first
Let’s capture for me the screenshots of the two product attributes ‘visibility’ and ‘status’ in table ‘eav_attribute’ in Magento1 database.
Regards,
Mall.
Hi
Let’s capture for me the screenshots of the two product attributes ‘visibility’ and ‘status’ in table ‘eav_attribute’ in Magento1 database.
=> https://prnt.sc/kdfb6m
-why other fields are ok only 2 field have problem
Thanks
Hi there,
I have checked but didn’t see any special settings on those attributes. As the issue you mentioned is strange, please move your instance to a live staging server and provide me your site credentials as my previous reply.
I will help to check further and get back to you then.
Regards,
Mall.
Hi,
- My server is weak got Internal Server Error http://prntscr.com/kdvud3, so we will send our database to you and you will check more detail??.
Thanks
Hi there,
- after install on live system got error http://prntscr.com/kdw12s, on localhost run ok but on my hosting is error, please check why
Here is root of that issue: http://i.prntscr.com/R7w3WqdhTOKSnO1THyFdEg.png
Do you have see the source code folder of our tool at below paht path?
pub/ub-tool/
Does your server is Nginx? If yes, you must do some extra settings for Nginx server as indicated in the guide of our tool in Readme.html.
If you still couldn’t solve the issue, let’s provide me more the SSH credentials of your M2 instance. I will help to check further and reply you more later.
Regards,
Mall.
Hi,
- i sent you private information in previous message ,please check, why visibilty and status still null
Hi there,
I have checked further into your instance and saw the root of issue you mentioned as per the screenshots below:
http://i.prntscr.com/DZm7oJLIQAGkeFZFw2_0wQ.png
http://i.prntscr.com/oy1GSRJpQ3SzcdHolD5lAQ.png
As you see, your M1 database has a large number of product attributes, but your server has limited max_input_vars setting.
As a result, you have not migrated all product attributes in the step #3 of our tool, and the ‘visibility’ and ‘status’… attributes were missing.
To solve that issue, please do steps below:
+ Contact to your hosting provider to increase the value of the PHP param named ‘max_input_vars’ to:
max_input_vars = 10000
+ And restart web server after updating such change.
+ Then, reset and restart data migration from step #3.
Once done, the issue should be resolve.
Regards,
Mall.
Hi,
- i set max_input_vars = 10000 http://prntscr.com/ke6jvm and the problem didn’t resolve http://prntscr.com/ke6k61
please check
Hi there,
i set max_input_vars = 10000 http://prntscr.com/ke6jvm and the problem didn’t
Did you reset and restart data migration from step #3 of our tool as my suggesting?
After changed that PHP setting. You must reset data migration in steps :#5, #4, #3
And then, restart data migration in these steps.
You could find how to reset step by step in the guide of our tool in Readme.html
php -f bin/ubdatamigration reset --step=5
php -f bin/ubdatamigration reset --step=4
php -f bin/ubdatamigration reset --step=3
Or you could do reset all steps by run below CLI command:
php -f bin/ubdatamigration reset
Regards,
Mall.
HI,
- I reset, please see old image: https://prnt.sc/ke3jan 312 records new image 200 records http://prntscr.com/ke6w47
after change max_input_vars = 10000, everything the same. Please check again
Hi,
- Seem the main problem is max_input_vars parameter, i see it work,
- i will check other part( customer migrate, sale…etc)
Thanks
Hi there,
Yeah, lets continue with other steps of data migration. And contact me if you need further assistance.
Regards,
Mall.