Jump to:

23371 Posts in 18161 Topics by 2865 members

General Questions

SilverStripe Forums » General Questions » dev/build issue on MS SQL database

General questions about getting started with SilverStripe that don't fit in any of the categories above.

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

Page: 1
Go to End
Author Topic: 363 Views
  • B-Side
    Avatar
    Community Member
    42 Posts

    dev/build issue on MS SQL database Link to this post

    Hi there

    I am developing a site on my local dev server running MySQL for a production site running MS SQL. Most things are going smoothly for the deployment to the MS SQL server end (except MS SQL doesn't allow the LIMIT function!?).

    However I am getting an odd dev/build report each and every time I run it, even when nothing has been altered. It seems to want to change some column names as below. It doesn't throw an error, but I'm wondering if this is something I need to remedy? Any ideas?

    Thanks, Jayne

    Index File.SearchFields: changed to fulltext (Filename,Title,Content) (from fulltext (Title,Filename,Content))

    ...

    Index Page_versions.Version: changed to (Version) (from unique (Version))
    BlogEntry
    Index BlogEntry_versions.Version: changed to (Version) (from unique (Version))
    BlogTree
    Index BlogTree_versions.Version: changed to (Version) (from unique (Version))
    Index BlogTree_versions.SideBarID: changed to (SideBarID) (from unique (SideBarID))
    NewsHolder
    NewsPage
    Index NewsPage_versions.Version: changed to (Version) (from unique (Version))
    ErrorPage
    Index ErrorPage_versions.Version: changed to (Version) (from unique (Version))
    RedirectorPage
    Index RedirectorPage_versions.Version: changed to (Version) (from unique (Version))
    VirtualPage
    Index VirtualPage_versions.Version: changed to (Version) (from unique (Version))
    UserDefinedForm
    Index UserDefinedForm_versions.Version: changed to (Version) (from unique (Version))
    BlogHolder
    Index BlogHolder_versions.Version: changed to (Version) (from unique (Version))

    363 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.