LinuxMCE Forums

General => Users => Topic started by: Andreaz on June 02, 2007, 10:11:37 pm

Title: CoverArt
Post by: Andreaz on June 02, 2007, 10:11:37 pm
Does someone have a fix for this? :
Fatal error: mysql error: [1052: Column 'FK_File' in field list is ambiguous] in EXECUTE(" SELECT Keyword1Type,Keyword1Search,Keyword2Type,Keyword2Search,Keyword3Type,Keyword3Search,Attributes, FK_CoverArtScan,PK_CoverArtScanEntry,FK_File,FK_Disc,FK_Attribute,File.Path,File.Filename,Attribute.Name,Engine FROM CoverArtScanEntry INNER JOIN CoverArtScan ON FK_CoverArtScan=PK_CoverArtScan LEFT JOIN File ON FK_File=PK_File LEFT JOIN Disc ON FK_Disc=PK_Disc LEFT JOIN Attribute ON FK_Attribute=PK_Attribute ORDER BY PK_CoverArtScanEntry ASC....

The other script-errors have beeen fixed in 1.1b2 but this one remains.. :-)
Title: Re: CoverArt
Post by: savvycenter on July 07, 2007, 08:23:23 pm
I ran into the same problem and I believe I have fixed it as follow:

Go to /var/www/pluto_admin/operations/mediaBrowser and edit the file matchCoverArt.php. Changed FK_File to CoverArtScan.FK_File in the problem statement.

That should fix it.
Title: Re: CoverArt
Post by: caiman on July 08, 2007, 10:53:49 pm
I confirm, by replacing all occurrences of  FK_File to CoverArtScan.FK_File, it works.
Thank you 1000 times !
Is there a bug filed already so it gets fixed in the next release
Title: Re: CoverArt
Post by: savvycenter on July 11, 2007, 05:39:31 am
Yes, reported as issue 3465.