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 ... 61 62 [63] 64 65 ... 118
931
Users / Re:
« on: October 15, 2013, 02:56:28 pm »
Testing MD setups on a 1204 core now.  Working (slowly) on media playback.  It functions but with some issues.  Not production ready atm.  J.

Sent from my SGH-I927 using Tapatalk 4

932
Users / Re:
« on: October 15, 2013, 02:50:29 pm »
Govo HADesigner should be available.  We'll have to update the links if they do not currently work.  J.

Sent from my SGH-I927 using Tapatalk 4

933
Users / Re:
« on: October 15, 2013, 02:48:26 pm »
Looks like the medibuntu repo was offline our in maintenance when you did the update.  Try again and let me know if you're still having issues.  J.

Sent from my SGH-I927 using Tapatalk 4

934
Developers / Re:
« on: October 07, 2013, 10:27:51 pm »
Excellent!  You are very welcome!  Let me know if you need any others checked in.  J.

Sent from my SGH-I927 using Tapatalk 4

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

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

937
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

938
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

939
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

940
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

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

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

943
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

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

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

Pages: 1 ... 61 62 [63] 64 65 ... 118