LinuxMCE Forums
May 26, 2013, 07:58:51 am GMT-1 *
Welcome, Guest. Please login or register.
Did you miss your activation email?

Login with username, password and session length
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
 
   Home   Help Search Chat Login Register  
Pages: [1]
  Print  
Author Topic: CoverArt  (Read 940 times)
Andreaz
Regular Poster
**
Posts: 26


View Profile
« on: June 02, 2007, 09: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.. :-)
Logged
savvycenter
Regular Poster
**
Posts: 21


View Profile
« Reply #1 on: July 07, 2007, 07: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.
Logged
caiman
Veteran
***
Posts: 119



View Profile
« Reply #2 on: July 08, 2007, 09: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
Logged
savvycenter
Regular Poster
**
Posts: 21


View Profile
« Reply #3 on: July 11, 2007, 04:39:31 am »

Yes, reported as issue 3465.
Logged
Pages: [1]
  Print  
 
Jump to:  

Powered by MySQL Powered by PHP Powered by SMF 1.1.18 | SMF © 2013, Simple Machines Valid XHTML 1.0! Valid CSS!