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've moved the forum!

Please use forum.silverstripe.org for any new questions (announcement).
The forum archive will stick around, but will be read only.

You can also use our Slack channel or StackOverflow to ask for help.
Check out our community overview for more options to contribute.

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


3 Posts   1067 Views

Avatar
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))
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))

Avatar
Willr

Forum Moderator, 5523 Posts

19 October 2011 at 5:34pm

If it's blue then you don't need to worry too much about it. Likely the MSSQL engine isn't correctly detecting alterations so it won't hurt the data.

Avatar
iON creative

Community Member, 42 Posts

19 October 2011 at 6:07pm

Thanks for that Willr - that's what I was hoping. Cheers, Y.