CodeGarden 10: The sixth annual Umbraco Developer Conference
June 23-25th 2010 - free ASP.NET MVC pre-conference. Register today!

ambiguous column name 'sortorder'

Go directly to solutionA reply has been marked as a solution
1/29/2010 2:36:00 PMAvatarNik WahlbergLocation: Providence, RI USAposts: 406Karma: 584

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

1/31/2010 3:52:26 PMAvatarTim GeyssensLocation: Zottegem, BelgiumMVP.Core.admin.posts: 1297Karma: 1147
Solution Comment with ID: 24943
0

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.

2/1/2010 7:36:22 AMAvatarTed JardineLocation: Langley, BC, CANADA V1M4C6posts: 49Karma: 63
Comment with ID: 24979

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.

 

2/1/2010 8:25:40 AMAvatarTim GeyssensLocation: Zottegem, BelgiumMVP.Core.admin.posts: 1297Karma: 1147
Comment with ID: 24982

Hi Ted,

We're looking into the problem right now.

Regards,
Tim

2/1/2010 5:27:40 PMAvatarNik WahlbergLocation: Providence, RI USAposts: 406Karma: 584
Comment with ID: 25052

Thanks Tim, I appreciate the help with this. 

Cheers.

2/3/2010 6:03:37 PMAvatarTim GeyssensLocation: Zottegem, BelgiumMVP.Core.admin.posts: 1297Karma: 1147
Comment with ID: 25316

Hi Nik,

Per solved the issue and we will get a new maintanance release out this week.

Regards,
Tim

2/3/2010 6:06:31 PMAvatarNik WahlbergLocation: Providence, RI USAposts: 406Karma: 584
Comment with ID: 25319

Awesome! Thanks man.

2/9/2010 4:47:07 AMAvatarsaintwrightLocation: 2095 australiaposts: 31Karma: 39
Comment with ID: 25735

Is the maintanance release out yet?

Please login or Sign up To post replies