Author Topic: i got this selecting cover art on pluto admin  (Read 2147 times)

rictec

  • Regular Poster
  • **
  • Posts: 29
    • View Profile
i got this selecting cover art on pluto admin
« on: April 06, 2007, 03:31:22 am »
Fatal error: mysql error: [1054: Unknown column 'FK_AttributeType' in 'on clause'] in EXECUTE("SELECT * FROM File_Attribute INNER JOIN AttributeType ON FK_AttributeType=PK_AttributeType INNER JOIN Attribute ON FK_Attribute=PK_Attribute WHERE FK_AttributeType IN (2,3) AND FK_File IN (157,156,1)") in /var/www/pluto-admin/include/adodb/adodb-errorhandler.inc.php on line 77

a ref to adodb? maybe or a bad install?

sharlee_angelo

  • Guru
  • ****
  • Posts: 316
    • View Profile
Re: i got this selecting cover art on pluto admin
« Reply #1 on: April 06, 2007, 12:51:01 pm »
if are using any user interface, do you see the cover arts for every media (video) file?
Read the F****** Logs!!!

rictec

  • Regular Poster
  • **
  • Posts: 29
    • View Profile
Re: i got this selecting cover art on pluto admin
« Reply #2 on: April 07, 2007, 08:51:09 pm »
no i can't see any convert art just green squares

rictec

legolas

  • Making baby steps
  • Posts: 3
    • View Profile
Re: i got this selecting cover art on pluto admin
« Reply #3 on: April 19, 2007, 12:34:22 pm »
Fatal error: mysql error: [1054: Unknown column 'FK_AttributeType' in 'on clause'] in EXECUTE("SELECT * FROM File_Attribute INNER JOIN AttributeType ON FK_AttributeType=PK_AttributeType INNER JOIN Attribute ON FK_Attribute=PK_Attribute WHERE FK_AttributeType IN (2,3) AND FK_File IN (157,156,1)") in /var/www/pluto-admin/include/adodb/adodb-errorhandler.inc.php on line 77

a ref to adodb? maybe or a bad install?
It's a SQL error (at least in mySQL 5.0, in 4.x it's working):
Code: newbielink:javascript:void(0); [nonactive]
SELECT * FROM File_Attribute INNER JOIN AttributeType ON FK_AttributeType=PK_AttributeType INNER JOIN Attribute ON FK_Attribute=PK_Attribute WHERE FK_AttributeType IN ... shold be
Code: newbielink:javascript:void(0); [nonactive]
SELECT * FROM File_Attribute INNER JOIN Attribute ON FK_Attribute=PK_Attribute INNER JOIN AttributeType ON FK_AttributeType=PK_AttributeType WHERE FK_AttributeType IN ...(first join with Attribute table, then with AttributeType).

rictec

  • Regular Poster
  • **
  • Posts: 29
    • View Profile
Re: i got this selecting cover art on pluto admin
« Reply #4 on: April 22, 2007, 12:58:38 am »
hi legolas
so as i m running MySQL version 5.0.24 tell me where is that sql i will change it and test

thanks
Rictec

lol Found it in /var/www/pluto-admin/operation/mediaBrowser/coverArt.php

i edited the file and its working

Thanks legolas nice one
« Last Edit: April 22, 2007, 01:16:55 am by rictec »

cirion

  • Guru
  • ****
  • Posts: 353
    • View Profile
Re: i got this selecting cover art on pluto admin
« Reply #5 on: May 03, 2007, 07:50:12 am »
I got almost the same error.. What shall I do?

Fatal error: mysql error: [1054: Unknown column 'FK_AttributeType' in 'on clause'] in EXECUTE("SELECT * FROM File_Attribute INNER JOIN AttributeType ON FK_AttributeType=PK_AttributeType INNER JOIN Attribute ON FK_Attribute=PK_Attribute WHERE FK_AttributeType IN (2,3) AND FK_File IN (9184,9183,9182,9181,9180,9179,9178,9177,9176,9175,9174,9173,9172,9171,9170,9169,9168,9167,9166,9165,9105,9104,9103,9102,9101,9100,9099,9097,9096,9095,9094,9093,9092,9091,9090,9089,9088,9087,9086,9085,9084,9083,9082,9081,9080,9079,9078,9077,9076,9075,9074,9073,9072,9071,9070,9069,9068,9067,9066,9065,9064,9063,9062,9061,9060,9059,9058,9057,9056,9055,9054,9053,9052,9051,9050,9049,9048,9047,9046,9045,9044,9043,9042,9041,9040,9039,9038,9037,9036,9033,9032,9031,9030,9029,9028,9027,9026,9025,9024,9023,9022,9021,9020,9019,9018,9017,9016,9015,9014,9013,9012,9011,9010,9009,9008,9007,9006,9005,9004,9003,8998,8996,8993,8992,8991,8990,8989,8988,8987,8986,8985,8984,8983,8982,8981,8980,8979,8978,8977,8976,8975,8974,8973,8972,8971,8970,8969,8968,8967,8966,896 in /var/www/pluto-admin/include/adodb/adodb-errorhandler.inc.php on line 77

cirion

  • Guru
  • ****
  • Posts: 353
    • View Profile
Re: i got this selecting cover art on pluto admin
« Reply #6 on: May 03, 2007, 09:37:17 am »
Same bug different text...

Editet /var/www/pluto-admin/operation/mediaBrowser/coverArt.php

cirion

  • Guru
  • ****
  • Posts: 353
    • View Profile
Re: i got this selecting cover art on pluto admin
« Reply #7 on: May 03, 2007, 09:46:06 am »
Now I can enter the CoverArt page in Admin.

But when I press Scan for Coverart I get a new error:

Fatal error: mysql error: [1054: Unknown column 'Disc.Slot' in 'field list'] in EXECUTE(" SELECT Keyword1Type,Keyword1Search,Keyword2Type,Keyword2Search,Keyword3Type,Keyword3Search,Attributes, FK_CoverArtScan,PK_CoverArtScanEntry,FK_File,FK_Disc,FK_Attribute,File.Path,File.Filename,Disc.Slot,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") in /var/www/pluto-admin/include/adodb/adodb-errorhandler.inc.php on line 77

deffcon

  • Veteran
  • ***
  • Posts: 94
    • View Profile
Re: i got this selecting cover art on pluto admin
« Reply #8 on: May 10, 2007, 01:21:10 pm »
I got this also, do you have an solution?\

Greetz,

Deffcon

cirion

  • Guru
  • ****
  • Posts: 353
    • View Profile
Re: i got this selecting cover art on pluto admin
« Reply #9 on: May 11, 2007, 10:46:26 pm »
No. I still have no solution to this.

And I have tried installing LinuxMCE countless times to try and find a solution that works... In the end I gave up on LinuxMCE for now, and installed Pluto. There it works on the same hardware. The error must be in LinuxMCE.