I'm trying to use the ContentApp to parse a page as a newsletter. Whenever I try to save the default information after creating a new campaign, I recieve a 500 error and can't proceed.
This is the error I get from the logs:
Microsoft.Data.Sqlite.SqliteException (0x80004005): SQLite Error 1: 'no such column: −331'.
at Microsoft.Data.Sqlite.SqliteException.ThrowExceptionForRC(Int32 rc, sqlite3 db)
at Microsoft.Data.Sqlite.SqliteCommand.PrepareAndEnumerateStatements(Stopwatch timer)+MoveNext()
at Microsoft.Data.Sqlite.SqliteCommand.GetStatements(Stopwatch timer)+MoveNext()
at Microsoft.Data.Sqlite.SqliteDataReader.NextResult()
at Microsoft.Data.Sqlite.SqliteCommand.ExecuteReader(CommandBehavior behavior)
at Microsoft.Data.Sqlite.SqliteCommand.ExecuteNonQuery()
at Umbraco.Cms.Infrastructure.Persistence.FaultHandling.RetryPolicy.ExecuteAction[TResult](Func`1 func)
at Umbraco.Cms.Persistence.Sqlite.Services.SqliteDistributedLockingMechanism.SqliteDistributedLock.ObtainWriteLock()
at Umbraco.Cms.Persistence.Sqlite.Services.SqliteDistributedLockingMechanism.SqliteDistributedLock..ctor(SqliteDistributedLockingMechanism parent, Int32 lockId, DistributedLockType lockType, TimeSpan timeout)
at Umbraco.Cms.Persistence.Sqlite.Services.SqliteDistributedLockingMechanism.WriteLock(Int32 lockId, Nullable`1 obtainLockTimeout)
at Umbraco.Cms.Infrastructure.Scoping.Scope.ObtainWriteLock(Int32 lockId, Nullable`1 timeout)
at Umbraco.Cms.Infrastructure.Scoping.Scope.LockInner(Guid instanceId, Dictionary`2& locks, HashSet`1& locksSet, Action`2 obtainLock, Nullable`1 timeout, Int32 lockId)
at Umbraco.Cms.Infrastructure.Scoping.Scope.EagerWriteLockInner(Guid instanceId, Nullable`1 timeout, Int32[] lockIds)
at Umbraco.Cms.Infrastructure.Scoping.Scope.EnsureDbLocks()
at Umbraco.Cms.Infrastructure.Scoping.Scope.get_Database()
at Umbraco.Cms.Infrastructure.Persistence.Repositories.Implement.ServerRegistrationRepository.PerformGetAll(Int32[] ids)
at Umbraco.Cms.Core.Cache.NoCacheRepositoryCachePolicy`2.GetAll(TId[] ids, Func`2 performGetAll)
at Umbraco.Cms.Core.Services.Implement.ServerRegistrationService.TouchServer(String serverAddress, TimeSpan staleTimeout)
at Umbraco.Cms.Infrastructure.HostedServices.ServerRegistration.TouchServerTask.PerformExecuteAsync(Object state)
I'm running Newsletter Studio 10.0.2 and Umbraco 10.1.
Fill in the information and press Next Step (or Save)
I now get a 500 back from /umbraco/backoffice/NewsletterStudio/CampaignContentApp/Save and can't proceed.
I tried an SQL Server database instead. Still same result, although I don't get any exceptions within the logs, the debug logs doesn't really produce anything helpful either, as far as I can tell. So, it seems like the exception causing the 500 is swallowed somehow. I'm currently on the trial (evaluating, waiting for a license) if that matters.
I've tried to reproduce the issue on Umbraco 10.1 and Newsletter Studio 10.0.2. As you can see here I can't reproduce the issue.
Does this reflect the flow that you are testing?
Could you elaborate on the content on the node and the rendering, are you using anything "special" when you're rendering the underlying page?
Did you try to render the page on the front end at all? Maybe the rendering throws the error?
I have a couple of things we could check:
I can tell from the console log that you sent that there is a 400-error before the 500-error with Newsletter Studio. Was that a failed login-attempt on your side or could this be related?
Since the NewsletterStudio-endpoint throws a 500-error there should be more details in the trace log (Settings -> Log Viewer). Do you see any errors that you can share?
Would it be possible to see the reponse body of the 500-error that you get when you're trying to save?
I found the issue to the first problem. I was using a RenderController to return the correct view with corresponding ViewModel. This means the default template wasn't populated, causing the error.
However, once I try and preview a template containing a block list I get a null reference exception:
SQLite error
Hello,
I'm trying to use the ContentApp to parse a page as a newsletter. Whenever I try to save the default information after creating a new campaign, I recieve a 500 error and can't proceed.
This is the error I get from the logs:
I'm running Newsletter Studio 10.0.2 and Umbraco 10.1.
Any advice?
Hi Andreas!
Thanks for posting the issue.
Looking at the trace that you posted it looks like the error happens inside Umbraco, could you explain more in detail how to reproduce the issue?
If I understand you correct:
Maybe a couple of screenshots of the flow would help making it clear.
// m
Hello,
Thanks for your reply!
Here is the flow:
Navigate to the correct node
Press the email tab and Create new Campaign
Fill in the information and press Next Step (or Save)
I now get a 500 back from /umbraco/backoffice/NewsletterStudio/CampaignContentApp/Save and can't proceed.
I tried an SQL Server database instead. Still same result, although I don't get any exceptions within the logs, the debug logs doesn't really produce anything helpful either, as far as I can tell. So, it seems like the exception causing the 500 is swallowed somehow. I'm currently on the trial (evaluating, waiting for a license) if that matters.
Thank you for your help!
Hi!
Thank you for the clear steps!
I'll try to reproduce this right away and keep you posted.
/ Markus
Hi again!
I've tried to reproduce the issue on Umbraco 10.1 and Newsletter Studio 10.0.2. As you can see here I can't reproduce the issue.
I have a couple of things we could check:
All the best,
// Markus
Edit: Seems like someone else is having a similar issue but unrelated to the Newsletter Studio-package https://our.umbraco.com/forum/using-umbraco-and-getting-started/110176-umbraco-10-no-such-column-333-sqlite
And another one: https://github.com/umbraco/Umbraco-CMS/issues/13206
Hello,
I found the issue to the first problem. I was using a RenderController to return the correct view with corresponding ViewModel. This means the default template wasn't populated, causing the error.
However, once I try and preview a template containing a block list I get a null reference exception:
NullReferenceException: Object reference not set to an instance of an object. NewsletterStudio.CssInline.AngleSharp.AutoSelectedMarkupFormatter.Comment(IComment comment) NewsletterStudio.CssInline.AngleSharp.Dom.Comment.ToHtml(TextWriter writer, IMarkupFormatter formatter) NewsletterStudio.CssInline.AngleSharp.Dom.Collections.NodeList.ToHtml(TextWriter writer, IMarkupFormatter formatter) NewsletterStudio.CssInline.AngleSharp.Extensions.FormatExtensions.ToHtml(IMarkupFormattable markup, IMarkupFormatter formatter) NewsletterStudio.CssInline.PreMailer.PreMailer.MoveCssInline(bool removeStyleElements, string ignoreElements, string css, bool stripIdAndClassAttributes, bool removeComments) NewsletterStudio.CssInline.CssInlineHelper.InlineCss(string html, string baseUrl) NewsletterStudio.Core.Rendering.EmailRenderer.Render(IRecipientDataModel recipient) NewsletterStudio.Core.Frontend.Rendering.RenderEmailControllerActions.RenderCampaign(Guid key) NewsletterStudio.Web.Controllers.RenderEmailController.RenderCampaign(Guid id) lambdamethod1516(Closure , object , object[] ) Microsoft.AspNetCore.Mvc.Infrastructure.ActionMethodExecutor+SyncActionResultExecutor.Execute(IActionResultTypeMapper mapper, ObjectMethodExecutor executor, object controller, object[] arguments) Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.InvokeActionMethodAsync() Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.Next(ref State next, ref Scope scope, ref object state, ref bool isCompleted) Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.InvokeNextActionFilterAsync() Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.Rethrow(ActionExecutedContextSealed context) Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.Next(ref State next, ref Scope scope, ref object state, ref bool isCompleted) Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.InvokeInnerFilterAsync() Microsoft.AspNetCore.Mvc.Infrastructure.ResourceInvoker.0(ResourceInvoker invoker, Task lastTask, State next, Scope scope, object state, bool isCompleted) Microsoft.AspNetCore.Mvc.Infrastructure.ResourceInvoker.Rethrow(ResourceExecutedContextSealed context) Microsoft.AspNetCore.Mvc.Infrastructure.ResourceInvoker.Next(ref State next, ref Scope scope, ref object state, ref bool isCompleted) Microsoft.AspNetCore.Mvc.Infrastructure.ResourceInvoker.InvokeFilterPipelineAsync() Microsoft.AspNetCore.Mvc.Infrastructure.ResourceInvoker.
Are there any known limits to the inline css?
Thank you for your help! /Andreas
Hi!
I think that there might be limitations with the inlining depending on how you try to use it. I have never seen that exact error.
It's kind of hard to tell why this is happening without seeing the exact code. But it's a good idea to follow these guidelines for the email content:
Make sure that all CSS used is rendered in the HTML as
is working on a reply...