1

getting the error while migrating data from magento CE 1.9.2.2 to magento EE 2.1

    Error:
    [2016-08-29 10:10:00][DEBUG][mode: data][stage: data migration]

[step: Customer Attributes Step][table: customer_entity]: migrating 100% [============================] 

Remaining Time: 1 sec [PDOException] SQLSTATE[HY093]: Invalid parameter 

number: number of bound variables does n ot match number of tokens

Anybody please help.

Thanks Meena R

Baby in Magento
  • 3,167
  • 16
  • 83
  • 221
meena
  • 31
  • 1
  • Exception trace: – meena Aug 29 '16 at 10:46
  • if you had find solution can you please post it because i am facing same issue. Thanks in advance ! – Yogesh Dec 31 '16 at 04:59
  • I had found the solution. please export your customer_entity table as CSV and check for wrong values I have found the invalid emails. – meena Jan 01 '17 at 06:20
  • and also I have found null and some invalid emails - for eg: somename without @gmail.com and some special characters. This may help you to solve the issues. – meena Jan 01 '17 at 06:26

0 Answers0