[ https://issues.apache.org/jira/browse/OFBIZ-6570?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Shi Jinghai reassigned OFBIZ-6570: ---------------------------------- Assignee: Shi Jinghai > Anonymous unsubscribe from contact list generates an error > ---------------------------------------------------------- > > Key: OFBIZ-6570 > URL: https://issues.apache.org/jira/browse/OFBIZ-6570 > Project: OFBiz > Issue Type: Bug > Components: marketing, specialpurpose/ecommerce > Affects Versions: Trunk > Reporter: Pierre Smits > Assignee: Shi Jinghai > > When trying to unsubscribe as an anonymous user, following error is shown: > {code} > 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.))) > {code} -- This message was sent by Atlassian JIRA (v6.3.4#6332)