Re: Roller system error

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)
>