I just received the same bug on another thread. What type of image was it?
Also here is the sql:
DELETE FROM Userimage WHERE Name = 'plexname'
Sent from my SM-N900P using Tapatalk
tried jpg and gif
tried jpg and gif
Thanks I will look into it.
Sent from my SM-N900P using Tapatalk
I just received the same bug on another thread. What type of image was it?
Also here is the sql:
DELETE FROM Userimage WHERE Name = 'plexname'
Sent from my SM-N900P using Tapatalk
Query doesn't work
22:25:24 DELETE FROM Userimage WHERE Name = 'sfnetwork' Error Code: 1146. Table 'plexnotify.userimage' doesn't exist 0.000 sec
Query doesn't work
22:25:24 DELETE FROM Userimage WHERE Name = 'sfnetwork' Error Code: 1146. Table 'plexnotify.userimage' doesn't exist 0.000 sec
Sorry it's UserImages with an s lol
Sent from my SM-N900P using Tapatalk
Sorry it's UserImages with an s lol
Sent from my SM-N900P using Tapatalk
lol, thanks I figured it out at the same time you posted it... It worked...
I'll wait for you feedback before testing images under MySQL...
I just pushed a update to fix the crash for images.
I just pushed a update to fix the crash for images.
no more crash but not working (no image shown)
logs:
A generic error occurred in GDI+.
at System.Drawing.Image.Save(Stream stream, ImageCodecInfo encoder, EncoderParameters encoderParams)
at System.Drawing.Image.Save(Stream stream, ImageFormat format)
at PlexNotify.DatabaseHelper.GetUserImage(String userTitle, DatabaseInterface dbi)
Error while attempting to convert Image from binary. User: sfnetwork ImageType: .jpeg
but the gif one worked... :blink:
but the gif one worked... :blink:
Correction, only png works fine.
gif was not giving an error but look corrupted.
png, 64x64 works perfectly.
no more crash but not working (no image shown)
logs:
A generic error occurred in GDI+.at System.Drawing.Image.Save(Stream stream, ImageCodecInfo encoder, EncoderParameters encoderParams)at System.Drawing.Image.Save(Stream stream, ImageFormat format)at PlexNotify.DatabaseHelper.GetUserImage(String userTitle, DatabaseInterface dbi)Error while attempting to convert Image from binary. User: sfnetwork ImageType: .jpeg
Good this is what I was after. I was unable to reproduce the crash so I output the error.
no more crash but not working (no image shown)
logs:
A generic error occurred in GDI+.at System.Drawing.Image.Save(Stream stream, ImageCodecInfo encoder, EncoderParameters encoderParams)at System.Drawing.Image.Save(Stream stream, ImageFormat format)at PlexNotify.DatabaseHelper.GetUserImage(String userTitle, DatabaseInterface dbi)Error while attempting to convert Image from binary. User: sfnetwork ImageType: .jpeg
I found the problem. I will have it fixed for next release.
Nice!
Seems like a great program but I can't seem to get this working. Version 0.0.0.25 connects to my plex user id and I've set up my local host details but the log shows errors in the DB. Seems to be a mismatch with the code and the schema? I won't dump the whole log but here are the first few lines.
Application started.
The number of columns in the query and the table must match. [ Number of columns in query = 21, Number of columns in table = 20 ]
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 PlexNotify.Databases.MSSqlCE.RunQuery(String sql, Dictionary`2 sqlParameters)
The column name is not valid. [ Node name (if any) = ,Column name = machineIdentifier ]
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 PlexNotify.Databases.MSSqlCE.RunQuery(String sql, Dictionary`2 sqlParameters)
Also, does it need my plex user/pwd if my PMS is on the local host with no security?
Tons of stats updates Coming tomorrow. Including top charts and more. With Plex Notify's Stat's framework now in place and at a solid point I can easily manipulate and display the data. Allowing me to rapidly add new features to statistics. I highly encourage Devs to make plugin's for the stats GUI. The documentation can be found here: https://plexnotify.codeplex.com/wikipage?title=IStatistics&referringTitle=Pugin%20Interfaces
I will add a plugin section to the Plex Notify page if anyone makes one.
Double post bug.
Seems like a great program but I can't seem to get this working. Version 0.0.0.25 connects to my plex user id and I've set up my local host details but the log shows errors in the DB. Seems to be a mismatch with the code and the schema? I won't dump the whole log but here are the first few lines.
Application started. The number of columns in the query and the table must match. [ Number of columns in query = 21, Number of columns in table = 20 ] 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 PlexNotify.Databases.MSSqlCE.RunQuery(String sql, Dictionary`2 sqlParameters) The column name is not valid. [ Node name (if any) = ,Column name = machineIdentifier ] 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 PlexNotify.Databases.MSSqlCE.RunQuery(String sql, Dictionary`2 sqlParameters)Also, does it need my plex user/pwd if my PMS is on the local host with no security?
Nope You dont need the login locally. It will only show the error that it cant connect to My Plex once on startup of the application. I will look into the error. Thanks for reporting.
Seems like a great program but I can't seem to get this working. Version 0.0.0.25 connects to my plex user id and I've set up my local host details but the log shows errors in the DB. Seems to be a mismatch with the code and the schema? I won't dump the whole log but here are the first few lines.
Application started. The number of columns in the query and the table must match. [ Number of columns in query = 21, Number of columns in table = 20 ] 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 PlexNotify.Databases.MSSqlCE.RunQuery(String sql, Dictionary`2 sqlParameters) The column name is not valid. [ Node name (if any) = ,Column name = machineIdentifier ] 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 PlexNotify.Databases.MSSqlCE.RunQuery(String sql, Dictionary`2 sqlParameters)Also, does it need my plex user/pwd if my PMS is on the local host with no security?
For the error Try this, close plex notify and open the config file and set
true
To false. The config file is located in C:\ProgramData\Plex Notify
Updated to 0.0.0.26 and made the change as suggested. I can now get visibility of what's playing in statistics and also get toasts.
The flag resets itself back to true when the program first runs - I guess this is a schema rebuild flag and once done it reverts to true?
I also get this error in the log:-
Application started.
A column ID occurred more than once in the specification.
at System.Data.SqlServerCe.SqlCeCommand.ProcessResults(Int32 hr)
at System.Data.SqlServerCe.SqlCeCommand.ExecuteCommandText(IntPtr& pCursor, Boolean& isBaseTableCursor)
at System.Data.SqlServerCe.SqlCeCommand.ExecuteCommand(CommandBehavior behavior, String method, ResultSetOptions options)
at System.Data.SqlServerCe.SqlCeCommand.ExecuteNonQuery()
at PlexNotify.Databases.MSSqlCE.RunQuery(String sql, Dictionary`2 sqlParameters)
Updated to 0.0.0.26 and made the change as suggested. I can now get visibility of what's playing in statistics and also get toasts.
The flag resets itself back to true when the program first runs - I guess this is a schema rebuild flag and once done it reverts to true?
I also get this error in the log:-Application started. A column ID occurred more than once in the specification. at System.Data.SqlServerCe.SqlCeCommand.ProcessResults(Int32 hr) at System.Data.SqlServerCe.SqlCeCommand.ExecuteCommandText(IntPtr& pCursor, Boolean& isBaseTableCursor) at System.Data.SqlServerCe.SqlCeCommand.ExecuteCommand(CommandBehavior behavior, String method, ResultSetOptions options) at System.Data.SqlServerCe.SqlCeCommand.ExecuteNonQuery() at PlexNotify.Databases.MSSqlCE.RunQuery(String sql, Dictionary`2 sqlParameters)
Yep there was a database schema change a few builds ago. I forgot to make all the changes to the setup, that why it was giving the errors. I fixed it in the latest build.
As for those errors it's just because some of the schemas where already set and it tried to make them again when you set the flag.
I'll probably get rid of the flag in first beta anyone with a alpha 20 schema would have had plenty of time to update it.
Sent from my SM-N900P using Tapatalk
Since last update, all images don't show up.
Tried to delete from MySQL and re add; same (no error in log)
