Hi Viking,

just did find time to find the query for my system and it puzzels me that every dvd/recording shows up not only once, but several times !? :

there is a command to prevent duplicate lines in result sets from mysql. Just try to do a "SELECT DISTINCT ..." instead of "SELECT ...". Reducing the result set of a query does also reduce resource usage, especially if the results are used to start another query.

What strikes me. Why is it doing this :
"AND PK_File in (37968,37996,38006, ....."

It looks like there is an query before that which sorts out the files to look at. The question is then if it makes sence to split that up in two. But maybe we should just try and optimize the query first.

Using nested queries should even speed up the process because the results do not have to be tranferred back and forth, i.e. try something like "SELECT ... FROM ... WHERE ... AND PK_File in (SELECT DISTINCT FK_File FROM ....)".

br,
/chriss

Hi Pos,

here's some status feedback: I currently have some problems with my dev environment; some days ago UpdateMedia started producing segfaults somewhere in libc. It seems it has nothing to do with my modifications since it also happens with the current lmce-0810 branch version. Still trying to locate the problem and just set up a new dev environment as per wiki instructions. Some parts still fail to build, e.g., Orbiter, but I can continue work on UpdateMedia.
Will add a note to the ticket, too. Any deadlines to catch?

cheers,
/chriss

I'm currently also putting some KNX parts together and would like to integrate them with LinuxMCE soon. Planning to have my new house completely on KNX...

br,
/chriss

Murcel,
great work, i really like the new site. One minor thing I'm missing in a prominent place on the front page is at least a short teaser for the news sections.

br,
/chriss

I'm not sure but if I remember correctly I saw Thom using some VNC stuff on UI2 in one of his videos.

Have you tried to spot the part of the system that is actually overwriting the file? Once you have the component you can correct the behavior to produce valid files and you can also enhance the system to allow for custom configuration via device templates (if this isn't implemented yet).

just my 2 c
/chriss

editing db schema directly sounds dangerous 

I'll try to get into the chat tonight. Maybe pos or hari are around and can assist me.

br,
/chriss

Thom, thanks for the hint, but it doesn't work:

Code:

dcerouter_113338:/home/chris# /usr/pluto/bin/sqlCVS -H schema.linuxmce.org -R 3999 -h localhost -a -D pluto_media -r media -t MediaType_AttributeType -d "root" -U "anonymous~nopass" -A -e diff
 Copyright (C) 2004 Pluto, Inc., a Florida Corporation
 www.plutohome.com
 Phone: +1 (877) 758-8648
This program is distributed according to the terms
of the Pluto Public License, available at:
 http://plutohome.com/index.php?section=public_license
This program is distributed in the hope that it will be useful,
but WITHOUT ANY WARRANTY; without even the implied warranty of MERCHANTABILITY
or FITNESS FOR A PARTICULAR PURPOSE. See the Pluto Public License for more details.

-------

Database host:localhost user:root pass: name:pluto_media port:3306
Users:anonymous~nopass
Updating repository 'media' schema version from: 43
pk: 0 7pk: 1 16 psc_id: 0
changed row  psc_id: 0 has keys:2 7,  16,
pk: 0 7pk: 1 29 psc_id: 0
changed row  psc_id: 0 has keys:2 7,  29,
pk: 0 7pk: 1 37 psc_id: 0
changed row  psc_id: 0 has keys:2 7,  37,
pk: 0 7pk: 1 47 psc_id: 0
changed row  psc_id: 0 has keys:2 7,  47,
pk: 0 7pk: 1 48 psc_id: 0
changed row  psc_id: 0 has keys:2 7,  48,
DetermineDeletions for table: MediaType_AttributeType from psc_id: 57 batch: 0
Scanning range of psc_id: [0, 99999999] with interval_length=10000000
Cannot get table stats from server:-3
Caught exception: Communication error
dcerouter_113338:/home/chris#

I have no idea what's the actual problem. The syntax is correct since it works well with e.g. pluto_main/dce. I suspect that the tables are not hosted on the sever as said above (there are no tables listed for media in the sqlCVS web management gui).

Any hints from the sqlCVS gurus?

cheers,
/chriss

Hi guys,

sorry for being quite for some time but unfortunately I can't spend as much time as intended...

I just wanted to make some changes to web admin to allow for modifying more than just the title attribute and discovered that there is a special table pluto_media.MediaType_AttributeType that controls which attributes can be added to a file. After making the changes I wanted to do a sqlCVS checkin, but... there is no pluto_media category in web admin and the web gui of schema.linuxmce.org does not contain any tables in the category media nor was I able to find the table in any of the other categories.

How can I get these changes into the build system? Maybe we have another mechanism to get these tables populated during install? Any hints?

thanks,
/chriss

Hi *,

since I've already seen a lot of attempts to translate the GUI elements which never really made it into the repositories I decided to put setup a step-by-step howto in the wiki. So please, if you already did a (partial) translation into a new language check if it complies to the howto and make it a feature for everyone by checking in to the repositories. Or make it compatibel and check it in 

Everybody, this is a good chance to help without being a coder! I've read at least of Italian, Russian and Dutch translations so I expect to see them on sqlCVS soon 

The howto can be found at http://wiki.linuxmce.org/index.php/Translate_the_GUI_into_another_language

You are welcome to extend the wiki page with further details or make suggestions here.

br,
/chriss

Wow, great work and impressive results!

Hi Martino

Obviously i did'nt make a DB Backup, am i screwed??

you could try to make an sqlCVS update and see if the correct table contents are pulled from the server.

My fresh install contained both mentioned tables Text_LS and Text_LS_AltVersions, however I don't know the purpose of the second one. Anyway, don't mess with tables by simply renaming/deleting them or the contents.

To insert a new translation you have to do the following two steps
1) add a new row with a new language to pluto_main.Language and remember the id (PK_Language) of the language. DO NOT OVERWRITE ANY EXISTING ROWS!
2) To translate the UI you have to add a new row to pluto_main.Text_LS for every row you would like to translate from pluto_main.Text, i.e., pick a row, translate it to italian and write your translation to the field Description in Text_LS. FK_Text has to be the same value as Text.PK_Text of the translated item and Text_LS.FK_Language has to be the same as Language.PK_Language. Note that you don't have to translate every field - if there is no match in Text_LS the UI falls back to the english text (fine for on-screen keyboard and stuff)

You need to understand what's happening here. We have a table the defines all available languages (pluto_main.Language). We also have a table with several texts for the UI (pluto_main.Text). Finally there is a table defining language specific texts/translation (pluto_main.Text_LS) in an overlay form. This last table is connected via foreign keys to pluto_main.Text (pluto_main.Text_LS.FK_Text -> pluto_main.Text.PK_Text) and pluto_main.Language (pluto_main.Text_LS.FK_Language -> pluto_main.Language.PK_Language). If you do not have these connections it won't work.

br,
/chriss

However I don't have much experience with this kind of software.
What kinda stuff would be usefull? Project/product names or just a general description of what it needs to do would be helpfull.

This basically needs a webserver to deliver the content to the clients. You can use Apache, it's already there for delivering the admin site. Create a new site within apache and you're done with that part. There's a lot of tutorials out there.

Secondly there has to be a (smart) way to get content into the site. Maybe some standard stuff delivered by the system, maybe by enabling the users to modify the content...

Guys, why not just use the existing SVN?

because we currently do not have the graphics in svn

ok, my fault...

Guys, why not just use the existing SVN?