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 ... 55 56 [57] 58 59 ... 111
841
Developers / Re: New Radio Thermostat CT-80/CT-30 template uploaded
« on: October 07, 2013, 05:19:44 am »
Approved.  Please do an sqlCVS update of your 'ir' and 'dce' tables.  Check that the template is intact and complete.  If there are any problems, please let me know so I can fix them at this end.

J.

842
Developers / Re: Transmission torrent on LinuxMCE
« on: October 05, 2013, 08:39:21 pm »
So I've fixed a bunch of errors in the postinst script and fixed the predepends (transmission-daemon instead of transmission, my bad).  Things will likely work after the repo is updated.  The proper installation method is to choose Core from the Wizard in webadmin, select transmission and press Save.  This will ensure the appropriate webadmin pages are activated along with the package installation.

J.

843
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

844
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

845
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

846
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

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

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

849
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

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

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

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

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

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

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

Pages: 1 ... 55 56 [57] 58 59 ... 111