Hi, I have installed Contour on a Windows 2003 server with SQL Server 2000 (had to modify the manual install scripts to run on 2k). I was able to create my first form but immediately after recieved the above error. Has anyone seen this before? This error appears in all nodes of Contour including the Contour Security tab in the Users section.
[SqlHelperException: Umbraco Exception (DataLayer): SQL helper exception in ExecuteReader] umbraco.DataLayer.SqlHelper`1.ExecuteReader(String commandText, IParameter[] parameters) +137 Umbraco.Forms.Data.Storage.FieldStorage.GetAllFields(FieldSet fieldset) in d:\TeamCity\buildAgent\work\39da791f9304089a\Umbraco.Forms.Core\Data\FormStorage\FieldStorage.cs:67 Umbraco.Forms.Data.Storage.FieldSetStorage.GetAllFieldSets(Page page) in d:\TeamCity\buildAgent\work\39da791f9304089a\Umbraco.Forms.Core\Data\FormStorage\FieldSetStorage.cs:42 Umbraco.Forms.Data.Storage.PageStorage.GetAllPages(Form form) in d:\TeamCity\buildAgent\work\39da791f9304089a\Umbraco.Forms.Core\Data\FormStorage\PageStorage.cs:41 Umbraco.Forms.Data.Storage.<>c__DisplayClass2.<GetAllForms>b__0() in d:\TeamCity\buildAgent\work\39da791f9304089a\Umbraco.Forms.Core\Data\FormStorage\FormStorage.cs:51 umbraco.cms.businesslogic.cache.Cache.GetCacheItem(String cacheKey, Object syncLock, CacheItemPriority priority, CacheItemRemovedCallback refreshAction, CacheDependency cacheDependency, TimeSpan timeout, GetCacheItemDelegate`1 getCacheItem) +109 umbraco.cms.businesslogic.cache.Cache.GetCacheItem(String cacheKey, Object syncLock, CacheItemPriority priority, CacheItemRemovedCallback refreshAction, TimeSpan timeout, GetCacheItemDelegate`1 getCacheItem) +84 umbraco.cms.businesslogic.cache.Cache.GetCacheItem(String cacheKey, Object syncLock, CacheItemRemovedCallback refreshAction, TimeSpan timeout, GetCacheItemDelegate`1 getCacheItem) +80 Umbraco.Forms.Core.Services.CacheService.GetCacheItem(String cacheKey, Object syncLock, TimeSpan timeout, GetCacheItemDelegate`1 getCacheItem) in d:\TeamCity\buildAgent\work\39da791f9304089a\Umbraco.Forms.Core\Services\CacheService\CacheService.cs:62 Umbraco.Forms.Data.Storage.FormStorage.GetAllForms() in d:\TeamCity\buildAgent\work\39da791f9304089a\Umbraco.Forms.Core\Data\FormStorage\FormStorage.cs:48 Umbraco.Forms.UI.Dashboard.FormsDashboard.Page_Load(Object sender, EventArgs e) in d:\TeamCity\buildAgent\work\39da791f9304089a\Umbraco.Forms.UI\Dashboard\FormsDashboard.ascx.cs:53 System.Web.Util.CalliHelper.EventArgFunctionCaller(IntPtr fp, Object o, Object t, EventArgs e) +15
Thanks,Nik
Hi Nik,
The "ambiguous column name" usually means that a SQL Statement is joining on more then one table and doesn't know wich column to retrieve.
So it looks like we'll need to update some of our statements to make them SQL 2000 compatible.
Same thing for me, but running on SQL Server 2008 (running on Windows Server 2008), with a site running on Windows Server 2008 R2 (so IIS 7.5 with application pool running under integrated pipeline).
Am considering purchasing, but not inspiring confidence! Please let me know if there's more info needed.
Hi Ted,
We're looking into the problem right now.
Regards,Tim
Thanks Tim, I appreciate the help with this.
Cheers.
Per solved the issue and we will get a new maintanance release out this week.
Awesome! Thanks man.
Is the maintanance release out yet?