Uploaded image for project: 'OFBiz'
  1. OFBiz
  2. OFBIZ-6570

Anonymous unsubscribe from contact list generates an error

    Details

      Description

      When trying to unsubscribe as an anonymous user, following error is shown:

      Exception thrown while creating the "newEntity" GenericValue: org.ofbiz.entity.GenericEntityException: Error while inserting: [GenericEntity:ContactListPartyStatus][contactListId,9000(java.lang.String)][createdStamp,2015-08-06 12:26:31.205(java.sql.Timestamp)][createdTxStamp,2015-08-06 12:26:31.007(java.sql.Timestamp)][lastUpdatedStamp,2015-08-06 12:26:31.205(java.sql.Timestamp)][lastUpdatedTxStamp,2015-08-06 12:26:31.007(java.sql.Timestamp)][partyId,_NA_(java.lang.String)][setByUserLoginId,system(java.lang.String)][statusDate,2015-08-06 12:26:31.205(java.sql.Timestamp)][statusId,CLPT_UNSUBS_PENDING(java.lang.String)] (SQL Exception while executing the following:INSERT INTO OFBIZ.CONTACT_LIST_PARTY_STATUS (CONTACT_LIST_ID, PARTY_ID, FROM_DATE, STATUS_DATE, STATUS_ID, SET_BY_USER_LOGIN_ID, OPT_IN_VERIFY_CODE, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (Column 'FROM_DATE' cannot accept a NULL value.)) (Error while inserting: [GenericEntity:ContactListPartyStatus][contactListId,9000(java.lang.String)][createdStamp,2015-08-06 12:26:31.205(java.sql.Timestamp)][createdTxStamp,2015-08-06 12:26:31.007(java.sql.Timestamp)][lastUpdatedStamp,2015-08-06 12:26:31.205(java.sql.Timestamp)][lastUpdatedTxStamp,2015-08-06 12:26:31.007(java.sql.Timestamp)][partyId,_NA_(java.lang.String)][setByUserLoginId,system(java.lang.String)][statusDate,2015-08-06 12:26:31.205(java.sql.Timestamp)][statusId,CLPT_UNSUBS_PENDING(java.lang.String)] (SQL Exception while executing the following:INSERT INTO OFBIZ.CONTACT_LIST_PARTY_STATUS (CONTACT_LIST_ID, PARTY_ID, FROM_DATE, STATUS_DATE, STATUS_ID, SET_BY_USER_LOGIN_ID, OPT_IN_VERIFY_CODE, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (Column 'FROM_DATE' cannot accept a NULL value.)))
      

        Activity

        Hide
        shi.jinghai Shi Jinghai added a comment -

        Hi Pierre,

        I tried to reproduce this error in my local enviroment but failed. Could you point out the step(s) to reproduce it?

        TIA,

        Show
        shi.jinghai Shi Jinghai added a comment - Hi Pierre, I tried to reproduce this error in my local enviroment but failed. Could you point out the step(s) to reproduce it? TIA,
        Hide
        shi.jinghai Shi Jinghai added a comment -

        I found a error while check this issue:
        org.ofbiz.webapp.control.RequestHandlerException: No definition found for view with name []

        The steps to reproduce it:
        1. A fresh installation of trunk by load-demo target.
        2. Login with admin/ofbiz to /ecommerce/.
        3. Logout.
        4. In "Sign Up For Contact List" section, fill "Email" field with test@test.com and click "Unsubscribe".
        5. "No definition found for view with name []" displays.

        This can be fixed by adding value="main" to the "error" response.

        Show
        shi.jinghai Shi Jinghai added a comment - I found a error while check this issue: org.ofbiz.webapp.control.RequestHandlerException: No definition found for view with name [] The steps to reproduce it: 1. A fresh installation of trunk by load-demo target. 2. Login with admin/ofbiz to /ecommerce/. 3. Logout. 4. In "Sign Up For Contact List" section, fill "Email" field with test@test.com and click "Unsubscribe". 5. "No definition found for view with name []" displays. This can be fixed by adding value="main" to the "error" response.
        Hide
        shi.jinghai Shi Jinghai added a comment -

        Submitted in trunk rev. 1696018.

        Show
        shi.jinghai Shi Jinghai added a comment - Submitted in trunk rev. 1696018.
        Hide
        jacques.le.roux Jacques Le Roux added a comment -

        Please Pierre Smits confirm and close if necessary
        Shi Jinghai should we not backport to releases?

        Show
        jacques.le.roux Jacques Le Roux added a comment - Please Pierre Smits confirm and close if necessary Shi Jinghai should we not backport to releases?
        Hide
        jacques.le.roux Jacques Le Roux added a comment -

        Backported in
        R14.12 r1705455
        R13.07 r1705456
        R12.04 r1705457

        Show
        jacques.le.roux Jacques Le Roux added a comment - Backported in R14.12 r1705455 R13.07 r1705456 R12.04 r1705457

          People

          • Assignee:
            shi.jinghai Shi Jinghai
            Reporter:
            pfm.smits Pierre Smits
          • Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

            • Created:
              Updated:
              Resolved:

              Development