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.

General Questions /

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

dev/build issue on MS SQL database


Reply


3 Posts   458 Views

Avatar
B-Side

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, 5513 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
B-Side

Community Member, 42 Posts

19 October 2011 at 6:07pm

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