Copied to clipboard

Flag this post as spam?

This post will be reported to the moderators as potential spam to be looked at


  • Nik Wahlberg 639 posts 1237 karma points MVP
    Jan 29, 2010 @ 14:36
    Nik Wahlberg
    0

    Ambiguous column name 'SortOrder'.

    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

  • Tim Geyssens 6562 posts 15373 karma points MVP 2x c-trib
    Jan 31, 2010 @ 15:52
    Tim Geyssens
    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.

  • Ted Jardine 98 posts 120 karma points
    Feb 01, 2010 @ 07:36
    Ted Jardine
    0

    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.

     

  • Tim Geyssens 6562 posts 15373 karma points MVP 2x c-trib
    Feb 01, 2010 @ 08:25
    Tim Geyssens
    0

    Hi Ted,

    We're looking into the problem right now.

    Regards,
    Tim

  • Nik Wahlberg 639 posts 1237 karma points MVP
    Feb 01, 2010 @ 17:27
    Nik Wahlberg
    0

    Thanks Tim, I appreciate the help with this. 

    Cheers.

  • Tim Geyssens 6562 posts 15373 karma points MVP 2x c-trib
    Feb 03, 2010 @ 18:03
    Tim Geyssens
    0

    Hi Nik,

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

    Regards,
    Tim

  • Nik Wahlberg 639 posts 1237 karma points MVP
    Feb 03, 2010 @ 18:06
    Nik Wahlberg
    0

    Awesome! Thanks man.

  • saintwright 69 posts 78 karma points
    Feb 09, 2010 @ 04:47
    saintwright
    0

    Is the maintanance release out yet?

  • This forum is in read-only mode while we transition to the new forum.

    You can continue this topic on the new forum by tapping the "Continue discussion" link below.

Please Sign in or register to post replies