Show Posts

This section allows you to view all posts made by this member. Note that you can only see posts made in areas you currently have access to.

Messages - phenigma

Pages: 1 ... 58 59 [60] 61 62 ... 114
Users / Re:
« on: September 27, 2013, 09:38:51 pm »
I just checked a default database... the template 2159 does not have any ruby codes associated with it... I added the codes for my HR20 to control channel changes and power.    I also thought I had submitted the template thru sqlCVS.  I can repost them for you to experiment with!

If you can do an sqlcvs update and then a new diff and submit it then we can get the ruby code into the DT.


Users / Re: Huge query in pluto_media : taking my disk down to crawling
« on: September 27, 2013, 01:10:56 am »
Here's a version that I'm testing now.  It fixes the CurrentDbAttrCount and HasAttributes values that were not reporting correctly in jamo's post.  I am no one as far as mysql goes but I've been bashing on this for a couple hours.  

The missing index was not implemented on my db.

Thanks jamo, buckle, bulek, tschak, and others for working on this query!  This has been a great collaboration!

Code: [Select]
  File.AttrDate AS OldDbAttrDate,
  File.AttrCount AS OldDbAttrCount,    
  File.ModificationDate AS OldFileDate,

      (IF(Bookmark.psc_mod IS NULL, CAST('0000-00-00 00:00:00' AS DATE),Bookmark.psc_mod)),
      (IF(Attribute.psc_mod IS NULL,CAST('0000-00-00 00:00:00' AS DATE), Attribute.psc_mod)),
      (IF(LongAttribute.psc_mod IS NULL,CAST('0000-00-00 00:00:00' AS DATE), LongAttribute.psc_mod)),
      (IF(Picture_File.psc_mod IS NULL,CAST('0000-00-00 00:00:00' AS DATE), Picture_File.psc_mod)) ) As CurrentDbAttrDate,
    (select count(*) from Bookmark where FK_File=PK_File) as BOOKMARKCOUNT,
    (select count(*) from File_Attribute where FK_File=PK_File) as ACOUNT,    
    (select count(*) from LongAttribute where FK_File=PK_File) as LONGATTRCOUNT,
    (select count(*) from Picture_File where FK_File=PK_File) as IMGCOUNT,
    ((1000000 * (select BOOKMARKCOUNT)) +
      (10000 * (select ACOUNT)) +    
      (100 * (select LONGATTRCOUNT)) +
      (select IMGCOUNT)) as CurrentDbAttrCount,
    ((select ACOUNT) + (select LONGATTRCOUNT)) as HasAttributes

  FROM File
    LEFT JOIN Bookmark ON Bookmark.FK_File = PK_File
    LEFT JOIN File_Attribute ON File_Attribute.FK_File = PK_File
    LEFT JOIN Attribute ON File_Attribute.FK_Attribute = PK_Attribute
    LEFT JOIN LongAttribute ON LongAttribute.FK_File = PK_File
    LEFT JOIN Picture_File ON Picture_File.FK_File = PK_File

  WHERE 1 = 1
    AND ( Path LIKE '/home/public/data%' OR (Path ='/home/public' AND Filename = 'data' )  
      OR Path LIKE '/home/user_1/data%' OR (Path = '/home/user_1' AND Filename = 'data' )  
      OR Path LIKE '/home/user_2/data%' OR (Path = '/home/user_2' AND Filename = 'data' )  
      OR Path LIKE '/home/user_3/data%' OR (Path = '/home/user_3' AND Filename = 'data' )  
      OR Path LIKE '/home/user_4/data%' OR (Path = '/home/user_4' AND Filename = 'data' )
      OR Path LIKE '/home/user_5/data%' OR (Path = '/home/user_5' AND Filename = 'data' )  
      OR Path LIKE '/home/user_6/data%' OR (Path = '/home/user_6' AND Filename = 'data' )  
      OR Path LIKE '/home/user_7/data%' OR (Path = '/home/user_7' AND Filename = 'data' )  
      OR Path LIKE '/home/user_8/data%' OR (Path = '/home/user_8' AND Filename = 'data' ) )  
    AND Missing = 0

    GROUP BY PK_File
) s

INNER JOIN File ON s.PK_File=File.PK_File;


Developers / Re: Re: Transmission torrent on LinuxMCE
« on: September 26, 2013, 01:34:40 am »
The pre depends should be there.  I'll double check the package definition.

Sent from my SGH-I927 using Tapatalk 2

Developers / Re: Transmission torrent on LinuxMCE
« on: September 25, 2013, 11:07:30 pm »
"Can't find any matching row in the user table" sounds like a MySQL error, but the first user based MySQL query in the post install script Jason has posted is on line 45, not line 1?!
Code: [Select]
mysql -e "GRANT SELECT, INSERT, UPDATE, DELETE ON transmission_links.* TO 'transmission'@'localhost' IDENTIFIED BY '';"

I'll check these lines for proper syntax.  As I've indicated, I haven't done an install test on the package yet.


Developers / Re: Transmission torrent on LinuxMCE
« on: September 25, 2013, 11:03:56 pm »
Install fails on 1204.

Setting up lmce-transmission-client ( ...
ERROR 1133 (42000) at line 1: Can't find any matching row in the user table
dpkg: error processing lmce-transmission-client (--configure):
 subprocess installed post-installation script returned error exit status 1
Errors were encountered while processing:
E: Sub-process /usr/bin/dpkg returned an error code (1)

Okay, I'll look into this.  I apologize that I hadn't done any install testing yet.


Developers / Re: Transmission torrent on LinuxMCE
« on: September 25, 2013, 11:03:07 pm »
Sounds like you've done the work to include the transmission pages into the LinuxMCE, if only my "Add Software" section worked, I could add the "official" version in!!  (my "Add Software" is completely empty, so haven't been able to add anything from there since I built the damn thing!!)

I still need to test installing, but the initial commits are made.  Thank you so much for doing the initial leg work!


Users / Re: Need some dedicated testers.
« on: September 16, 2013, 12:32:59 am »
So you're using the existing datagrid fetches?  That would explain lots to me.


Users / Re: Need some dedicated testers.
« on: September 15, 2013, 06:33:10 am »
Here is a question for everyone
*The datagrid can get everything, or certain chunks at a time
*When it gets everything (its current setting) you have to wait for everything to load before you can get to the bottom.
*If I enable the paging mechanism (its already there and active) it splits things up and you can jump around by page or letter immediately.
*Some people like one free flowing grid
*Some people like expeditions navigation

Both.  The entire list should be able to load (titles) quickly and easily?  Then as I scroll around, or select letters to jump around, it should load the images for the most immediate items.  Essentially, don't load things unless they are with 1 or 2  scrollable screens of the currently displayed items.  Dynamic, little waiting, less transfer required as you only grab what the user is close to.  Perhaps more difficult to implement.  Am I making any sense here?   :P   It's past my bedtime.


Users / Re: HD PVR 1212 id 4093
« on: September 15, 2013, 01:07:49 am »
There is an error with the sQL information or script on line 1.

Do you have a fix for this?  Regardless can you create a ticket for this so devs are aware?  Thanks!


Users / Re: Need some dedicated testers.
« on: September 14, 2013, 11:33:54 pm »
So far so good on my phone (SGH-i927).  It's showing me that my wife is watching 'PS3' right now.  When I go to the Audio datagrid it crashes before showing the list.  Video list worked, but dropped to the main menu a couple of times during scrolling.  I have > 1400 video files and even with sorting by attribute the lists can be _extremely_ long to navigate, any way to incorporate quick selects for the alphabet (A,B,etc) to jump to the first title in the list with that starting char, or am I just missing that somewhere?  My artists list for audio is >1400 too.  :)

Love the look of the video datagrid with the images in the background of the titles.  Very slick.

Hmm, trying to access audio datagrid caused a router reload that time. 
* phenigma didn't update qml, was I supposed to?


Users / Re: HD PVR 1212 id 4093
« on: September 14, 2013, 02:08:49 am »
Hmm, I've not used one before so I don't know what the expected behaviour is.  My first question is: Is it assigned to a room? 


Users / Re: HD PVR 1212 id 4093
« on: September 14, 2013, 12:15:16 am »
After the kernel upgrade to linux-image-generic-lts-backport-natty I would generally follow instructions at regarding audio.  Then it's a matter of running avwiz to build the sound config files again, or set it manually.


Users / Re: HD PVR 1212 id 4093
« on: September 13, 2013, 08:15:12 pm »
1004?  Core/MD?  What kernel are you currently running?  What kernel version do you need to update to?  Sound can usually be fixed after a kernel upgrade. 


Users / Re: Need some dedicated testers.
« on: September 13, 2013, 08:12:13 pm »
What do you need to connect to exactly?  I'm sure we can arrange this.  :)


Users / Re: MAME problem
« on: September 11, 2013, 04:31:43 pm »
Code: [Select]
Unknown PCM plughw:1,

This looks like an issue to me, and would probably prevent MAME from launching, hench the errors that show in the log saying no window id to grab.

Do you have audio when playing music/movies?

I'm not sure where MAME gets it's audio output device from, or if it is using default.  tschak would know.

At first I would pastebin your /etc/asound.conf and pastebin the output of aplay -L to determine your current sound config.

tschak, feel free to thwack me if you think it's something else... ;)


Pages: 1 ... 58 59 [60] 61 62 ... 114