You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@roller.apache.org by "Vidyadhar Salunkhe (JIRA)" <no...@atlassian.com> on 2007/11/26 12:47:34 UTC
[Roller-JIRA] Created: (ROL-1617) Unable to Add new User in Roller
3.1 version
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: Blocker
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
[Roller-JIRA] Updated: (ROL-1617) Unable to Add new User in Roller
3.1 version
Posted by "Contegix Administration Account (JIRA)" <no...@atlassian.com>.
[ http://opensource.atlassian.com/projects/roller/browse/ROL-1617?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Contegix Administration Account updated ROL-1617:
-------------------------------------------------
Comment: was deleted
> 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
[Roller-JIRA] Updated: (ROL-1617) Unable to Add new User in Roller
3.1 version
Posted by "David Johnson (JIRA)" <no...@atlassian.com>.
[ http://opensource.atlassian.com/projects/roller/browse/ROL-1617?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
David Johnson updated ROL-1617:
-------------------------------
Priority: Minor (was: Blocker)
Level of effort: n/a (was: Immediate)
Do you mean Microsoft SQL Server? If so, did you follow step 8.3 in the installation guide? Because, If you're using some other database with Roller, then you must override the Hibernate dialect. For SQL Server you'll need this dialect:
org.hibernate.dialect.SQLServerDialect
> 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
[Roller-JIRA] Commented: (ROL-1617) On MS SQL Server: Unable to add
new user in Roller 3.1 version
Posted by "David Johnson (JIRA)" <no...@atlassian.com>.
[ http://opensource.atlassian.com/projects/roller/browse/ROL-1617?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_14199 ]
David Johnson commented on ROL-1617:
------------------------------------
Instructions for subscribing to the dev and user lists are here:
http://cwiki.apache.org/confluence/display/ROLLER/Roller+Mailing+Lists
> On MS SQL Server: 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: Database Access & Data Model
> 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
[Roller-JIRA] Commented: (ROL-1617) Unable to Add new User in
Roller 3.1 version
Posted by "Contegix Administration Account (JIRA)" <no...@atlassian.com>.
[ http://opensource.atlassian.com/projects/roller/browse/ROL-1617?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_14196 ]
Contegix Administration Account commented on ROL-1617:
------------------------------------------------------
test
> 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
[Roller-JIRA] Updated: (ROL-1617) On MS SQL Server: Unable to add
new user in Roller 3.1 version
Posted by "David Johnson (JIRA)" <no...@atlassian.com>.
[ http://opensource.atlassian.com/projects/roller/browse/ROL-1617?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
David Johnson updated ROL-1617:
-------------------------------
Component/s: (was: User Management)
Database Access & Data Model
Summary: On MS SQL Server: Unable to add new user in Roller 3.1 version (was: Unable to Add new User in Roller 3.1 version)
> On MS SQL Server: 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: Database Access & Data Model
> 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
[Roller-JIRA] Commented: (ROL-1617) Unable to Add new User in
Roller 3.1 version
Posted by "David Johnson (JIRA)" <no...@atlassian.com>.
[ 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
[Roller-JIRA] Commented: (ROL-1617) On MS SQL Server: Unable to add
new user in Roller 3.1 version
Posted by "Vidyadhar Salunkhe (JIRA)" <no...@atlassian.com>.
[ http://opensource.atlassian.com/projects/roller/browse/ROL-1617?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_14198 ]
Vidyadhar Salunkhe commented on ROL-1617:
-----------------------------------------
Can you tell how do ask help on the Roller user list??? It is not possible for me to change the Database at this stage of project. Thanks once again.
> On MS SQL Server: 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: Database Access & Data Model
> 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
[Roller-JIRA] Commented: (ROL-1617) Unable to Add new User in
Roller 3.1 version
Posted by "Vidyadhar Salunkhe (JIRA)" <no...@atlassian.com>.
[ 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