/srv/irclogs.ubuntu.com/2009/03/04/#ubuntu-mythtv.txt

tgm4883I don't know if it has comm skipping, but you could look at linvdr00:01
tgm4883it has some plugin called noad00:01
h2oshttp://www.linuxtv.org/vdrwiki/index.php/Noad00:03
h2osmight be what i want00:03
tgm4883yep, then you just need a program that will read the cutlist00:05
omoorehello all.. anyone awake? :) I am thinking about filing a bug that I don't see listed.. but want to ping you guys to see if anyone knows about this issue...03:07
rhpot1991omoore: whats the issue?03:07
omooreI am seeing non-date information in date fields of both Recorded and RecordedProgram tables...03:07
omoorethe issue seems to be...03:07
omoorethat when a description has special characters, the SQL is probably not escaping the content properly...03:08
rhpot1991omoore: interesting, you should make a bug and include information about where your data comes from03:09
omoorefrankly.. I am surprised it *could* get in there.. anyway.. when i use a database tool to query the data...03:09
omoore(considering the datatype for the column)03:10
rhpot1991what do you use for your listings?03:10
omoorethe listings look fine.. it's when i query the database table.. specifically.. i'm using JPA, but it also shows odly when querying via JDBC.. and the MySQL query tool03:11
omooreie.. mythweb lists ok.. as does the mythtv client...03:11
omoorebut if i query the data directly.. some date columns have invalid data...03:11
omoore(using JDBC, JPA or the MySQL query tool)03:11
omooreI also was going to try a fresh install first.. since I want to rule out some oddity with my installation.. because I have also noticed that a station which changed channels in my area still shows as the old station03:13
omoore(too bad! it's SCIFI! :) )03:13
rhpot1991omoore: well the thing to do would be to see if thats bad data you are getting from somewhere or what the deal is03:14
omooreThe database is pretty small.. you think there would be value in my dumping the db and having it available to the person working the bug?03:14
rhpot1991if its being cleaned up by something on myth's end then it may not be an issue03:14
omooreno external updates are being done.. unless mythweb is messing something up...03:14
omoorewhich might be thecase as i work almost exclusively with my mythbacken from a mythweb browser widow03:15
rhpot1991omoore: mythweb could be cleaning that up before showing it to you or something03:15
omoorewindow03:15
omooreahh.. right03:15
rhpot1991omoore: you could just do a dump of the problem rows, tar.gz that up and attach it to the bug03:15
omooretrue.. should be small enough...03:16
rhpot1991omoore: so what you do is mysqldump -u<user> -p mythconverg <tables tables> --where="something='something'" --no-create-db --no-create-info > dump.sql03:19
rhpot1991keys on the recordings tables are normally chanid and starttime03:19
rhpot1991then if someone so wanted they could import that03:19
omoorewill do.. i think i will dump the database and preserve.. but going to rbuild too just to be sure it isn't something screwey with my environment (i copy off the recordings to a network attached storage box here at home so no data to speakof on the actuall myth box)03:21
=== anii is now known as aniiena
lifewithryananyone running mythbuntu with a pvr350?  i'm getting scrambled recordings over basic cable...16:17
c0p3rn1c I just removed the package ubuntu-mythtv-frontend but the mythtv user account still tries to login, how do I stop this?16:32
tgm4883c0p3rn1c, have you looked in System > Administration > Login Window16:33
tgm4883under the security tab16:33
c0p3rn1cI'll check thx16:33
c0p3rn1ctgm4883: should I also delete the account ?16:35
tgm4883if you want?16:42
tmetro1After synchronizing versions between an 8.10 front-end and 8.04 back-end by running the 0.21.0+fixes19878 weekly build on both, I'm still seeing the front-end fail to start with a complaint:23:48
tmetro1 Unexpected DB Schema version. ... QString::arg(): Argument missing: ERROR: Unable to acquire database upgrade lock ... Access denied for user...23:48
tmetro1I don't get why it is still (saw this before I synced up versions and though it was version skew) trying to upgrade the schema. I've restarted the back-end process and ran a front-end there locally, which should have triggered any needed schema upgrade.23:48
tmetro1The db user has more limited access rights than the typical mythtv MySQL user. Is this error a red herring and it just needs sufficient access to create a temporary table for a lock semaphore and then it'll be happy?23:50

Generated by irclog2html.py 2.7 by Marius Gedminas - find it at mg.pov.lt!