ucomments in 71 on azure - Extending Umbraco

Press Ctrl / CMD + C to copy this to your clipboard.

Copied to clipboard

Flag this post as spam?

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

Phil 5 posts 25 karma points

Apr 27, 2014 @ 11:57

uComments in 7.1 on Azure

I'm installed uComments in 7.1 running on Azure I'm getting the following error in Umbraco when I click on the Comments Tab:

Error running Reader: 
SQL Statement:
select * from comment where spam != 1 order by created desc

Exception:
System.Data.SqlServerCe.SqlCeException (0x80004005): The specified table does not exist. [ comment ]
   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 SqlCE4Umbraco.SqlCeApplicationBlock.ExecuteReader(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 Reader: 
SQL Statement:
select * from comment where spam != 1 order by created desc

Exception:
System.Data.SqlServerCe.SqlCeException (0x80004005): The specified table does not exist. [ comment ]
   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 SqlCE4Umbraco.SqlCeApplicationBlock.ExecuteReader(String connectionString, CommandType commandType, String commandText, SqlCeParameter[] commandParameters)

Might it not have created the table when I did the install or is it a more general problem with 7.1?

Copy Link

Phil 5 posts 25 karma points

Apr 27, 2014 @ 21:34

So I found the solution for this and thought I'd post it here.

Firstly, run this query against the database:

CREATE TABLE [Comment](
[id][int] IDENTITY(1,1) NOT NULL CONSTRAINT [PK_Comment] PRIMARY KEY ,
[mainid][int] NOT NULL,
[nodeid][int] NOT NULL,
[name][nvarchar](250) NULL,
[email][nvarchar](250) NULL,
[website][nvarchar](250) NULL,
[comment][ntext] NULL,
[spam][bit] NULL,
[ham][bit] NULL,
[created][datetime] NULL
);

This will solve the error above, but you'll get another error saying:

The control with ID 'UpdatePanel1' requires a ScriptManager on the page. The ScriptManager must appear before any controls that need it.

To resolve this you'll need to edit UCommentModeration.ascx and add the line

<asp:ScriptManager ID="ScriptManager1" runat="server"></asp:ScriptManager>

above

<asp:UpdatePanel ID="UpdatePanel1" runat="server">

Copy Link

is working on a reply...

Please Sign in or register to post replies