OroCRM Forums

Covering OroCRM topics, including community updates and company announcements.

Forums Forums OroCRM OroCRM – Installation/Technical Issues or Problems Magento bridge sync error email

This topic contains 1 reply, has 2 voices, and was last updated by  Alexandr Smaga 6 years, 4 months ago.

Starting from March 1, 2020 the forum has been switched to the read-only mode. Please head to StackOverflow for support.

  • Creator
    Topic
  • #26016
    bogma001
    bogma001
    Participant

    Dear Oro,

    while using the latest version 1.1.0 and magento bridge 1.1.0
    and creating a new channel I still keep on getting the following errors

    is this a magento or oro issue?
    ————————————————–

    [notice] Run sync for “shop” channel.
    [error] Errors were occurred:
    [error] An exception occurred while executing ‘INSERT INTO orocrm_contact_email (email, is_primary, owner_id) VALUES (?, ?, ?)’ with params [null, 1, 123]:

    SQLSTATE[23000]: Integrity constraint violation: 1048 Column ’email’ cannot be null
    [error] Errors were occurred:
    [error] The EntityManager is closed.
    [error] Errors were occurred:
    [error] The EntityManager is closed.
    [error] Errors were occurred:
    [error] The EntityManager is closed.
    [notice] Completed

    PHP Notice: Undefined index: email in /var/www/crm-application/vendor/oro/crm/src/OroCRM/Bundle/MagentoBundle/ImportExport/Serializer/CustomerDenormalizer.php on line 272
    PHP Notice: Undefined index: email in /var/www/crm-application/vendor/oro/crm/src/OroCRM/Bundle/MagentoBundle/ImportExport/Serializer/CustomerDenormalizer.php on line 272

    ———–

    form log file

    SQLSTATE[23000]: Integrity constraint violation: 1048 Column ’email’ cannot be null [] []
    [2014-04-29 15:45:12] batch.DEBUG: Step execution complete: id=9, name=[import], status=[6], exitCode=[EXECUTING], exitDescription=[], readCount=100, writeCount=0, filterCount=0 [] []
    [2014-04-29 15:45:12] batch.DEBUG: Upgrading JobExecution status: startTime=2014-04-29T13:45:04+00:00, endTime=, updatedTime=, status=3, exitStatus=[UNKNOWN] , exitDescription=[], job=[mage_customer_import_2014_04_29_15_45_04_535face0924594_78647143] [] []
    [2014-04-29 15:45:12] batch.DEBUG: Job execution starting: startTime=, endTime=, updatedTime=, status=2, exitStatus=[UNKNOWN] , exitDescription=[], job=[mage_cart_import_2014_04_29_15_45_12_535face82696b1_30272814] [] []
    [2014-04-29 15:45:12] batch.INFO: Step execution starting: id=0, name=[import], status=[2], exitCode=[EXECUTING], exitDescription=[], readCount=0, writeCount=0, filterCount=0 [] []

Viewing 1 replies (of 1 total)
  • Author
    Replies
  • #26017

    Alexandr Smaga
    Participant

    Hello.

    It says that your customer do not have email, that’s not possible for magento and due to this it provokes error in ORO. We are planning to make most fields not required in ORO because a lot of magento instances have broken data(caused by some import or some extensions) in nearest release.

Viewing 1 replies (of 1 total)

The forum ‘OroCRM – Installation/Technical Issues or Problems’ is closed to new topics and replies.

You will be redirected to [title]. Would you like to continue?

Yes No