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

[m3rcury]

Probably an off topic... just tell me if it's more a movingpictures questions.

I'm using multiseat (database and thumbs stored on a NAS) setup for now 4 years without a lot of problems (just the mptvseries corrupted one time) and I want to give a try to your plugin because I think that it could be a great improvement in speed browsing if the database and thumbs are local on clients.

But I think about a problem : I've got 3 clients : 2 running Win7 and 1 running XP and as it's well known the program data paths are different between XP and 7 version.
I know that in movingpictures database, thumb path are stored with complete path, so if I get a copy of database from an Win 7 client on a Win XP client, movingpictures will probably get some difficulties to find the thumbs! ;-)
I think about a workaround : Changing the database and thumbs path in the directories xml file like we do to make a database sharing but this time changing the path to (e.g.) c:\mpdatas\database and c:\mpdatas\thumbs
By doing this on each client (7 and XP), I get the same path on each client.

Is any of you as already get this problem or think that this workaround could be a good solution?

Thanks for your answers.

TiboTv, what you suggest is a good workaround. By making paths same for Win7 and WinXP clients, you can then freely share the databases between clients using this plugin.

 

[TiboTv]

Ok thanks! I'll do the test and give you some feedback.

 

[m3rcury]

ajs, have replied you directly with the solutions to your issues, but for information to others, will produce below the resolution.

ajs,
 
The problems you are complaining about are all due to invalid data in your database.  These erroneous records and databases were clearly highlighted in the logs attached by yourself.
 
In the case of VideoDatabaseV5.db3, record with idMovie = 149 is corrupt as can be seen from the attached screen shot called "Error in video database.jpg".  Please amend.
 
As regards the error with the MusicDatabaseV12.db3, I could not recreate as using all the versions provided, I managed to synchronize without an error.

 

[ajs]

But I think about a problem : I've got 3 clients : 2 running Win7 and 1 running XP and as it's well known the program data paths are different between XP and 7 version.

FanartHandler.db3 It is also affected by this problem.[DOUBLEPOST=1368305164][/DOUBLEPOST]

ajs, have replied you directly with the solutions to your issues, but for information to others, will produce below the resolution.

VideoDatabaseV5.db3 on master, idMovie = 149 no problem

 

[ajs]

TVSeries database on Master:


after sync (on nas):


Such an error exists in the database of movies and music, but they are harder to find. Plug-in series immediately highlights such records in a different color and refuses to work normally with these serials.

LOG:

11.05.2013 14:09:48 - [DEBUG] MPSync: INSERT OR REPLACE INTO online_series (id,pretty_name,sortname,origname,status,genre,bannerfilenames,currentbannerfilename,posterfilenames,posterbannerfilename,summary,onli
nedataimported,airsday,airstime,actors,episodeorders,choosenorder,episodesortorder,bannersdownloaded,haslocalfiles,haslocalfiles_temp,getepisodestimestamp,updatebannerstimestamp,watchedfiletimestamp,unwatchedi
tems,episodecount,episodesunwatched,viewtags,language,banner,firstaired,imdb_id,zap2it_id,contentrating,network,networkid,rating,runtime,seriesid,added,addedby,fanart,lastupdated,poster,myrating,hasnewepisodes
,ratingcount,traktignore,aliasnames) VALUES('74608','Top Gear','Top Gear','Top Gear','Continuing','|Comedy|Documentary|Special Interest|Talk Show|','\Top Gear\-langen-graphical/74608-g2.jpg|\Top Gear\-langen-g
raphical/27682-g.jpg|\Top Gear\-langen-graphical/74608-g5.jpg|\Top Gear\-langen-graphical/74608-g.jpg|\Top Gear\-langen-text/74608.jpg|\Top Gear\-langen-graphical/74608-g3.jpg|\Top Gear\-langen-graphical/74608
-g4.jpg|\Top Gear\-langen-text/27682.jpg|\Top Gear\-langen-graphical/27682-g2.jpg|\Top Gear\-langen-graphical/74608-g6.jpg|\Top Gear\-langen-graphical/74608-g7.jpg|\Top Gear\-langen-graphical/74608-g8.jpg|\Top
Gear\-langen-graphical/74608-g9.jpg','\Top Gear\-langen-graphical/27682-g2.jpg','\Top Gear\-langen-posters/74608-3.jpg|\Top Gear\-langen-posters/74608-5.jpg|\Top Gear\-langen-posters/74608-2.jpg|\Top Gear\-la
ngen-posters/74608-4.jpg|\Top Gear\-langen-posters/74608-1.jpg|\Top Gear\-langen-posters/74608-6.jpg','\Top Gear\-langen-posters/74608-1.jpg','Top Gear - самое популярное авто-шоу всех времен. Аудитория переда
чи более 350 миллионов человек из 100 стран. Здесь вы не найдете занудных рассказов о семейных автомобилях и советов автолюбителям. Зато здесь много безумных тестов, неполитко','ектных шуток и драйва. Встречай
те: Джереми Кларкстон, Ричард Хаммонд, Джеймс Мэй и Стиг!','2','Sunday','8:00 PM','|Jeremy Clarkson|Richard Hammond|James May|The Stig|Jason Dawe|','','','','0','1','1','0','0','0','1','37','26','','ru','graph
ical/74608-g6.jpg','2002-10-20','tt1628033','SH00335172','TV-PG','BBC Two','','9.6','60','27682','','','fanart/original/74608-21.jpg','1368206277','posters/74608-5.jpg',NULL,'0','354','0')
11.05.2013 14:09:51 - [DEBUG] MPSync: 0 record deleted from actorlinkmovie in database M:\Mediaportal\DB\VideoDatabaseV5.db3

... Зато здесь много безумных тестов, неполитко','ектных шуток и драйва ...

Why plugin stole the letters р (two russian letters in a row) and ',' put there?

After sync on NAS:


LOG: ... попытку Фаерса подстрелить в небе самолет Фе','ис.','2013-05-08' ...

 

[ajs]

TiboTv, what you suggest is a good workaround. By making paths same for Win7 and WinXP clients, you can then freely share the databases between clients using this plugin.

You do not plan to change paths automatically? After all, the plugin knows the standard path and also knows the operating system version.

 

[m3rcury]

TiboTv, what you suggest is a good workaround. By making paths same for Win7 and WinXP clients, you can then freely share the databases between clients using this plugin.

You do not plan to change paths automatically? After all, the plugin knows the standard path and also knows the operating system version.

ajs, the plugin knows the paths one enters in the settings. It does not read the MediaPortal configuration to determine this. So as long as TiboTv configures one HTPC correctly, he can then synchronize the databases of the others.

 

[ajs]

ajs, the plugin knows the paths one enters in the settings. It does not read the MediaPortal configuration to determine this

I know, but I do not know. I suggest. Plug-in synchronization, looking at the database, and if it finds a valid standard paths for XP, and the plug-in running on the 7. It changes the standard path with XP to 7. This can be done in customizable configuration.

So as long as TiboTv configures one HTPC correctly, he can then synchronize the databases of the others.

This solution is good, but it is valid only for new systems for older systems that entails a complete updating of content, as path in databases for old systems are all old.

 

[m3rcury]

So as long as TiboTv configures one HTPC correctly, he can then synchronize the databases of the others.

This solution is good, but it is valid only for new systems for older systems that entails a complete updating of content, as path in databases for old systems are all old.

ajs, that is why I suggested to get one HTPC updated with the new paths and then use it to synchronize the rest...

 

[m3rcury]

... Зато здесь много безумных тестов, неполитко','ектных шуток и драйва ...

LOG: ... попытку Фаерса подстрелить в небе самолет Фе','ис.','2013-05-08' ...

ajs, seems that the ascii code of those characters happened to be the delimiter combination I used in the plugin. In the next version this will change to a different combination, so hopefully the new delimiter won't be equivalent to any valid Russian character combination