| --- | Log | opened Mon Feb 26 00:00:59 2007 |
| 00:02 | |-| | Cardoe [n=Cardoe@gentoo/developer/Cardoe] has quit ["Leaving"] |
| 00:18 | |-| | CDev_ [n=CDev@c-71-233-206-26.hsd1.ma.comcast.net] has joined #mythtv |
| 00:35 | |-| | CDev [n=CDev@c-71-233-206-26.hsd1.ma.comcast.net] has quit [Read error: 110 (Connection timed out)] |
| 00:52 | |-| | okolsi [n=okolsi@kosh.hut.fi] has joined #mythtv |
| 00:53 | |-| | cattelan [n=cattelan@c-24-118-241-119.hsd1.mn.comcast.net] has quit ["This computer has gone to sleep"] |
| 00:59 | |-| | crazyldor [n=crazyldo@c-71-206-21-174.hsd1.md.comcast.net] has quit [Read error: 60 (Operation timed out)] |
| 01:00 | |-| | kormoc [n=kormoc@pool-71-164-10-252.sttlwa.fios.verizon.net] has quit [] |
| 01:08 | |-| | eskil [n=eskil@natint3.juniper.net] has quit [Read error: 110 (Connection timed out)] |
| 01:08 | |-| | eskil [n=eskil@adsl-66-120-85-205.dsl.snfc21.pacbell.net] has joined #mythtv |
| 01:57 | |-| | kormoc [n=kormoc@pool-71-164-10-252.sttlwa.fios.verizon.net] has joined #mythtv |
| 01:57 | |-| | kormoc [n=kormoc@pool-71-164-10-252.sttlwa.fios.verizon.net] has quit [Read error: 104 (Connection reset by peer)] |
| 02:25 | |-| | robthebob [n=rn114@82-46-18-118.cable.ubr02.bath.blueyonder.co.uk] has quit [Read error: 113 (No route to host)] |
| 02:27 | <okolsi> | xris: noticed that MythWeb music search is somewhat broken for me. I think it might be because of various patches I've prepared lately. I could try to find out the cause before you commit those pending patches.. |
| 02:27 | <xris> | okolsi: are you otto? |
| 02:27 | <okolsi> | xris: yes |
| 02:27 | <xris> | any chance you could not use tab chars in your patches? |
| 02:28 | <okolsi> | xris: sorry!! I'll fix that of cource.. I think my emacs configs has gone bad because I installed XEmacs |
| 02:29 | <xris> | well, the music/mp3act files are especially problematic. I think most of the mythweb files authored by me have vi commands in them somewhere (but I'm probably wrong) |
| 02:29 | <xris> | nope, they don't, either. |
| 02:29 | <xris> | anyway, 4 spaces is preferred. |
| 02:29 | <xris> | search seems to work for me. |
| 02:29 | <okolsi> | for me it fails when there are results |
| 02:30 | <okolsi> | if there aren't any.. it shows correctly that.. but it used to work for me also.. so it must be one of my changes |
| 02:30 | <okolsi> | I'll try to figure that out |
| 02:30 | <xris> | just tested again. works fine for me. |
| 02:30 | <xris> | (although I can't figure out how to test your album art patch -- no idea how to display the art) |
| 02:31 | <okolsi> | when you browse for artists.. then in the bottom it lists albums for that artist.. click one of those |
| 02:32 | <okolsi> | then it'll display info for exactly that album.. and in the top there should be a image |
| 02:32 | <xris> | ah, cool |
| 02:32 | <okolsi> | of cource, only if in the directory that holds that album, there is a jpg |
| 02:32 | <xris> | I never scrolled down far enough |
| 02:32 | <okolsi> | :) |
| 02:32 | <xris> | yeah, it works, though. |
| 02:33 | <okolsi> | I think it sucks that there are first the songs and album is at the bottom |
| 02:33 | <okolsi> | IMHO that should be changed |
| 02:33 | <xris> | yeah, it's odd |
| 02:34 | <xris> | I don't actually like mp3act all that much. |
| 02:34 | <xris> | always felt a little klunky |
| 02:34 | <okolsi> | hmm.. but we NEED music stuff in Mythweb :) |
| 02:34 | <xris> | y |
| 02:34 | <xris> | so they tell me. :) |
| 02:35 | <xris> | I'd like to see a flash/swf audio player.. easier than streaming |
| 02:35 | <okolsi> | I made couple of additional hacks on the weekend and now I have my entire collection steramable from the work.. everything else is HTTPS but music streaming is HTTP |
| 02:35 | <okolsi> | yes.. thats true |
| 02:35 | <okolsi> | none of the players seem to support HTTPS streaming :( |
| 02:35 | <xris> | you *did* notice the "stream via http" setting, right? |
| 02:36 | <okolsi> | yes.. but it seems to enable too much stuff as HTTP.. I don't remember exactly |
| 02:36 | <xris> | just audio and video |
| 02:36 | <okolsi> | and.. I run both HTTPS and HTTP through non-standard ports.. |
| 02:36 | <xris> | ah, that might be a concern |
| 02:37 | <okolsi> | yep.. I thought that the port might be usefull as a configuration parameter.. |
| 02:37 | <xris> | probably would. would need a way to extract it via perl, though, at least until the streaming handler is ported to php. |
| 02:38 | |-| | gnome42 [n=obi@dsl-149-50.aei.ca] has quit ["Leaving"] |
| 02:38 | <okolsi> | okay.. haven't looked it yet.. but.. the flash/swf player would solve much of these problems.. :) |
| 02:40 | <xris> | yeah. |
| 02:40 | <xris> | would still be nice to support m3u stuff, but a flash player would be very convenient. |
| 02:40 | <xris> | assuming one can be made to do ogg. |
| 02:40 | <okolsi> | if I remember correctly.. the force HTTP streaming loads the playlist also through HTTP (which is logical).. at least for WinAmp you can load the list still through HTTPS but the actual streaming URLs must be HTTP.. |
| 02:41 | <okolsi> | something like that.. |
| 02:41 | <xris> | well, xmms can't do either |
| 02:41 | <xris> | and I don't think amarok can, either. |
| 02:42 | <xris> | which keeps most linux users out of the picture. |
| 02:42 | <okolsi> | can't do what? the HTTPS? |
| 02:43 | <xris> | yeah |
| 02:43 | <xris> | someone submitted a patch in like 2004 but it hasn't been accepted |
| 02:43 | <okolsi> | okay.. good to know. I've played with streaming only in WinAmp environment.. have to try with Linux stuff also |
| 02:44 | <xris> | I don't touch windows unless I have to. heh. |
| 02:44 | <okolsi> | understandable :) |
| 02:45 | <xris> | anyway, there's the slimserver app, and I remember some other mp3 backend that someone tried to get mythweb hooked up with. It actually had a nice flash player built in, but I can't remember the name |
| 02:45 | <xris> | devs were really flaky |
| 02:47 | <okolsi> | hmm.. unfortunately I don't know slimserver or other such systems.. should investigate |
| 02:47 | <xris> | slimserver is perl, and open source. integrates with their hardware player, and itunes. |
| 02:48 | <xris> | pretty slick, actually.. handles transcoding, etc. |
| 02:48 | <okolsi> | many good words there.. |
| 02:48 | <xris> | http://www.slimdevices.com/su_downloads.html |
| 02:49 | <okolsi> | lunch time.. |
| 02:49 | <xris> | bed time. :) (or well past it). |
| 02:50 | <xris> | I'll let you know if I figure out the name of that other app. |
| 02:51 | |-| | LLyric [n=simon@d58-105-58-71.dsl.vic.optusnet.com.au] has joined #mythtv |
| 02:52 | |-| | xris [n=xris@xris.forevermore.net] has quit ["Leaving."] |
| 02:55 | |-| | xris [n=xris@xris.forevermore.net] has joined #mythtv |
| 02:56 | <xris> | okolsi: http://www.jinzora.org/ |
| 02:58 | |-| | xris [n=xris@xris.forevermore.net] has quit [Client Quit] |
| 03:01 | |-| | eskil [n=eskil@adsl-66-120-85-205.dsl.snfc21.pacbell.net] has quit ["Leaving"] |
| 03:08 | |-| | stuarta [n=stuart@unaffiliated/stuarta] has joined #mythtv |
| 03:29 | <okolsi> | xris: both slimserver and jinzora seem very interesting.. |
| 04:27 | |-| | cliche [n=t@newlay.plus.com] has joined #mythtv |
| 05:05 | |-| | daMaestro [n=jon@fedora/damaestro] has quit ["Leaving"] |
| 05:12 | |-| | crazyldor [n=crazyldo@c-71-206-21-174.hsd1.md.comcast.net] has joined #mythtv |
| 05:47 | |-| | MrGandalf [n=buechlmr@cpe-72-225-32-214.rochester.res.rr.com] has quit ["Leaving"] |
| 06:03 | |-| | CDev_ [n=CDev@c-71-233-206-26.hsd1.ma.comcast.net] has quit [Read error: 104 (Connection reset by peer)] |
| 06:03 | |-| | CDev [n=CDev@c-71-233-206-26.hsd1.ma.comcast.net] has joined #mythtv |
| 06:05 | |-| | Netsplit brown.freenode.net <-> irc.freenode.net quits: LLyric |
| 06:05 | |-| | Netsplit brown.freenode.net <-> irc.freenode.net quits: kvandivo, offset, janneg, adante, lucas123, GreyFoxx, PacketScan, madfactor, cliche, gbee, (+27 more, use /NETSPLIT to show all of them) |
| 06:06 | |-| | Netsplit over, joins: LLyric, cliche, stuarta, okolsi, tanq, sphery, gbee, briand, flatronf701B, rtsai (+28 more) |
| 06:08 | |-| | visit0r [n=visit0r@movietron.net] has quit [Remote closed the connection] |
| 06:08 | |-| | visit0r [n=visit0r@movietron.net] has joined #mythtv |
| 06:08 | |-| | purserj [n=purserj@k-sit.com] has quit [Connection reset by peer] |
| 06:08 | |-| | purserj [n=purserj@k-sit.com] has joined #mythtv |
| 06:18 | |-| | Anduin [n=awithers@adsl-69-110-10-140.dsl.pltn13.pacbell.net] has quit [Connection timed out] |
| 06:40 | |-| | PointyPumper [i=Pintlezz@OL221-67.fibertel.com.ar] has quit [Read error: 104 (Connection reset by peer)] |
| 06:58 | |-| | LLyric [n=simon@d58-105-58-71.dsl.vic.optusnet.com.au] has quit ["Leaving"] |
| 06:59 | |-| | vaineh [n=evaing@82-71-116-46.dsl.in-addr.zen.co.uk] has joined #mythtv |
| 07:06 | |-| | MoRpHeUz [n=morphbr@200.184.118.132] has joined #mythtv |
| 07:24 | |-| | crazyldor [n=crazyldo@c-71-206-21-174.hsd1.md.comcast.net] has quit [Read error: 113 (No route to host)] |
| 07:50 | |-| | Netsplit brown.freenode.net <-> irc.freenode.net quits: olds, kvandivo, offset, janneg, adante, GreyFoxx, lucas123, PacketScan, cliche, madfactor, (+43 more, use /NETSPLIT to show all of them) |
| 07:51 | |-| | Netsplit over, joins: purserj, Captain_Murdoch, Agrajag-, Beirdo, sc00p, splat1, bagpuss_thecat |
| 07:52 | |-| | Netsplit over, joins: MoRpHeUz, vaineh, visit0r, Tuomaz_, fall0ut, kurre2, psyco-obiwan, cliche, stuarta, okolsi (+36 more) |
| 07:53 | |-| | lsobral [n=sobral@200.184.118.132] has joined #mythtv |
| 08:29 | |-| | PointyPumper [i=Pintlezz@OL221-67.fibertel.com.ar] has joined #mythtv |
| 08:33 | |-| | luna6 [n=luna6@ip68-14-110-43.no.no.cox.net] has joined #mythtv |
| 08:35 | |-| | Cardoe [n=cardoe@gentoo/developer/Cardoe] has joined #mythtv |
| 08:53 | |-| | okolsi [n=okolsi@kosh.hut.fi] has left #mythtv [] |
| 08:58 | |-| | cattelan [n=cattelan@c-24-118-241-119.hsd1.mn.comcast.net] has joined #mythtv |
| 09:19 | |-| | cattelan [n=cattelan@c-24-118-241-119.hsd1.mn.comcast.net] has quit ["This computer has gone to sleep"] |
| 09:19 | |-| | bdale [n=bdale@winfree.gag.com] has joined #mythtv |
| 09:29 | |-| | jmk [n=jmk@pat.foofus.net] has joined #mythtv |
| 09:31 | |-| | jgarvey [n=jgarvey@cpe-075-177-158-190.nc.res.rr.com] has joined #mythtv |
| 09:59 | |-| | crazyldor [n=crazyldo@c-71-206-21-174.hsd1.md.comcast.net] has joined #mythtv |
| 10:18 | |-| | aevil [n=aevil@i59F54549.versanet.de] has joined #mythtv |
| 10:20 | |-| | crazyldor [n=crazyldo@c-71-206-21-174.hsd1.md.comcast.net] has quit [Read error: 113 (No route to host)] |
| 10:23 | <gbee> | briand: I'd be suprised, that patch was well tested |
| 10:34 | <gbee> | the only way I can think that those files were removed is if the earlier music_directories update failed for some reason |
| 10:39 | <bdale> | the text of the menus for G.A.N.T. at head of release-20-fixes is failing to render after an update, though everything else seems to be worknig fine. can't find any reference to this being a known problem, -users didn't provide any useful clues. is it just me, or is this a known problem? |
| 10:56 | |-| | beavis [n=beavis@p54A7A5C0.dip0.t-ipconnect.de] has joined #mythtv |
| 11:00 | |-| | JoeyBorn [n=rootmeis@dsl017-022-247.chi1.dsl.speakeasy.net] has joined #mythtv |
| 11:02 | |-| | splat1 changed nick to splAt1 |
| 11:16 | |-| | gnome42 [n=obi@dsl-149-50.aei.ca] has joined #mythtv |
| 11:18 | |-| | JoeBorn [n=rootmeis@adsl-75-3-47-238.dsl.chcgil.sbcglobal.net] has quit [Read error: 110 (Connection timed out)] |
| 11:25 | |-| | kvandivo [n=kvandivo@ppp-70-225-171-229.dsl.chmpil.ameritech.net] has quit [Read error: 145 (Connection timed out)] |
| 11:28 | |-| | jk1joel [i=nobody@64.58.232.133] has joined #mythtv |
| 11:28 | |-| | stuarta [n=stuart@unaffiliated/stuarta] has quit ["zzz"] |
| 11:29 | |-| | splAt1 changed nick to splat1 |
| 11:31 | |-| | xris [n=xris@xris.forevermore.net] has joined #mythtv |
| 11:42 | |-| | robthebob [n=rn114@82-46-18-118.cable.ubr02.bath.blueyonder.co.uk] has joined #mythtv |
| 11:45 | |-| | S2 [n=s2@host214-118.pool80180.interbusiness.it] has joined #mythtv |
| 11:58 | |-| | aevil [n=aevil@i59F54549.versanet.de] has quit [Remote closed the connection] |
| 11:59 | |-| | xris [n=xris@xris.forevermore.net] has quit ["Leaving."] |
| 12:02 | |-| | cattelan [n=cattelan@68.178.56.100] has joined #mythtv |
| 12:11 | |-| | S2 [n=s2@host214-118.pool80180.interbusiness.it] has quit [Remote closed the connection] |
| 12:47 | |-| | kormoc [n=kormoc@pool-71-164-10-252.sttlwa.fios.verizon.net] has joined #mythtv |
| 12:48 | |-| | kormoc [n=kormoc@pool-71-164-10-252.sttlwa.fios.verizon.net] has quit [Client Quit] |
| 13:02 | |-| | LLyric [n=simon@d58-105-58-71.dsl.vic.optusnet.com.au] has joined #mythtv |
| 13:28 | |-| | nero [n=nero@unaffiliated/nero] has joined #mythtv |
| 13:35 | |-| | gnome42 [n=obi@dsl-149-50.aei.ca] has quit [Read error: 104 (Connection reset by peer)] |
| 13:42 | |-| | cattelan [n=cattelan@68.178.56.100] has quit ["This computer has gone to sleep"] |
| 13:51 | |-| | gnome42 [n=obi@dsl-152-216.aei.ca] has joined #mythtv |
| 13:54 | |-| | bekks [n=bekks@unaffiliated/bekks] has joined #mythtv |
| 13:54 | <bekks> | hi |
| 13:55 | |-| | bekks [n=bekks@unaffiliated/bekks] has left #mythtv ["Konversation terminated!"] |
| 13:56 | |-| | cattelan [n=cattelan@68.178.56.100] has joined #mythtv |
| 13:57 | |-| | o_cee [n=oscar@c83-249-228-253.bredband.comhem.se] has joined #mythtv |
| 14:04 | |-| | xris [n=xris@dsl081-161-160.sea1.dsl.speakeasy.net] has joined #mythtv |
| 14:17 | |-| | Wibble- [n=bob@ip-217.146.111.247.merula.net] has joined #mythtv |
| 14:19 | <Wibble-> | hey. I've just upgraded from 0.18 to 0.20 (by re-installing Ubuntu) and my video performance has plummeted. CPU usage of dvbstream & mplayer is ~50% but when mythbackend and mythfrontend do the live TV it is 100% and gets less than 1 frame per second displayed. Can anyone suggest why? Nova-T and graphics card TV out |
| 14:19 | <gardengnome> | try #mythtv-users |
| 14:19 | <Wibble-> | oopsie - would help if I read the title :/ sorry guys |
| 14:19 | <Wibble-> | and thanks :) |
| 14:23 | |-| | Anduin [n=awithers@adsl-69-110-10-140.dsl.pltn13.pacbell.net] has joined #mythtv |
| 14:25 | |-| | cliche [n=t@newlay.plus.com] has quit ["This computer has gone to sleep"] |
| 14:33 | <gbee> | knew a Wibble once, graphic designer named Rob from London |
| 14:43 | |-| | CDev [n=CDev@c-71-233-206-26.hsd1.ma.comcast.net] has quit [Read error: 104 (Connection reset by peer)] |
| 14:51 | |-| | LLyric [n=simon@d58-105-58-71.dsl.vic.optusnet.com.au] has quit ["Leaving"] |
| 14:51 | <Wibble-> | :P not me. I'm Rob from Cambridge. |
| 14:52 | <gbee> | :) |
| 14:52 | <xris> | Wibble-: you have to specify which one... |
| 14:55 | |-| | lsobral [n=sobral@200.184.118.132] has quit ["Leaving"] |
| 14:55 | <Wibble-> | xris: You mean graphics card? I've asked for help in mythtv-users now and they said the same (I told them too) its an geforce2mx and I was using the cvidix driver for mplayer and "vesa" for X |
| 15:20 | |-| | Honk [i=honk@forschungslabor.dyndns.org] has joined #mythtv |
| 15:21 | |-| | CDev [n=CDev@71.233.206.26] has joined #mythtv |
| 15:21 | <j-rod> | vesa driver. gack. |
| 15:25 | |-| | muh-die-kuh [n=hco@217.79.190.99] has joined #mythtv |
| 15:26 | |-| | tomimo [n=kurre@a80-186-77-174.elisa-laajakaista.fi] has quit [Read error: 104 (Connection reset by peer)] |
| 15:26 | |-| | crazyldor [n=crazyldo@71.206.21.174] has joined #mythtv |
| 15:45 | <xris> | Wibble-: no, I meant which Cambridge. There's one in the US and one in the UK. |
| 15:46 | <Wibble-> | Ah, yes, of course. I had forgotten there was a second Cambridge. I'm from the one near London ;) (UK) |
| 15:48 | |-| | Wibble- [n=bob@ip-217.146.111.247.merula.net] has quit ["Ex-Chat"] |
| 15:51 | <briand> | gbee: i dunno.. i didn't see anything right off the bat, looking at the patch, either. the files still exist (thankfully!), but only the new files appear in music_songs... i'll do some further testing, now that I'm at home and have access to everything |
| 15:52 | <gbee> | the older files aren't added if you re-run the scan? |
| 15:55 | <MoRpHeUz> | I'm not being able to attach a file to Trac...receiving: "Rejecting spam: LED" |
| 15:55 | <MoRpHeUz> | any ideas ? |
| 15:55 | <xris> | MoRpHeUz: ticket created ok? |
| 15:56 | <janneg> | compress the file |
| 15:56 | <xris> | ah |
| 15:56 | <MoRpHeUz> | =) thanks =) |
| 15:57 | <MoRpHeUz> | xris: http://cvs.mythtv.org/trac/ticket/3126 |
| 15:57 | <xris> | MoRpHeUz: setup for the conference going well? |
| 15:57 | <janneg> | does anyone know if the spam filter helps? |
| 15:57 | <MoRpHeUz> | xris: as we talked the other day.. |
| 15:57 | <briand> | gbee: that's yet to be determined. I didn't even realize they were "missing" until today, and I was at work, so I couldn't re-run the scan |
| 15:57 | <MoRpHeUz> | xris: yeah...It's another staff that is setting up the conference....just not sure that captain murdoch will be able to get his visa on time...=\ |
| 15:57 | <briand> | I -do- have a full db backup, so I can restore the whole table if I need to |
| 15:58 | <xris> | MoRpHeUz: yeah, that's definitely a concern. no one ever got back to me, so I'm just giving up hoping. maybe next year. |
| 15:58 | <MoRpHeUz> | xris: I hope so...(sometimes big companies are not organized =\ ) |
| 15:58 | <gbee> | I'm guessing the filename in the database didn't match the patch / file found in the scan, so they were removed from the database |
| 15:59 | <gbee> | well I'm not guessing, that's the only scenerio in which we remove records from the music_songs table |
| 16:00 | <briand> | that's the only 'delete from music_songs' that I saw in the source, as well |
| 16:00 | <briand> | so, I'd agree. |
| 16:01 | <gbee> | restoring the backup might help to debug the problem, but running the scan again should re-add the files (slowly) |
| 16:01 | <briand> | incidentally.. on the earlier bug I entered -- I think what caused the "save failure" was not the ' character in the song title, but the fact that it was also in the filename -- failed to write to the file, and failed to save to db. i'll do further research on that and update the ticket appropriately |
| 16:02 | <briand> | up to you... how would you like me to proceed? I've got a 1-hour program commercial flagging, but it should be done in a few minutes |
| 16:02 | <briand> | i can try whichever scenario you'd like. |
| 16:03 | <gbee> | how old is the backup? |
| 16:05 | <gbee> | if it's from before the music_directories table was added, it will be easier to re-run the scan, although you'll use the 'play count' and 'last played' info |
| 16:08 | <briand> | I do a daily backup, and rotate it every seven days |
| 16:08 | <briand> | when was music_directories added? |
| 16:09 | |-| | jk1joel [i=nobody@64.58.232.133] has quit [Remote closed the connection] |
| 16:11 | <gbee> | couple of weeks back |
| 16:11 | <gbee> | doesn't seem like it was that long ago, would have said less than a week if I hadn't checked |
| 16:12 | <briand> | well, sunday's backup was at 4:00am local time... so, about 10 hours before I updated, and probably 15 hours before the data was deleted... |
| 16:12 | <gbee> | that'll do :) |
| 16:13 | <briand> | i can never remember the dang syntax for 'yank', tho... |
| 16:13 | |-| | jk1joel [i=nobody@64.58.232.133] has joined #mythtv |
| 16:13 | <briand> | i should just memorize the vi manual. :) |
| 16:13 | <gbee> | after restoring it, but before running the scan you should probably check the content of the filename field in the database and the contents of the music_directories database |
| 16:15 | [~] | briand nods. |
| 16:16 | <briand> | i'm wondering, though, if we didn't have an incomplete list bounded by music_files.begin() and music_files.end() ... |
| 16:18 | |-| | LLyric [n=chatzill@d58-105-58-71.dsl.vic.optusnet.com.au] has joined #mythtv |
| 16:18 | <briand> | speaking in ui-mode, though.. we should probably warn the user that "x files were specified in the database, but do not exist and will be deleted. proceed? y/n" |
| 16:19 | <gbee> | that's one of the changes I plan to make before I close the scanning improvements ticket |
| 16:45 | |-| | jgarvey [n=jgarvey@cpe-075-177-158-190.nc.res.rr.com] has quit ["Leaving"] |
| 16:55 | <briand> | 628 lines of inserts... :) |
| 16:59 | <briand> | hmm. definitely a problem here... |
| 17:01 | |-| | crazyldor [n=crazyldo@71.206.21.174] has quit [Read error: 110 (Connection timed out)] |
| 17:01 | <briand> | I updated my music_songs table: |
| 17:01 | <briand> | mysql> select count(*) from music_songs; |
| 17:01 | <briand> | +----------+ |
| 17:01 | <briand> | | count(*) | |
| 17:01 | <briand> | +----------+ |
| 17:01 | <briand> | | 15239 | |
| 17:01 | <briand> | +----------+ |
| 17:01 | <briand> | 1 row in set (0.00 sec) |
| 17:01 | <briand> | ran "Scan for new music" (which should pick up the 109 new files) |
| 17:01 | <briand> | mysql> select count(*) from music_songs; |
| 17:01 | <briand> | +----------+ |
| 17:01 | <briand> | | count(*) | |
| 17:01 | <briand> | +----------+ |
| 17:01 | <briand> | | 28 | |
| 17:01 | <briand> | +----------+ |
| 17:02 | <briand> | 1 row in set (0.00 sec) |
| 17:03 | <briand> | and the files *do* exist: [root@myth ~]# ls /video/music | wc -l |
| 17:03 | <briand> | 15266 |
| 17:05 | |-| | cliche [n=t@newlay.plus.com] has joined #mythtv |
| 17:05 | <gbee> | what was in the filename column of music_songs before the scan? |
| 17:06 | <gbee> | the output of -v database might help |
| 17:07 | <briand> | the files are (currently) named like: "Artist Name - Song Title.mp3" |
| 17:07 | <gbee> | actually it won't, not a lot of useful output when it's deleting files |
| 17:07 | <briand> | i dunno... |
| 17:08 | |-| | MoRpHeUz [n=morphbr@200.184.118.132] has quit ["Leaving..."] |
| 17:08 | <briand> | after I restore the db, I can go into mythmusic and play any of the files... so they're definitely "there" and mythmusic is finding them alright... |
| 17:08 | <gbee> | hmm |
| 17:08 | <gbee> | ahh, bugger, think I know the issue |
| 17:09 | [~] | gbee goes to the code to check |
| 17:11 | <gbee> | hmm, no, didn't find what I was expecting |
| 17:11 | <gbee> | sorry I think you might need to do some more debugging |
| 17:12 | <briand> | no problem. it only takes a few seconds to feed the backup SQL back into mysql |
| 17:15 | |-| | beavis [n=beavis@p54A7A5C0.dip0.t-ipconnect.de] has quit ["Verlassend"] |
| 17:16 | <briand> | it was working properly on 2007-02-13 12:05:02, when I successfully imported 7 Gin Blossoms songs... |
| 17:20 | |-| | cliche [n=t@newlay.plus.com] has quit ["This computer has gone to sleep"] |
| 17:21 | <gbee> | think sticking a couple of VERBOSE in there is going to be the quickest way to establish the problem, but with the number of files in your collection that'll mean a *lot* of worthless info too |
| 17:22 | <briand> | i could trim the temporary sql down to a few hundred.. that'd speed it up 10-fold |
| 17:24 | <gbee> | first I'd check that we are actually finding the files on the drive by putting a verbose in BuildFileList, just before "music_files[filename] = kFileSystem;" |
| 17:24 | <gbee> | to output 'filename' |
| 17:25 | <briand> | if you want to patch up something for me to try, i'd be happy to plug it in... you're much more up-to-speed on the c++ (and object-oriented) programming, in general, than I am |
| 17:27 | <briand> | i've trimmed my test suite down to a couple hundred files, and verified the problem still occurs with the sub-set.. so we're good to go at this end |
| 17:27 | <gbee> | http://pastebin.ca/373715 |
| 17:28 | <gbee> | it's a very simple "dumped everything to the log" approach to debugging the problem :) |
| 17:33 | <briand> | it's `mythfrontend -v important` right? |
| 17:35 | <gbee> | yeah, although it should output important and general messages by default |
| 17:35 | |-| | czth [i=dbrobins@nat/microsoft/x-0bdfeb72ff223b39] has joined #mythtv |
| 17:36 | |-| | psyon [n=exodus@exodus.psyon.org] has joined #mythtv |
| 17:36 | <psyon> | Is there any way to make mythtv pump DVD video out my PVR-250, but decode the audio and pump that out the sound card? |
| 17:36 | <psyon> | sorry, I need to be in the other channel |
| 17:36 | |-| | psyon [n=exodus@exodus.psyon.org] has left #mythtv ["Leaving"] |
| 17:39 | <briand> | wow. self-correcting users. nice improvement. ;) |
| 17:40 | |-| | Will [n=willyum2@c-24-98-75-16.hsd1.ga.comcast.net] has joined #mythtv |
| 17:40 | |-| | Will [n=willyum2@c-24-98-75-16.hsd1.ga.comcast.net] has left #mythtv [] |
| 17:40 | <briand> | heheh.. nice. I ended up removing -exactly- 14,000 entries for the test set. stand by for the log... |
| 17:42 | <briand> | hmm. and only 15 imported this time. |
| 17:42 | <gbee> | strange |
| 17:43 | <gbee> | technically it's failing at an area of the code I didn't touch which is what's bothering me most - can't wait for that log |
| 17:43 | <briand> | I think I see the problem... |
| 17:44 | <briand> | contrast this: |
| 17:44 | <briand> | 2007-02-26 18:41:19.826 File in path: /video/music/William Devaughn - Be Thankful For What You've Got.mp3 |
| 17:45 | [~] | gbee knows where this is going |
| 17:45 | <briand> | with: |
| 17:45 | <briand> | 2007-02-26 18:41:20.974 File not in database: /video/music//William Devaughn - Be Thankful For What You've Got.mp3 |
| 17:45 | <briand> | one too many /'s there... |
| 17:45 | <briand> | so, it deletes everything |
| 17:45 | <briand> | i could send you the whole log, if you'd like... ;) |
| 17:45 | <gbee> | yeah, know why and simple to fix |
| 17:46 | <briand> | basically 1200 lines of 'we have this file' followed by 1200 lines of 'we don't have that, though' |
| 17:46 | <briand> | indeed. |
| 17:46 | <gbee> | I don't have any files in the root of my music directory so I didn't hit that problem when testing |
| 17:46 | <briand> | if the directory contains a trailing slash, don't add one |
| 17:47 | <gbee> | actually if the dir = "" then don't add a slash |
| 17:48 | <gbee> | it'll only happen for files in the base dir |
| 17:48 | <briand> | heh.. the -only- subdirectory I have under that is from when I ripped "After The Gold Rush" from CD.. everything else is in /video/music/ |
| 17:48 | <briand> | ah, gotcha |
| 17:49 | <briand> | well, eventually, I think I'm going to rename all of my files... |
| 17:50 | <briand> | probably use a AAA######.mp3 naming convention |
| 17:50 | <briand> | first letter = genre, second/third letters = first two of artist last name, then sequential 6-digit number |
| 17:51 | <briand> | and i'll just use the database to select a given song |
| 17:51 | <gbee> | I use directories to divide them up "genre/artist/album/" |
| 17:52 | <briand> | one of these days, I want to add a Billboard data table to my database, and link it to the song_id in music_songs... then I'll have all the chart data (date entered, number of weeks on chart, peak position, etc) available as well |
| 17:52 | <gbee> | although the genre groupings are pretty general - e.g. anything near, or a sub-genre of rock goes in the rock dir |
| 17:52 | <briand> | then I can start constructing "really, really smartplaylists" |
| 17:52 | <gbee> | http://pastebin.ca/373758 |
| 17:53 | <briand> | these are 99.9% "pop chart" songs... with a few other random cuts in there now and then... |
| 17:53 | <briand> | i've got the billboard charts for 1954-present available, but it's a lot of data entry, even for the small portion of the Top100 I have encoded at the moment.. |
| 17:55 | <briand> | okay.. how do I quickly revert the previous patch? |
| 17:56 | <Anduin> | briand: you can just patch again, it will ask to revert, or run patch with the revert flag |
| 17:56 | <gbee> | patch -Rp0 < patch |
| 17:56 | <gbee> | -R for revert |
| 17:57 | <briand> | gotcha.. thanks. |
| 17:57 | <briand> | ;) |
| 17:58 | <gbee> | what format is that information in? if it's consistent you can probably write a script to handle the parsing and input |
| 17:58 | <gbee> | alternatively you can 'svn revert filename' |
| 17:58 | <gbee> | obviously you wouldn't want to do that if you had multiple patches applied and only wanted to revert one :) |
| 17:59 | <briand> | it's in book form (Joel Whitburn's Top Pop" book). I believe you can "rent" database access by the month, however... so I could electronically get the data if I don't feel like typing it |
| 18:01 | <gbee> | pretty telling that I didn't even consider a non-digital format when you said you had the charts available |
| 18:01 | <briand> | I *wish* I had it on cd or dvd data disk... that'd be sweet. |
| 18:01 | [~] | gbee hates data entry with a vengence |
| 18:02 | [~] | gbee hates any repetitive activity |
| 18:02 | <briand> | i hear ya. |
| 18:03 | <briand> | interesting.. |
| 18:03 | <briand> | first, the "import songs" ran significantly quicker than before... |
| 18:03 | <briand> | pre: |
| 18:03 | <briand> | mysql> select count(*) from music_songs; |
| 18:03 | <briand> | +----------+ |
| 18:03 | <briand> | | count(*) | |
| 18:03 | <briand> | +----------+ |
| 18:03 | <briand> | | 1239 | |
| 18:03 | <briand> | +----------+ |
| 18:03 | <briand> | 1 row in set (0.00 sec) |
| 18:03 | <briand> | post: |
| 18:03 | <briand> | mysql> select count(*) from music_songs; |
| 18:03 | <briand> | +----------+ |
| 18:03 | <briand> | | count(*) | |
| 18:03 | <briand> | +----------+ |
| 18:03 | <briand> | | 1238 | |
| 18:03 | <briand> | +----------+ |
| 18:03 | <briand> | 1 row in set (0.00 sec) |
| 18:04 | <briand> | net result: -1 entry, rather than adding in the 109 new songs. |
| 18:04 | <gbee> | rerun it, see what happens |
| 18:05 | <briand> | stayed at 1238 |
| 18:06 | <gbee> | sticking the debug strings back in would tell you which file was removed - are you sure the 109 songs aren't included in the 1239 figure? |
| 18:06 | <briand> | that's what I'm checking now.. |
| 18:08 | <briand> | -rwxr-xr-x 1 root root 4.6M Feb 25 21:05 Eric Carmen - All By Myself.mp3 |
| 18:08 | <briand> | -rwxr-xr-x 1 root root 3.8M Feb 25 21:05 Eric Carmen - Hungry Eyes.mp3 |
| 18:08 | <briand> | -rwxr-xr-x 1 root root 4.4M Feb 25 21:05 Eric Carmen - Make Me Lose Control.mp3 |
| 18:09 | <briand> | mysql> select artist_id,artist_name,artist_sortkey from music_artists where artist_name like 'Eric Carm%'; |
| 18:09 | <briand> | +-----------+-------------+----------------+ |
| 18:09 | <briand> | | artist_id | artist_name | artist_sortkey | |
| 18:09 | <briand> | +-----------+-------------+----------------+ |
| 18:09 | <briand> | | 709 | Eric Carmen | Eric Carmen | |
| 18:09 | <briand> | | 710 | Eric Carmen | | |
| 18:09 | <briand> | +-----------+-------------+----------------+ |
| 18:09 | <briand> | mysql> select count(*) from music_songs where artist_id in (709,710); |
| 18:09 | <briand> | +----------+ |
| 18:09 | <briand> | | count(*) | |
| 18:09 | <briand> | +----------+ |
| 18:09 | <briand> | | 0 | |
| 18:09 | <briand> | +----------+ |
| 18:09 | <briand> | 1 row in set (0.00 sec) |
| 18:10 | <briand> | so, umm.. it added the artist, but didn't add the song. :/ |
| 18:10 | <briand> | good part is, it didn't -delete- any songs this time, anyway. :) |
| 18:11 | <gbee> | it's progress |
| 18:11 | |-| | Cardoe [n=cardoe@gentoo/developer/Cardoe] has quit ["Leaving"] |
| 18:11 | <briand> | :) |
| 18:14 | <gbee> | not sure why it would add the artist but not the song "-v database" might shed some light |
| 18:15 | <briand> | i've only been restoring the music_songs table, as it appeared to be the only one affected |
| 18:15 | <briand> | let me delete those rows from music_artists and re-run the import |
| 18:17 | <briand> | interesting.. it imported one of those three songs. |
| 18:22 | |-| | daMaestro [n=jon@fedora/damaestro] has joined #mythtv |
| 18:38 | <gbee> | briand: I committed the fix for the first issue |
| 18:38 | <briand> | okay, thanks... |
| 18:39 | <briand> | i'll see if i can find out why it's not picking up the new stuff, now. |
| 18:41 | <briand> | if you happen to be as much (or *bigger*) pop music fan, check out: http://www.recordresearch.com/ |
| 18:42 | <briand> | that's where i order my copies of the book. he tracks several different genres/charts and publishes fairly often |
| 18:42 | <briand> | in the us, this is the "industry standard" bible for pop radio stations |
| 18:46 | |-| | robthebob [n=rn114@82-46-18-118.cable.ubr02.bath.blueyonder.co.uk] has quit [Read error: 113 (No route to host)] |
| 18:48 | <briand> | $9.95/month for a subscription to the online database |
| 18:53 | |-| | cattelan [n=cattelan@68.178.56.100] has quit [Read error: 110 (Connection timed out)] |
| 19:09 | |-| | NightMonkey [n=NightMon@pdpc/supporter/sustaining/NightMonkey] has joined #mythtv |
| 19:11 | |-| | jwestfall [i=jwestfal@snapper.surrealistic.net] has quit [Remote closed the connection] |
| 19:14 | |-| | rtsai1111 [n=rtsai@208-201-231-158.dsl.dynamic.sonic.net] has joined #mythtv |
| 19:17 | |-| | MoRpHeUz [n=morphbr@189.12.106.224] has joined #mythtv |
| 19:20 | |-| | MoRpHeUz [n=morphbr@189.12.106.224] has quit [Client Quit] |
| 19:31 | |-| | rtsai [n=rtsai@208-201-231-158.dsl.dynamic.sonic.net] has quit [Read error: 110 (Connection timed out)] |
| 19:53 | |-| | jwestfall [i=jwestfal@snapper.surrealistic.net] has joined #mythtv |
| 19:58 | <tanq> | OK so i made the mistake of buying the hauppauge HVR -1600.. I tend to buy the unsupported hardware 9 out of ten times.. |
| 19:58 | <tanq> | that is my luck with most OS projects. |
| 19:58 | <tanq> | what is a middle of the road HD tuner card? |
| 19:58 | <tanq> | that is supported by this project |
| 19:59 | |-| | MoRpHeUz [n=morphbr@189.12.106.224] has joined #mythtv |
| 20:00 | <xris> | tanq: /topic |
| 20:01 | |-| | MoRpHeUz [n=morphbr@189.12.106.224] has quit [Client Quit] |
| 20:01 | |-| | nero [n=nero@unaffiliated/nero] has quit [Remote closed the connection] |
| 20:33 | |-| | luna6 [n=luna6@ip68-14-110-43.no.no.cox.net] has quit [Read error: 104 (Connection reset by peer)] |
| 20:42 | |-| | xris [n=xris@dsl081-161-160.sea1.dsl.speakeasy.net] has quit ["http://forevermore.net/"] |
| 20:48 | |-| | crazyldor [n=crazyldo@c-71-206-21-174.hsd1.md.comcast.net] has joined #mythtv |
| 21:25 | |-| | xris [n=xris@xris.forevermore.net] has joined #mythtv |
| 22:02 | |-| | crazyldor_ [n=crazyldo@c-71-206-21-174.hsd1.md.comcast.net] has joined #mythtv |
| 22:02 | |-| | crazyldor [n=crazyldo@c-71-206-21-174.hsd1.md.comcast.net] has quit [Read error: 113 (No route to host)] |
| 22:03 | |-| | crazyldor_ [n=crazyldo@c-71-206-21-174.hsd1.md.comcast.net] has quit [Client Quit] |
| 22:13 | |-| | NightMonkey [n=NightMon@pdpc/supporter/sustaining/NightMonkey] has quit [Client Quit] |
| 22:20 | |-| | PointyPumper [i=Pintlezz@OL221-67.fibertel.com.ar] has quit [Read error: 113 (No route to host)] |
| 22:28 | |-| | nosun [n=djpc47@wnpgmb02dc1-60-181.dynamic.mts.net] has joined #mythtv |
| 22:30 | |-| | nosun2 [n=djpc47@wnpgmb02dc1-60-181.dynamic.mts.net] has quit [Read error: 104 (Connection reset by peer)] |
| 22:47 | |-| | kurre2 [n=tomimo@a80-186-77-174.elisa-laajakaista.fi] has quit ["leaving"] |
| 22:51 | |-| | Cardoe [n=Cardoe@gentoo/developer/Cardoe] has joined #mythtv |
| 23:01 | |-| | kvandivo [n=kvandivo@ppp-70-225-171-229.dsl.chmpil.ameritech.net] has joined #mythtv |
| 23:25 | |-| | mikal [n=mikal@69-12-129-6.dsl.static.sonic.net] has joined #mythtv |
| 23:31 | |-| | degreseven [n=bryan@c-71-227-220-4.hsd1.or.comcast.net] has joined #mythtv |
| --- | Log | closed Tue Feb 27 00:00:57 2007 |