.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
Unable to create export - Umbraco V7.1.4 + SQLCE4
Hi
Here is our config...
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:
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
is working on a reply...