Author Topic: media search error  (Read 1003 times)

darkwizard864

  • Veteran
  • ***
  • Posts: 101
    • View Profile
media search error
« on: September 09, 2016, 05:04:50 am »
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?

posde

  • Administrator
  • LinuxMCE God
  • *****
  • Posts: 3618
  • Wastes Life On LinuxMCE Since 2007
    • View Profile
    • My Home
Re: media search error
« Reply #1 on: September 09, 2016, 06:43:16 am »
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

  • Veteran
  • ***
  • Posts: 101
    • View Profile
Re: media search error
« Reply #2 on: September 09, 2016, 04:25:33 pm »
posde I would agree with you. but it a ssd and never had a problem before until all updates to updatemedia...

posde

  • Administrator
  • LinuxMCE God
  • *****
  • Posts: 3618
  • Wastes Life On LinuxMCE Since 2007
    • View Profile
    • My Home
Re: media search error
« Reply #3 on: September 10, 2016, 11:02:18 am »
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

  • Veteran
  • ***
  • Posts: 101
    • View Profile
Re: media search error
« Reply #4 on: September 10, 2016, 04:04:33 pm »
* 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.

posde

  • Administrator
  • LinuxMCE God
  • *****
  • Posts: 3618
  • Wastes Life On LinuxMCE Since 2007
    • View Profile
    • My Home
Re: media search error
« Reply #5 on: September 10, 2016, 06:17:59 pm »
See if changing the sort by to something like genre will help.

posde

  • Administrator
  • LinuxMCE God
  • *****
  • Posts: 3618
  • Wastes Life On LinuxMCE Since 2007
    • View Profile
    • My Home
Re: media search error
« Reply #6 on: September 10, 2016, 08:20:54 pm »
Just a heads up: I am experiencing the same issue, and have way less media. Seems a recent update broke stuff.

phenigma

  • LinuxMCE God
  • ****
  • Posts: 1722
    • View Profile
Re: media search error
« Reply #7 on: September 10, 2016, 10:15:09 pm »

posde

  • Administrator
  • LinuxMCE God
  • *****
  • Posts: 3618
  • Wastes Life On LinuxMCE Since 2007
    • View Profile
    • My Home
Re: media search error
« Reply #8 on: September 11, 2016, 06:23:24 am »
1404 update available - 1204 in the making

posde

  • Administrator
  • LinuxMCE God
  • *****
  • Posts: 3618
  • Wastes Life On LinuxMCE Since 2007
    • View Profile
    • My Home
Re: media search error
« Reply #9 on: September 11, 2016, 10:08:51 am »
and 1204 is done as well.