[
http://opensource.atlassian.com/projects/roller/browse/ROL-1617?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_14194
]
Vidyadhar Salunkhe commented on ROL-1617:
-----------------------------------------
Hi David,
Thanks for quick reply.
I have already changed the Dialect in the 'hibernate.cfg.xml' file
under 'C:\Tomcat5.5\webapps\roller\WEB-INF\classes' as follows:
<!--property
name="dialect">org.hibernate.dialect.MySQLDialect</property-->
<property
name="dialect">org.hibernate.dialect.SQLServerDialect</property>
<property name="show_sql">true</property>
Also I have created the 'roller-custom.properties' under
'C:\Tomcat5.5\common\classes' folder with following settings:
uploads.dir=C:\apache-roller-3.1\webapp\roller\roller_data\uploads
search.index.dir=C:\apache-roller-3.1\webapp\roller\roller_data\search-index
passwds.encryption.enabled=true
hibernate.dialect=org.hibernate.dialect.SQLServerDialect
Also to debug the issue I am logging the SQL queries and found
following query with 'limit' keyword in it.
Hibernate: select this_.id as id1_0_, this_.isenabled as isenabled1_0_,
this_.username as username1_0_, this_.passphrase as passphrase1_0_,
this_.fullname as fullname1_0_, this_.emailaddress as emailadd6_1_0_,
this_.datecreated as datecrea7_1_0_, this_.locale as locale1_0_, this_.timeZone
as timeZone1_0_ from rolleruser this_ where this_.datecreated<? and
this_.isenabled=? order by this_.datecreated desc limit ?
Let me know if I am doing anyting wrong in the setting.
Thanks & Regards,
Vidyadhar
> 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
