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 ... 56 57 [58] 59 60 ... 112
856
Users / Re:
« on: October 02, 2013, 09:40:06 pm »
The Linux desktop qorbiter segfaults on exit, related?

Sent from my SGH-I927 using Tapatalk 4

857
Users / Re:
« on: September 30, 2013, 02:14:37 pm »
Likely a copy paste issue.  Edit:  Hmm, getting used to this Tapatalk app, and missing some posts apparently.  Ho hum.  Never mind me.

Sent from my SGH-I927 using Tapatalk 4

858
Users / Re:
« on: September 30, 2013, 05:38:41 am »
I'm hoping we can get some more people to test the various versions and report back about the timings.

Sent from my SGH-I927 using Tapatalk 4

859
Users / Re:
« on: September 28, 2013, 02:09:56 pm »
Well...  As we found last night.  Buckle's query takes over 20 minutes to run on my 1004.  Jamo's with the additional corrections I made last night runs in 6 seconds.  The original takes over 25 seconds.  

http://pastebin.com/9XxjscCf <- jamo's with corrections

Sent from my SGH-I927 using Tapatalk 4

860
Users / Re:
« on: September 27, 2013, 09:38:51 pm »
*********UPDATE**********
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.

J.

861
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]
SELECT
  File.PK_File,
  File.Path,
  File.Filename,
  File.Inode,  
  s.CurrentDbAttrDate,
  s.CurrentDbAttrCount,
  s.HasAttributes,  
  File.AttrDate AS OldDbAttrDate,
  File.AttrCount AS OldDbAttrCount,    
  File.ModificationDate AS OldFileDate,
  File.Source

FROM
(
  SELECT
    PK_File,
    greatest(
      (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;

J.

862
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

863
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.

J.

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

Setting up lmce-transmission-client (2.0.0.46.13091728061) ...
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:
 lmce-transmission-client
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.

J.

865
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!

J.

866
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.

J.

867
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
Thoughts?

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.

J.

868
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!

J.

869
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?

J.

870
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? 

J.

Pages: 1 ... 56 57 [58] 59 60 ... 112