Plex Notify

Dev Community Dev/API Corner
221

SQL is going much further now.

Except this (no notification)

 
 
    Table 'plexnotify.user' doesn't exist
      at MySql.Data.MySqlClient.MySqlStream.ReadPacket()
   at MySql.Data.MySqlClient.NativeDriver.GetResult(Int32& affectedRow, Int64& insertedId)
   at MySql.Data.MySqlClient.Driver.GetResult(Int32 statementId, Int32& affectedRows, Int64& insertedId)
   at MySql.Data.MySqlClient.Driver.NextResult(Int32 statementId, Boolean force)
   at MySql.Data.MySqlClient.MySqlDataReader.NextResult()
   at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior)
   at MySql.Data.MySqlClient.MySqlCommand.ExecuteNonQuery()
   at PlexNotify.Databases.MySqlDB.RunQuery(String sql, Dictionary`2 sqlParameters)
   
   
 
 
    Table 'plexnotify.transcodesession' doesn't exist
      at MySql.Data.MySqlClient.MySqlStream.ReadPacket()
   at MySql.Data.MySqlClient.NativeDriver.GetResult(Int32& affectedRow, Int64& insertedId)
   at MySql.Data.MySqlClient.Driver.GetResult(Int32 statementId, Int32& affectedRows, Int64& insertedId)
   at MySql.Data.MySqlClient.Driver.NextResult(Int32 statementId, Boolean force)
   at MySql.Data.MySqlClient.MySqlDataReader.NextResult()
   at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior)
   at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader()
   at PlexNotify.Databases.MySqlDB.RunReturnQuery(String sql, Dictionary`2 sqlParameters)
   
   
 
 
    Transcode ID F36766033C27EF06DA015F9E09716F4F does not exist in TranscodeSession table
 
 
    Table 'plexnotify.transcodesession' doesn't exist
      at MySql.Data.MySqlClient.MySqlStream.ReadPacket()
   at MySql.Data.MySqlClient.NativeDriver.GetResult(Int32& affectedRow, Int64& insertedId)
   at MySql.Data.MySqlClient.Driver.GetResult(Int32 statementId, Int32& affectedRows, Int64& insertedId)
   at MySql.Data.MySqlClient.Driver.NextResult(Int32 statementId, Boolean force)
   at MySql.Data.MySqlClient.MySqlDataReader.NextResult()
   at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior)
   at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader()
   at PlexNotify.Databases.MySqlDB.RunReturnQuery(String sql, Dictionary`2 sqlParameters)
   
   
 
 
    Specified cast is not valid.
      at PlexNotify.DatabaseHelper.GetStates(String transcodeID, DatabaseInterface dbi)
   at PlexNotify.DatabaseHelper.StoreMediaContainer(MediaContainer mc)
   at PlexNotify.MainWindow.BW_DoWork(Object sender, DoWorkEventArgs e)
   
   
 
 
    Table 'plexnotify.transcodesession' doesn't exist
      at MySql.Data.MySqlClient.MySqlStream.ReadPacket()
   at MySql.Data.MySqlClient.NativeDriver.GetResult(Int32& affectedRow, Int64& insertedId)
   at MySql.Data.MySqlClient.Driver.GetResult(Int32 statementId, Int32& affectedRows, Int64& insertedId)
   at MySql.Data.MySqlClient.Driver.NextResult(Int32 statementId, Boolean force)
   at MySql.Data.MySqlClient.MySqlDataReader.NextResult()
   at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior)
   at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader()
   at PlexNotify.Databases.MySqlDB.RunReturnQuery(String sql, Dictionary`2 sqlParameters)
   
   
 
 
Seems to be missing tables...

ok im going to download MySql and do some testing ill have this fixed tonight.

222

ok im going to download MySql and do some testing ill have this fixed tonight.

Thanks for this, appreciate it!

After this will be up and running, I'll be able to fully test with multiple application with centralized database.

How do we choose the "primary" option? I installed two applications on same database both have this disabled... (I guess, one thing at the time; SQL fully working first :rolleyes: )

Sorry to be annoying... Just very exciting stuff...

223

Thanks for this, appreciate it!

After this will be up and running, I'll be able to fully test with multiple application with centralized database.

How do we choose the "primary" option? I installed two applications on same database both have this disabled... (I guess, one thing at the time; SQL fully working first :rolleyes: )

Sorry to be annoying... Just very exciting stuff...

Yeah, that option is controlled by the database.

224

Yeah, that option is controlled by the database.

Makes sense..

***During your test, don't know what you have available in your environment but testing with Windows 2008 R2 server with those permission issues could be useful (for you to be able to reproduce this)

Not sure if other server versions of Windows generate this (or if this is actually only in my server specifically)

Anyways, let me know if I can help.

225

tried that several times, apologies for being a noob but now it isn't even updating me a file is being played let alone crashing.

Is there a way I can do a clean install (remove the blank icon from the notification area and freshly install). PlexNotify is no longer in my control panel to select to uninstall

If you open task manager (Press alt+ctrl+delete then click task manager) then find all the Plex Notify.exe Processes, right click on each one and select "End Task". Im adding a fix so only 1 plex notify can be open.

226

I am still working on the fix for mysql. This goes deeper that I thought. I realized that a plex media server will have multiple addresses I will finish the fix for my sql tomorrow but I put a fix in to get you back up and running in this release. Im also going to include database migration tomorrow so you can keep your data.

227

Ok I have some sad news. The next update is going to "refresh" your database. Some table columns where using reserved keywords and I had to change the names. This means That the database has to be re-created and you will lose all your information. Sorry for the inconvenience. 

228

Ok I have some sad news. The next update is going to "refresh" your database. Some table columns where using reserved keywords and I had to change the names. This means That the database has to be re-created and you will lose all your information. Sorry for the inconvenience.

Oh Man don't worry about that. It's still in alpha and it was just released so I don't think anybody will panic restarting with fresh DBs IMO.

Just happy you work that fast.
Looking forward to it. This is actually good news, not bad for me :)


Sent from Tapatalk.
229

I managed to remove the secondary process in task manager which has got rid of the blank icon (cheers).

It seems I needed to set the .exe shortcut to run as admin for it to restart my media notifications, my main problem is the auto crash as soon as the notification hits and growl pushes me an update, was there anything obvious from my log to suggest why this was happening?

Thanks in advance

Tylor

230

The pushalot notifications are working really well for me. One thing I would like to be able to do is to customise the % of progress for the notifications as I'm only really interested in when the progress hits 80% so I know it has been scrobbled to trakt.tv.

231

The pushalot notifications are working really well for me. One thing I would like to be able to do is to customise the % of progress for the notifications as I'm only really interested in when the progress hits 80% so I know it has been scrobbled to trakt.tv.


If you go to basic settings it can be configured there

Sent from my SM-N900P using Tapatalk
232

this is working well for me.  the front-end is a bit big for my little monitor but functionally it does what i was looking for.  thank you, i'll be donating something come payday .... 

now, if someone can turn the API into something useful like a screensaver?

hehe

233

I managed to remove the secondary process in task manager which has got rid of the blank icon (cheers).
 
It seems I needed to set the .exe shortcut to run as admin for it to restart my media notifications, my main problem is the auto crash as soon as the notification hits and growl pushes me an update, was there anything obvious from my log to suggest why this was happening?
 
Thanks in advance
Tylor


If you download the latest version it has a fix for this.
234

The latest update seem to fix the log issue for me! Everything is working great! 

235

If you go to basic settings it can be configured there

Sent from my SM-N900P using Tapatalk

I must have missed that, thanks!

236

Should the latest update be showing when you press the check update as I am just getting the standard message that an update is not available!

237

Should the latest update be showing when you press the check update as I am just getting the standard message that an update is not available!


Try uninstalling and re installing. It sounds like your stuck on alpha 2

Sent from my SM-N900P using Tapatalk
238

For the updates, now it doesn't open a second instance of of the app but it doesn't close it when it mentions it needs to restart (I simply have to close it manually and reopen it.

Question:

I guess it's not implemented yet but for the users images, will it take the ones from MyPlex or it will be user defined (in Plex Notify)?

239

For the updates, now it doesn't open a second instance of of the app but it doesn't close it when it mentions it needs to restart (I simply have to close it manually and reopen it.

Question:
I guess it's not implemented yet but for the users images, will it take the ones from MyPlex or it will be user defined (in Plex Notify)?


Yeah I fixed that in this version. For sure this time :).

I will look into sneaking this in today's update

Sent from my SM-N900P using Tapatalk
240

Yeah I fixed that in this version. For sure this time :).

I will look into sneaking this in today's update

Sent from my SM-N900P using Tapatalk

cool!

How's the MySQL testing?