-
-
Notifications
You must be signed in to change notification settings - Fork 403
New issue
Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.
By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.
Already on GitHub? Sign in to your account
Newsletter test emails not working. #1163
Comments
Hi! |
The newsletter is now send through EAP, but the newsletter is blank. |
Any errors? |
I'm seeing these errors, but sending the newsletter there aren't any errors when it's sent. System.InvalidOperationException: There is an error in XML document (1, 2). ---> System.InvalidOperationException: was not expected. at Microsoft.Xml.Serialization.GeneratedAssembly.XmlSerializationReaderPlexLibraries.Read4_MediaContainer () <0x41ac3ca0 + 0x000b7> in :0 at (wrapper managed-to-native) System.Reflection.MonoMethod:InternalInvoke (System.Reflection.MonoMethod,object,object[],System.Exception&) at System.Reflection.MonoMethod.Invoke (System.Object obj, BindingFlags invokeAttr, System.Reflection.Binder binder, System.Object[] parameters, System.Globalization.CultureInfo culture) <0x400c03d0 + 0x000a3> in :0 --- End of inner exception stack trace --- at System.Xml.Serialization.XmlSerializer.Deserialize (System.Xml.XmlReader xmlReader, System.String encodingStyle, XmlDeserializationEvents events) <0x41ac14b0 + 0x007f3> in :0 at System.Xml.Serialization.XmlSerializer.Deserialize (System.Xml.XmlReader xmlReader, System.String encodingStyle) <0x41ac1410 + 0x0007f> in :0 at System.Xml.Serialization.XmlSerializer.Deserialize (System.IO.TextReader textReader) <0x41ac1000 + 0x0008f> in :0 at Ombi.Api.ApiRequest.DeserializeXml[T] (System.String input) <0x41a73d90 + 0x000b3> in :0 Ombi.Api.ApiRequest Error 2/27/2017 5:56:14 AM |
I am having this issue as well on 2.1.1336 (stable branch) on Server 2012 R2 The email is sent and received but its empty these are the only things in the logs Sent Ombi.Services.Jobs.RecentlyAdded Debug 3/3/2017 7:00:03 AM |
Can you guys try the latest EAP please? |
I just tried the latest EAP, and the test newsletter e-mail does not get sent. Application Version: 2.1.1514 In the log (I have debug level set), I am seeing the following, repeatedly, which I don't know whether it is related to this issue or not: 2017/03/13 10:46:20.351 Ombi.Api.PlexApi Error: Exception when calling GetMetadata for Plex, Retrying 00:00:30 Ombi.Helpers.Exceptions.ApiRequestException: Got StatusCode=0 for . My Plex server is up and running (version 1.4.3.3433) in the same machine as Ombi, Ombi communicates correctly with the Plex server (test connectivity from settings works), and e-mail notifications are working (test from settings sends the e-mail correctly). |
Latest EAP
|
Tried the latest EAP (as of 10 minutes ago). The e-mail gets sent. It doesn't show any movies or series. This is what I have in the log: 2017/03/14 09:18:04.204 Ombi.Services.Jobs.RecentlyAddedNewsletter.RecentlyAddedNewsletter Debug: Starting Recently Added Newsletter Test
2017/03/14 09:18:04.389 Ombi.Services.Jobs.RecentlyAddedNewsletter.RecentlyAddedNewsletter Debug: <!doctype html> <title>Ombi</title> <style media="all" type="text/css"> @media all { .btn-primary table td:hover { background-color: #34495e !important; } .btn-primary a:hover { background-color: #34495e !important; border-color: #34495e !important; } } @media all { .btn-secondary a:hover { border-color: #34495e !important; color: #34495e !important; } } @media only screen and (max-width: 620px) { table[class=body] h1 { font-size: 28px !important; margin-bottom: 10px !important; } table[class=body] h2 { font-size: 22px !important; margin-bottom: 10px !important; } table[class=body] h3 { font-size: 16px !important; margin-bottom: 10px !important; } table[class=body] p, table[class=body] ul, table[class=body] ol, table[class=body] td, table[class=body] span, table[class=body] a { font-size: 16px !important; } table[class=body] .wrapper, table[class=body] .article { padding: 10px !important; } table[class=body] .content { padding: 0 !important; } table[class=body] .container { padding: 0 !important; width: 100% !important; } table[class=body] .header { margin-bottom: 10px !important; } table[class=body] .main { border-left-width: 0 !important; border-radius: 0 !important; border-right-width: 0 !important; } table[class=body] .btn table { width: 100% !important; } table[class=body] .btn a { width: 100% !important; } table[class=body] .img-responsive { height: auto !important; max-width: 100% !important; width: auto !important; } table[class=body] .alert td { border-radius: 0 !important; padding: 10px !important; } table[class=body] .span-2, table[class=body] .span-3 { max-width: none !important; width: 100% !important; } table[class=body] .receipt { width: 100% !important; } } @media all { .ExternalClass { width: 100%; } .ExternalClass, .ExternalClass p, .ExternalClass span, .ExternalClass font, .ExternalClass td, .ExternalClass div { line-height: 100%; } .apple-link a { color: inherit !important; font-family: inherit !important; font-size: inherit !important; font-weight: inherit !important; line-height: inherit !important; text-decoration: none !important; } } </style>
2017/03/14 09:18:04.410 Ombi.Services.Jobs.RecentlyAddedNewsletter.RecentlyAddedNewsletter Debug: Entering SendNewsletter 2017/03/14 09:18:04.531 Ombi.Services.Jobs.RecentlyAddedNewsletter.RecentlyAddedNewsletter Debug: Created Plain/HTML MIME body 2017/03/14 09:18:05.820 Ombi.Services.Jobs.RecentlyAddedNewsletter.RecentlyAddedNewsletter Debug: Sending 2017/03/14 09:18:07.689 Ombi.Services.Jobs.RecentlyAddedNewsletter.RecentlyAddedNewsletter Debug: Sent 2017/03/14 09:18:39.250 Ombi.Services.Jobs.PlexContentCacher Debug: done all that, moving onto the DB now 2017/03/14 09:18:39.291 Ombi.Services.Jobs.PlexContentCacher Debug: Exception: 2017/03/14 09:18:39.308 Ombi.Services.Jobs.PlexContentCacher Debug: Mono.Data.Sqlite.SqliteException (0x80004005): SQLite error table PlexContent has no column named ItemId at Mono.Data.Sqlite.SQLite3.Prepare(SqliteConnection cnn, String strSql, SqliteStatement previous, UInt32 timeoutMS, String& strRemain) at Mono.Data.Sqlite.SqliteCommand.BuildNextCommand() at Mono.Data.Sqlite.SqliteCommand.GetStatement(Int32 index) at Mono.Data.Sqlite.SqliteDataReader.NextResult() at Mono.Data.Sqlite.SqliteDataReader..ctor(SqliteCommand cmd, CommandBehavior behave) at Mono.Data.Sqlite.SqliteCommand.ExecuteReader(CommandBehavior behavior) at Mono.Data.Sqlite.SqliteCommand.ExecuteDbDataReader(CommandBehavior behavior) at System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior) at Dapper.SqlMapper.QueryMultipleImpl(IDbConnection cnn, CommandDefinition& command) at SQLiteAdapter.Insert(IDbConnection connection, IDbTransaction transaction, Nullable 1 commandTimeout, String tableName, String columnList, String parameterList, IEnumerable 1 keyProperties, Object entityToInsert)at Dapper.Contrib.Extensions.SqlMapperExtensions.Insert[T](IDbConnection connection, T entityToInsert, IDbTransaction transaction, Nullable 1 commandTimeout) at Ombi.Store.Repository.BaseGenericRepository 1.Insert(T entity) in C:\projects\requestplex\Ombi.Store\Repository\BaseGenericRepository.cs:line 99at Ombi.Services.Jobs.PlexContentCacher.CachedLibraries(PlexSettings plexSettings) in C:\projects\requestplex\Ombi.Services\Jobs\PlexContentCacher.cs:line 272 Mono.Data.Sqlite.SqliteException (0x80004005): SQLite error table PlexContent has no column named ItemId |
Please can you take a look at this and follow the instructions then restart Ombi |
This works for me now. |
Can anyone post a guide to deleting the PlexContent table as suggested above? I'm running Ombi (stable, most recent update) using the LinuxServer/Ombi docker. |
You would need to use a program lite SQLiteBrowser, File > Open, locate the Ombi.sqlite file. |
I went ahead and moved to the EAP branch, and it appears to have resolved my issue(s) with the newsletter and other emails. |
I just installed the latest EAP branch, and the newsletter test e-mail gets sent, but it lists every single movie in my collection, and a few episodes. Is there anything I need to do to just list what has been recently added? How does Ombi determine what is recently added? |
We keep a list of items we have sent. If there is new content then it will not be in that list. So we will include it |
…hows and also newly added episodes. #1163
Guys, pleas update to the last EAP version. Tidusjar just pushed a update to fix your reported problems |
So good news the newsletter sent, but it included every movie and TV show in the first email, some of the stuff was added many months ago. |
That is correct. The first newsletter included everything. |
Beceause Ombi doesn't know what the 0 zero point is. |
Okay, that makes sense now. I missed the post above which stated the same thing. Thanks for every bodies work on this! |
Cool! @dtk1989 feel free to open a new issue report if you have any problems with ombi :) I will close this one for now. |
Ombi Version:
V 2.1.1430
Update Branch:
Stable/Early Access Preview
Media Sever:
Plex
Media Server Version:
1.4.1.3362
Operating System:
unRAID
Mono Version (only if your not on windows)
Applicable Logs (from
/logs/
directory or the Admin page):Problem Description:
I'm unable to send a test newsletter but I can send a test email. I see this error pop up in the web interface, Object reference not set to an instance of an object.
Reproduction Steps:
I can send test emails to myself and other email accounts but the newsletter tests aren't working. I have new content added.
The text was updated successfully, but these errors were encountered: