media search error

[darkwizard864]

every time I do a search in my movies it restart dcerouter. in router logs I see this

01   09/08/16 22:59:25.592      Query failed (Column 'FK_AttributeType' in field list is ambiguous): select DISTINCT PK_Attribute, IF(FK_AttributeType IN (2,3,13,57), IF(Name LIKE 'the %', CONCAT(SUBSTR(Name, 5), ', The'), Name), Name ) AS Name, Description, FK_Picture FROM Attribute JOIN AttributeType ON Attribute.FK_AttributeType=PK_AttributeType JOIN MediaType_AttributeType ON MediaType_AttributeType.FK_AttributeType=PK_AttributeType LEFT JOIN Picture_Attribute ON FK_Attribute=PK_Attribute WHERE Name Like 'w%' AND Identifier>0 AND MediaType_AttributeType.EK_MediaType=5 ORDER BY Name limit 30 (1) <0x9122bb40>
05   09/08/16 22:59:25.592      Resetting db_wrapper connection <0x9122bb40>
01   09/08/16 22:59:25.593      Query failed (Column 'FK_AttributeType' in field list is ambiguous): select DISTINCT PK_Attribute, IF(FK_AttributeType IN (2,3,13,57), IF(Name LIKE 'the %', CONCAT(SUBSTR(Name, 5), ', The'), Name), Name ) AS Name, Description, FK_Picture FROM Attribute JOIN AttributeType ON Attribute.FK_AttributeType=PK_AttributeType JOIN MediaType_AttributeType ON MediaType_AttributeType.FK_AttributeType=PK_AttributeType LEFT JOIN Picture_Attribute ON FK_Attribute=PK_Attribute WHERE Name Like 'w%' AND Identifier>0 AND MediaType_AttributeType.EK_MediaType=5 ORDER BY Name limit 30 (1) <0x9122bb40>
05   09/08/16 22:59:25.593      Resetting db_wrapper connection <0x9122bb40>
01   09/08/16 22:59:25.593      Query failed (): select DISTINCT PK_Attribute, IF(FK_AttributeType IN (2,3,13,57), IF(Name LIKE 'the %', CONCAT(SUBSTR(Name, 5), ', The'), Name), Name ) AS Name, Description, FK_Picture FROM Attribute JOIN AttributeType ON Attribute.FK_AttributeType=PK_AttributeType JOIN MediaType_AttributeType ON MediaType_AttributeType.FK_AttributeType=PK_AttributeType LEFT JOIN Picture_Attribute ON FK_Attribute=PK_Attribute WHERE Name Like 'w%' AND Identifier>0 AND MediaType_AttributeType.EK_MediaType=5 ORDER BY Name limit 30 retry: (nil) <0x9122bb40>
Return code: 139
3   09/08/16 22:59:26   DCERouter (server)   Device died... count=8/200 dev=DCERouter
Thu Sep  8 22:59:26 EDT 2016 died

does this mean my database is wacked?

[Marie.O]

If DCERouter restarts during a media query most of the time it has to do with speed of the HDD. Post the log starting a minute before the failing.

[darkwizard864]

posde I would agree with you. but it a ssd and never had a problem before until all updates to updatemedia...

[Marie.O]

I am not really seeing stuff in the log file. Couple of notes:

* Does it matter what type of Orbiter you use, ie. Onscreen Orbiter, Weborbiter, Windows Orbiter?

* Do you mean going into Option / Search when you say you search for movies?

* What happens after the crash if you go into the same list again. Does the crash happen again?

* How do you have your movies sorted by, and how many movies do you have. There is a limit of 16384 entries for a datagrid.

[darkwizard864]

* Does it matter what type of Orbiter you use, ie. Onscreen Orbiter, Weborbiter, Windows Orbiter? all them

* Do you mean going into Option / Search when you say you search for movies? Option / Search

* What happens after the crash if you go into the same list again. Does the crash happen again? it crashes in option search type any key.

* How do you have your movies sorted by, and how many movies do you have. There is a limit of 16384 entries for a datagrid.. sort type title

when I do option / search and sort type is by title I have 8290 movies.

[Marie.O]

See if changing the sort by to something like genre will help.

[Marie.O]

Just a heads up: I am experiencing the same issue, and have way less media. Seems a recent update broke stuff.

[phenigma]

Fixed.  Should be in the next update, watch http://wiki.linuxmce.org/index.php/LinuxMCE-1204/1404_Updates#Upcoming_fixes...

[Marie.O]

1404 update available - 1204 in the making

[Marie.O]

and 1204 is done as well.