Jump to:

1036 Posts in 810 Topics by 315 members

Forum Module

SilverStripe Forums » Forum Module » Forum Installation Failure using MSSQL2008

Discuss the Forum Module.

Moderators: martimiz, Sean, biapar, Willr, Ingo, swaiba, simon_w

Page: 1
Go to End
Author Topic: 1257 Views
  • GetCarter68
    Avatar
    Community Member
    3 Posts

    Forum Installation Failure using MSSQL2008 Link to this post

    I am trying to install the latest forum module release (0.3.1), though have also tried 0.3.0 but it fails with this when running dev/build:

    [User Error] Couldn't run query (42S22, 1911, [Microsoft][SQL Server Native Client 10.0][SQL Server]Column name 'fulltext (Title' does not exist in the target table or view.): IF EXISTS (SELECT name FROM sys.indexes WHERE name = 'ix_Post_SearchFields') DROP INDEX ix_Post_SearchFields ON "Post"; CREATE INDEX ix_Post_SearchFields ON "Post" ("fulltext (Title","Content");: [Microsoft][SQL Server Native Client 10.0][SQL Server]Column name 'fulltext (Title' does not exist in the target table or view.

    My environment is W2K8R2 and MSSQL 2008R2. I am also runnin on the latest version of the CMS 2.4.5 with the mssql module installed and working.

    Does anyone know how to fix this please? Thanks.

  • Willr
    Avatar
    Forum Moderator
    5511 Posts

    Re: Forum Installation Failure using MSSQL2008 Link to this post

    Hi,

    Please try the latest master release. That has a number of cross db improvements. I haven't tested the older releases on MSSQL or Postgres that much recently.

    https://github.com/silverstripe/silverstripe-forum

  • GetCarter68
    Avatar
    Community Member
    3 Posts

    Re: Forum Installation Failure using MSSQL2008 Link to this post

    Thanks for the quick reply.

    However I have tried 0.3.1 and this is the same error as reported earlier.

  • Willr
    Avatar
    Forum Moderator
    5511 Posts

    Re: Forum Installation Failure using MSSQL2008 Link to this post

    FYI 0.3.1 is not the latest master. On that github link it would be under 'master'.

  • GetCarter68
    Avatar
    Community Member
    3 Posts

    Re: Forum Installation Failure using MSSQL2008 Link to this post

    Thanks Willr, sorry when the popup came up I though the top of the list was the latest, but it was actually the download.zip button above that I should of used. New to the site, will know next time!

    All working now and thanks a lot for your help

    1257 Views
Page: 1
Go to Top

Want to know more about the company that brought you SilverStripe? Then check out SilverStripe.com

Comments on this website? Please give feedback.