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

dev/build issue on MS SQL database


Go to End
Reply


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