[
https://issues.apache.org/jira/browse/OFBIZ-6570?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14702914#comment-14702914
]
Jacques Le Roux commented on OFBIZ-6570:
----------------------------------------
Please [~pfm.smits] confirm and close if necessary
[~shi.jinghai] should we not backport to releases?
> 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)
