News:

Rule #1 - Be Patient - Rule #2 - Don't ask when, if you don't contribute - Rule #3 - You have coding skills - LinuxMCE's small brother is available: http://www.agocontrol.com

Main Menu

CoverArt

Started by Andreaz, June 02, 2007, 10:11:37 PM

Previous topic - Next topic

Andreaz

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.. :-)

savvycenter

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.

caiman

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

savvycenter

Yes, reported as issue 3465.