[00:11] balloons, are you still here? [00:16] Does anyone know how to fix this error: sqlite3.OperationalError: table schemaVersion already exists [00:24] smajevicirfan, i believe launchpad docs tell you [00:30] balloons: Can I get some more time on this task? https://codein.withgoogle.com/dashboard/task-instances/6125765456297984/ I had some VM issues and Im still trying to get it to actually work, I have most of the code written but there's something somewhere I didnt do so it doesnt work === salem_ is now known as _salem === _salem is now known as salem_ [00:32] balloons, the thing is heat only includes subscribers and duplicates from the 3 listed for the filtering the iso tracker task [00:33] and not the number of comments [01:30] mcinitreevan, time added [01:30] smajevicirfan, I guess I'm missing the context here a little bit [01:31] if you want to ask about filtering, talk to flocculant, as he knows what he wants specifically on that [01:31] I can help more on the technical end :-) [01:31] leaving a message might be best [01:32] mcinitreevan, I see the time rolled over, but you have plenty of time for this round ;-) [01:34] balloons: Haha yeah I re-accepted the task, Im so determined to figure this out, it's kinda hard with no official documentation to go off of though [01:40] balloons, looks like I'm not quite done. I keep getting this error: sqlite3.OperationalError: table 'schemaVersion' already exists [01:41] sorry for bailing earlier btw, I had to go study for my final exams and do other work at home [01:43] fazer, where are you getting that error? [01:44] balloons, when I run my test [01:44] at this line: cur.executescript(sql) [01:44] in _patch_mediascanner_home() [01:44] oh well, it would be nice to run the branch myself and see :-) [01:44] or a full log. It's hard to guess at this point [01:45] however, it sounds like you need to modify the patch. Don't have it create that table again [01:45] but it's confusing because we copied over the existing table which works with that patch [01:46] which is what I was wondering. [01:51] so pushing your changes to a branch would help immensely at this point [01:51] have you finished writing the other bits? [01:51] so once this works it'll be all set or? [01:53] Yup, I believe so. [01:53] I'll push to a branch now [02:06] Heyy [02:09] balloons, this is my branch: https://code.launchpad.net/~vamrocks602/music-app/test-empty-library [02:14] fazer, ok I have to call it a night now, but can look tomorrow. Leave it in a comment on your task for the other mentors :-) [02:14] sounds like it's really close [02:15] sure, no problem. I'll do that. yeah, I hope so. [02:23] Hi I am currently working on this task: https://bugs.launchpad.net/ubuntu/+source/qtcreator-plugin-ubuntu/+bug/1524027 and I was wondering if I am to make the html app an exact copy stylistically, should i be changing the app.css or editing */ubuntu-html5-ui-toolkit/0.1/ambiance/css/appTemplate.css/SASS [02:23] Launchpad bug 1524027 in qtcreator-plugin-ubuntu (Ubuntu) "Adjust HTML5 template to mirror the QML sample app" [Undecided,New] [02:38] It seems like editing the ui-toolkit is a beyond the scope of this project but it's not up to me to make that decision [02:39] but editing the app.css on the might unessecarily convolute the template === salem_ is now known as _salem [02:50] but editing the app.css on the might unessecarily convolute the template [03:49] Up [03:49] Rl [06:58] first time at gci, and we're already at the top of the heap for completed tasks! [06:58] good job admins, mentors, and students!!!!! [07:10] wxl, I reckon 50% of students I have dealt with already ran ubuntu [07:11] that's fantastic, darkxst. i admit to not having discussed it much with my students. [07:11] too busy getting work done XD [07:12] I'm just guessing from there reports [07:13] and quite a lot have said they do, but wanted to try Ubuntu GNOME etc [07:13] ah cool [07:15] one even said he gave his Ubuntu GNOME livecd to his teacher, so had to make a new VM. [07:16] nice [07:16] I've got it on my Laptop for school and running it through a VM for codein on my desktop, don't know anyone else from my school that runs it though [07:21] MatthewAllen, there have been a few, but probably they are in different countries to you ;) === _salem is now known as salem_ === salem_ is now known as _salem === alan_g is now known as alan_g|lunch [14:05] wxl: Wow, how many tasks done so far? === alan_g|lunch is now known as alan_g [15:05] balloons, jose, popey I think we have a lot of Install Ubuntu task [15:06] we should have a hangout for trying to explain different task to students, probably that's the reason their are not getting them [15:25] Hi, pls can you review my task I cannot move on [15:25] And deadline is 3 days so in case of error I will not have time [15:27] rob1507: which is your task? [15:28] Port your favorite go program for snappy using snapcraft [15:30] rob1507: that's a cool task, but I can't help you on that one [15:31] are you familiar with Raspberry or Beaglebone? [15:31] rob1507, I am working on it this morning ;-) [15:33] hey robert1507, do you know how to include the dependencies for the go application [15:33] in the .yaml file [15:34] rob1507, did you manage to publish your snap file?> [15:34] Yes [15:34] no, where do i publish it to, the Ubuntu Software Cetner [15:35] Xcub, github [15:36] snappy can't locate the package if it isn't inside the ubuntu software archives [15:37] rob1507, weird I'm not finding the app in the store [15:37] Look it on github =D in store t was not published [15:37] @balloons, are we supposed to publish the .snap package or the .yaml file? [15:38] xcub, it would be nice to get the snap package uploaded in the store [15:38] For the task, I'd like both to check your work [15:38] doesn't it need to go through a review proces [15:38] did you test the app rob1507, and if so, how? [15:39] xcub, yes, but it's an automated review. [15:39] No I havent tested [15:39] should be quick [15:39] Baloons, I need some review to identify my errors [15:39] rob1507, what does it do? Seems like it's an example application [15:40] rob1507, yes, I'm looking it over now [15:40] so if the package is published to the ubuntu software center, I would just run "sudo snappy install gochatapp" [15:40] on snappy [15:40] xcub, you would publish to myapps [15:40] xcub, so https://myapps.developer.ubuntu.com/dev/click-apps/?format=snap . Read https://developer.ubuntu.com/en/publish/ [15:41] so it would be sudo snappy install gochatapp [15:42] snappy packages can only be built on ubuntu core operating systems right? So if I try to run "sudo snappy install gochatapp" it wouldn't be able to install the app [15:43] *If i try to run it on 15.10 it will not work? [15:44] xcub, you can run snappy locally via kvm, to give you a taste of what it's like on a device [15:44] https://developer.ubuntu.com/en/snappy/start/#snappy-local [15:45] snappy is basically a minimial ubuntu image, where apps can be installed as snapps, and there is security, atomic upgrades and rollback. Things apt doesn't provide [15:45] Reading https://developer.ubuntu.com/en/snappy/ should help [15:48] balloons, are there many errors in my work? [15:50] uploaded the package yesterday, and it says that the automated process got 12 errors. It says I don't have any current approved version [15:51] rob1507, yes you are missing some hooks it seems [15:51] xcub, ohh, what errors did you get? [15:52] All 12 fails were the same: No JSON object could be decoded. Value: "ERROR: could not find required 'hooks' in manifest: {'architecture': ['amd64'], 'description': 'Go and Angular.js Chat Application using Socket.io', 'framework': 'ubuntu-core-15.04-dev1', 'icon': 'meta/icon.png', 'installed-size': '8157', 'maintainer': 'Daniyaal Rasheed @gmail.com>', 'name': 'gochatapp', 'title': 'Go and Angular.js Chat Application using Socket.io', 'version': '1'} ". click-check-security [15:52] balloons, can you give some advice what to do next? [15:52] I also had those errors [15:54] It is hard to find a program to find basic snap as in examples [15:54] rob1507, just checking to see how it runs inside snappy [15:54] we'll need to fix the metadata to start with [15:55] Comparing with the examples, what looks different about your metadata? [15:55] balloons, it is the start :D [15:55] rob1507, the goal isn't to find the simplest program to package, but to package something you find interesting :-) [15:56] the ap i am trying to package is this one: https://github.com/trustmaster/gochat [15:58] balloons, ok can I choose another program? [15:58] rob1507, you most certainly may yes [15:58] And i'm confused about what else to include beside [15:58] parts: [15:58] rob1507, xcub, want to /join #snappy [15:58] gochat-main: [15:58] there's some folks in there who can help us [15:58] ok === RobGev is now known as Rob1507 [16:00] xcub, let's try now to ask them [16:05] balloons, I don't understand, if I choose go project from github, and everthing needed is written here should I have more than 1 part [16:07] more than 1 part? [16:07] you are creating the packaging bits [16:11] balloons, in case of webcam example parts are server and webcam, right? [16:16] yes, that sounds right [17:55] https://codein.withgoogle.com/tasks/4843721241657344/ [17:56] Submitted for review. [17:57] Also balloons, I have an exam tomorrow so wouldn't be able to work on the READMEs today. Will catch up tomorrow. [17:58] Girish, I was thinking about how you were doing [17:58] btw, even after upgrade I'm getting the same error: Couldnt find QtQuick 2.3 [17:59] that doesn't sound fun. I will do the other README tasks right now. I've yet to get to them and I owe you [18:00] it might be worth just moving forward. Someone else can try and get those dependencies added. Your readme's are already a big improvement [18:00] heck, just installing everything in debian/control does work, so :-) [18:00] you can always just say do that, heh [18:02] I also made the terminal READMEs when I was doing the calendar ones. I need to review them as my calendar ones weren't exactly correct the first time. I'll review them and send them to you tomorrow. [18:04] Girish, sounds excellent. Thanks again for taking on these tasks! [18:07] Np! :) === alan_g is now known as alan_g|EOD [18:10] * balloons is slowly adding the other tasks. They'll all be under the readme tag === ubuntu is now known as Guest68909 === Guest68909 is now known as Girish [18:36] done and added [18:53] balloons, I've got pass in click-review :D what I should do now? Just upload? [18:53] Rob1507, ohh excellent. Yea, I'd give it an upload, and try it out on snappy [18:54] Upload on store, right? [18:54] Rob1507, yea, on myapps [18:54] Rob1507, also, elopio could have another look if you'd like [18:55] I talked to him he said that in myapps it will pass too [18:56] Rob1507, ok, so to complete the task, it would be great to have the snap in the store. What app did you end up choosing? [18:57] balloons, The same app I submitted first time. If you want I can change app now, I understood what I am doing, so if you wish I can change [18:58] Rob1507, ohh. I only mention it because I think the first app you did probably doesn't need to go to the store eh? It doesn't do anything right? Just an example? [18:59] It is hard to find an app actually :D but I find some kind of number type converter. I can try to work it out [19:00] balloons, can I submit this for task and then do another program. Just to have some useful thing done? [19:01] Rob1507, yes, no worries. The goal was for you to learn a little about snapcraft [19:01] balloons, I am submitting this and I promise to write another one for a useful program :D [19:02] If you want to post the completed snap again, and submit for review that would be fine [19:02] Is number type converter good one? [19:03] balloons, only snap on GCI website? [19:03] Rob1507, the folks in #snappy might have a good idea for something [19:04] balloons, ok, ask for program there then? [19:05] yea, see what ideas they have [19:12] Hi~ [19:12] i am doing the task https://codein.withgoogle.com/dashboard/task-instances/4816928648462336/ [19:12] balloons, submitted [19:13] but i can't find where to leave a comment on lp [19:13] tsimonq2, ^^ [19:14] Rob1507, I still see it as more work needed: https://codein.withgoogle.com/dashboard/task-instances/4559311409774592/ [19:16] balloons, I think my network was a problem. Any changes now? [19:21] Rob1507, got it. Snap looks good as well [19:23] balloons, Thanks very much. I will send you another one after finding good program to snap, today or tomorrow. [19:47] balloons, how to send the snap to you? [19:58] balloons, https://myapps.developer.ubuntu.com/dev/click-apps/4184/ [20:01] Rob1507, send the snap? what did you call it> [20:01] balloons, I will send it now [20:02] I saw you attached the new snap on submission [20:02] balloons, how to send? [20:03] balloons, as for GCI task, my work was approved. As for new snap, I will send it shortly [20:04] balloons, I published an app on myapps [20:05] ack [20:06] how can you see it? [20:10] Rob1507, you can see it too. Install snappy and then grab it from the store [20:10] balloons, Is it working? :D [20:12] Rob1507, what's the name of the app? [20:12] ytdl-snapcraft [20:13] sudo snappy install ytdl-snapcraft right? [20:15] Rob1507, a third party interface to the store is here: https://uappexplorer.com/apps?type=snappy [20:16] and there is no ytdl [20:19] balloons, i will send you a .snap [20:48] balloons, How can I access people from Ubuntu GNOME Marketing team? [20:48] Rob1507, perhaps contacting the team, or asking in #ubuntu-gnome [20:48] ok [20:49] balloons, thanks a lot for your support === Sal is now known as Guest40817 [21:37] ahayzen, I tried the command you suggested in the comments : CREATE TABLE IF EXISTS 'schemaVersion' (Version integer ) [21:37] but it doesn't recoggnize 'IF' as a command, and I'm also getting the same error as earlier: no such table schemaVersion [21:49] balloons: hm? [21:53] sorry, to fix my last message: it says- table schemaVersion already exists [22:03] ahayzen, I created a base class like you suggested and inherited from it whatever I needed. [22:05] But, the error I was getting earlier, has not been affected, I'm aware that that wasn't the point of making that change but I don't know how to fix this. [22:11] tsimonq2: For the task i am doing, i found out i installed the wrong version of lubuntu image Ծ‸Ծ So don't worry i solved it ! [22:12] But i can't find where to report bug at launch pad... [22:13] Miaomato: you can do it with the ubuntu-bug command [22:13] Miaomato: just ubuntu-bug [22:13] Miaomato: e.g. ubuntu-bug evince [22:15] wxl: ok, thank you. [22:15] fazer, try just removing the create tabel command [22:15] Miaomato: no problem! [22:18] ahayzen, but leave the Delete from command? OR get rid of that too? [22:21] ahayzen, without the CREATE TABLE command I get an error saying that the table doesn't exist, both with and without the delete from command [22:37] HI balloons, I've submitted my package to the software center, but it won't show up yet. Can I just send you the .snap file [22:39] fazer, did you try doing the create table with the if exists...and then doing the delete from as well? [22:40] without knowing what you are exactly talking about, how would "CREATE TABLE IF EXISTS..." even make sense? [22:40] if would only ever try to create a table which already exists, which isn't possible [22:40] wouldn't a "CREATE TABLE IF NOT EXISTS..." statement make more sense? [22:42] ahayzen, yes I did, it didn't recognize the IF as a viable command [22:42] elopio, can you review my task https://codein.withgoogle.com/dashboard/task-instances/5486692492378112/ [22:43] hmmm yeah it would be if not exists as knome said :-) [22:43] it returned a syntax error and in my text editor (gedit) it didn't color it the same as the rest of the commands. Although that probably doesn't mean much [22:43] Yeah, that's what I thought is was supposed to be. [22:44] let me try [22:45] ok that worked, now it gives me the same error, but for a different table. This time for media_attic and media [22:46] ahayzen, I would assume that the IF NOT EXISTS solution wouldn't be viable here as we want to override the previous values and have it be empty. [22:47] if you want to purge the table, then it's better to delete the table and create it; you don't need any IF statements if you know the table doesn't exist (it doesn't since you just deleted it) [22:47] fazer, yeah you'd still need the delete from after... [22:48] ok, makes sense. [22:48] if you look at the other one if does a DROP then CREATE TABLE for the media table [22:48] ok, I'll attempt that. [22:49] fazer, have you seen what happens if you do not inject any database? [22:49] does mediascanner automatically have an empty database, or does it have data from other places in it? [22:49] I'm not sure. I havent attempted that. [22:50] you can also truncate the table if you know the schema is correct [22:50] that only deletes the data, not the table [22:50] then you don't need to re-create it [22:54] ahayzen knome, if I try to either truncate or drop before the create, it says it doesn't exist, but at the create it throws an error saying that it already exists?! [22:54] \o/ [22:55] fazer, what are you actually working on and do you have your code available somewhere? [22:55] knome I'm writing a test for the music-app [22:56] knome, for the music-app we have to inject a database into mediascanner when we are mocking the data (as its gets the locations wrong) [22:56] my branch is here: https://code.launchpad.net/~vamrocks602/music-app/test-empty-library [22:56] but fazer is working on making a test when the library is empty (to check the UI has the empty state components displayed) [22:56] currently, I'm trying to get mediascanner to use a blank database. [22:56] yup, thats right. [22:57] fazer, could you point me to the file you are working with? [22:58] knome, this is what is done currently on the database ... http://bazaar.launchpad.net/~music-app-dev/music-app/trunk/view/head:/tests/autopilot/music_app/content/mediascanner-2.0/mediastore.sql ... and this is the one fazer is working on http://bazaar.launchpad.net/~vamrocks602/music-app/test-empty-library/view/962/tests/autopilot/music_app/content/mediascanner-2.0/blank_mediastore.sql [22:58] here: https://code.launchpad.net/~vamrocks602/music-app/test-empty-library [22:58] knome, I mean here: http://bazaar.launchpad.net/~vamrocks602/music-app/test-empty-library/view/head:/tests/autopilot/music_app/content/mediascanner-2.0/blank_mediastore.sql [22:58] oh ok. [22:59] balloons, Where can I find the source for the ubuntuqa bot? [22:59] ok... so which file has the problems... or both? [22:59] fazer, i'm starting to wonder if you can just skip the injection and it'll be ok, assuming mediascanner2 hasn't picked anything up [22:59] knome, the blank one is the failing one [22:59] i see [23:00] so the file starts with create table [23:00] shouldn't it start with either truncate (which empties) or delete and then create? [23:02] it only creates if not exists [23:02] the same outcome is reached. [23:02] "CREATE TABLE 'schemaVersion' (version INTEGER);" [23:03] oh, I just pushed those changes sorry [23:03] you might have to reload [23:05] and the error is what? [23:05] table already exists if the drop table command is removed [23:06] and table doesn't exist if the drop table command is there [23:06] table being media and media_attic [23:06] oh, ok [23:06] drop table if exists ... [23:10] hjarrell, I don't know that it exists outside of production actually. You mean the bot that goes for lp bugs? [23:10] fazer, I also wonder what would happen if you take out the call to the patching of the database (as that is only really done because the paths are to the wrong location) so as you have not content it might already be blank [23:10] fazer, that would mean removing the call self._patch_mediascanner_home(content_dir, mediascannerpath) in your _create_empty_music_library() [23:11] balloons, Yeah the bot that comments on the lp bugs with the link to the iso page. [23:12] hjarrell, the person to ask would be stgraber, but not sure if / when he'll be around [23:12] ahayzen, trying that now. [23:12] hey knome, ahayzen, fazer. [23:12] hullo balloons [23:12] hello. [23:12] balloons, o/ [23:12] * knome pops a few [23:12] are you thinking of just not mocking the db, as mediascanner presumably will do it [23:13] balloons, yeah that's what i'm thinking [23:13] I like that idea [23:13] balloons, IIRC the injected one was only so we could fix the path names from /home/user/Music -> /tmp/tmpfolder/Music/ [23:14] ahayzen, correct. And lol, you are right. We don't need or want any media. We literally don't need to do anything [23:14] yup :-) [23:14] just as long as there isn't anything already in there it should be ok :-) [23:15] balloons, Can I just email, https://launchpad.net/~stgraber, and ask him about it? [23:16] ok, now I get a autopilot.processSearchError that originates when I run self.app = MusicApp(self.Launcher()) in my MusicAppTestCase class [23:16] that sounds like the music-app isn't starting correctly [23:16] hjarrell, yes [23:16] fazer, can you pastebin the full output ? [23:16] hjarrell, is it stopping you on a task or ? [23:17] * balloons is making dinner, feel free to ping [23:17] I think you are in good hands with ahayzen [23:17] balloons yes: http://paste.ubuntu.com/14040202/ [23:17] ahayzen ^ [23:17] balloons, The task is to modify the bot so it adds the product in the message with the iso link [23:18] hjarrell, ahh right! [23:18] I'm currently working on https://bugs.launchpad.net/ubuntu/+source/qtcreator-plugin-ubuntu/+bug/1524027, I'm wondering if there is a way to access package/project name information for a html5 project so I can add it to the title/header. The only reason for this is so it wont be a static value like "Project name" [23:18] Launchpad bug 1524027 in qtcreator-plugin-ubuntu (Ubuntu) "Adjust HTML5 template to mirror the QML sample app" [Undecided,New] [23:18] by the way, hi guys [23:18] fazer, 'terminate called after throwing an instance of 'std::runtime_error' what(): unable to open database file' .. \o/ [23:18] hjarrell, hmm. again, stgraber would know offhand. i'll have to dig. [23:20] it looks like the manifest.json and .desktop contain that information but I'm not sure if I would be able to parse that succinctly [23:20] so hjarrell, one thing that is admin controllable in the tracker if you will is the bug comment [23:21] you can see it in the admin section of the qatracker [23:21] ahayzen : ok, so it's still trying to open the database? to stop it from trying t oaccess it would I have to get rid of my entire _create_empty_music_library() method? [23:21] fazer, the application will try to access the database when it starts, so its telling us something is wrong with the db [23:22] hjarrell, so it might better to nab a different task for now. Remind me if I don't remember to have a better look tomorrow. [23:22] sorry about that [23:22] fazer, hmm ok well you may have to inject an empty one then :-/ maybe ms2 doesn't generate one in the temporary directory that is used [23:23] ahayzen ok, so then we do hav....... ok [23:23] balloons, Its okay I can always re-select this task later. [23:23] right-o [23:24] fazer, what is the platform you are running on again ? [23:24] wily [23:24] 15.10 [23:25] bvut I have mediascanner packages from xenial [23:25] coolio :-) and doing qmlscene app/music-app.qml works? ... ah yes i remember now [23:25] yup. [23:27] fazer, ok, i think for now continue down the injecting route, i'll have a chat with Victor (the other music-app dev) to see what he thinks as he usually deals with the sql db part :-) [23:27] ahayzen: ok, I'll see what I can do about it. I think i'm close, but.. who knows? anyway, thank you. [23:28] fazer, don't worry, mediascanner is really fiddly to setup a mocked environment, it took us ages to get it right. I looked at your other bits and the main autopilot code looks like it should work once the mocking works :-) [23:29] ahayzen: cool, good to hear. :D [23:30] I also looked into this https://developer.ubuntu.com/api/apps/html5/sdk-15.04.1/RuntimeApi.RuntimeApi/ but i get Application name: ubuntu-html5-app-launcher every time