[
https://issues.apache.org/jira/browse/ROL-1080?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Glen Mazza closed ROL-1080.
---------------------------
Resolution: Cannot Reproduce
The Roller version listed (2.1) is too old, please try with the 5.0.x version.
> Not nullable rolleruser.isenabled causes problems when disabling a user
> -----------------------------------------------------------------------
>
> Key: ROL-1080
> URL: https://issues.apache.org/jira/browse/ROL-1080
> Project: Roller
> Issue Type: Bug
> Components: Database Access & Data Model
> Affects Versions: 2.1
> Environment: Linux, Fedora Core 4, PostgreSQL , roller 2.1
> Reporter: Andrus Adamchik
> Assignee: Roller Unassigned
> Priority: Minor
>
> Global Admin -> User Admin screen.
> An attempt to uncheck "enabled" checkbox for a user results in this exception:
> Caused by: java.sql.BatchUpdateException: Batch entry 0 update rolleruser set
> isenabled=NULL, username=user2, passphrase=ttnm5%2, fulln
> ame=User 2, [email protected], datecreated=2006-03-10
> 07:47:44.675000-0500, locale=en_US, timeZone=America/New_York w
> here id=5083da3409e417090109e432c0300025 was aborted. Call getNextException
> to see the cause.
> at
> org.postgresql.jdbc2.AbstractJdbc2Statement$BatchResultHandler.handleError(AbstractJdbc2Statement.java:2392)
> at
> org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1257)
> at
> org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:334)
> at
> org.postgresql.jdbc2.AbstractJdbc2Statement.executeBatch(AbstractJdbc2Statement.java:2451)
> at
> org.apache.commons.dbcp.DelegatingStatement.executeBatch(DelegatingStatement.java:294)
> at
> org.hibernate.jdbc.BatchingBatcher.doExecuteBatch(BatchingBatcher.java:57)
> at
> org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:174)
> When I manually do "alter table rolleruser alter column isenabled drop not
> null;" in psql, user enable/disable operation starts to work again. I believe
> this is the file to fix:
> http://svn.apache.org/repos/asf/incubator/roller/trunk/web/WEB-INF/dbscripts/postgresql/130-to-200-migration.sql
> I am not submitting a patch, as I am new to Roller and maybe the fix on the
> UI end is preferrable (??) Also it seems that MySQL has this problem as well.
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira
