problem creating a template

Use this forum for questions regarding installation, upgrading and configuration of OpenEMM

Moderator: moderator

ago
Posts: 3
Joined: Sat Sep 26, 2015 12:10 am

problem creating a template

Post by ago » Sat Sep 26, 2015 12:21 am

When testing out a new install, I first tried to create a template. I get a "A general error occurred. Please check your input", but it's not all clear what I'm missing, doing wrong. I run into similar problems when attempting a test mailing. In fact the only thing I've been able to do successfully is add new recipients.

I did notice the following in the log, which doesn't look good.

2015-09-25 18:16:31,671: WARN [http-nio-8080-exec-2] org.hibernate.util.JDBCExceptionReporter - SQL Error: 1048, SQLState: 23000
2015-09-25 18:16:31,672: ERROR [http-nio-8080-exec-2] org.hibernate.util.JDBCExceptionReporter - Column 'creation_date' cannot be null
2015-09-25 18:16:31,673: ERROR [http-nio-8080-exec-2] org.agnitas.web.MailingBaseAction - execute: org.springframework.dao.DataIntegrityViolationException: could not insert: [M
ailing]; SQL [insert into mailing_tbl (company_id, campaign_id, shortname, description, mailing_type, is_template, needs_target, mailtemplate_id, mailinglist_id, deleted, archi
ved, target_expression, creation_date, openaction_id, clickaction_id, dynamic_template) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)]; constraint [null]; nested exce
ption is org.hibernate.exception.ConstraintViolationException: could not insert: [Mailing]
org.springframework.dao.DataIntegrityViolationException: could not insert: [Mailing]; SQL [insert into mailing_tbl (company_id, campaign_id, shortname, description, mailing_typ
e, is_template, needs_target, mailtemplate_id, mailinglist_id, deleted, archived, target_expression, creation_date, openaction_id, clickaction_id, dynamic_template) values (?,
?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)]; constraint [null]; nested exception is org.hibernate.exception.ConstraintViolationException: could not insert: [Mailing]
at org.springframework.orm.hibernate3.SessionFactoryUtils.convertHibernateAccessException(SessionFactoryUtils.java:643)
at org.springframework.orm.hibernate3.HibernateAccessor.convertHibernateAccessException(HibernateAccessor.java:412)

ago
Posts: 3
Joined: Sat Sep 26, 2015 12:10 am

Re: problem creating a template

Post by ago » Mon Oct 05, 2015 4:34 pm

Nothing?

Post Reply