Page 1 of 1

Strange issue on mySQL database

Posted: 09 Dec 2015, 19:57
by whityini
First of all my biggest thank for bringing our favourite media center into the new AppleTv.
And now my issue.
I have all my media file into a remote nas under a MySQL database and this configuration works perfectly with Kodi.
Now I have configured MrMC in this way:
Firstly I have mapped my remote source directories for video and TV series. I can browse the files inside these directories and also start playing any media.
Then I have configured MySQL parameters into the relative menu: ip of the nas, name and password of the database.
The system recognizes the database information and in the Video and TV Series menu are shown with the correct metadata.
The issue is that while I can start playing the TV Series without any problem when I try to start a movie the system tells me that the file is not more available.
Considering that the video database is the same for movie and series tv and that the same database works well under kodi system, I don't really understand what could be the reason.
An help will be really appreciate.

Re: Strange issue on mySQL database

Posted: 09 Dec 2015, 20:32
by davilla
which file server format is your nas exporting ?

Re: Strange issue on mySQL database

Posted: 09 Dec 2015, 20:45
by whityini
SMB if you mean that.

Re: Strange issue on mySQL database

Posted: 10 Dec 2015, 15:11
by Nagsterus
If you start a library update in MrMC, does it try to duplicate all your movies? If so, stop it before it makes a mess, and you may have a similar issue that I did. My years-old XBMC/Kodi MySQL database for some reason had the same sources interpreted differently than MrMC. If you're comfortable with MySQL, you can use Workbench to look at the myvideos database. Look at the path, files, and movie tables and try to find out what MrMC sees as the sources. For me, it looked like Kodi was using some old configuration of the sources that had a password embedded, so the "fix" was to run some SQL commands to force the movie and files tables to see the sources as MrMC does, but this "fix" may cause issues if you're trying to share the library with different installs of Kodi and MrMC, so back the DB up first.

Re: Strange issue on mySQL database

Posted: 10 Dec 2015, 20:04
by whityini
Thanks Nagsterus I fixed it.
I take a look inside myvideos database and I have find out that for all the movies the name of the server into the path was written in lowercase while for the tv shows the name was in uppercase. So I changed the name in uppercase and now the film start without any problem.
Problem solved.

Re: Strange issue on mySQL database

Posted: 10 Dec 2015, 20:11
by davilla
was your original advancedsettings.xml in upper or lower ?

Re: Strange issue on mySQL database

Posted: 10 Dec 2015, 20:14
by whityini
in advancesettings.xml was indicated as an ip and not as a name