Gajim - 2018-05-16


  1. bot Logan proposed a new merge request for _gajim/master_ < https://dev.gajim.org/gajim/gajim/merge_requests/246 >: Fix call to config.get_per() in method that gets account name from jid
  2. bbreezin lovetox, ^ small change to fix the get_account_from_jid method you added for me last week
  3. bot Philipp Hörist pushed 1 commit to branch _refs/heads/master_ of _gajim_ < https://dev.gajim.org/gajim/gajim >: *f13ff8ac* < https://dev.gajim.org/gajim/gajim/commit/f13ff8ac68d8e2e015f35e750346acf70ea96c3a > Fix call to config.get_per() in method that gets account name from jid
  4. bot Philipp Hörist merged a merge request for _gajim/master_ < https://dev.gajim.org/gajim/gajim/merge_requests/246 >: Fix call to config.get_per() in method that gets account name from jid
  5. bbreezin lovetox, so when a pre-1.0 log database gets migrated to 1.0, all the account_id fields will be NULL?
  6. lovetox row.account_id will be None
  7. bbreezin So I think for the SQL statements, I want to filter based on rows with account_id matching my search, or account_id being null
  8. lovetox yes
  9. bbreezin Struggling to get that to work in my SELECT statement. I thought AND (account_id in ({account_ids}) OR account_id IS NULL) would work, but it does not
  10. lovetox post me the whole query
  11. bbreezin ''' SELECT MAX(time) as time FROM logs NATURAL JOIN jids WHERE jid IN ({jids}) AND (account_id in ({account_ids}) OR account_id IS NULL) AND kind NOT IN ({kinds}) '''.format(jids=', '.join('?' * len(jids)), account_ids=', '.join('?' * len(account_ids)), kinds=', '.join(kinds))
  12. lovetox and how does this not work?
  13. lovetox it returns nothing? syntax error?
  14. lovetox or not the NULL rows?
  15. lovetox how are you testing this anyway?
  16. lovetox with deleting the value from account_id?
  17. bbreezin doesn't return the NULL rows, only returns the rows with account_id in the list account_ids
  18. lovetox maybe your deleting the value from account_id does not set it NULL in your editor
  19. bbreezin copied my 1.0.2 database to a new one, opened in sqlitebrowser(http://sqlitebrowser.org), set all the account_id fields to NULL
  20. lovetox maybe run a update query
  21. lovetox UPDATE table SET acount_id IS NULL
  22. lovetox try to run the query in sqlite browser
  23. lovetox simplify it
  24. bbreezin I'm thinking they are NULL, something is wrong with the that sql statement that I don't understand. Not sure if it is the interaction with NATURAL JOIN or something. I just opened up a python environment, connected to the sqlite database, and executed "sql = 'SELECT account_id FROM logs WHERE (account_id = 2 OR account_id IS NULL)'"
  25. bbreezin and did a fetchall()
  26. bbreezin and it got all the NULL rows
  27. lovetox hm
  28. bbreezin I'll keep messing with it, just wanted to check if I was missing something obvious
  29. lovetox try: account_id in ({account_ids}, IS NULL)
  30. bbreezin Hmm....actually it looks like it might be working in its current form...I guess I got thrown off expecting multiple records, but that SELECT statement selects only the max() of the matching time fields. So it returns 1 row
  31. bbreezin So it is working....I was just expecting something incorrect. Lol....time for sleep
  32. lovetox ^^
  33. lovetox bbreezin, in what timezone are you?
  34. bbreezin EDT, GMT-4
  35. bbreezin get_account_from_jid() works for what I needed it for, now I can use app.nicks[] again
  36. bbreezin Does anyone ever update an issue on the issue tracker to reflect its being worked on? Not sure if I should do something like that to prevent someone else from seeing an issue and duplicating efforts
  37. lovetox i think the chance of this happening right now is minimal
  38. lovetox but yes i can assign you to the issue
  39. bot Philipp Hörist modified an issue in _gajim_ < https://dev.gajim.org/gajim/gajim/issues/9092 >: #9092: < History mishmash when contact is in roster of 2 accounts >
  40. bot Philipp Hörist modified an issue in _gajim_ < https://dev.gajim.org/gajim/gajim/issues/9092 >: #9092: < History mishmash when contact is in roster of 2 accounts >
  41. bbreezin Can only you assign people? Or could I have assigned myself?
  42. lovetox i added you to the gajim project, you can now assign yourself, and also edit issues
  43. lovetox but for that issue i did the assigning
  44. zuglufttier Is it possible to display a default avatar for those people who don't upload one?
  45. Daniel No not yet. But it was mentioned several times. There is an issue open about it
  46. Daniel And it was discussed for lovetox' messagewindow branch
  47. lovetox depends where
  48. lovetox we already show a default avatar in the chat window
  49. lovetox or do you mean the roster?
  50. zuglufttier Actually I was talking about the roster.
  51. zuglufttier Or will the normal roster be a thing of the past sooner or later?
  52. lovetox we will always have some kind of roster
  53. lovetox but i want to get away to use it to start a conversation
  54. lovetox ctrl + N has default avatars
  55. zuglufttier And "ctrl+n" is looking very good already.
  56. zuglufttier For many users it could replace the roster completely.
  57. Daniel You can have a look at lovetox' branch if you like! Can't remember if it was messagewindow or message_window (I think the latter). In that branch, active conversations are in a list to the left and the actual conversation is displayed on the right. That adds default avatars as well.
  58. zuglufttier Daniel, message_window was closed in 2014: https://dev.gajim.org/gajim/gajim/commits/message_window I was looking over there already, is it hidden?
  59. Daniel No in lovetoxes fork
  60. Daniel https://dev.gajim.org/lovetox/gajim/branches
  61. zuglufttier Ah, alright! I'll have a look there.
  62. Daniel I think messagewindow it is
  63. zuglufttier Daniel, it is!
  64. zuglufttier Looking very good!
  65. Daniel That's what I'm thinking :) but everything needs its time ;)
  66. zuglufttier Of course, there must be thousands of problems that need to be fixed before this will be released ;)
  67. Daniel It needs people testing it before :)
  68. bot Sophie Herold updated a merge request for _gajim/master_ < https://dev.gajim.org/gajim/gajim/merge_requests/240 >: WIP: Idle time for GNOME without X11
  69. bot Sophie Herold updated a merge request for _gajim/master_ < https://dev.gajim.org/gajim/gajim/merge_requests/240 >: Idle time for GNOME without X11
  70. bot Sophie Herold updated a merge request for _gajim/master_ < https://dev.gajim.org/gajim/gajim/merge_requests/240 >: Idle time for GNOME without X11
  71. bot jo-so proposed a new merge request for _gajim/master_ < https://dev.gajim.org/gajim/gajim/merge_requests/247 >: WIP: Rework password.py
  72. Daniel lovetox / asterix, I think @jo-so needs to be enabled for MR pipelines
  73. bbreezin Have we talked about having an option to still display MUC rooms in the roster even when they are open in the message window? I typically run my Gajim as a combined roster/messagewindow, and have multiple messages open. I have to scroll across the message titles at the top to find the MUC I am looking for. It would be easier to just double click it in my roster
  74. bot Aldo Machado created an issue in _gajim_ < https://dev.gajim.org/gajim/gajim/issues/9129 >: #9129: < 177/5000 >
  75. Daniel bbreezin, there's an issue open about it
  76. Daniel Hm, I cannot find it right now but it's been mentioned several times
  77. Daniel There it is! https://dev.gajim.org/gajim/gajim/issues/5289
  78. bot Daniel modified an issue in _gajim_ < https://dev.gajim.org/gajim/gajim/issues/5289 >: #5289: < Saved MUCs always in roster >
  79. bot Philipp Hörist modified an issue in _gajim_ < https://dev.gajim.org/gajim/gajim/issues/9129 >: #9129: < Gajim error on startup >
  80. bot Philipp Hörist updated a merge request for _gajim/master_ < https://dev.gajim.org/gajim/gajim/merge_requests/245 >: Preserve SSL handshake errors order
  81. bot Philipp Hörist pushed 1 commit to branch _refs/heads/master_ of _gajim_ < https://dev.gajim.org/gajim/gajim >: *4f29e2b3* < https://dev.gajim.org/gajim/gajim/commit/4f29e2b353c2adec10c5754d56d8e0ba62fae426 > Preserve SSL handshake errors order Sets are unordered and list with push/pop acts as LIFO, though we need FIFO. Since the number of elements is tiny, no need to use deque. Addresses #9120
  82. bot Philipp Hörist merged a merge request for _gajim/master_ < https://dev.gajim.org/gajim/gajim/merge_requests/245 >: Preserve SSL handshake errors order
  83. bot Markus Wintermann proposed a new merge request for _gajim/master_ < https://dev.gajim.org/gajim/gajim/merge_requests/248 >: WIP: First step for file transfers in log window
  84. troom i started working on adding file transfers to the log
  85. troom maybe someone can have a look
  86. Dubrava Hi. How do I enable the Russian language for Gajim in Windows 10? Adding LANG ru_RU does not work!
  87. zuglufttier Dubrava: It's not working at the moment on windows.
  88. Dubrava zuglufttier‎, And where in the configuration files can I specify the localization?
  89. zuglufttier The translation is not working at all, I think.
  90. andrey.g Dubrava. it is not possible at all. It is a known but not yet resolved issue: https://dev.gajim.org/gajim/gajim/issues/8658
  91. andrey.g Asterix, what was this? I could not send the message for the first time. Only after second try: "[00:01:49] ‎error while sending ... ( The room is currently overactive, please try again later )"
  92. Dubrava zuglufttier‎, andrey.g‎, Thanks for the info.