i got this selecting cover art on pluto admin

[rictec]

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]

if are using any user interface, do you see the cover arts for every media (video) file?

[rictec]

no i can't see any convert art just green squares

rictec

[legolas]

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: [Select]

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: [Select]

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]

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

[cirion]

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]

Same bug different text...

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

[cirion]

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]

I got this also, do you have an solution?\

Greetz,

Deffcon

[cirion]

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.