Skip to main content

This site requires you to update your browser. Your browsing experience maybe affected by not having the most up to date version.

We're retiring the forums!

The SilverStripe forums have passed their heyday. They'll stick around, but will be read only. We'd encourage you to get involved in the community via the following channels instead:

General Questions /

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

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

dev/build issue on MS SQL database

Go to End


iON creative

Community Member, 42 Posts

10 October 2011 at 11:54am

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))
Index BlogEntry_versions.Version: changed to (Version) (from unique (Version))
Index BlogTree_versions.Version: changed to (Version) (from unique (Version))
Index BlogTree_versions.SideBarID: changed to (SideBarID) (from unique (SideBarID))
Index NewsPage_versions.Version: changed to (Version) (from unique (Version))
Index ErrorPage_versions.Version: changed to (Version) (from unique (Version))
Index RedirectorPage_versions.Version: changed to (Version) (from unique (Version))
Index VirtualPage_versions.Version: changed to (Version) (from unique (Version))
Index UserDefinedForm_versions.Version: changed to (Version) (from unique (Version))
Index BlogHolder_versions.Version: changed to (Version) (from unique (Version))