[01:58] jose, can you publish https://codein.withgoogle.com/dashboard/tasks/4811708518367232/ please [01:58] darkxst: all set [02:01] jose, hopefully we can find a new QA team from this ;) [02:02] darkxst: it would be amazing, though isn't that task for a bug? [02:03] I meant in general, our daily images have been broken for 7 weeks in virtualbox and no one noticed! [02:03] yes that last one was for a bugfix [02:08] cool :) [04:01] popey : Please review my merge request: https://code.launchpad.net/~emailgirishrawat/ubuntu-calendar-app/READMEs/+merge/280392 [06:58] Hi I'm having some issues with bzr. My public key is denied every time. Can anybody help me out? === tvoss is now known as tvoss|errands === tvoss|errands is now known as tvoss [09:29] morning all === _salem is now known as salem_ [11:55] I'm interested to know how everyones going? How many tasks have you guys done? === alan_g is now known as alan_g|lunch [12:56] MatthewAllen: over 9000 :P\ [13:02] tsimonq2, wow - you're pretty quick! [13:04] MatthewAllen: joking...but I am a mentor of like 15 tasks [13:13] balloons, I made a merge request for the top 100 task (https://code.launchpad.net/~smajevic-irfan/ubuntu-qa-website/gci/+merge/280403), can you please review it? [13:17] tsimongq2, what do you work on mainly for Ubuntu? [13:21] MatthewAllen: https://wiki.ubuntu.com/tsimonq2/Contributions === alan_g|lunch is now known as alan_g [14:20] does anyone know where Ken Vandine is? [14:23] xcub, he should be about in a little while. He's in the US so it's still morning over there [14:24] ok, thank you. [15:40] hello everyone, so I got the task to fix the bug bugs.launchpad.net/ubuntu-gnome/+bug/1525402 [15:40] it says that i should propose a better placement and design for the button [15:42] darkxst: I would propose to move it up, directly under the "cursor blinking" section and make a button shape around it [15:45] indielives: I presume they mean comment on the bug? [15:45] georgewhite: actually the task states "implement an improved design and submit upstream for a design review" [15:46] OK then [16:56] https://codein.withgoogle.com/tasks/4608447228149760/ [16:57] https://code.launchpad.net/~emailgirishrawat/ubuntu-calendar-app/READMEs/+merge/280392 [16:59] hey Girish [17:00] balloons : hi [17:00] ohh this will be so NICE [17:00] What? [17:00] My task? [17:00] your MP. It will be very helpful to everyone [17:00] yes [17:01] Thank you! It will be my very first thing pushed and merged! So excited! :D [17:01] Girish, do you know about autopilot-sandbox-run? [17:02] Are they the tests that can be run from the sdk? [17:03] Girish, see https://developer.ubuntu.com/en/start/platform/guides/running-autopilot-tests/ [17:04] Girish, you can use the SDK, or autopilot3-sandbox-run as easier ways of running tests on the desktop [17:04] Ok, so should I include this in the README? [17:05] the README links to that page, but yes it might be worth mentioning anyway I suppose [17:05] That's why I asked if you knew about it or not. I suspect most people would rather run tests via the SDK? [17:06] And Girish, if you are up for it, the other core apps need the same treatment :-) [17:06] that is; a nice set of README's [17:07] Yep, I was supposing to take the terminal app next. [17:07] excellent! I'm so happy to see this be fixed [17:08] balloons : So should I edit my readme for the sandbox tests or not? [17:08] Girish, I would mention how to run them using the SDK if you don't mind [17:09] Ok, on it. [17:10] Girish, if you want to just more or less link to the page rather than repeat things to much, that's ok as it's more visual instructions [17:10] it's just worth mentioning that you can run them via SDK [17:10] Okay, I'll leave a link to it then. [17:46] balloons : Updated README.autopilot. [17:47] https://code.launchpad.net/~emailgirishrawat/ubuntu-calendar-app/READMEs/+merge/280392 [17:51] :/ can’t find libsoy.so on ‘import soy’ [17:51] :( [17:56] Oh well [17:57] !patience | georgewhite [17:57] georgewhite: Don't feel ignored and repeat your question quickly; if nobody knows your answer, nobody will answer you. While you wait, try searching https://help.ubuntu.com or http://ubuntuforums.org or http://askubuntu.com/ [17:58] Oops, sorry, I’m on the wrong channel [17:58] d-oh. [17:59] balloons : https://codein.withgoogle.com/tasks/4608447228149760/ [17:59] Girish, yep, I top approved === alan_g is now known as alan_g|EOD [17:59] Yay! :D [18:00] balloons : Which all core apps need READMEs? [18:01] Girish, all of them could use an update, besides clock and calendar which you just did [18:01] How many core apps are there? [18:02] Girish, actually, one more question [18:02] Yeah? [18:02] did you list dependencies in order to build calendar? People get confused by those [18:02] Yes I did. [18:03] everything is in debian/control, but by default we aren't building debian packages [18:03] hmm, I don't see it [18:03] the core apps are listed here: https://developer.ubuntu.com/en/community/core-apps/ [18:03] there's 12 [18:03] address-book-service-testability and a couple of other [18:04] Girish, yes but under +Building and running on Vivid Desktop (15.04), I'm not sure those commands will work unless they install some things [18:04] * balloons looks @ calendar [18:05] Okay what all dependencies do I need? [18:06] look in debian/control [18:06] I think ubuntu-sdk-libs will take care of most of those. But you'll want cmake and intltool [18:07] Okay I'll list them. [18:07] your MP merged, so heh, you'll have to repropose it [18:08] Yep. [18:08] I guess it would be useful to try checking out the code in a pristine environment and double checking what's needed to make sure [18:08] Should I list all the dependencies in debian/control in the main README? [18:10] Girish, well that would technically work, I think it might be easier to see what's not in the ubuntu-sdk-libs metapackage and list only those [18:10] Okay. [18:10] On it. [18:10] also, I noticed python3-dateutil was missing from autopilot dependencies [18:10] sorry, just a few little tweak [18:11] Np. [18:20] Should I add a README.dependencies where I list all the dependencies required to run different packages? [18:27] Hmm.. Sure. Then feference it in the developers and autopilot reademe [18:27] Yes.s [18:28] I just want to make sure it's really easy for new folks to get setup properly. That's the goal, and you get it [18:28] Yep. [18:40] hello [18:40] can anyone help me a little bit? [18:40] gabriel_: sure, just ask [18:40] i have to run some test on calendar [18:40] i installed the sdk and i saw i can use c++ [18:40] i am pretty familiar with c++ but i can't figure out how to test and what to test [18:41] gabriel_: who are your mentor(s)? [18:41] Carla Sella Alan Pope Samsrut [18:41] xcub, hello [18:41] hello [18:41] popey: could you be of assistance to gabriel_ ? [18:41] gabriel_ : You have to run 2 types of tests: Unit tests and Autopilot tests. Read the README provided in the code [18:41] yes, everything with the tutorial looks good to me. I'm not sure in Ken will be around today or not [18:41] that's alan pope i just pinged gabriel_ :) [18:42] I can approve, and I'm sure Ken will still have a last look. I'm curious about where you want to publish it. Did you have a place in mind? [18:42] aham okay [18:43] I was thinking about coverting it into an HTML file, then handing it to the people who administer Bacon 2D to decide where to put it. [18:43] gabriel_ : The code is hosted at https://code.launchpad.net/ubuntu-calendar-app [18:43] i was going to ask that, thanks :)) [18:43] Or i could post it on github [18:43] gabriel_ : Np. [18:48] Sorry balloons, I got disconnected from IRC; did you say anything after I said "or i could post it on github" [18:48] xcub, that sounds like a good idea. I'll personally still promote it, as I think it's cool. Let me know when you have it marked up as HTML [18:49] I'd like to get it on ubuntu planet for instance [18:49] planet.ubuntu.com [18:49] xcub, no no worries, I didn't respond while you dc'd [18:49] ok, thank you. I'll let you know then. \ [18:49] xcub, so I'll go ahead and approve so you can keep working [18:50] xcub, all approved [18:50] It is okay [18:50] balloons : http://i.imgur.com/yPaJlDt.png I made a list of dependencies needed. Can you check if any are missing? [18:50] Thanks! [18:51] xcub, posting on github if you want to post it yourself is a better idea than using a free webhost ;) [18:51] Ubnu is not user friendly comper to Windows [18:52] Girish, that looks pretty good, although some are redudant. When you put it in the file, I would post it as an install string. sudo apt-get instal .... [18:52] Nis: is there something you need help with? [18:52] Yeah i thought of that [18:52] So i should put a single string with all the dependencies? [18:52] I think we have to provide a firewall in ubutu [18:53] Girish, so I think outside of autopilot depends, ubuntu-sdk-libs qtcontact5-galera qtorganizer5-eds might be enough. Did you try installing things in a chroot to see? [18:53] Girish, yea a single install string makes it easy for people Ithink [18:53] sudo apt-get install first && second && thrid <- that would make a pretty large string [18:54] Nis: already is one http://www.howtogeek.com/115116/how-to-configure-ubuntus-built-in-firewall/ [18:54] Girish, it would be like sudo apt-get install package1 package2 package3 [18:54] oh yes. [18:55] balloons : What do you mean by ubuntu-sdk-libs qtcontact5-galera qtorganizer5-eds might be enough? [18:56] Girish, yes and the list could be shorter, as some of those packages install other ones. Finding the smaller list would be useful. For example, ubuntu-sdk-libs install qtorganizer; see http://packages.ubuntu.com/wily/ubuntu-sdk-libs [18:57] Girish, that's why I was saying the simplest thing to do would be use a clean system and follow your instructions [18:57] Okay. [18:57] then install the meta-packages and see what the build still wants / needs [18:57] Okay. [18:58] Girish, ideally the developers would have done this, but we get to do a little sluething [18:58] Girish, do you know how to create a chroot? [18:59] Nope. But I've a clean copy of ubuntu installed in a VM [18:59] Girish, that works :-) [18:59] Girish, you'll want to make sure you snapshot it beforehand, so you can do the same thing for other apps [18:59] or uninstall the packages you install between each one [19:00] Oh yaeh that's a brilliant idea! [19:00] really a clean VM is a handy thing to have a snapshot of! [19:03] balloons: tsimonq2 made four tasks that were supposed to be for doing the entire suite of test cases for a particular image. they need editing, though, before they are published. can you add me to them? [19:03] wxl, yes [19:04] balloons: https://codein.withgoogle.com/dashboard/tasks/5855101298147328/ https://codein.withgoogle.com/dashboard/tasks/4899542210183168/ https://codein.withgoogle.com/dashboard/tasks/5751474072059904/ https://codein.withgoogle.com/dashboard/tasks/6122000900685824/ [19:05] wxl, looking at them, I think you could ask them to do all of them; or do it for more than one day, etc. Also the instance count could be higher [19:05] Guys, sorry for bothering you one more time, I have a problem while building ubuntu calendar app [19:05] balloons: agree [19:05] wxl, so it likely will end up being 1 task eh? [19:05] either way, nice to see some lubuntu stuff out there! [19:06] balloons: no, it'll be four tasks, one for each image [19:06] ahh, gotcha [19:06] balloons: or maybe i could make two [19:06] balloons: can't assume someone has both i386 and amd64 [19:09] hey, can I ask a question? [19:09] Rob1507 : Sure, whatsup? [19:10] Girish: I am working on task "Port pastebinit to snappy using snapcraft" [19:10] And I cannot find out where to find pastebinit archive [19:10] Here is the link of the task - https://codein.withgoogle.com/tasks/4645817537265664/?sp-status=2&sp-is_exhausted=False [19:11] AFAIK, pastebinit is an UBuntu package which can be installed using sudo apt-get install pastebinit [19:11] Rob1507, https://launchpad.net/pastebinit [19:12] Rob1507, if you wish, you can port a different package that is not pastebinit. I'm the mentor for the task. The goal is to get your feedback on using snapcraft, so if you have an app you'd rather do, let me know and go for it [19:13] I can try pastebinit, but in the case of change I will say. Thank you for help :) [19:13] One more question [19:13] Rob1507, you are welcome. Good luck! [19:13] Also, #snappy on freenode has the rest of the snappy team, should you get stuck on something [19:14] so /join #snappy will put you in there channel [19:14] balloons: thanks. And I should attach only files I get after work? [19:17] Hi balloons, It says that I have to wait for parental consent, though I already had my parents fill it out [19:17] already [19:17] wxl : tsimonq2 : https://codein.withgoogle.com/dashboard/task-instances/5043945318907904/ [19:17] Rob1507, hmm. Good question. Make a branch on github or launchpad that has your work. I think that would be best [19:18] Girish: thanks for the reminder. i'm doing about 12,000 things at once but will get to it shortly :) [19:18] xcub_, :-( hmm. Well, that's something to ask Google then, I don't have much control over it. Let me ask for you [19:18] balloons: Ok, thanks again [19:19] xcub_: it will not be approved until beginner task is done. Have you done it already? [19:19] ok, thanks! [19:19] ohh.. interesting [19:21] xcub_: You are welcome :) [19:22] balloons: ok they should be fixed [19:25] wxl, published [19:30] Girish: you did all four! i just made a task for that if you want to switch [19:31] Girish: needless to say, i'd approve for this task or that one, depending on whta you want to do [19:31] Approve for this one. [19:32] Girish: did you not find any of the "bugs to look out for?" [19:35] hey xcub [19:35] hello [19:35] xcub, great work on the tutorial [19:35] thanks! [19:35] i'm still reviewing it, but probably won't finish today [19:35] i'm sort of on vacation right now :) [19:35] What kind of adjustments do you think I should make so far [19:35] oh :) [19:36] replace Bacon 2D with Bacon2D :) [19:36] and the suggestion i made earlier, which you accepted [19:36] xcub, and you made me think of a feature i should add to Boundaries [19:36] but won't affect your tutorial [19:36] i'm going to expose an API in Boundaries to access it's fixtures [19:37] simple to do [19:37] and would greatly simplify your Breakout use case [19:37] ok, I think that would be a great feature to add. [19:37] yup [19:37] Let me know when you complete the fix so I can update my tutorial :) [19:38] oh, and where do you want me to post the html file [19:38] I plan on converting the tutorial to a website [19:38] And I was wondering if I should post it on github or just give it you to decide where to put it [19:39] balloons, the bacon2d tutorial task says it should get posted on developer.ubuntu.com [19:39] balloons, any guidance on what we should do to make it suitable? [19:39] just plain html? [19:39] I can help with that. I wanted to make sure it got out there. Not sure if there was anywhere else you wanted it [19:40] xcub, it would be great if you could post your Breakout project on github [19:40] ok, so I'll just make the website and give it to balloons to post [19:40] wxl: Do I specifically need to try and reproduce the bugs? I just followed the instructions and checked if all things were functioning correctly. [19:40] And then I'll also post the project on github [19:40] kenvandine, I believe I was thinking of putting it on https://developer.ubuntu.com/en/community/blog/ [19:40] balloons, i still need to spend more time reviewing it, but didn't want xcub to waste time on formating/markup stuff if it would need something specific [19:41] so it went to planet. But it nees a long term home [19:41] Girish: it's a general rule with iso testing, but i see it's not clear, so consider it approved! [19:41] i can put it on bacon2d.com for a permanent location [19:41] ok. So markdown is fine for me [19:41] I don't really want raw html [19:41] xcub, ^^ [19:42] wxl: Okay, will keep that in mind the next time I'm doing QA tracking. [19:42] xcub, markdown would be cool [19:42] xcub, but lets wait until i finish reviewing it in google docs [19:42] alright, I'll try to use markdown after your done reviewing it [19:42] I've got to go to my next class now, bye and thanks! [19:43] kenvandine, I approved the task so xcub was free to get his consent form going also. But we'll do the final review and upload ofc ;-) [19:44] balloons, awesome! [19:44] thx [19:44] ty [19:44] Girish: done [19:45] wxl : Thanks! [19:45] Girish: thank you on a job well done :) [19:45] balloons, i was thinking about adding a few more similar tasks, not full tutorials but shorter tutorials on specific components in bacon2d [19:46] like some primers on Behaviors, Sprites, Layers, etc [19:46] kenvandine, go for it. I'm guessing xcub might be interested :-) amongst others [19:46] yeah [19:46] kenvandine : That would be really cool. I've wanted to play with Bacon2D myself [19:46] Girish, great! [20:07] balloons, i added 2 tasks [20:13] kenvandine, I'll approve in a moment [20:13] published [20:14] i added the bacon2d tah [20:14] *tag [20:16] Can anyone suggest a go application :D i do not have favorite one to port :D [20:23] please anyone [20:23] Hello! I am interested in the "Bacon2D viewport primer" on google code-in. [20:23] Can anyone administrative here tell me about it? [20:25] balloons, thx [20:47] balloons : Which package is QtQuick in? [20:47] Or is it an individual package? [20:49] Girish, hmm. I'm not 100% sure offhand [20:49] I know there are packages with qtquick in the name [20:50] generally I would expect that to install as part of a default qt5 instal [20:50] I found many packages with QtQuick. Which do I include in the dependency list? [20:50] QtQuick is the first error I got while building the calendar on a frsh install [20:51] fresh * [20:54] Girish, ahh I get it [20:54] Girish, did you install the ubuntu-sdk-libs package? [20:54] Yep. [20:54] And the sdk [20:54] And cmake. [20:54] Ok, shouldn't need the sdk; just the libs I think [20:54] but whatever.. anyways, ok qtquick [20:55] so let's look at the list of depends then [20:55] Sorry I didn't really get your question until now :-) [20:56] You said many packages install other packages. So to list as few packages in the dependency list. How do I find which package QtQuick is in? Which package should I list to install QtQuick? [20:59] Should I list qtdeclarative5-qtquick2-plugin in the dependency list? [21:00] Even that doesnt install QtQuick 2.3 [21:00] It's asking for QtQuick 2.3 [21:06] Girish, ohh, did you install the sdk ppa? [21:06] I mean, did you follow the guide for installing the sdk? I assume as much [21:06] sorry, I haven't looked yet a the depends [21:06] Oops, I forget to do that. [21:07] Girish, I'm guessing you've solved the issue then with that package, but from the sdk ppa so it's the new version [21:09] yep, looking at the depends I agree with your findings [21:09] sorry for the troubles on this Girish [21:10] No problem. It will help more people get started [21:11] I was not able to solve the issue btw [21:11] How do I solve the issue of QtQuick 2.3? [21:12] Do I need to install ubuntu sdk for qtquick ? [21:13] so if you used the ubuntu sdk ppa, you should get the new version of qtquick it wants [21:14] How? [21:14] since you installed beforehand, try distr-uograding [21:14] sudo apt-get update && sudo apt-get dist-upgrade [21:14] Okay [21:14] it should say it wants to update some packages [21:14] Ok [21:24] Anyone here? [21:38] balloons what do I need to do for my task to fix it (it's the tabbed terminal interactive [21:38] interface mockup (sorry pressed enter) [21:38] adueppen, the tabbed terminal interface? [21:38] Girish, any luck? [21:38] Rob1507, how's things with snapcraft? [21:39] balloons https://codein.withgoogle.com/dashboard/task-instances/4638205445931008 [21:39] it was funny because i haven't claimed pastebin task :D [21:40] balloons, now I am doing another one of the same type [21:40] Rob1507, I am doing snapcraft as well [21:40] adueppen, ohh.. that's a question for popey, sorry. I hit the button because I thought you wanted more time. I didn't specifically have anything [21:40] I wanted to ask [21:40] balloons : My VM is getting really slow internet. So it;s still upgrading. [21:41] xcub, you work on pastebin? [21:41] :D [21:41] balloons OK I'll check with him. I think he was able to straight up extend the deadline because he's the mentor [21:41] no, I'm porting a go application [21:41] Girish, ahh [21:41] xcub, me too. And have you choosen an app? [21:41] adueppen, yes he did. But is it ready to review then or ? [21:41] Girish: if you have a spare flash drive of a decent size you should condsider just installing it onto there, its sooo much quicker than a VM [21:42] nope :) [21:42] xcub, I would point out #snappy here on freenode as well [21:42] balloons I think he's reviewing it, I asked him before if he knew why you had sent it back, but he didn't [21:43] Girish the good news is once this is done, making the other readme's should be easy. The apps are all similar on dependencies [21:43] back in a bit [21:43] Rob1507, do you know where to find go applications to port [21:43] Yep. [21:43] Like there is some archive [21:43] xcub, GitHub [21:44] just any application on there [21:44] xcub, actually there are many, it is harder to choose a good one. [21:44] one that will be appropriate [21:46] hi, kenvandine, what did you mean by "add one" [21:47] balloons, I've submitted the task now [21:51] xcub, i added some more tasks [21:55] balloons, I submitted the task but I am sure it is not right. I've messed up [21:59] balloons, can I have the task of pastebin back? I finished it and was not able to post [22:01] smajevicirfan, ack [22:01] Rob1507, what do you mean? [22:02] which one? [22:02] submitting the task [22:02] I can do it later, but not sure what you are asking [22:03] I have accidentally forgotten to claim task. After finishing work I noticed that it is not in task list. [22:03] balloons: I don't understand, the top 100 change is accepted, right? [22:03] balloons: and if it is, why don't I see it? :P [22:04] balloon, and after it I claimed another one and I think I messed it up [22:10] popey: are you reviewing my task (tabbed terminal app) now? the whole situation with balloons has been resolved [22:15] Rob1507, what go application did you port so I know not to do it [22:18] martini-gorm [22:18] ok, thanks. [22:18] And by the way, do you know where to post the resulting package [22:18] xcub, I am not sure that I've done everything right [22:19] Have you done it? [22:19] no, not yet, I'll PM you about it when I'm done so we can compare what we did if you want to [22:19] does anybody here have any experience with sql? [22:19] Really need some help for a task [22:20] a little [22:20] how can I copy the structure of a 'table' without the data [22:20] xcub, I definitely want :) [22:21] http://stackoverflow.com/questions/233870/how-can-i-create-a-copy-of-an-oracle-table-without-copying-the-data [22:21] xcub, as for resulting package you should create GitHub account and place there as repository [22:22] ok, thanks! [22:22] xcub where does that command get executed? from a sqlite prompt? [22:22] Sorry, I have to go now, I have an exam tomorrow. Bye. [22:25] I would think so [22:26] ok [22:30] Hi everyone, I'm trying to build the dekko email client but I keep getting "Error 2" [22:30] I run "./scripts/run-desktop --with-uitk" but I get "[sub-src-make_first] Error 2" [22:31] Does anyone know how I can fix this? [22:31] Also - I'm on 14.04 [22:45] tsimonq2, I have to deploy it to production. [22:45] balloons: oh ok, cool [22:45] fazer, hello [22:45] nathan_, that's a question for DanChapman, but it sounds like you need to build dekko first [22:46] balloons, hey! [22:46] balloons, I'm having trouble with these tables [22:46] I'm unable to copy the table structure. [22:47] I have a question about snapcraft and the yaml file [22:48] Spcecifically, icon: [22:48] The application I want to port doesn't provide an icon, is it ok if I just leave this area blank. [22:51] should i use the one in /usr/share/icons/hicolor/64/apps/apport.png [22:52] fazer, I saw something along those lines in your post [22:55] yup. [22:56] balloons: I'm still unable to do it, and none of the solutions I can find seem to work, including the ones that letozaf pointed me toward [22:56] fazer, so since you are on IRC at the same time, let me grab the project and help [22:57] I assume you have the big picture idea down now right? [22:57] yes. [23:01] when I try this: http://stackoverflow.com/questions/233870/how-can-i-create-a-copy-of-an-oracle-table-without-copying-the-data [23:01] it returns: "Error: no such table: mediastore" [23:03] fazer, so I would copy the blank database from a fresh install [23:03] fazer, that way we don't have to copy anything :-) [23:03] since we don't need or want any media in it. does that make sense? [23:04] balloons, from a fresh install of what> [23:04] no not really, honestly [23:04] fazer, my thought was to just grab the db from a ubuntu install that doesn't have any Music files in ~/Music [23:04] it should be blank [23:05] but let me try cloning the db too [23:05] ok. so I tell it to locate the db created by the os? [23:06] fazer, I can't remember the exact location, but ~/.mediascanner perhaps [23:06] I'm not on my primary machine [23:07] sorry, i just say what you are trying to do. [23:07] I don't have a .mediascanner directory in my home dir [23:08] the db is a sqlite3 file. The other option is to simply dump it to sql, edit the stuff we don't want out, and create a new db [23:08] i'm not sure what the stackoverflow stuff is [23:09] * balloons does it [23:11] * tsimonq2 subtley slides a picture of a lenny face to balloons [23:11] fazer, so i just did this: [23:11] sqlite3 mediastore.db .dump > blank_mediastore.db [23:12] then removed most of the insert into calls (all of the ones adding real content) [23:13] then I restored the sql file into a new db [23:13] sqlite3 blank_mediastore.db < blank_mediastore.sql [23:14] fazer, sorry the original dump should be to a sql file, lol [23:14] sqlite3 mediastore.db .dump > blank_mediastore.sql [23:14] let me push the new blank db, which I think will do the trick for you [23:14] or you can do it yourself [23:14] Let me try it myself. [23:15] Thank you. [23:16] balloons, I only have to remove the insert statements inside the media table right? THe rest don't add any content. [23:17] fazer, attached to the task what I did [23:17] ok, taking a look now. [23:17] * tsimonq2 wonders if balloons got my subtle hint [23:19] ::salt:: [23:23] fazer, I believe that is correct. [23:24] balloons, and to convert back to a .db file i would run this right? [23:25] sqlite3 .read blank_mediastore [23:31] fazer, I did it by reading back the sql file into a new db [23:31] sqlite3 blank_mediastore.db < blank_mediastore.sql [23:31] k [23:41] fazer, anything else? If not, I'll grab some chow [23:41] balloons, no, I think I'm done. Thank you. [23:42] you are welcome. I hope that helps [23:49] balloons, how exactly does the number of comments influence bug heat?