I'm trying to export our production site for import on a test environment, but I get the following error:
Error exporting objects.
Message: [SqlHelper.BuildDistinctList] Forbidden character ',' is not supported in collection of values.
(full trace below)
A second error message seems to indicate that the problem is coming from Forum User Favorites:
@@Error getting 'Forum user favorites' data
Message: [SqlHelper.BuildDistinctList] Forbidden character ',' is not supported in collection of values.
But we aren't using Forums and the table Forums_UserFavorites is completely empty.
I'd appreciate any suggestions on how I can bypass this error and successfully export my site.
Full Trace:
Message: [SqlHelper.BuildDistinctList] Forbidden character ',' is not supported in collection of values.
Exception type: System.NotSupportedException
Stack Trace:
at CMS.DataEngine.SqlHelper.BuildDistinctList(IEnumerable values)
at CMS.DataEngine.SqlHelper.ParseList(String method, IEnumerable values, QueryDataParameters parameters)
at CMS.DataEngine.SelectCondition.PrepareWhereCondition(String usedColumn, String method, String columnName, IEnumerable values, Boolean negation)
at CMS.DataEngine.SelectCondition.PrepareCondition[T](String columnName, ICollection`1 values, Boolean negation)
at CMS.CMSImportExport.SiteExportSettings.EnsureAutomaticSelection(GeneralizedInfo infoObj, Boolean siteObjects)
at CMS.CMSImportExport.ExportProvider.GetExportData(SiteExportSettings settings, String objectType, Boolean siteObjects, Boolean childData, Boolean selectionOnly, TranslationHelper th)
at CMS.CMSImportExport.ExportProvider.ExportObjectType(SiteExportSettings settings, TranslationHelper th, String objectType, Boolean siteObjects)
at CMS.CMSImportExport.ExportProvider.ExportObjectsData(SiteExportSettings settings)
at CMS.CMSImportExport.ExportManager.Export(Object parameter)