Copied to clipboard

Flag this post as spam?

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


  • Peter Flannery 23 posts 43 karma points
    Dec 14, 2011 @ 00:55
    Peter Flannery
    0

    Error running NonQuery on installing 0.3.3

    Hi,

    Here is my setup. Umbaco 4.7.1 with CampaignLetter 0.3.3 on windows 7 64bit.

    I get the following error whilst trying to install this package.

     

    Server Error in '/' Application.
    
    Error running NonQuery: 
    SQL Statement:
    IF NOT EXISTS(SELECT [user] FROM umbracoUser2app WHERE [user] = 0 AND app = 'campaignletters')                                          INSERT INTO umbracoUser2app([user],app) VALUES(0, 'campaignletters')
    
    Exception:
    System.Data.SqlServerCe.SqlCeException (0x80004005): There was an error parsing the query. [ Token line number = 1,Token line offset = 1,Token in error = IF ]
      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.ExecuteNonQuery()
      at SqlCE4Umbraco.SqlCeApplicationBlock.ExecuteNonQuery(String connectionString, CommandType commandType, String commandText, SqlCeParameter[] commandParameters)
    
    Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. 
    
    Exception Details: SqlCE4Umbraco.SqlCeProviderException: Error running NonQuery: 
    SQL Statement:
    IF NOT EXISTS(SELECT [user] FROM umbracoUser2app WHERE [user] = 0 AND app = 'campaignletters')                                          INSERT INTO umbracoUser2app([user],app) VALUES(0, 'campaignletters')
    
    Exception:
    System.Data.SqlServerCe.SqlCeException (0x80004005): There was an error parsing the query. [ Token line number = 1,Token line offset = 1,Token in error = IF ]
      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.ExecuteNonQuery()
      at SqlCE4Umbraco.SqlCeApplicationBlock.ExecuteNonQuery(String connectionString, CommandType commandType, String commandText, SqlCeParameter[] commandParameters)
    
    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 NonQuery: 
    SQL Statement:
    IF NOT EXISTS(SELECT [user] FROM umbracoUser2app WHERE [user] = 0 AND app = 'campaignletters')                                          INSERT INTO umbracoUser2app([user],app) VALUES(0, 'campaignletters')
    
    Exception:
    System.Data.SqlServerCe.SqlCeException (0x80004005): There was an error parsing the query. [ Token line number = 1,Token line offset = 1,Token in error = IF ]
       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.ExecuteNonQuery()
       at SqlCE4Umbraco.SqlCeApplicationBlock.ExecuteNonQuery(String connectionString, CommandType commandType, String commandText, SqlCeParameter[] commandParameters)]
       SqlCE4Umbraco.SqlCeApplicationBlock.ExecuteNonQuery(String connectionString, CommandType commandType, String commandText, SqlCeParameter[] commandParameters) +854
       umbraco.DataLayer.SqlHelper`1.ExecuteNonQuery(String commandText, IParameter[] parameters) +150
    
    [SqlHelperException: Umbraco Exception (DataLayer): SQL helper exception in ExecuteNonQuery]
       umbraco.DataLayer.SqlHelper`1.ExecuteNonQuery(String commandText, IParameter[] parameters) +261
       uWebZone.CampaignLetters.UserControls.Installer.Page_Load(Object sender, EventArgs e) +197
       System.Web.Util.CalliHelper.EventArgFunctionCaller(IntPtr fp, Object o, Object t, EventArgs e) +25
       System.Web.UI.Control.LoadRecursive() +71
       System.Web.UI.Control.LoadRecursive() +190
       System.Web.UI.Control.LoadRecursive() +190
       System.Web.UI.Control.LoadRecursive() +190
       System.Web.UI.Control.LoadRecursive() +190
       System.Web.UI.Control.LoadRecursive() +190
       System.Web.UI.Control.LoadRecursive() +190
       System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +3064
    
    Version Information: Microsoft .NET Framework Version:4.0.30319; ASP.NET Version:4.0.30319.237
    
  • Owen 123 posts 246 karma points
    Dec 14, 2011 @ 01:03
    Owen
    0

    Are your use SqlCE as database source?

    This package only support SQL Server and MySql.

  • Peter Flannery 23 posts 43 karma points
    Dec 14, 2011 @ 01:17
    Peter Flannery
    0

    yeah. will you ever support it?

  • Owen 123 posts 246 karma points
    Dec 14, 2011 @ 01:25
    Owen
    0

    Don't have a plan right now.

    Are you use SqlCE in live site or only for test?

Please Sign in or register to post replies

Write your reply to:

Draft