You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@roller.apache.org by "Glen Mazza (JIRA)" <ji...@apache.org> on 2013/01/07 02:25:13 UTC
[jira] [Closed] (ROL-1080) Not nullable rolleruser.isenabled causes
problems when disabling a user
[ 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, emailaddress=andrus@objectstyle.org, 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