(2012-09-08, 07:45)ZaPHoN Wrote: This can't be installed in ubuntu 11.10 Oneiric

the dependency is not satisfiable libqtgui4 (>=4:4.8.0)

When trying to use the deb for libqtgui4 (>=4:4.8.0) from 4:4.8.1-0ubuntu2 it shows it's already installed.

Can provide some direction on this. It seems a lot of people are having issues with this package.

(2012-09-08, 14:28)GreenEyez Wrote: Hey Komet, when is the new version expected? I see you closed the milestone for 9.5 on github, so are we to expect a new version soon ?

(2012-09-09, 09:58)zestef Wrote: Hi Komet,

Very very good job on mediaelch (donated a little ), hope you will continue to improve it.

I'm facing a bug that i do not understand, here we go :

Configuration :
Mac OS X 10.7.3
MedialElch 0.9.4
XBMC 11
MySQL Server

Movies Path & MediaCenter Path correctly configured (smb://), separate folder checked.
XMBC MySQL correctly configured
Thumbnails Path correctly configured

Metadata already stored in MySQL are nearly complete (XBMC Database contains nearly all metadata for my files).
My goal is to use MediaElch to add/modify metadata to my movies.

When MediaElch scan my folder and associates movies folder with xbmc mysql metadata, I've got different behavior :
Case 1 - Some movies have their metadata and their poster/fanart displayed by MediaElch (The good way )
Case 2 - Some movies have not their metadata and their poster/fanart displayed by MediaElch (again the database is complete for these movies), after a first analysis it seems to be related with m2ts files or with movies with special character in their title like "L'Âge de glace 3".
Case 3 - Some movies does not have metadata but MediaElch display their respective poster/fanart found in the thumbnail cache (I though that the xbmc thumbnail cache was related to the informations stored in the xbmc database), that's this behavior that i do not understand .

As usual screenshots are a better way to explain :

Case 1 :


Case 2 :


Case 3 :


Hope you can help, regards.

Zestef.

Quote:What's going wrong in case 2 and 3 is there is some bug in MediaElchs XBMC sql interface, maybe the special characters don't get escaped or something like that. So MediaElch couldn't retrieve the metadata from the database.
In case 2 my implementation of the hash calculation seems also to be broken when it comes to filenames with special characters. So I may be constructing a wrong hash.
In case 3 the hash calculation is ok (that's because you see the thumbnails) but the sql query is wrong.

As said earlier, the next release comes with a debug log. With this information it would be easier to track bugs like this down.

(2012-09-19, 09:45)zestef Wrote: Case 2 : I've got this problem only with the three Ice Age movies, the french Spelling is "L'Âge de glace", i think the problem concerns the "Â" character, and by consequence the hash calculation :
Here is an example with the ice age fanart :
Real Path (on my system) = "/Users/zestef/Library/Application Support/XBMC/userdata/Thumbnails/Video/Fanart/4d1b627f.tbn"
fanartPath ( from MediaElch Log) = "/Users/zestef/Library/Application Support/XBMC/userdata/Thumbnails/Video/Fanart/f4598df6.tbn"

Case 3 : the problem is on the apostrophe character ' who is replaced by a double apostrophe character '' in your XbmcSQL.cpp file (sqlWhereFile / loadMovie process), I've just changed the double apostrophe back to a simple apostrophe and the problem is gone. But maybe there are others implications that i don't understand.

(2012-09-19, 09:50)GreenEyez Wrote: Komet, speaking of github, i see 0.9.6 is completed (which includes the new debug options as far as i can tell), any plans on releasing the binaries for it, or are you also skipping this version and going to 0.9.7 directly ?

(2012-09-08, 16:08)Komet Wrote:

(2012-09-08, 07:45)ZaPHoN Wrote: This can't be installed in ubuntu 11.10 Oneiric

the dependency is not satisfiable libqtgui4 (>=4:4.8.0)

When trying to use the deb for libqtgui4 (>=4:4.8.0) from 4:4.8.1-0ubuntu2 it shows it's already installed.

Can provide some direction on this. It seems a lot of people are having issues with this package.

Maybe I'll have a look into this but I'm testing the deb's only with the latest stable Ubuntu release. All others are free to compile MediaElch on their own

(2012-09-08, 14:28)GreenEyez Wrote: Hey Komet, when is the new version expected? I see you closed the milestone for 9.5 on github, so are we to expect a new version soon ?

I decided to skip the release of version 0.9.5 and go straight forward to 0.9.6 which will include the debug mode. So please stand by a little bit longer

(2012-09-20, 09:02)Komet Wrote:

(2012-09-19, 09:45)zestef Wrote: Case 3 : the problem is on the apostrophe character ' who is replaced by a double apostrophe character '' in your XbmcSQL.cpp file (sqlWhereFile / loadMovie process), I've just changed the double apostrophe back to a simple apostrophe and the problem is gone. But maybe there are others implications that i don't understand.

Case 3: The double apostroph is correct, escaping of apostrophs in SQL is done with another apostroph. The problem is the accent in "Vidéos" which is causing problems with the sql query. I experimented a little bit but haven't found a solution yet.

---

(2012-09-20, 17:08)zestef Wrote:

(2012-09-20, 09:02)Komet Wrote:

(2012-09-19, 09:45)zestef Wrote: Case 3 : the problem is on the apostrophe character ' who is replaced by a double apostrophe character '' in your XbmcSQL.cpp file (sqlWhereFile / loadMovie process), I've just changed the double apostrophe back to a simple apostrophe and the problem is gone. But maybe there are others implications that i don't understand.

Case 3: The double apostroph is correct, escaping of apostrophs in SQL is done with another apostroph. The problem is the accent in "Vidéos" which is causing problems with the sql query. I experimented a little bit but haven't found a solution yet.

---

Hi Komet,

Sorry to insist but I compiled your code (XbmcSQL.cpp file) with the following change and every SQL query works (all my movies metadata are now displayed in mediaElch) :

Code:

if (m_isMySQL) {
            file.replace("\\", "\\\\");
            qDebug() << "Is MySQL, file=" << file;
        }
        sqlWhereFile = QString("M.c22='%1'").arg(file.replace("'", "''"));
    } else {
        qDebug() << "Movie is made of multiple files";
        if (m_isMySQL) {
            file.replace("\\", "\\\\\\\\");
            qDebug() << "Is MySQL, file=" << file;
        }
        sqlWhereFile = QString("M.c22 LIKE 'stack://%%1%'").arg(file.replace("'", "''"));
    }

Replaced by :

Code:

if (m_isMySQL) {
            file.replace("\\", "\\\\");
            qDebug() << "Is MySQL, file=" << file;
        }
        sqlWhereFile = QString("M.c22='%1'").arg(file.replace("'", "'"));
    } else {
        qDebug() << "Movie is made of multiple files";
        if (m_isMySQL) {
            file.replace("\\", "\\\\\\\\");
            qDebug() << "Is MySQL, file=" << file;
        }
        sqlWhereFile = QString("M.c22 LIKE 'stack://%%1%'").arg(file.replace("'", "'"));
    }

Regards
Zestef

(2012-09-20, 17:11)Komet Wrote: Are you sure it isn't working without your change? With this change you will run into trouble when a filename contains an apostroph.