Author Topic: CoverArt  (Read 4929 times)

Andreaz

  • Regular Poster
  • **
  • Posts: 26
    • View Profile
CoverArt
« 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.. :-)

savvycenter

  • Regular Poster
  • **
  • Posts: 21
    • View Profile
Re: CoverArt
« Reply #1 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.

caiman

  • Veteran
  • ***
  • Posts: 119
    • View Profile
Re: CoverArt
« Reply #2 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

savvycenter

  • Regular Poster
  • **
  • Posts: 21
    • View Profile
Re: CoverArt
« Reply #3 on: July 11, 2007, 05:39:31 am »
Yes, reported as issue 3465.