AnsweredAssumed Answered

Bug / Bugfix: SQL Script for MS SQL Server

Question asked by sfb on Apr 23, 2008
Latest reply on Apr 23, 2008 by Stefan Reuter

Hi,

 

Openfire 3.5 latest (downloaded yesterday), used the plugins section to download the Asterisk-IM plugin and the install failed.

 

SQL Server 2005, code from resources/asterisk-im_sqlserver.sql ...

 

phoneUser.userID is defined as an integer, phoneDevice.userID is a bigint, and the constraint linking the two fails because of this.

Redefining the phoneDevice.userID to be an integer allows the script to run.

Outcomes