931
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
Sent from my SGH-I927 using Tapatalk 4
Rule #1 - Be Patient - Rule #2 - Don't ask when, if you don't contribute - Rule #3 - You have coding skills - LinuxMCE's small brother is available: http://www.agocontrol.com
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.
*********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!
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;
"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 '';"
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)