| *** cody-somerville has quit IRC | 02:08 | |
| *** cody-somerville has joined #storyboard | 03:54 | |
| *** cody-somerville has quit IRC | 04:11 | |
| *** cody-somerville has joined #storyboard | 05:44 | |
| *** jcoufal has joined #storyboard | 07:07 | |
| *** openstackgerrit has quit IRC | 07:46 | |
| *** openstackgerrit has joined #storyboard | 07:47 | |
| *** jcoufal has quit IRC | 09:06 | |
| *** jcoufal has joined #storyboard | 09:09 | |
| Zara | updated mysql for my instance since it was giving me peculiar errors. I'm still getting them. :( | 10:35 |
|---|---|---|
| Zara | this is annoying for two reasons, 1) because I don't want storyboard to do this sort of thing, and 2) because I like to review patches by trying to break them, more than by looking at the code. | 10:37 |
| *** mrmartin has joined #storyboard | 12:10 | |
| *** jcoufal has quit IRC | 13:37 | |
| *** jcoufal has joined #storyboard | 13:40 | |
| *** jcoufal has left #storyboard | 13:44 | |
| SotK | is it something about not being able to find a fulltext index? | 14:09 |
| Zara | yeah | 14:09 |
| Zara | a very long 500 error | 14:09 |
| SotK | aha, I forgot a step to fixing it | 14:10 |
| SotK | since you created the database in mysql 5.5 the fulltext indexes for the tables don't exist | 14:10 |
| SotK | you'll need to add them manually | 14:10 |
| Zara | ¬_¬ | 14:11 |
| Zara | just kidding, oh well :P | 14:11 |
| Zara | I've been busy with conference stuff today anyway. | 14:11 |
| SotK | "alter table stories add fulltext search(`title`, `description`);" for the stories table for example | 14:12 |
| Zara | okay, I understand it in theory, but I've barely touched sql beyond running the instructions given in the storyboard install guide; any guides for what I need to do, syntax-wise? (eg: i'm not sure if that should be `mysql -u $user -p $pass ALTER TABLES <stuff>` on the command line; I'm guessing 'probably' :)) | 14:16 |
| persia | I usually run `mysql -u $user -p $pass` by itself (ideally encoding the authentication so that it isn't in the command line), and then run the SQL interactiecly att he prompt (after "use $database") | 14:18 |
| SotK | I do what persia does | 14:18 |
| persia | You can also pass the sql directly on the command line, or with stdin. | 14:18 |
| persia | (or with <<< if you want to be extra fancy) | 14:18 |
| SotK | the tables which are supposed to have fulltext indices (and the columns to index in those tables) can be gleaned from storyboard/db/models.py in storyboard.git | 14:21 |
| Zara | ahh, thanks | 14:30 |
| Zara | hmm, tasks have a fulltext column but not a table name | 14:32 |
| Zara | oh, most of them seem to be like that. is the class name the relevant name, then? | 14:33 |
| Zara | but then it can't be because it was 'stories', not 'story' | 14:34 |
| *** MarkAtwood has joined #storyboard | 14:37 | |
| * Zara is wary of guessing at it in case she messes up her database | 14:39 | |
| persia | Adding an index isn't likely to do anything except possibly slow some queries. | 14:44 |
| persia | And you can remove it with a "DROP INDEX ..." command. | 14:44 |
| Zara | I'm confused because the first table I wanted to alter was 'stories', which matches the table name for the class 'story', but then none of the others which are supposed to have fulltext indices have names. I'd assumed the 'stories' in the command corresponded to the table name | 14:46 |
| Zara | going by models.py, anyway. | 14:48 |
| persia | Yes, the table name should be in the command. | 14:48 |
| persia | You may want to list tables, just to see. | 14:49 |
| Zara | (so for tasks: "alter table ??? add fulltext search(`title`);" ; I suppose I can just try out 'tasks' and see what happens, just odd because there's no __tablename__ listed in models.py.) | 14:49 |
| Zara | ah okay I'll try that | 14:49 |
| SotK | the table name is normally the pluralised version of the class name from models.py | 14:50 |
| Zara | heh, thanks. I now have a list of tables and can see that you're right. :) today I learned a thing! \o/ | 14:52 |
| Zara | at first I didn't realise that use storyboard; and <foo other command> had to be two separate things. that was fun | 14:53 |
| Zara | ooh, interesting | 14:57 |
| Zara | projects have names and descriptions | 14:57 |
| Zara | I remember wanting to change it to 'title' to be consistent; mordred left a todo in model.py which sounds like he was thinking along similar lines. | 14:57 |
| SotK | I wish they had titles too, so it was possible to give them a prettified name | 14:58 |
| Zara | okay, things should be updated on my end. time to test... | 15:03 |
| Zara | it works | 15:06 |
| Zara | \o/ | 15:06 |
| Zara | and I can now confirm that your patch fixes the offset problem | 15:07 |
| Zara | whew | 15:09 |
| Zara | thanks for all your help, both of you, and glad I was able to review it at last. :) | 15:11 |
| SotK | \o/ thanks | 15:13 |
| Zara | I'm still getting the other odd 500 errors if I try to edit the descriptions of my older stories, but that's a separate thing. | 15:16 |
| *** mrmartin has quit IRC | 15:26 | |
| *** mrmartin has joined #storyboard | 15:28 | |
| *** MarkAtwood has quit IRC | 15:42 | |
| *** mrmartin has quit IRC | 16:37 | |
| *** mrmartin has joined #storyboard | 19:51 | |
| *** mrmartin has quit IRC | 20:13 | |
| *** jongchoi has joined #storyboard | 22:36 | |
| *** jongchoi has quit IRC | 22:36 | |
Generated by irclog2html.py 2.14.0 by Marius Gedminas - find it at mg.pov.lt!