Dear All,
I got the following error in step 3 while importing the attributes
Message: CDbCommand failed to execute the SQL statement: SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘AND attribute_group_name = ‘General’ LIMIT 1′ at line 1. The SQL statement executed was: SELECT * FROM `eav_attribute_group` `t` WHERE attribute_set_id = AND attribute_group_name = ‘General’ LIMIT 1
can anyone advise what is the issue
Thanks
5 answers
Hi Mohammed Abdelrasoul,
Kindly provide me the admin credentials, ssh credentials and web root path of your Magento2. I will check further and help you out.
Regards,
Mall.
Hello Mr.mall
i send to you all the credentials you asked for in private message.
i apperciate your fast response.
Kind Regards,
Hi there,
I got the following error in step 3 while importing the attributes
I have checked your working, and see that issue because you have big volume of Attribute Sets, Attribute Groups, Attributes but the php setting of the param named max_input_vars was not enough to handle that: http://i.prntscr.com/IXuzrwTfQxeAMoy1TUxGsw.png
To solve that issue lets do steps as bellow:
Step 1: Re-setting the php settings of param named max_input_vars to increases value on it to 10000 (max_input_vars = 10000)
and restart your web server after your changing.
Step 2: Once done, let’s start data migration with our tool as our guide in the Readme.html (included file in your downloaded package)
Regards,
Mall.
thank you Mr.Mall for your kind support
it’s working now perfectely
Hi there,
Yeah, let’s contact me if you need further assistance.
Regards,
Mall.