patch - centralized DB fixes. (1 Viewer)

[gibman]

Hi!

As in this thread:
https://forum.team-mediaportal.com/moving-pictures-284/patch-centralized-db-fixes-76414/

tvseries is in similar ways to movpics also plagued by centralized database issues.

My fixes include:

1) The database connection was not closed when going into standby/hibernation mode. This would cause all kinds of SQL lite exceptions once the HTPC was resumed again. This would often cause the db image (file) to become malformed. The only solution in these situations would be to rebuild the database once again. Tedious job.

My fix for this includes having the tvseries plugin now properly react to the onsuspend and onresume events.
On "OnSuspend" it will close the DB connection. On resume it will reestablish connection.

/gibman

 

[ltfearme]

Thanks, added in r895

 

[disaster123]

AW: patch - centralized DB fixes.

THere seems to be a bug still in it:

00000001 - 22.01.2010 23:17:51 - MP-TVSeries is entering standby
00000001 - 22.01.2010 23:17:51 - Successfully closed Database: \\192.168.178.100\mp.data\DB\TVSeriesDatabase4.db3
00000065 - 22.01.2010 23:17:54 - Successfully opened database '\\192.168.178.100\mp.data\DB\TVSeriesDatabase4.db3'
00000065 - 22.01.2010 23:17:54 - Commit failed on this command: <update local_episodes set DownloadPending = '0' where EpisodeFilename = '\\192.168.178.100\mp.data\VID\Monk\Monk - (Mr. Monk als Wahlhelfer) S3E15 - 2009-10-20 - 22_15.ts'> (SQLiteClient: TVSeriesDatabase4.db3 cmd:sqlite3_prepare16:pvm=null err:ERROR detailed:no such column: DownloadPending query:update local_episodes set DownloadPending = '0' where EpisodeFilename = '\\192.168.178.100\mp.data\VID\Monk\Monk - (Mr. Monk als Wahlhelfer) S3E15 - 2009-10-20 - 22_15.ts').

The DB was right again opened when i started to send the system to standby

 

[memme]

What do I have to do, to activate the patch?

 

[Zinu]

Download the trunk (svn), apply patch and compile.

 

[ltfearme]

It's already in the latest release.

 

[Zinu]

Oh, didn't notice the dates Thanks damien.