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

  • Comment author was deleted

    Jan 31, 2010 @ 15:52

    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.

     

  • Comment author was deleted

    Feb 01, 2010 @ 08:25

    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.

  • Comment author was deleted

    Feb 03, 2010 @ 18:03

    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 77 karma points
    Feb 09, 2010 @ 04:47
    saintwright
    0

    Is the maintanance release out yet?

Please Sign in or register to post replies

Write your reply to:

Draft