Hi Boris, the database you're using here, is it a brand-new database
installed by Roller 5.1.x, or did you just place the 5.1.x on a 5.0.4
database without running the 5.0.x-->5.1 database migration?
Does the below problem happen regardless of what your blog entry is?
I.e., even if the blog entry contains just a single letter "a", you get
the same problem? Have you gotten any blog entries to post correctly,
or they always fail with the below error?
In system admin screen, did you delete all your ping targets? That
could be a bug in Roller that it is trying to write a ping target entry
but there are no ping targets defined for some reason. Few people need
the ping functionality today, if you set pings.disablePingUsage=true in
your roller-custom.properties (line 519 here:
http://svn.apache.org/viewvc/roller/trunk/app/src/main/resources/org/apache/roller/weblogger/config/roller.properties?revision=1618360&view=markup)
and override tasks.enabled and remove PingQueueTask from it (line 233 in
the same file), this problem should go away. That said, you shouldn't
have to do that, my blog is on 5.1.1 and the Roller team blog is on
5.1.2-SNAPSHOT and it doesn't have that problem, but if you don't have
any ping targets then there's no reason to activate the Ping functionality.
Glen
On 10/30/2014 4:24 AM, Boris wrote:
Persistence Services - 2.5.2.v20140319-9ad6abd):
org.eclipse.persistence.exceptions.DatabaseException
Internal Exception:
com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolat
ionException:
Column 'pingtargetid' cannot be null
Error Code: 1048
Call: INSERT INTO pingqueueentry (id, attempts, entrytime, pingtargetid,
websiteid) VALUES (?, ?, ?, ?, ?)
bind => [5 parameters bound]
Query: InsertObjectQuery({52d75a1d-fbce-4cc6-a55f-8b30b2e6283f,
2014-10-29
23:43:17.553, 0})
at
org.eclipse.persistence.internal.jpa.transaction.
EntityTransactionImpl.commit(EntityTransactionImpl.java:157)
at
org.apache.roller.weblogger.business.jpa.JPAPersistenceStrategy.flush(
JPAPersistenceStrategy.java:135)
at
org.apache.roller.weblogger.business.jpa.JPAWebloggerImpl.
flush(JPAWebloggerImpl.java:105)
at
org.apache.roller.weblogger.ui.struts2.editor.EntryEdit.
save(EntryEdit.java:252)
at
org.apache.roller.weblogger.ui.struts2.editor.EntryEdit.
publish(EntryEdit.java:168)
