Plex Notify

tylordurton · February 4, 2014, 8:36pm

The above makes perfect sense, cheers for the explanation.

JimBurlison · February 4, 2014, 8:44pm

I've posted the bug report https://forums.plex.tv/topic/97575-statussessions-viewoffset-problem/

tylordurton · February 4, 2014, 8:46pm

Cool, any news on when you update will go live to fix the recurring update box ;-)

JimBurlison · February 4, 2014, 8:51pm

Cool, any news on when you update will go live to fix the recurring update box ;-)

Tonight with the database fix

tylordurton · February 4, 2014, 8:53pm

Good man cheers

sfnetwork · February 4, 2014, 8:56pm

Cool, any news on when you update will go live to fix the recurring update box ;-)

BTW, to avoid this in meantime, just restart app and don't check update...

JimBurlison · February 5, 2014, 4:45am

The update is out. Just as a friendly reminder this update wipes your database.

sfnetwork · February 5, 2014, 4:53am

A lot of MySQL errors still

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '1 * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'PlexNotifyClients' AND C' at line 1

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)

Unknown table 'plexnotify.user'

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)

Unknown table 'plexnotify.settings'

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 'servaraliases' already exists

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)

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '1 * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'PlexNotifyClients' AND C' at line 1

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)

Unknown table 'plexnotify.user'

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)

Unknown table 'plexnotify.settings'

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.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.ExecuteReader()

at PlexNotify.Databases.MySqlDB.RunReturnQuery(String sql, Dictionary`2 sqlParameters)

Table 'servaraliases' already exists

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)

JimBurlison · February 5, 2014, 5:16am

Holly crap. I just had to push 2 updates. I should have fixed your problem I inadvertently introduced the uber update notify bug. I hotfixed it.

JimBurlison · February 5, 2014, 5:31am

I am happy to announce that Plex Notify is an official Pushalot application now! https://pushalot.com/sources

JimBurlison · February 5, 2014, 5:49am

A lot of MySQL errors still

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '1 * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'PlexNotifyClients' AND C' at line 1

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)

Unknown table 'plexnotify.user'

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)

Unknown table 'plexnotify.settings'

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 'servaraliases' already exists

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)

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '1 * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'PlexNotifyClients' AND C' at line 1

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)

Unknown table 'plexnotify.user'

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)

Unknown table 'plexnotify.settings'

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.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.ExecuteReader()

at PlexNotify.Databases.MySqlDB.RunReturnQuery(String sql, Dictionary`2 sqlParameters)

Table 'servaraliases' already exists

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)

was your issue fixed?

sfnetwork · February 5, 2014, 5:52am

was your issue fixed?

no, tested again and notifications still doesn't work (0.0.0.11):

PlexNotifyLog>

Application started.

Table 'servaraliases' already exists

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)

Specified cast is not valid.

at PlexNotify.DatabaseHelper.RegisterClientWithDatabase()

at PlexNotify.MainWindow..ctor()

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.ExecuteReader()

at PlexNotify.Databases.MySqlDB.RunReturnQuery(String sql, Dictionary`2 sqlParameters)

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.ExecuteReader()

at PlexNotify.Databases.MySqlDB.RunReturnQuery(String sql, Dictionary`2 sqlParameters)

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.ExecuteReader()

at PlexNotify.Databases.MySqlDB.RunReturnQuery(String sql, Dictionary`2 sqlParameters)

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.ExecuteReader()

at PlexNotify.Databases.MySqlDB.RunReturnQuery(String sql, Dictionary`2 sqlParameters)

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.ExecuteReader()

at PlexNotify.Databases.MySqlDB.RunReturnQuery(String sql, Dictionary`2 sqlParameters)

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.ExecuteReader()

at PlexNotify.Databases.MySqlDB.RunReturnQuery(String sql, Dictionary`2 sqlParameters)

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.ExecuteReader()

at PlexNotify.Databases.MySqlDB.RunReturnQuery(String sql, Dictionary`2 sqlParameters)

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.ExecuteReader()

at PlexNotify.Databases.MySqlDB.RunReturnQuery(String sql, Dictionary`2 sqlParameters)

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.ExecuteReader()

at PlexNotify.Databases.MySqlDB.RunReturnQuery(String sql, Dictionary`2 sqlParameters)

sfnetwork · February 5, 2014, 5:52am

duplicate post

JimBurlison · February 5, 2014, 6:19am

duplicate post

use MySql workbench to delete your database and re-create it. servaraliases error will come up that is a bug.

CrazyWatermelon · February 5, 2014, 6:19am

The app is crashing on my computer. I get the force close screen on Windows, the following app has stopped working, I've attached the files that it claims are related to the issue. I also have another file that is too large to be uploaded to the forum so I've uploaded it to my domain. This is the link to that file. Its called WERF969.tmp.mdmp. Hope this helps if you need any additional information please let me know.

hopkinsbrett · February 5, 2014, 6:28am

I am getting the same errors as sfnetwork. Closed Plex Notify, recreated db, same issue.

Edit

Make sure users have permissions.

So I was trying to use mysql db instead of mssqlce once I go back to ce it works fine.

JimBurlison · February 5, 2014, 6:28am

The app is crashing on my computer. I get the force close screen on Windows, the following app has stopped working, I've attached the files that it claims are related to the issue. I also have another file that is too large to be uploaded to the forum so I've uploaded it to my domain. This is the link to that file. Its called WERF969.tmp.mdmp. Hope this helps if you need any additional information please let me know.

Are there any logs in "C:\ProgramData\Plex Notify\Logs"

JimBurlison · February 5, 2014, 7:03am

Ok I have a fix in place. I changed all tables to have primitive TSQL data types. publishing now.

JimBurlison · February 5, 2014, 7:14am

What a crazy night. Im heading to bed. I hope everything is working ok for you guys now. Seems to be working great on my local MySql. Lessons learned tonight. I think we are done with the database problems and update problems. I will start creating more statistics content tomorrow.

hopkinsbrett · February 5, 2014, 7:23am

What fix was that for? Is it so we can use mysql instead of mssqlce?

Topic		Replies	Views
plexWatch - Windows Branch Dev/API Corner other-dev	669	3219	December 21, 2019
PlexWatch and PlexWatchWeb installation and configuration procedure for dummies (Windows) Dev/API Corner other-dev	201	7887	January 8, 2020
Native integration of Plex Notify or Plex Watch, or a replacement - ie native data export Feature Suggestions	47	316	June 10, 2021
plexWatch - Plex Notify Script - Send Push Alerts On New Sessions and Stopped Dev/API Corner other-dev	1328	7098	December 20, 2019
Notifications for Plex Pass members Feature Suggestions	23	84	June 10, 2021

Plex Notify

Related topics