Login at Kodi Home

Mitch23 · 2012-10-21, 18:11

Hi!

I am trying to use MediaElch with a MySQL Database, but it seems that ME can't find any entries in the database, because off different path settings.

Log

Code:
"void MovieWidget::setMovie(Movie*)                                     :" Entered, movie= "Zorn der Titanen (2012)" 

"bool Movie::loadData(MediaCenterInterface*, bool)                      :" Entered, force= false 

"virtual bool XbmcSql::loadMovie(Movie*)                                :" Entered, movie= "Zorn der Titanen (2012)" 

"QString XbmcSql::mediaCenterPath(QString)                              :" Entered, file= "W:\HDTV\Fantasy\Zorn der Titanen (2012)\Zorn der Titanen (2012).mkv" 

"QString XbmcSql::mediaCenterPath(QString)                              :" mediaCenterFile= "W:\HDTV\Fantasy\Zorn der Titanen (2012)\Zorn der Titanen (2012).mkv" 

"virtual bool XbmcSql::loadMovie(Movie*)                                :" File "W:\HDTV\Fantasy\Zorn der Titanen (2012)\Zorn der Titanen (2012).mkv" becomes "W:\HDTV\Fantasy\Zorn der Titanen (2012)\Zorn der Titanen (2012).mkv" 

"virtual bool XbmcSql::loadMovie(Movie*)                                :" Movie is a single file movie 

"virtual bool XbmcSql::loadMovie(Movie*)                                :" isUnixFile= false 

"virtual bool XbmcSql::loadMovie(Movie*)                                :" fileSplit= ("W:", "HDTV", "Fantasy", "Zorn der Titanen (2012)", "Zorn der Titanen (2012).mkv") 

"virtual bool XbmcSql::loadMovie(Movie*)                                :" Single file movie 

"virtual bool XbmcSql::loadMovie(Movie*)                                :" Got no result, trying foldername 

"virtual bool XbmcSql::loadMovie(Movie*)                                :" file is now "W:\HDTV\Fantasy\Zorn der Titanen (2012)\" 

"virtual bool XbmcSql::loadMovie(Movie*)                                :" No entry found for movie, giving up

Therefore alle Movies in ME show "new" at the beginning.

All Movies are on a Samba-Share. Path in all XBMC-Clients is

Code:
<source>

            <name>HDTV</name>

            <path pathversion="1">smb://SERVER/Video/HDTV/</path>

        </source>

In ME I can't select a network share directly. I am using smb-shares because of 3 different clients (2 x Openelec, 1 x Windows).
Database is working on all of them.

Komet · 2012-10-21, 19:22

In settings, set the Media Center Directory to "smb://SERVER/Video/HDTV/" or whatever you need.

Mitch23 · 2012-10-21, 21:14

Hi Komet!

I set the Media Center Directory to "smb://SERVER/Video/HDTV". Note: without "/" at the end. Did not noticed that extra field earlier.

But ME can't find the entry. Here is the Log:

Code:
"bool Movie::loadData(MediaCenterInterface*, bool)                      :" Entered, force= true 

"virtual bool XbmcSql::loadMovie(Movie*)                                :" Entered, movie= "Zorn der Titanen" 

"QString XbmcSql::mediaCenterPath(QString)                              :" Entered, file= "W:\HDTV\Fantasy\Zorn der Titanen (2012)\Zorn der Titanen (2012).mkv" 

"QString XbmcSql::mediaCenterPath(QString)                              :" mediaCenterFile= "smb://SERVER/Video/HDTV/Fantasy/Zorn der Titanen (2012)/Zorn der Titanen (2012).mkv" 

"virtual bool XbmcSql::loadMovie(Movie*)                                :" File "W:\HDTV\Fantasy\Zorn der Titanen (2012)\Zorn der Titanen (2012).mkv" becomes "smb://SERVER/Video/HDTV/Fantasy/Zorn der Titanen (2012)/Zorn der Titanen (2012).mkv" 

"virtual bool XbmcSql::loadMovie(Movie*)                                :" Movie is a single file movie 

"virtual bool XbmcSql::loadMovie(Movie*)                                :" isUnixFile= true 

"virtual bool XbmcSql::loadMovie(Movie*)                                :" fileSplit= ("smb:", "", "SERVER", "Video", "HDTV", "Fantasy", "Zorn der Titanen (2012)", "Zorn der Titanen (2012).mkv") 

"virtual bool XbmcSql::loadMovie(Movie*)                                :" Single file movie 

"virtual bool XbmcSql::loadMovie(Movie*)                                :" Got no result, trying foldername 

"virtual bool XbmcSql::loadMovie(Movie*)                                :" file is now "smb://SERVER/Video/HDTV/Fantasy/Zorn der Titanen (2012)/" 

"virtual bool XbmcSql::loadMovie(Movie*)                                :" No entry found for movie, giving up

The MySQL path entry:

Code:
smb://SERVER/Video/HDTV/Fantasy/Zorn der Titanen (2012)/

The MySQL files entry:

Code:
Zorn der Titanen (2012).mkv

Can't find an difference. Maybe my database is too new for ME (MyVideos69 - OpenELEC-ION.x86_64-devel-20121016142319-r12188).

zestef · 2012-10-22, 07:42

Hi Mitch,

Maybe your xbmc path is stored in the database with the credential login like : "smb://login:password@SERVER/Video/HDTV/Fantasy/Zorn der Titanen (2012)/Zorn der Titanen (2012).mkv"

The best way is to use a mysql client to browse your database "MyVideos69" on your MySQL Server in order to check the real path :
- Open the "movie" table
- Find the row corresponding to your movie
- check the c22 column who is the field that MediaElch use to check if the movie exists.

Do you have one folder for one movie ? in this case check "Sep. folders".

Hope it's help.

Mitch23 · 2012-10-22, 18:25

Hi zestef!

Thanks for helping.

The MySQL c22 entry is

Code:
smb://SERVER/Video/HDTV/Fantasy/Zorn der Titanen (2012)/

I am using one folder for one movie. Sep. folders is checked. So I unchecked to test, but nothing. Movie is not found.

TV-Shows are recognized correcly.

Any suggestions?

Komet · 2012-10-22, 20:24

Just a quick note:
Version 1.1 was released: Release Notes, Download, Changelog

The MySQL/SQLite interfaces are no longer supported, read about it in the release notes.

newsilentsilver · (This post was last modified: 2012-10-22, 21:46 by newsilentsilver.)

(2012-10-22, 20:24)Komet Wrote: Version 1.1 was released

Great update, thank you. Smile

And DVD dirs are scanned correct now, too.

The only thing I really missed because of partially re-scraping director, writer and extra fanart for each movie was a "search all"/batch button ... Tongue

Komet · 2012-10-22, 21:16

Is on the roadmap, stay tuned Wink

**ArieS** · 2012-10-22, 21:53

Thanks a lot for the new version Komet!
And just to make sure I'm not missing something, the audio, resolution, etc codecs didn't make it to this release, right?

newsilentsilver · (This post was last modified: 2012-10-22, 22:23 by newsilentsilver.)

(2012-10-22, 21:16)Komet Wrote: Is on the roadmap, stay tuned

Good to hear. Laugh

Oh, and one more question: Why can you change priority of "Film NFO", "Film Poster", "Film Fanarts" etc. if MediaElch is saving all activated file names? Is this a first step to Ember like option "Benutze <movie> nur für Verzeichnisse mit mit mehreren Filmen" in one of the next versions? Huh

Komet · 2012-10-22, 22:27

(2012-10-22, 21:53)ArieS Wrote: Thanks a lot for the new version Komet!
And just to make sure I'm not missing something, the audio, resolution, etc codecs didn't make it to this release, right?

Thanks!

Metadata didn't make it, right. But right now I'm experimenting with libmediainfo Wink

(2012-10-22, 22:22)newsilentsilver Wrote: Oh, and one more question: Why can you change priority of "Film NFO", "Film Poster", "Film Fanarts" etc. if MediaElch is saving all activated file names? Is this a first step to Ember like option "Benutze <movie> nur für Verzeichnisse mit mit mehreren Filmen" in one of the next versions?

No

You can change the priority because you need to specify which file to use when loading information. The one with the highest priority is tried first, if it's not there, the next one and so on.

Linusorg · 2012-10-23, 11:08

Hi Komet,
thanks for the new version and it really speeds up loading and the new extra art incl. loading actor pictures is just great.
Besides all improvements it looks like there is a regression bug:
Right now ALL BDMV structures will not show up anymore :
American Pie
--BDMV (within sub dirs with the streams)
--- index.bdmv
--- movieobjects.bdmv
--Certificate

There are no (new) entries for the individual streams ( was my first idea that the new filetypes might be the reason for it ), all these directories are simply ignored.
It would be great if you could have a look at it.
Based on the fact that i have quite a lot of these movies i am going back to 1.0 :-)
Best Regards
Linus

Komet · 2012-10-23, 11:32

(2012-10-23, 11:08)Linusorg Wrote: Hi Komet,
thanks for the new version and it really speeds up loading and the new extra art incl. loading actor pictures is just great.
Besides all improvements it looks like there is a regression bug:
Right now ALL BDMV structures will not show up anymore :
American Pie
--BDMV (within sub dirs with the streams)
--- index.bdmv
--- movieobjects.bdmv
--Certificate

There are no (new) entries for the individual streams ( was my first idea that the new filetypes might be the reason for it ), all these directories are simply ignored.
It would be great if you could have a look at it.
Based on the fact that i have quite a lot of these movies i am going back to 1.0 :-)
Best Regards
Linus

What do you mean with "within sub dirs with the streams"? Structures like

Moviename
--BDMV
---index.bdmv

Are working...

Linusorg · 2012-10-23, 12:20

Sorry my fault it looks like its not related to the BDMV structure, but related to Moviesets or better how i organize them on disk.
f.e. :
Volumename
-- American Pie
---- American Pie I
------ BDMV
------ Certificate
---- American Pie II
------ BDMV
------ Certificate
---- American Pie III
------ BDMV
------ Certificate
etc.
Based on the fact that most of my BR Structures are Movie sets i got the impression that the problem is related to the bdmv structure, but since "normal 1:1 copies show up it seems to be related to my on-disk set structure.
Sorry for the wrong error report.
Linus.

Meaning of subdirs with streams was that these are all 1:1 BR copies

newsilentsilver · 2012-10-23, 17:16

(2012-10-22, 22:27)Komet Wrote: No You can change the priority because you need to specify which file to use when loading information. The one with the highest priority is tried first, if it's not there, the next one and so on.

Uuups ... thank you for correcting me. Blush

Oh, and btw., have the OFDb and VideoBuster problems or the MediaElch scrapers? The other two scrapers are working well, but with the OFDb and the VideoBuster scraper you don't get any result.