[Plugin] MPSync - MediaPortal multi-seat Synchronization (7 Viewers)

[m3rcury]

ok, my setup follows your explenation too

master client --> Server Place --> Client a
--> Client b

The master client aint used for watching, just used to import stuff and use for mpextended to watch external on my android devices with ampdroid,
do i understand correctly it needs to run always for syncing watched status event its not used, only clent a / b are used ... ?

Now lets start with my simple problem, i cleaned Server Place /database and /thumbs folder to startup with a clean sync,
now when i make a manual sync i see lotsa errors in log like

2013-04-01 15:27:37.507467 [Info.][(16)]: MPSync: Error reading data from table online_series in database TVSeriesDatabase4.db3
2013-04-01 15:27:37.507967 [ERROR][(16)]: MPSync: Error reading data from table online_series in database TVSeriesDatabase4.db3
2013-04-01 15:27:37.517469 [Info.][(16)]: MPSync: synchronization of watched for table online_series in database C:\ProgramData\Team MediaPortal\MediaPortal\database\TVSeriesDatabase4.db3 in progress...
2013-04-01 15:27:37.526470 [Info.][(16)]: MPSync: synchronization of watched for table online_series in database C:\ProgramData\Team MediaPortal\MediaPortal\database\TVSeriesDatabase4.db3 complete.
2013-04-01 15:27:37.526470 [Info.][(16)]: MPSync: synchronization of table online_series in database \\ALSSERVER\AlsServer_I\Mediaportal\MPSync\database\TVSeriesDatabase4.db3 in progress...
2013-04-01 15:27:37.553473 [Info.][(16)]: MPSync: Error reading data from table season in database TVSeriesDatabase4.db3
2013-04-01 15:27:37.553473 [ERROR][(16)]: MPSync: Error reading data from table season in database TVSeriesDatabase4.db3
2013-04-01 15:27:37.561974 [Info.][(16)]: MPSync: synchronization of watched for table season in database C:\ProgramData\Team MediaPortal\MediaPortal\database\TVSeriesDatabase4.db3 in progress...
2013-04-01 15:27:37.568475 [Info.][(16)]: MPSync: synchronization of watched for table season in database C:\ProgramData\Team MediaPortal\MediaPortal\database\TVSeriesDatabase4.db3 complete.
2013-04-01 15:27:37.568475 [Info.][(16)]: MPSync: synchronization of table season in database \\ALSSERVER\AlsServer_I\Mediaportal\MPSync\database\TVSeriesDatabase4.db3 in progress...
2013-04-01 15:27:38.356075 [Info.][(16)]: MPSync: Error reading data from table local_episodes in database TVSeriesDatabase4.db3
2013-04-01 15:27:38.356075 [ERROR][(16)]: MPSync: Error reading data from table local_episodes in database TVSeriesDatabase4.db3
... log attached

i assume thats why my server database is never updated and filesizes doesnt match ... and clients will never really work well either

attached pic is from main client where i fill up tv series etc ... other clients arrow is leading up, should be correct ?

alturismo, do you have debug on as it seems there are not enough details in the logs....

 

[alturismo]

now with debug enabled

 

[m3rcury]

MPSync v0.0.0.13 Beta has just been released. This version includes the ability for clients to update the watched/resumed status between themselves as well as performance enhancements.

Please download from the repository link on post #1.

 

[alturismo]

me again, i looked into the log and wondered no errors came up, now i tested again to see if i may forgot to trigger debug ...

funny thing now is, when debug is enabled no errors come up in log, with debug off all those errors occur log with both attached,
first part with debug, second part without debug ...
still same result on both, no tv series, movie databases sync ...

i ll check tomorrow if clients work here without tv series and movies.

thanks alot for your efforts

 

[m3rcury]

me again, i looked into the log and wondered no errors came up, now i tested again to see if i may forgot to trigger debug ...

funny thing now is, when debug is enabled no errors come up in log, with debug off all those errors occur log with both attached,
first part with debug, second part without debug ...
still same result on both, no tv series, movie databases sync ...

i ll check tomorrow if clients work here without tv series and movies.

thanks alot for your efforts

alturismo, can you please attach the error.log as well.

 

[alturismo]

2013-04-02 21:26:19.918873 [ERROR][(1)]: SQLiteClient: TVSeriesDatabase4.db3 cmd:sqlite3_prepare16vm=null err:ERROR detailed:no such column: new.myRating query:update online_episodes set Watched = 1 where CompositeID = '164541_3x8'
2013-04-02 21:26:23.182788 [ERROR][(1)]: SQLiteClient: TVSeriesDatabase4.db3 cmd:sqlite3_prepare16vm=null err:ERROR detailed:no such column: new.myRating query:update online_episodes set Watched = 1 where CompositeID = '247897_1x10'
2013-04-02 21:26:26.315685 [ERROR][(1)]: SQLiteClient: TVSeriesDatabase4.db3 cmd:sqlite3_prepare16vm=null err:ERROR detailed:no such column: new.myRating query:update online_episodes set Watched = 1 where CompositeID = '72108_10x13'
2013-04-02 21:26:28.636980 [ERROR][(1)]: SQLiteClient: TVSeriesDatabase4.db3 cmd:sqlite3_prepare16vm=null err:ERROR detailed:no such column: new.myRating query:update online_episodes set Watched = 1 where CompositeID = '95441_4x1'
2013-04-02 21:29:33.635972 [ERROR][(1)]: SQLiteClient: TVSeriesDatabase4.db3 cmd:sqlite3_prepare16vm=null err:ERROR detailed:no such column: new.myRating query:update online_episodes set Watched = 1 where CompositeID = '95441_4x1'
2013-04-02 21:29:40.442336 [ERROR][(1)]: SQLiteClient: TVSeriesDatabase4.db3 cmd:sqlite3_prepare16vm=null err:ERROR detailed:no such column: new.myRating query:update online_episodes set Watched = 1 where CompositeID = '72108_10x13'
2013-04-02 21:29:46.738136 [ERROR][(1)]: SQLiteClient: TVSeriesDatabase4.db3 cmd:sqlite3_prepare16vm=null err:ERROR detailed:no such column: new.myRating query:update online_episodes set Watched = 1 where CompositeID = '247897_1x10'

thats the only entries i see ... what i may think off, i set all to german here, also tv series, may thats an issue ? different values ?

 

[m3rcury]

alturismo, seems to be a MP-TVSeries version issue. Can you check your version and compare with the pre-requisites in post #1. It is complaining of a missing field in TVSeriesDatabase4.db3

Could be something similar for your MovingPictures issue.

 

[alturismo]

MP-TVSeries-3.4.2.2018.mpe1 ... should be fine

thats the version i use, never used it before due no multiseat, so pretty fresh cause only makes sence to me with a plugin like yours

 

[m3rcury]

MP-TVSeries-3.4.2.2018.mpe1 ... should be fine

thats the version i use, never used it before due no multiseat, so pretty fresh cause only makes sence to me with a plugin like yours

So don't understand how the column is missing from your table . Will see how to go around this issue...

 

[m3rcury]

MPSync v0.0.0.14 Beta has been released. This should solve the issue reported above by alturismo when different db versions exist.

Please give it a try and report back any feedback.

You can download from the repository link on post #1.

Thanks