Jive Software Open Source

  • Log In Access more options
    • Online Help
    • Keyboard Shortcuts
    • About JIRA
    • JIRA Credits
    • What’s New
  • Dashboards Access more options (Alt+d)
  • Projects Access more options (Alt+p)
  • Issues Access more options (Alt+i)
  • Asterisk-IM
  • PHONE-75

Incorrect db script for MS SQL

  • Log In
  • Views
    • XML
    • Word
    • Printable

Details

  • Type: Bug Bug
  • Status: Resolved Resolved
  • Priority: Major Major
  • Resolution: Fixed
  • Affects Version/s: 1.4.0
  • Fix Version/s: 1.4.1
  • Component/s: Database
  • Labels:
    None
  • Acceptance Test - Add?:
    No

Description

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.

See http://www.igniterealtime.org/community/message/169164

Activity

  • All
  • Comments
  • Work Log
  • History
  • Activity
  • Source
  • Reviews
  • Builds
There are no comments yet on this issue.

People

  • Assignee:
    Stefan Reuter
    Reporter:
    Stefan Reuter
Vote (0)
Watch (0)

Dates

  • Created:
    04/23/08 01:56 PM
    Updated:
    04/23/08 01:57 PM
    Resolved:
    04/23/08 01:57 PM
  • Atlassian JIRA (v5.0.4#731-sha1:3aa7374)
  • Report a problem
  • Powered by a free Atlassian JIRA open source license for igniterealtime.org. Try JIRA - bug tracking software for your team.