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.
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!
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
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
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 (126.96.36.199.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:
E: Sub-process /usr/bin/dpkg returned an error code (1)
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!!)
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
There is an error with the sQL information or script on line 1.