Skip to:

  1. Skip to Jira Navigation
  2. Skip to Side Navigation
  3. Skip to Main Content

Upgrade from OF3.5 fails due to incorrect sqlserver database script

Description

http://www.igniterealtime.org/community/message/197718

There's a bug in number 17 of the sqlserver database scripts which prevents users from updating.

Environment

None

Activity

Show:

Guenther Niess January 5, 2010 at 11:36 PM

Commited a patch which is based on the proposal from Guus slightly smiling face

Guus der Kinderen January 5, 2010 at 3:27 AM

Daryls initial fix was rolled back by Guenther. I might have identified the problem. This issue could be caused by a lacking of casts in the subqueries. I've asked for verification in the discussion thread.

Guenther Niess November 5, 2009 at 2:03 PM

This causes a SQLException for embedded DBs.

Database setup or configuration error: Please verify your database settings and check the logs/error.log file for detailed error messages. java.lang.IllegalArgumentException: java.sql.SQLException: Unexpected token , requires FROM in statement [SELECT 1] at org.jivesoftware.openfire.XMPPServer.verifyDataSource(XMPPServer.java:719) at org.jivesoftware.openfire.XMPPServer.start(XMPPServer.java:436) at org.jivesoftware.openfire.XMPPServer.<init>(XMPPServer.java:169) at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39) at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27) at java.lang.reflect.Constructor.newInstance(Constructor.java:494) at java.lang.Class.newInstance0(Class.java:350) at java.lang.Class.newInstance(Class.java:303) at org.jivesoftware.openfire.starter.ServerStarter.start(ServerStarter.java:114) at org.jivesoftware.openfire.starter.ServerStarter.main(ServerStarter.java:59)

Daryl Herzmann October 31, 2009 at 3:23 AM

r11355 committed change.

Fixed

Details

Assignee

Reporter

Components

Fix versions

Affects versions

Priority

Created October 31, 2009 at 3:07 AM
Updated February 1, 2010 at 3:15 AM
Resolved January 5, 2010 at 11:36 PM

Flag notifications