[
http://opensource.atlassian.com/projects/roller/browse/ROL-1617?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_14197
]
David Johnson commented on ROL-1617:
------------------------------------
You should probably ask for help on the Roller user list. None of the Roller
developers use or test with MS SQL Server, but there may be some users who have
experience getting it to work with Roller.
And if possible, consider using one of the more commonly used databases: MySQL,
PostgreSQL or Derby.
> Unable to Add new User in Roller 3.1 version
> --------------------------------------------
>
> Key: ROL-1617
> URL:
> http://opensource.atlassian.com/projects/roller/browse/ROL-1617
> Project: Roller
> Issue Type: Bug
> Components: User Management
> Affects Versions: 3.1
> Environment: Windows XP, Tomcat 5.5.17, JDK 1.4.1_02
> Reporter: Vidyadhar Salunkhe
> Assignee: Roller Unassigned
> Priority: Minor
>
> Hi,
> I installed Roller 3.1 successfully. But when I am adding new user, it shows
> following error:
> INFO 2007-11-26 17:02:35,687 PreviewResourceServlet:init - Initializing
> PreviewResourceServlet
> INFO 2007-11-26 17:02:35,703 PreviewServlet:init - Initializing
> PreviewServlet
> ERROR 2007-11-26 17:07:32,500 FuturePostingsInvalidationJob:execute -
> java.lang.reflect.UndeclaredThrowableException
> WARN 2007-11-26 17:07:51,281 JDBCExceptionReporter:logExceptions - SQL
> Error: 102, SQLState: S1000
> ERROR 2007-11-26 17:07:51,281 JDBCExceptionReporter:logExceptions - Incorrect
> syntax near 'limit'.
> ERROR 2007-11-26 17:07:51,296 UserNewAction:add - ERROR in addUser
> org.apache.roller.RollerException
> at
> org.apache.roller.business.hibernate.HibernateUserManagerImpl.getUsers(HibernateUserManagerImpl.java:599)
> at
> org.apache.roller.business.hibernate.HibernateUserManagerImpl.getUsers(HibernateUserManagerImpl.java:575)
> at
> org.apache.roller.business.hibernate.HibernateUserManagerImpl.addUser(HibernateUserManagerImpl.java:252)
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://opensource.atlassian.com/projects/roller/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
