| --- | Log | opened Sun Mar 11 00:00:40 2007 |
| 00:07 | |-| | czth_ [i=dbrobins@nat/microsoft/x-c8be965fc02b1fd1] has joined #mythtv |
| 00:16 | <knowledgejunkie> | Very nice work on MythMusic guys. Just updated to r13000 and it looks nice. |
| 00:18 | <knowledgejunkie> | Any plans to add mythweb navigation from a specific track/album back up to the album/artist/song listing? |
| 00:23 | |-| | czth__ [i=dbrobins@nat/microsoft/x-fbff72f5d7f77ad6] has quit [Read error: 110 (Connection timed out)] |
| 00:39 | |-| | knowledgejunkie changed nick to knowledgejunkie_ |
| 00:42 | |-| | cattelan [n=cattelan@c-24-118-241-119.hsd1.mn.comcast.net] has quit ["Leaving"] |
| 01:05 | |-| | gnome42 [n=obi@dsl-135-150.aei.ca] has quit ["Leaving"] |
| 01:33 | |-| | knowledgejunkie_ [n=knowledg@cpc3-warw7-0-0-cust145.sol2.cable.ntl.com] has quit ["I want my, I want my, I want my MythTV"] |
| 03:26 | |-| | malban [n=chatzill@adsl-69-149-118-172.dsl.austtx.swbell.net] has quit [Read error: 110 (Connection timed out)] |
| 03:51 | <xris> | anyone know how to poke the backend to tell it that there's a new jobqueue entry? |
| 03:53 | <xris> | ah, nevermind. was using the wrong time field. |
| 03:59 | |-| | daMaestro [n=jon@fedora/damaestro] has quit ["Leaving"] |
| 04:00 | <visit0r> | kormoc: do you have plans on using find_meta.py in MythWeb like we discussed? |
| 04:01 | <kormoc> | visit0r, I believe so. I haven't poked at it yet tho :/ |
| 04:05 | <visit0r> | ok |
| 04:16 | <xris> | cool. jobqueue stuff seems to work from mythweb. |
| 04:16 | <xris> | now to clean it up |
| 04:24 | <okolsi> | knowledgejunkie: I have that back navigation implemented.. should post a patch to Trac within day or two |
| 04:24 | <okolsi> | damn.. already left |
| 04:36 | |-| | robthebob [n=rn114@82-46-18-118.cable.ubr02.bath.blueyonder.co.uk] has joined #mythtv |
| 04:42 | [~] | gbee wonders what knowledgejunkie meant by 'nice work on MythMusic' |
| 04:43 | <gbee> | yes a lot of stuff has gone into it recently, but most of that the average user wouldn't really notice as it's in the background |
| 04:45 | <xris> | hmm.. I just realized that I accidentally removed all of the date-setting config from mythweb. |
| 04:46 | <xris> | 14 minutes until it's 1:14 later. |
| 04:53 | <gbee> | would be good if there was a way to reduce the number of date setting options ~ it's somewhere around 6 at the moment? |
| 04:54 | <xris> | or more |
| 04:54 | <xris> | and yes, I wish there was |
| 04:56 | <gbee> | mostly I just want them all to use a 24 clock, so if the 'time' component could be seperate it would make things easier |
| 04:57 | <xris> | yeah. |
| 04:57 | <xris> | should have "string date", "numeric date", "time", "date/time layout" and then maybe config for which version of what to use on which page. |
| 04:57 | <xris> | layout being "date (time)" vs "date, time" (or something like that) |
| 04:58 | <gbee> | sounds good |
| 04:58 | <xris> | I need to go sleep now. |
| 04:59 | <xris> | it's almost 2 AM now, and it'll be 3 AM in 1 minute. |
| 04:59 | <gbee> | I'm just about to go have a shave and wake up properly |
| 04:59 | <xris> | heh |
| 05:00 | |-| | choenig [n=choenig@static-87-79-201-148.netcologne.de] has joined #mythtv |
| 05:00 | <xris> | there. FAR fewer xris tickets open now. heh |
| 05:01 | <xris> | wow.. either php or mythtv is really smart. I don't even have listings available for the 2:00 hour. |
| 05:03 | |-| | xris [n=xris@xris.forevermore.net] has quit ["Leaving."] |
| 05:20 | |-| | robthebob [n=rn114@82-46-18-118.cable.ubr02.bath.blueyonder.co.uk] has quit [Read error: 113 (No route to host)] |
| 06:23 | |-| | o_cee [n=oscar@c83-249-228-253.bredband.comhem.se] has joined #mythtv |
| 06:33 | |-| | aevil [n=aevil@i59F54802.versanet.de] has joined #mythtv |
| 06:46 | |-| | subbyz [i=fw49olGC@cpe-70-113-20-48.austin.res.rr.com] has joined #mythtv |
| 06:53 | |-| | subbyz [i=fw49olGC@cpe-70-113-20-48.austin.res.rr.com] has quit ["Zoned"] |
| 06:54 | |-| | subbyz [i=CuDbiAHa@cpe-70-113-20-48.austin.res.rr.com] has joined #mythtv |
| 06:55 | <subbyz> | "anybody around I can ask a question about the db internals of autoexpire? |
| 06:59 | <subbyz> | I've set record.autoexpire = 0 and recorded.autoexpire = 0 for all programs, but the autoexpire module is still deleting programs, and I'm trying to figure out why. |
| 07:04 | |-| | laga changed nick to gardengnome |
| 09:30 | |-| | gbee [n=gbee@cpc1-derb5-0-0-cust840.lei3.cable.ntl.com] has quit [Read error: 113 (No route to host)] |
| 09:31 | |-| | Syphn [n=canadabo@fctnnbsc15w-156034091184.nb.aliant.net] has joined #mythtv |
| 09:31 | |-| | Chutt_ [n=blah@69-88-222-242.thewavz.com] has joined #mythtv |
| 09:38 | |-| | gbee [n=gbee@cpc1-derb5-0-0-cust840.lei3.cable.ntl.com] has joined #mythtv |
| 09:42 | |-| | gbee [n=gbee@cpc1-derb5-0-0-cust840.lei3.cable.ntl.com] has quit [Remote closed the connection] |
| 09:42 | |-| | aevil [n=aevil@i59F54802.versanet.de] has quit [Read error: 104 (Connection reset by peer)] |
| 09:47 | |-| | gbee [n=gbee@cpc1-derb5-0-0-cust840.lei3.cable.ntl.com] has joined #mythtv |
| 10:04 | |-| | malban [n=chatzill@adsl-69-149-118-172.dsl.austtx.swbell.net] has joined #mythtv |
| 10:06 | |-| | blackest [n=john@cpc4-linc4-0-0-cust684.nott.cable.ntl.com] has joined #mythtv |
| 10:06 | |-| | blackest [n=john@cpc4-linc4-0-0-cust684.nott.cable.ntl.com] has left #mythtv [] |
| 10:07 | |-| | Chutt_ [n=blah@69-88-222-242.thewavz.com] has quit [] |
| 10:18 | |-| | aevil [n=aevil@i59F54802.versanet.de] has joined #mythtv |
| 10:24 | |-| | malban [n=chatzill@adsl-69-149-118-172.dsl.austtx.swbell.net] has quit [Read error: 110 (Connection timed out)] |
| 10:47 | |-| | snk00sj [n=mythtv@apollo.digitalbase.be] has joined #mythtv |
| 10:47 | |-| | janneg [n=janne@v29714.1blu.de] has quit [Read error: 104 (Connection reset by peer)] |
| 11:10 | |-| | janneg [n=janne@v29714.1blu.de] has joined #mythtv |
| 11:22 | |-| | briand [n=brian@c-68-35-194-216.hsd1.fl.comcast.net] has quit [Read error: 110 (Connection timed out)] |
| 11:25 | |-| | briand [n=brian@c-68-35-194-216.hsd1.fl.comcast.net] has joined #mythtv |
| 11:33 | |-| | gnome42 [n=obi@dsl-132-123.aei.ca] has joined #mythtv |
| 12:02 | |-| | Syphn [n=canadabo@fctnnbsc15w-156034091184.nb.aliant.net] has quit [] |
| 12:18 | |-| | CDev [n=CDev@c-71-233-206-26.hsd1.ma.comcast.net] has quit [Read error: 104 (Connection reset by peer)] |
| 12:46 | |-| | snk00sj [n=mythtv@apollo.digitalbase.be] has quit ["Ex-Chat"] |
| 12:56 | |-| | russellb [i=russell@asterisk/developer-and-stable-maintainer/drumkilla] has quit ["leaving"] |
| 13:03 | |-| | malban [n=chatzill@adsl-69-149-118-172.dsl.austtx.swbell.net] has joined #mythtv |
| 13:25 | |-| | robthebob [n=rn114@82-46-18-118.cable.ubr02.bath.blueyonder.co.uk] has joined #mythtv |
| 13:42 | |-| | daMaestro [n=jon@fedora/damaestro] has joined #mythtv |
| 13:54 | |-| | janneg [n=janne@v29714.1blu.de] has quit [Read error: 145 (Connection timed out)] |
| 13:57 | |-| | janneg [n=janne@v29714.1blu.de] has joined #mythtv |
| 14:12 | |-| | Nem^ [n=Nem@dslb-084-056-232-023.pools.arcor-ip.net] has joined #mythtv |
| 14:18 | |-| | ahbritto [n=ahbritto@adsl-64-161-117-110.dsl.snfc21.pacbell.net] has joined #mythtv |
| 14:20 | |-| | okolsi [n=mythtv@62.142.251.131] has left #mythtv [] |
| 14:21 | |-| | beavis [n=beavis@drms-590c760b.pool.einsundeins.de] has joined #mythtv |
| 14:22 | |-| | okolsi [n=FIOTTKOL@unaffiliated/okolsi] has joined #mythtv |
| 14:35 | |-| | reaspired [n=reaspire@pool-71-104-156-216.lsanca.dsl-w.verizon.net] has joined #mythtv |
| 14:35 | |-| | lcase [n=l-case@p54B32D64.dip0.t-ipconnect.de] has joined #mythtv |
| 14:38 | |-| | Keithamus [i=Keith@82-44-100-163.cable.ubr08.croy.blueyonder.co.uk] has joined #mythtv |
| 14:39 | <Keithamus> | sorry wrong chan. Good day to you all. |
| 14:39 | |-| | Keithamus [i=Keith@82-44-100-163.cable.ubr08.croy.blueyonder.co.uk] has left #mythtv ["Leaving"] |
| 14:39 | |-| | reaspired [n=reaspire@pool-71-104-156-216.lsanca.dsl-w.verizon.net] has left #mythtv ["Leaving"] |
| 14:46 | |-| | xris [n=xris@xris.forevermore.net] has joined #mythtv |
| 14:52 | <gbee> | xris: spent the afternoon repairing my sister's car so didn't have time to work on the albumart stuff, maybe tomorrow evening I can get it done |
| 14:53 | <gbee> | I'd do it now, but I'm knackered |
| 14:55 | <xris> | heh |
| 15:13 | |-| | Speedy2 [n=Javier_6@cpe-70-95-210-2.san.res.rr.com] has quit [] |
| 15:14 | |-| | rtsai [n=rtsai@208-201-231-158.dsl.dynamic.sonic.net] has quit [Remote closed the connection] |
| 15:20 | |-| | russellb [i=russellb@nat/digium/x-702359cb1745377e] has joined #mythtv |
| 15:22 | <xris> | heh. user job stuff via mythweb is actually kind of useful |
| 15:23 | <xris> | now if only I had any user jobs. |
| 15:26 | |-| | lcase [n=l-case@p54B32D64.dip0.t-ipconnect.de] has quit [] |
| 15:36 | |-| | LLyric changed nick to lllSleep |
| 15:41 | |-| | charlieS_ [i=charlie@schluting.com] has joined #mythtv |
| 15:41 | |-| | charlieS_ [i=charlie@schluting.com] has left #mythtv [] |
| 15:55 | <subbyz> | "anybody around I can ask a question about the db internals of autoexpire? |
| 15:56 | <subbyz> | I've set record.autoexpire = 0 and recorded.autoexpire = 0 for all programs, but the autoexpire module is still deleting programs, and I'm trying to figure out why. |
| 16:01 | <Captain_Murdoch> | maxepisodes can also cause shows to expire whether autoexpire is turned on or not for that particular program. also, Programs in the LiveTV recording group will autoexpire whether they have the autoexpire field set to non-zero or not. |
| 16:05 | <sphery> | Captain_Murdoch: got a second? |
| 16:08 | <sphery> | Captain_Murdoch: nvm. I'll catch you later--just leaving a message for now. |
| 16:08 | <sphery> | Captain_Murdoch: Did you see my post at http://www.gossamer-threads.com/lists/mythtv/users/254631#254631 ? After wanting to put optimize and repair in housekeeping, I'm now thinking it should stay out and be put in a separate script (like mythfilldatabase). |
| 16:10 | <sphery> | (Just wanted to let you know where I'm at on that. I'll talk with you about it in a couple weeks. Also, I'm still planning on implementing some changes including the leadtime change we discussed, but I'd like to do it differently from how we discussed.) |
| 16:11 | |-| | degreseven [n=bryan@c-71-227-220-4.hsd1.or.comcast.net] has joined #mythtv |
| 16:12 | <gbee> | just don't actually put it in mythfilldatabase - imho it just doesn't belong there and user who have no need for mfdb won't ever benefit from it |
| 16:14 | <kormoc> | sphery, couldn't the housekeeper check each table's engine and then just run the commands on the myisam or similar tables? |
| 16:14 | <gbee> | actually I think it would be better in housekeeping actually, when we've switched to using an embedded database issues of the user changing the engine won't really apply and the errors can be caught/ignored |
| 16:14 | <gbee> | or we can check the engine first |
| 16:14 | <gbee> | heh, what kormoc said |
| 16:15 | <xris> | gbee: repair/etc works fine on inno tables. just doesn't actually DO anything on engines that don't support them |
| 16:15 | <kormoc> | xris, actually, on memory and heap, i thought it threw an error |
| 16:16 | <kormoc> | although, that hardly matters in this case |
| 16:16 | <xris> | doesn't actually hurt the tables, though |
| 16:16 | <kormoc> | true enough |
| 16:16 | <xris> | would be another concern if we were trapping errors and reporting back |
| 16:16 | <kormoc> | well, I do agree with the issue of a crash during a 'hidden' repair |
| 16:17 | <kormoc> | but a optimize I believe should be safe |
| 16:22 | <gbee> | kormoc: thanks for adding the new duplicate check to mythweb |
| 16:22 | <kormoc> | you're welcome |
| 16:22 | <kormoc> | gbee, I was right in reading that it is not the default? |
| 16:22 | <kormoc> | *now the |
| 16:23 | <xris> | that's what I get for closing the OLD tickets first. heh |
| 16:24 | <gbee> | it's not the default no, too many competiting viewpoints on the issue and most people like the status quo |
| 16:24 | <gbee> | in the UK at least it probably would be better if it were the default :) |
| 16:24 | <kormoc> | hrm... kk |
| 16:24 | <xris> | should eventually add tooltips so people know what things mean |
| 16:24 | <kormoc> | I'll swap it back to the 'Subtitle and Description' as the default then :P |
| 16:25 | <gbee> | heh |
| 16:27 | <gbee> | in mythfrontend it comes second in the list |
| 16:28 | <xris> | okolsi: you need to remember to put your name on tickets. |
| 16:28 | <xris> | click "session" and add it there so it auto-fills |
| 16:29 | <okolsi> | hmm |
| 16:30 | |-| | gr33npho3nix [n=turk@utopia.ccs.neu.edu] has joined #mythtv |
| 16:31 | |-| | gr33npho3nix [n=turk@utopia.ccs.neu.edu] has left #mythtv [] |
| 16:31 | <GreyFoxx> | Hrm, this is odd. My mythweb is showing shows off by an our, but upcoming reecordings and the frontend show everything correctly. |
| 16:32 | <xris> | GreyFoxx: php has its own timezone settings |
| 16:32 | <xris> | okolsi: your patch doesn't work |
| 16:33 | <okolsi> | xris: before Trac update you could just enter your name/email to reporter field.. now it changes that to anonymous |
| 16:33 | <xris> | okolsi: always? that's lame |
| 16:33 | <GreyFoxx> | xris: Ahh |
| 16:33 | <okolsi> | xris: you mean this latest patch or the one I sent you earlier? |
| 16:34 | <xris> | #3195 |
| 16:37 | <janneg> | ah, that explains all the anonymous reports lately |
| 16:39 | <sphery> | kormoc: I'm mostly worried about server crash during repair. On restart, we can't guarantee a repair on that table before it's accessed if we're doing things in mythbackend. |
| 16:39 | <okolsi> | xris: I keep messing with these patches.. I believe you need both the one that I sent you earlier and 3195.. I'll clean my tree and try both patches.. |
| 16:39 | <xris> | 3195 is the only "music" patch for mythweb |
| 16:39 | <xris> | at least, by ticket title |
| 16:39 | <xris> | oh, you mean the one you sent in email. |
| 16:39 | <xris> | hang on |
| 16:40 | <kormoc> | sphery, yeah, that I understand... Any reason not to at least put the optimize in the house keeper thread and the repair as a separate script? |
| 16:40 | <okolsi> | xris: yes, that one |
| 16:41 | <xris> | nope. hunk 1 of the albums patch still fails |
| 16:41 | <xris> | but hang on, I'll commit your other stuff first |
| 16:41 | <okolsi> | could it be related to one tab character there..? |
| 16:42 | <sphery> | kormoc: we could do that, but as long as the user needs to do a repair... |
| 16:42 | <xris> | okolsi: could be |
| 16:42 | <xris> | you're still using tabs? |
| 16:42 | <kormoc> | sphery, yeah, it's just most people don't realize that running a optimize does/can help, and thus if we could do that for them, I think people would be a little bit happier |
| 16:42 | <sphery> | And, gbee, as far as mythfilldatabase goes, I was recommending they put it in the mythfilldatabase script (not in mythfilldatabase, itself). I.e. if not using mfdb, just put some script name in there to execute daily. |
| 16:43 | <okolsi> | no, not anymore! I just saw one tab left in mp3act_functions.. thought it was because of the earlier editor problems |
| 16:43 | <xris> | there. big convert |
| 16:43 | <xris> | all tabs removed |
| 16:43 | <sphery> | Seems reasonable. Once I'm back from a 2-week trip, I'll work on patching housekeeper to allow jobs to request a leadtime before the next recording. |
| 16:44 | <sphery> | I'll put a patch in for the optimize (with appropriate leadtime) once that's done. |
| 16:44 | <sphery> | I'm also looking at doing a backup with rotate in there (i.e. to default storage group). |
| 16:44 | <sphery> | Still have to determine if that's a good idea, though. |
| 16:45 | <janneg> | can we detect crashed tables? it would be nice to display some sort of warning if there is a crashed table |
| 16:46 | <sphery> | good question... |
| 16:46 | <sphery> | If someone else doesn't get to it first, I'll do some research on that... |
| 16:46 | <kormoc> | sphery, I've wondered if perhaps backuping up would be good. I've also wondered if we could auto-backup before schema updates |
| 16:46 | <sphery> | Even if we don't detect it on every table access, we could potentially do so during a daily job... |
| 16:47 | <sphery> | Yeah. If I put it in housekeeper, I'll do it so we could call the same function before schema upgrades. |
| 16:47 | [~] | xris wishes schema updates could be transactional. |
| 16:47 | <xris> | heh |
| 16:47 | <kormoc> | sphery, I *think* crashed status is shown in the comment field of SHOW TABLE STATUS |
| 16:47 | <sphery> | I guess I could quit running repairs on my tables to eventually find out. ;) |
| 16:48 | <sphery> | If in table status, though, it would be easy to add that to daily housekeeping. |
| 16:48 | <xris> | kormoc: see, lots of benefit from going to that mysql training. :) |
| 16:48 | <sphery> | Then, we just need a way to get it to the UI (i.e. System Status and Backend Status stuff?) |
| 16:48 | [~] | kormoc laughs |
| 16:48 | <janneg> | the only table crash I expierenced was a hdd failure |
| 16:49 | <janneg> | caused by |
| 16:49 | <sphery> | Wouldn't it have been nice if Myth told you about it after your Myth disk died? :) |
| 16:49 | <okolsi> | xris: did the tab conversion help, does the 3195 now apply? |
| 16:51 | <xris> | okolsi: you'll have to regenerate the patch against current svn |
| 16:51 | <okolsi> | I'll do that |
| 16:52 | <sphery> | It would be nice if when we detect a crashed table, we could write some file as a lock to prevent myth from starting, then repair, then remove the lock, but that won't help with remote backends/frontends... |
| 16:53 | <kormoc> | sphery, well... couldn't we have the MBE as the only one that can repair and if a FE/RBE detect it, ask the MBE to do stuff? |
| 16:53 | <kormoc> | or isn't there any communication channels of that sort yet? |
| 16:53 | <janneg> | sphery: write the log into the settings table. I doubt mythtv would start if the settings table is crashed |
| 16:54 | <janneg> | s/log/lock |
| 16:54 | <Captain_Murdoch> | sphery: look at how I did the db schema updating lock, that uses a separate schemalock table that is only used to allow anyone to lock the DB for a schema upgrade. |
| 16:54 | [~] | Captain_Murdoch goes back to lurking |
| 16:55 | <sphery> | Only the MBE would detect it, but if a FE/SBE tries to read some table (if MySQL crashes during the repair and the user restarted MySQL) before someone (MBE or user) re-repaired it... |
| 16:55 | <sphery> | (I.e. if the check is in housekeeping, we would only run it on the master backend.) |
| 16:56 | <kormoc> | ahh, yeah |
| 16:56 | <sphery> | OK, thanks Captain_Murdoch. I'll look at it. |
| 16:58 | <sphery> | Might be able to do both repair and optimize, after all. |
| 16:58 | <sphery> | Anyone know if ANALYZE is also necessary/worthwhile/whatever? |
| 16:59 | <sphery> | I know it's not being run in optimize_mythdb.pl (and probably doesn't need run daily), but I don't know if our usage (especially of things like recordedseek) could benefit from running it every couple of weeks. |
| 17:00 | <kormoc> | sphery, yeah, it likely would help |
| 17:00 | <sphery> | that was a worthwhile MySQL class :) |
| 17:00 | <xris> | hmm, I always figured that kind of thing happened automatically |
| 17:00 | <sphery> | thanks |
| 17:00 | <xris> | sphery: and we haven't even taken it yet. heh |
| 17:00 | <sphery> | Wow. Ahead of your time. |
| 17:01 | <kormoc> | sphery, in theory, it won't actually /help/ anything, but it gives the engine better data to index in the future |
| 17:01 | <kormoc> | which might give better results, or might not |
| 17:01 | <kormoc> | well, for joins at least |
| 17:02 | <kormoc> | which we do use a lot in myth if I'm remembering correctly |
| 17:02 | <okolsi> | xris: how about now? |
| 17:02 | <okolsi> | xris: updated the patch in 3195 |
| 17:04 | <xris> | okolsi: you know you can replace uploads, right? |
| 17:04 | <xris> | that worked |
| 17:04 | <kormoc> | xris, only if logged in I believe |
| 17:05 | <xris> | oh? |
| 17:05 | <xris> | lame |
| 17:05 | <xris> | but that makes sense |
| 17:05 | <okolsi> | xris: good that it now works |
| 17:06 | [~] | xris grumbles about not being able to search on diacritic chars |
| 17:09 | <okolsi> | gotta go now.. I still have that Back navigation and genre addition things almost ready (for Mythweb music).. I'll post these within couple of days |
| 17:09 | <xris> | hmm, jinzora is gpl. means we could use their swf music plaer |
| 17:09 | <okolsi> | xris: have to discuss that another time.. |
| 17:10 | |-| | okolsi [n=FIOTTKOL@unaffiliated/okolsi] has left #mythtv [] |
| 17:11 | <kormoc> | xris, well, perhaps you can add ANALYZE to the optimize.pl script and see if people think it helps or not? |
| 17:11 | <xris> | yeah |
| 17:11 | <xris> | though it'd be a lot faster to test with the db at work. heh |
| 17:11 | [~] | kormoc laughs |
| 17:12 | <kormoc> | well, it won't ever hurt (beyond the extra second it takes to run...) |
| 17:12 | <kormoc> | I've been running it on mine for a while... but I donno if I noticed it speed things up or not |
| 17:16 | <xris> | man, it's handy having so many copies of the same db laying around. |
| 17:30 | |-| | SdamasLPT [n=me@blk-222-92-202.eastlink.ca] has joined #mythtv |
| 17:36 | <xris> | one more bug fixed |
| 17:36 | |-| | knowledgejunkie [n=knowledg@cpc3-warw7-0-0-cust145.sol2.cable.ntl.com] has joined #mythtv |
| 17:39 | |-| | aevil^aw [n=aevil@i59F54D11.versanet.de] has joined #mythtv |
| 17:40 | |-| | CDev [n=CDev@c-71-233-206-26.hsd1.ma.comcast.net] has joined #mythtv |
| 17:41 | <xris> | kormoc: analyze DOES seem to help, at least on large tables |
| 17:41 | |-| | aevil [n=aevil@i59F54802.versanet.de] has quit [Read error: 110 (Connection timed out)] |
| 17:42 | |-| | daMaestro [n=jon@fedora/damaestro] has quit ["Leaving"] |
| 17:43 | <xris> | it's added to optimize_mythdb |
| 17:51 | |-| | CDev [n=CDev@c-71-233-206-26.hsd1.ma.comcast.net] has quit ["Trillian (http://www.ceruleanstudios.com"] |
| 17:52 | |-| | beavis [n=beavis@drms-590c760b.pool.einsundeins.de] has quit ["Verlassend"] |
| 17:56 | |-| | CDev [n=CDev@c-71-233-206-26.hsd1.ma.comcast.net] has joined #mythtv |
| 17:59 | |-| | CDev [n=CDev@c-71-233-206-26.hsd1.ma.comcast.net] has left #mythtv [] |
| 17:59 | |-| | CDev [n=CDev@c-71-233-206-26.hsd1.ma.comcast.net] has joined #mythtv |
| 18:01 | |-| | DrNickRiviera [n=riviera@so-5494-x0.essex.ac.uk] has joined #mythtv |
| 18:03 | |-| | hd420 [n=hdiwan@c-76-21-56-32.hsd1.ca.comcast.net] has joined #mythtv |
| 18:03 | <hd420> | how do i get the schema version of the mythconverg database? |
| 18:04 | <gbee> | SELECT * FROM settings WHERE value='DBSchemaVer'; |
| 18:04 | <sphery> | or read like line 7 of a log file after starting mythfrontend or mythbackend... |
| 18:05 | |-| | erUSUL [n=erUSUL@27.Red-83-38-73.dynamicIP.rima-tde.net] has joined #mythtv |
| 18:05 | <gbee> | bah, too easy |
| 18:06 | |-| | erUSUL [n=erUSUL@27.Red-83-38-73.dynamicIP.rima-tde.net] has left #mythtv [] |
| 18:09 | |-| | johnf [n=johnf@c211-30-227-143.carlnfd3.nsw.optusnet.com.au] has joined #mythtv |
| 18:10 | <knowledgejunkie> | tac /var/log/mythtv/mythbackend.log |grep -m 1 "Current Schema Version" |
| 18:13 | |-| | rtsai [n=rtsai@208-201-231-158.dsl.dynamic.sonic.net] has joined #mythtv |
| 18:13 | |-| | choenig [n=choenig@static-87-79-201-148.netcologne.de] has quit [Remote closed the connection] |
| 18:16 | |-| | ferent [n=ferent@131.Red-83-50-240.dynamicIP.rima-tde.net] has joined #mythtv |
| 18:16 | |-| | ferent [n=ferent@131.Red-83-50-240.dynamicIP.rima-tde.net] has left #mythtv ["Konversation terminated!"] |
| 18:27 | <kormoc> | tac? don't you mean cat? |
| 18:30 | <hd420> | tac just reverses cat, kormoc |
| 18:31 | <kormoc> | yeah... but for one file it doesn't do anything different and honestly, most people don't know bout it |
| 18:31 | [~] | kormoc shrugs |
| 18:32 | <kormoc> | of course, what is better is just grep -m 1 "Current Schema Version" /var/log/mythtv/mythbackend.log |
| 18:36 | |-| | robthebob [n=rn114@82-46-18-118.cable.ubr02.bath.blueyonder.co.uk] has quit [No route to host] |
| 18:37 | <hd420> | does 0.20 correspond to schema version 1160? |
| 19:05 | |-| | johnf [n=johnf@c211-30-227-143.carlnfd3.nsw.optusnet.com.au] has left #mythtv [] |
| 19:10 | <gnome42> | xris: there's a typo in that optimize db commit :) |
| 19:11 | <knowledgejunkie> | kormoc: your grep will match the first Schema in the logfile - using tac will get the most recent |
| 19:11 | <kormoc> | ahh, fair nuff |
| 19:21 | |-| | Whopper [i=whoppy@wikipedia/wossi] has joined #mythtv |
| 19:21 | |-| | Whopper [i=whoppy@wikipedia/wossi] has left #mythtv [] |
| 19:23 | |-| | sigger_ [n=mark@ool-44c0a897.dyn.optonline.net] has quit [Read error: 104 (Connection reset by peer)] |
| 19:44 | |-| | lllSleep changed nick to LLyric |
| 19:48 | |-| | daMaestro [n=jon@fedora/damaestro] has joined #mythtv |
| 19:51 | |-| | theBishop [n=mike@c-68-80-122-9.hsd1.pa.comcast.net] has joined #mythtv |
| 19:52 | <theBishop> | hi, i have a Motorola 6412 DVR, and i'm trying to capture video from it using Firewire |
| 19:52 | <theBishop> | i've had this working in Windows, but i can't find a gnu/linux solution |
| 19:52 | <briand> | hmm. |
| 19:52 | <briand> | possibly reading channel topics before typing in channels might help... |
| 19:52 | |-| | JoeBorn [n=rootmeis@adsl-75-3-46-207.dsl.chcgil.sbcglobal.net] has quit [Read error: 145 (Connection timed out)] |
| 20:08 | |-| | jams [n=jams@CPE-72-131-6-174.wi.res.rr.com] has quit [Read error: 104 (Connection reset by peer)] |
| 20:09 | |-| | jams [n=jams@CPE-72-131-6-174.wi.res.rr.com] has joined #mythtv |
| 20:12 | |-| | aevil^aw [n=aevil@i59F54D11.versanet.de] has quit [Remote closed the connection] |
| 20:23 | |-| | egsavage [n=egsavage@user-0c8hqm1.cable.mindspring.com] has joined #mythtv |
| 20:24 | |-| | theBishop [n=mike@c-68-80-122-9.hsd1.pa.comcast.net] has quit [Remote closed the connection] |
| 21:11 | |-| | SdamasLPT [n=me@blk-222-92-202.eastlink.ca] has left #mythtv [] |
| 21:21 | |-| | egsavage [n=egsavage@user-0c8hqm1.cable.mindspring.com] has left #mythtv [] |
| 21:31 | |-| | jebel [n=je@c-67-187-134-27.hsd1.ca.comcast.net] has joined #mythtv |
| 21:44 | |-| | MightyBall [n=chatzill@dyn216-8-171-109.ADSL.mnsi.net] has joined #mythtv |
| 21:44 | |-| | MightyBall [n=chatzill@dyn216-8-171-109.ADSL.mnsi.net] has left #mythtv [] |
| 21:45 | |-| | ahbritto [n=ahbritto@adsl-64-161-117-110.dsl.snfc21.pacbell.net] has quit [Client Quit] |
| 21:47 | |-| | DrNickRiviera [n=riviera@so-5494-x0.essex.ac.uk] has quit ["Leaving."] |
| 22:06 | |-| | benlake [n=benlake@cpe-76-187-73-152.tx.res.rr.com] has joined #mythtv |
| 22:07 | <benlake> | any thoughts on the Hauppauge WinTV-HVR 1600 HDTV 1080i PCI? |
| 22:08 | [~] | Captain_Murdoch thinks you should try #mythtv-users |
| 22:08 | <benlake> | oops sorry about that |
| 22:08 | <Captain_Murdoch> | :) |
| 22:08 | <knowledgejunkie> | benlake: unsupported in Linux |
| 22:08 | <benlake> | knowledgejunkie: oh well that sums that up :P |
| 22:09 | <benlake> | keep up the good work, you enrich my life. Cheers! |
| 22:09 | [~] | benlake hugs all devs |
| 22:10 | [~] | knowledgejunkie refers benlake to http://ivtvdriver.org/index.php/Supported_hardware |
| 22:11 | <benlake> | knowledgejunkie: danke |
| 22:12 | <knowledgejunkie> | benlake: keine probleme |
| 22:20 | <knowledgejunkie> | Is trac no longer applying the "reported by:" field when not logged in? |
| 22:21 | <knowledgejunkie> | Tickets 3197 & 3198(dupe) show anonymous even though the field was set to my email address |
| 22:29 | <knowledgejunkie> | subsequent ticket updates do honour the reported by: field |
| 22:33 | |-| | waldo [n=dlg@chaos.dsrw.org] has joined #mythtv |
| 22:34 | <waldo> | wrong place, technically, but who should I ask about why an apt-get upgrade hosed lirc? |
| 22:35 | <hd420> | your distribution's IRC channel? |
| 22:35 | <hd420> | waldo: your distribution's IRC channel? |
| 22:35 | <waldo> | you'd think so. good luck getting a word in edgewise on #ubuntu :] |
| 22:42 | <hd420> | just wait,waldo, I've had good luck on #ubuntu |
| 22:52 | |-| | t0ny-p40 [n=t0ny-p40@67.60.43.42] has joined #mythtv |
| 22:53 | <waldo> | they've been arguing about apt-get v. aptitude. it's fairly tedious. |
| 22:55 | |-| | benlake [n=benlake@cpe-76-187-73-152.tx.res.rr.com] has left #mythtv [] |
| 22:55 | |-| | cmorgan [n=cmorgan@68-116-193-70.dhcp.oxfr.ma.charter.com] has joined #mythtv |
| 23:01 | <knowledgejunkie> | Beirdo: does BeirdoBot collect logs from #mythtv? |
| 23:15 | |-| | Magni [n=tony@pythia.bakeyournoodle.com] has joined #mythtv |
| 23:16 | |-| | Magni [n=tony@pythia.bakeyournoodle.com] has left #mythtv ["Wrong channel ATM"] |
| 23:28 | <knowledgejunkie> | night all... |
| 23:29 | |-| | knowledgejunkie [n=knowledg@cpc3-warw7-0-0-cust145.sol2.cable.ntl.com] has left #mythtv [] |
| 23:35 | |-| | mark_ [n=mark@ool-44c0a897.dyn.optonline.net] has joined #mythtv |
| 23:38 | <mark_> | is there documentation for the -ui.xml themeing system? |
| 23:43 | |-| | mark_ [n=mark@ool-44c0a897.dyn.optonline.net] has quit ["Leaving"] |
| 23:45 | |-| | cmorgan [n=cmorgan@68-116-193-70.dhcp.oxfr.ma.charter.com] has quit [Remote closed the connection] |
| 23:49 | |-| | daMaestro [n=jon@fedora/damaestro] has quit ["Leaving"] |
| 23:53 | |-| | Cardoe [n=Cardoe@gentoo/developer/Cardoe] has quit ["Leaving"] |
| 23:59 | |-| | Nem^1 [n=Nem@dslb-084-056-241-225.pools.arcor-ip.net] has joined #mythtv |
| --- | Log | closed Mon Mar 12 00:00:32 2007 |