Author Topic: Idea: Photo management  (Read 3616 times)

chriss

  • Veteran
  • ***
  • Posts: 140
    • View Profile
Re: Idea: Photo management
« Reply #15 on: July 14, 2009, 07:03:50 am »
Thom, thanks for the hint, but it doesn't work:

Code: [Select]
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

tschak909

  • LinuxMCE God
  • ****
  • Posts: 5495
  • DOES work for LinuxMCE.
    • View Profile
Re: Idea: Photo management
« Reply #16 on: July 14, 2009, 08:42:26 am »
hmmm, anyone wanna get chriss some creds so he can edit the db on schema directly?

-Thom

chriss

  • Veteran
  • ***
  • Posts: 140
    • View Profile
Re: Idea: Photo management
« Reply #17 on: July 14, 2009, 09:11:55 am »
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

posde

  • Administrator
  • LinuxMCE God
  • *****
  • Posts: 2935
  • Wastes Life On LinuxMCE Since 2007
    • View Profile
    • My Home
Re: Idea: Photo management
« Reply #18 on: September 16, 2009, 09:42:17 am »
chriss,

would you mind updating the status of http://svn.linuxmce.org/trac.cgi/ticket/217

thx

chriss

  • Veteran
  • ***
  • Posts: 140
    • View Profile
Re: Idea: Photo management
« Reply #19 on: September 16, 2009, 10:55:06 am »
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

colinjones

  • Alumni
  • LinuxMCE God
  • *
  • Posts: 3003
    • View Profile
Re: Idea: Photo management
« Reply #20 on: September 16, 2009, 10:44:00 pm »
chriss - are you intending also to make some changes to the UI so that these new tags can be used? Sorting or filtering?

posde

  • Administrator
  • LinuxMCE God
  • *****
  • Posts: 2935
  • Wastes Life On LinuxMCE Since 2007
    • View Profile
    • My Home
Re: Idea: Photo management
« Reply #21 on: September 16, 2009, 10:59:26 pm »
Will add a note to the ticket, too. Any deadlines to catch?

Thanks for adding notes to the ticket. As the stuff is already in svn there are no deadlines to catch. Just move your stuff over into the branches part instead of your personal area.