Copied to clipboard

Flag this post as spam?

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


  • Simon Burgess 1 post 21 karma points
    Jul 15, 2014 @ 11:46
    Simon Burgess
    0

    Unable to create export - Umbraco V7.1.4 + SQLCE4

    Hi

    Here is our config...

    • Umbraco version 7.1.4 assembly: 1.0.5261.28127
    • SqlCE4
    • Visual Studio 2012
    • .net 4.5 (I see the documentation say requires .net 3.5... is it 4.5 compatible?)
    • MemberExport Pro (license in bin folder)

    When we try to export member info I we get the below exception.

    Looks like the the SQL isNull() function is not supported in SQLCE4 (http://technet.microsoft.com/en-us/library/ms174065%28v=sql.110%29.aspx).

    Any ideas on how we can resolve this?

    Thanks,
    Simon

    Source Error:

    An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.


    Stack Trace:

    [SqlCeProviderException: Error running Reader: 
    SQL Statement:
    SELECT DISTINCT   node.[text] as __memberName ,node.createDate as __memberCreated, u.UserName as __memberCreatedBy ,m.nodeId AS __memberId, m.LoginName as __memberLogin, m.Password as __memberPassword, m.Email as __memberEmail, ct.alias as  __memberType   , CONVERT(NVARCHAR(2000), p28.dataNtext) as [umbracoMemberComments], p78.dataNvarchar as [rlapTitle], p79.dataNvarchar as [rlapFirstName], p80.dataNvarchar as [rlapLastName], p81.DataInt as [rlapDobDay], p82.DataInt as [rlapDobMonth], p83.DataInt as [rlapDobYear], p84.dataNvarchar as [rlapAddress], p85.dataNvarchar as [rlapPostcode], p86.dataNvarchar as [rlapCurrentCar], p87.dataNvarchar as [rlapTelephone], p88.dataNvarchar as [rlapEmail], p89.DataInt as [rlapValidLicence], p90.DataInt as [rlapNewsletter], p91.dataNvarchar as [rlapDonationId], p92.dataDate as [rlapDonationDate],  ',' +  CONVERT(NVARCHAR(10), isnull( CM1124.MemberGroup,''))  +  ',' +  CONVERT(NVARCHAR(10), isnull( CM1201.MemberGroup,''))  +  ',' +  CONVERT(NVARCHAR(10), isnull( CM1150.MemberGroup,''))  +  ',' +  CONVERT(NVARCHAR(10), isnull( CM1144.MemberGroup,''))  +  ',' +  CONVERT(NVARCHAR(10), isnull( CM1165.MemberGroup,''))  +  ',' +  CONVERT(NVARCHAR(10), isnull( CM1146.MemberGroup,''))  +  ',' +  CONVERT(NVARCHAR(10), isnull( CM1153.MemberGroup,''))  +  ',' +  CONVERT(NVARCHAR(10), isnull( CM1207.MemberGroup,''))  +  ',' +  CONVERT(NVARCHAR(10), isnull( CM1152.MemberGroup,''))  as __memberGroups  FROM  cmsMember AS m  Inner join umbracoNode as node on m.nodeId = node.id Inner join umbracoUser as u on node.nodeUser = u.id   INNER JOIN cmsContent as c on m.nodeId = c.nodeId and c.contentType = 1044 INNER JOIN cmsContentType as ct on c.contentType = ct.nodeId  INNER JOIN cmsPropertyData AS p28 ON p28.contentNodeId = m.nodeId AND p28.propertytypeid = 28  INNER JOIN cmsPropertyData AS p78 ON p78.contentNodeId = m.nodeId AND p78.propertytypeid = 78  INNER JOIN cmsPropertyData AS p79 ON p79.contentNodeId = m.nodeId AND p79.propertytypeid = 79  INNER JOIN cmsPropertyData AS p80 ON p80.contentNodeId = m.nodeId AND p80.propertytypeid = 80  INNER JOIN cmsPropertyData AS p81 ON p81.contentNodeId = m.nodeId AND p81.propertytypeid = 81  INNER JOIN cmsPropertyData AS p82 ON p82.contentNodeId = m.nodeId AND p82.propertytypeid = 82  INNER JOIN cmsPropertyData AS p83 ON p83.contentNodeId = m.nodeId AND p83.propertytypeid = 83  INNER JOIN cmsPropertyData AS p84 ON p84.contentNodeId = m.nodeId AND p84.propertytypeid = 84  INNER JOIN cmsPropertyData AS p85 ON p85.contentNodeId = m.nodeId AND p85.propertytypeid = 85  INNER JOIN cmsPropertyData AS p86 ON p86.contentNodeId = m.nodeId AND p86.propertytypeid = 86  INNER JOIN cmsPropertyData AS p87 ON p87.contentNodeId = m.nodeId AND p87.propertytypeid = 87  INNER JOIN cmsPropertyData AS p88 ON p88.contentNodeId = m.nodeId AND p88.propertytypeid = 88  INNER JOIN cmsPropertyData AS p89 ON p89.contentNodeId = m.nodeId AND p89.propertytypeid = 89  INNER JOIN cmsPropertyData AS p90 ON p90.contentNodeId = m.nodeId AND p90.propertytypeid = 90  INNER JOIN cmsPropertyData AS p91 ON p91.contentNodeId = m.nodeId AND p91.propertytypeid = 91  INNER JOIN cmsPropertyData AS p92 ON p92.contentNodeId = m.nodeId AND p92.propertytypeid = 92  LEFT JOIN cmsMember2MemberGroup as CM1124 ON CM1124.Member =  m.nodeId and CM1124.MemberGroup = 1124  LEFT JOIN cmsMember2MemberGroup as CM1201 ON CM1201.Member =  m.nodeId and CM1201.MemberGroup = 1201  LEFT JOIN cmsMember2MemberGroup as CM1150 ON CM1150.Member =  m.nodeId and CM1150.MemberGroup = 1150  LEFT JOIN cmsMember2MemberGroup as CM1144 ON CM1144.Member =  m.nodeId and CM1144.MemberGroup = 1144  LEFT JOIN cmsMember2MemberGroup as CM1165 ON CM1165.Member =  m.nodeId and CM1165.MemberGroup = 1165  LEFT JOIN cmsMember2MemberGroup as CM1146 ON CM1146.Member =  m.nodeId and CM1146.MemberGroup = 1146  LEFT JOIN cmsMember2MemberGroup as CM1153 ON CM1153.Member =  m.nodeId and CM1153.MemberGroup = 1153  LEFT JOIN cmsMember2MemberGroup as CM1207 ON CM1207.Member =  m.nodeId and CM1207.MemberGroup = 1207  LEFT JOIN cmsMember2MemberGroup as CM1152 ON CM1152.Member =  m.nodeId and CM1152.MemberGroup = 1152  inner join [cmsMember2MemberGroup] g on m.nodeId = g.Member and  (  g.MemberGroup = 1124  or  g.MemberGroup = 1201  or  g.MemberGroup = 1150  or  g.MemberGroup = 1144  or  g.MemberGroup = 1165  or  g.MemberGroup = 1146  or  g.MemberGroup = 1153  or  g.MemberGroup = 1207  or  g.MemberGroup = 1152  )  ORDER BY __memberName
    
    Exception:
    System.Data.SqlServerCe.SqlCeException (0x80004005): The number of arguments specified for the function is not correct. [ Minimum argument count = 1, Maximum argument count = 1,Name of function(if known) = isnull ]
       at System.Data.SqlServerCe.SqlCeCommand.ProcessResults(Int32 hr)
       at System.Data.SqlServerCe.SqlCeCommand.CompileQueryPlan()
       at System.Data.SqlServerCe.SqlCeCommand.ExecuteCommand(CommandBehavior behavior, String method, ResultSetOptions options)
       at System.Data.SqlServerCe.SqlCeCommand.ExecuteReader(CommandBehavior behavior)
       at SqlCE4Umbraco.SqlCeApplicationBlock.ExecuteReader(String connectionString, CommandType commandType, String commandText, SqlCeParameter[] commandParameters)]
       SqlCE4Umbraco.SqlCeApplicationBlock.ExecuteReader(String connectionString, CommandType commandType, String commandText, SqlCeParameter[] commandParameters) +184
       SqlCE4Umbraco.SqlCEHelper.ExecuteReader(String commandText, SqlCeParameter[] parameters) +37
       umbraco.DataLayer.SqlHelper`1.ExecuteReader(String commandText, IParameter[] parameters) +82
    
    [SqlHelperException: Umbraco Exception (DataLayer): SQL helper exception in ExecuteReader]
       umbraco.DataLayer.SqlHelper`1.ExecuteReader(String commandText, IParameter[] parameters) +202
       MemberExport.DAL.MemberData.GetAllMembers(List`1 fields, List`1 membergroups, Int32 memberType, Int32 amountOfRecords, Boolean includeGroups) +533
       MemberExport.Library.Helpers.ExportHelper.ExportMembers(ExportState state) +397
       MemberExport.Usercontrols.MemberExport.ExportButton_Click(Object sender, EventArgs e) +44
       System.Web.UI.WebControls.Button.OnClick(EventArgs e) +9615682
       System.Web.UI.WebControls.Button.RaisePostBackEvent(String eventArgument) +103
       System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument) +10
       System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) +13
       System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) +35
       System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +1724
    

     

  • Richard Soeteman 4035 posts 12842 karma points MVP
    Jul 16, 2014 @ 08:31
    Richard Soeteman
    0

    Hi Simon,

    Sorry this bug for SQL Ce slipped through. I have a fix available at https://www.dropbox.com/s/yw1xml1gq2mm6o9/MemberExport%20V2.6.1.zip

    If you install that package all should be good again.

    Best,

    Richard

Please Sign in or register to post replies

Write your reply to:

Draft