i found that if i delete a weblog's creating user, something strange happens to the weblog. the system acts like the weblog does not exist, but any attempt to re-create it results in:

/ERROR 2006-04-17 11:22:28,391 HibernateStrategy:store - EXCEPTION storing object, id=4092c2870aa906b4010aa916dae5004d, class={1} org.hibernate.PropertyValueException: not-null property references a null or transient value: org.roller.pojos.WebsiteData.creator at org.hibernate.engine.Nullability.checkNullability(Nullability.java:72)/

if i then re-create the same user name, an attempt to re-create results in:

/WARN 2006-04-17 11:27:25,417 JDBCExceptionReporter:logExceptions - SQL Error: 1062, SQLState: 23000 ERROR 2006-04-17 11:27:25,424 JDBCExceptionReporter:logExceptions - Duplicate entry 'xxx' for key 2 ERROR 2006-04-17 11:27:25,430 AbstractFlushingEventListener:performExecutions - Could not synchronize database state with session org.hibernate.exception.ConstraintViolationException: Could not execute JDBC batch update at org.hibernate.exception.ErrorCodeConverter.convert(ErrorCodeConverter.java:74)/

("xxx" is the weblog handle).

i don't think it makes sense to delete or otherwise disable a weblog if the creating user is deleted. it seems like the creating user should be a user that is initially given admin membership to the weblog, and nothing more. maybe just keep the creating user as an unlinked string for reference purposes.

regardless, it if weblog deletion upon creating user deletion is expected, it seems like the system is not behaving properly and fully removing the weblog.

thoughts?

Reply via email to