Re: [Django] #32934: Fix Admin's sidebar height to be dynamic based on visible header

[Django]

#32934: Fix Admin's sidebar height to be dynamic based on visible header
-+-
 Reporter:  gary |Owner:
 |  Hrushikesh Vaidya
 Type:  Bug  |   Status:  assigned
Component:  contrib.admin|  Version:  3.2
 Severity:  Normal   |   Resolution:
 Keywords:   | Triage Stage:  Accepted
Has patch:  1|  Needs documentation:  0
  Needs tests:  0|  Patch needs improvement:  1
Easy pickings:  1|UI/UX:  1
-+-
Changes (by Hrushikesh Vaidya):

 * owner:  (none) => Hrushikesh Vaidya
 * status:  new => assigned


Comment:

 A CSS only approach [https://github.com/django/django/pull/15234 PR]

-- 
Ticket URL: 
Django 
The Web framework for perfectionists with deadlines.

-- 
You received this message because you are subscribed to the Google Groups 
"Django updates" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to django-updates+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/django-updates/066.15c43be642e56207ee31e6ea07ed4d0d%40djangoproject.com.

Re: [Django] #33382: Different count and len result for a distinct QuerySet

[Django]

#33382: Different count and len result for a distinct QuerySet
-+-
 Reporter:  crazy|Owner:  nobody
 Type:  Uncategorized|   Status:  closed
Component:  Database layer   |  Version:  3.2
  (models, ORM)  |
 Severity:  Normal   |   Resolution:  duplicate
 Keywords:   | Triage Stage:
 |  Unreviewed
Has patch:  0|  Needs documentation:  0
  Needs tests:  0|  Patch needs improvement:  0
Easy pickings:  0|UI/UX:  0
-+-

Comment (by crazy):

 Thanks for your patience,  now I understand why there difference, because
 the `id`  field is used for sorting, it interfered with the `distinct`
 results. So if count records, should use `count`.

-- 
Ticket URL: 
Django 
The Web framework for perfectionists with deadlines.

-- 
You received this message because you are subscribed to the Google Groups 
"Django updates" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to django-updates+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/django-updates/067.8ef9b4d44f54656639a8f9b871f42078%40djangoproject.com.

Re: [Django] #31617: Improve overall admin accessibility.

[Django]

#31617: Improve overall admin accessibility.
-+-
 Reporter:  Gustavo Siñovsky |Owner:  Saugat
 |  Rajbhandari
 Type:  New feature  |   Status:  assigned
Component:  contrib.admin|  Version:  dev
 Severity:  Normal   |   Resolution:
 Keywords:  accessibility, ui,   | Triage Stage:
  ux, admin  |  Someday/Maybe
Has patch:  0|  Needs documentation:  0
  Needs tests:  0|  Patch needs improvement:  0
Easy pickings:  1|UI/UX:  1
-+-

Comment (by GitHub ):

 In [changeset:"a0d43a7a6e1c30c08f853ba64e17e148fb6921e6" a0d43a7a]:
 {{{
 #!CommitTicketReference repository=""
 revision="a0d43a7a6e1c30c08f853ba64e17e148fb6921e6"
 Refs #31617 -- Changed dark mode primary-fg to give higher contrast to
 secondary.
 }}}

-- 
Ticket URL: 
Django 
The Web framework for perfectionists with deadlines.

-- 
You received this message because you are subscribed to the Google Groups 
"Django updates" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to django-updates+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/django-updates/067.40b09b5b6fed05d11a3b25b65bf2cbea%40djangoproject.com.

Re: [Django] #33383: Inconsistent capitalization in admin's msgid "the web/Web site today"

[Django]

#33383: Inconsistent capitalization in admin's msgid "the web/Web site today"
---+--
 Reporter:  Carsten Fuchs  |Owner:  nobody
 Type:  Bug|   Status:  closed
Component:  contrib.admin  |  Version:  4.0
 Severity:  Normal |   Resolution:  invalid
 Keywords: | Triage Stage:  Unreviewed
Has patch:  0  |  Needs documentation:  0
  Needs tests:  0  |  Patch needs improvement:  0
Easy pickings:  0  |UI/UX:  0
---+--

Comment (by Claude Paroz):

 I confirm the diagnostic. Updating all po files even when no translations
 have been added/fixed on Transifex would give huge diffs/commits
 (including binary .mo files) without any added value. So when you see
 occurrences of `Web`, that means that translators didn't do their job (on
 time) :-)

-- 
Ticket URL: 
Django 
The Web framework for perfectionists with deadlines.

-- 
You received this message because you are subscribed to the Google Groups 
"Django updates" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to django-updates+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/django-updates/066.f990cd22310d59ea7112bfcdb2f2ed8a%40djangoproject.com.

Re: [Django] #33383: Inconsistent capitalization in admin's msgid "the web/Web site today"

[Django]

#33383: Inconsistent capitalization in admin's msgid "the web/Web site today"
---+--
 Reporter:  Carsten Fuchs  |Owner:  nobody
 Type:  Bug|   Status:  closed
Component:  contrib.admin  |  Version:  4.0
 Severity:  Normal |   Resolution:  invalid
 Keywords: | Triage Stage:  Unreviewed
Has patch:  0  |  Needs documentation:  0
  Needs tests:  0  |  Patch needs improvement:  0
Easy pickings:  0  |UI/UX:  0
---+--
Changes (by Mariusz Felisiak):

 * cc: Claude Paroz (added)
 * status:  new => closed
 * resolution:   => invalid


Comment:

 We don't update locales without any new translated strings that's why for
 some languages you can still find `web` instead of `Web`. As far as I'm
 aware this doesn't cause extra issues because translations would be
 missing anyway.

-- 
Ticket URL: 
Django 
The Web framework for perfectionists with deadlines.

-- 
You received this message because you are subscribed to the Google Groups 
"Django updates" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to django-updates+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/django-updates/066.43445c2667bf309b7a55c7a8c2e70ca1%40djangoproject.com.

Re: [Django] #33328: Use native JS events to trigger 'formset:added'/'formset:removed'

[Django]

#33328: Use native JS events to trigger 'formset:added'/'formset:removed'
-+-
 Reporter:  Claude Paroz |Owner:  Claude
 Type:   |  Paroz
  Cleanup/optimization   |   Status:  assigned
Component:  contrib.admin|  Version:  dev
 Severity:  Normal   |   Resolution:
 Keywords:   | Triage Stage:  Accepted
Has patch:  1|  Needs documentation:  0
  Needs tests:  0|  Patch needs improvement:  0
Easy pickings:  0|UI/UX:  0
-+-
Changes (by Claude Paroz):

 * has_patch:  0 => 1


Comment:

 [https://github.com/django/django/pull/15233 PR]

-- 
Ticket URL: 
Django 
The Web framework for perfectionists with deadlines.

-- 
You received this message because you are subscribed to the Google Groups 
"Django updates" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to django-updates+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/django-updates/065.a385ab8423c4003652a065477e0d130f%40djangoproject.com.

Re: [Django] #33328: Use native JS events to trigger 'formset:added'/'formset:removed'

[Django]

#33328: Use native JS events to trigger 'formset:added'/'formset:removed'
-+-
 Reporter:  Claude Paroz |Owner:  Claude
 Type:   |  Paroz
  Cleanup/optimization   |   Status:  assigned
Component:  contrib.admin|  Version:  dev
 Severity:  Normal   |   Resolution:
 Keywords:   | Triage Stage:  Accepted
Has patch:  0|  Needs documentation:  0
  Needs tests:  0|  Patch needs improvement:  0
Easy pickings:  0|UI/UX:  0
-+-
Changes (by Claude Paroz):

 * owner:  (none) => Claude Paroz
 * status:  new => assigned


-- 
Ticket URL: 
Django 
The Web framework for perfectionists with deadlines.

-- 
You received this message because you are subscribed to the Google Groups 
"Django updates" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to django-updates+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/django-updates/065.9a77d6554b45f9904b927c60facb53c6%40djangoproject.com.

Re: [Django] #33383: Inconsistent capitalization in admin's msgid "the web/Web site today"

[Django]

#33383: Inconsistent capitalization in admin's msgid "the web/Web site today"
---+--
 Reporter:  Carsten Fuchs  |Owner:  nobody
 Type:  Bug|   Status:  new
Component:  contrib.admin  |  Version:  4.0
 Severity:  Normal |   Resolution:
 Keywords: | Triage Stage:  Unreviewed
Has patch:  0  |  Needs documentation:  0
  Needs tests:  0  |  Patch needs improvement:  0
Easy pickings:  0  |UI/UX:  0
---+--
Changes (by Carsten Fuchs):

 * type:  Uncategorized => Bug
 * component:  Uncategorized => contrib.admin


Comment:

 Specifically, locale `de` used to use '''Web''' up to Django 3.2 whereas
 Django 4.0 uses '''web''', but I think that this is a generic issue.

-- 
Ticket URL: 
Django 
The Web framework for perfectionists with deadlines.

-- 
You received this message because you are subscribed to the Google Groups 
"Django updates" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to django-updates+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/django-updates/066.df7dfb73cb6afe81be8fae2aab66b10f%40djangoproject.com.

[Django] #33383: Inconsistent capitalization in admin's msgid "the web/Web site today"

[Django]

#33383: Inconsistent capitalization in admin's msgid "the web/Web site today"
-+
   Reporter:  Carsten Fuchs  |  Owner:  nobody
   Type:  Uncategorized  | Status:  new
  Component:  Uncategorized  |Version:  4.0
   Severity:  Normal |   Keywords:
   Triage Stage:  Unreviewed |  Has patch:  0
Needs documentation:  0  |Needs tests:  0
Patch needs improvement:  0  |  Easy pickings:  0
  UI/UX:  0  |
-+
 In the admin, some locales use the message id
 "Thanks for spending some quality time with the '''web''' site today."
 and others use
 "Thanks for spending some quality time with the '''Web''' site today."

 Using `ack` to count the number of occurrences:
 {{{
 django/contrib/admin/locale$ ack -c -h -I "the web site today"
 31
 django/contrib/admin/locale$ ack -c -h -I "the Web site today"
 65
 }}}

 If I understand things correctly, if the message id with lowercase "web"
 is used, all translations based on the uppercase variant cannot be found,
 and vice versa?

-- 
Ticket URL: 
Django 
The Web framework for perfectionists with deadlines.

-- 
You received this message because you are subscribed to the Google Groups 
"Django updates" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to django-updates+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/django-updates/051.6faf8a8cd4937357c6a15e6f7a09ce61%40djangoproject.com.

Re: [Django] #28889: Use JavaScript to prevent double submission of admin forms

[Django]

#28889: Use JavaScript to prevent double submission of admin forms
-+-
 Reporter:  Manuel Saelices  |Owner:  Marcelo
 Type:   |  Galigniana
  Cleanup/optimization   |   Status:  assigned
Component:  contrib.admin|  Version:  1.11
 Severity:  Normal   |   Resolution:
 Keywords:   | Triage Stage:  Accepted
Has patch:  1|  Needs documentation:  0
  Needs tests:  0|  Patch needs improvement:  1
Easy pickings:  0|UI/UX:  0
-+-

Comment (by Marcelo Galigniana):

 For this issue there are currently 2 approaches:

 - [https://github.com/django/django/pull/15217 Trigger an alert when
 submitting twice]

 - [https://github.com/django/django/pull/15229 Disable buttons while
 submitting]

-- 
Ticket URL: 
Django 
The Web framework for perfectionists with deadlines.

-- 
You received this message because you are subscribed to the Google Groups 
"Django updates" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to django-updates+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/django-updates/067.53a8ecc061ad6da9c098d31f69f3b3a9%40djangoproject.com.

Re: [Django] #33355: Optimize SQLite backend connection functions

[Django]

#33355: Optimize SQLite backend connection functions
-+-
 Reporter:  Adam Johnson |Owner:  Adam
 Type:   |  Johnson
  Cleanup/optimization   |   Status:  closed
Component:  Database layer   |  Version:  dev
  (models, ORM)  |
 Severity:  Normal   |   Resolution:  fixed
 Keywords:   | Triage Stage:  Ready for
 |  checkin
Has patch:  1|  Needs documentation:  0
  Needs tests:  0|  Patch needs improvement:  0
Easy pickings:  0|UI/UX:  0
-+-
Changes (by Mariusz Felisiak):

 * status:  assigned => closed
 * resolution:   => fixed


-- 
Ticket URL: 
Django 
The Web framework for perfectionists with deadlines.

-- 
You received this message because you are subscribed to the Google Groups 
"Django updates" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to django-updates+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/django-updates/068.992b8b40e9f4f31aff5ce0d99a0f2ef9%40djangoproject.com.

Re: [Django] #33355: Optimize SQLite backend connection functions

[Django]

#33355: Optimize SQLite backend connection functions
-+-
 Reporter:  Adam Johnson |Owner:  Adam
 Type:   |  Johnson
  Cleanup/optimization   |   Status:  assigned
Component:  Database layer   |  Version:  dev
  (models, ORM)  |
 Severity:  Normal   |   Resolution:
 Keywords:   | Triage Stage:  Ready for
 |  checkin
Has patch:  1|  Needs documentation:  0
  Needs tests:  0|  Patch needs improvement:  0
Easy pickings:  0|UI/UX:  0
-+-

Comment (by Mariusz Felisiak ):

 In [changeset:"deec15a9a613558b35024637d02d348a8a95deb1" deec15a9]:
 {{{
 #!CommitTicketReference repository=""
 revision="deec15a9a613558b35024637d02d348a8a95deb1"
 Refs #33355 -- Made trunc functions raise ValueError on invalid lookups on
 SQLite.

 Co-Authored-By: Nick Pope 
 }}}

-- 
Ticket URL: 
Django 
The Web framework for perfectionists with deadlines.

-- 
You received this message because you are subscribed to the Google Groups 
"Django updates" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to django-updates+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/django-updates/068.ef93561587972b79741343c8d6000b8a%40djangoproject.com.

Re: [Django] #33355: Optimize SQLite backend connection functions

[Django]

#33355: Optimize SQLite backend connection functions
-+-
 Reporter:  Adam Johnson |Owner:  Adam
 Type:   |  Johnson
  Cleanup/optimization   |   Status:  assigned
Component:  Database layer   |  Version:  dev
  (models, ORM)  |
 Severity:  Normal   |   Resolution:
 Keywords:   | Triage Stage:  Ready for
 |  checkin
Has patch:  1|  Needs documentation:  0
  Needs tests:  0|  Patch needs improvement:  0
Easy pickings:  0|UI/UX:  0
-+-

Comment (by Mariusz Felisiak ):

 In [changeset:"2d991ff661f72195f3a57be66d2bbc761c923f7e" 2d991ff6]:
 {{{
 #!CommitTicketReference repository=""
 revision="2d991ff661f72195f3a57be66d2bbc761c923f7e"
 Refs #33355 -- Moved SQLite functions to separate module.

 Co-Authored-By: Nick Pope 
 }}}

-- 
Ticket URL: 
Django 
The Web framework for perfectionists with deadlines.

-- 
You received this message because you are subscribed to the Google Groups 
"Django updates" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to django-updates+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/django-updates/068.bb1a90004a5ef99e27b5effd0f007617%40djangoproject.com.

Re: [Django] #33355: Optimize SQLite backend connection functions

[Django]

#33355: Optimize SQLite backend connection functions
-+-
 Reporter:  Adam Johnson |Owner:  Adam
 Type:   |  Johnson
  Cleanup/optimization   |   Status:  assigned
Component:  Database layer   |  Version:  dev
  (models, ORM)  |
 Severity:  Normal   |   Resolution:
 Keywords:   | Triage Stage:  Ready for
 |  checkin
Has patch:  1|  Needs documentation:  0
  Needs tests:  0|  Patch needs improvement:  0
Easy pickings:  0|UI/UX:  0
-+-

Comment (by Mariusz Felisiak ):

 In [changeset:"5f6a727a6a06437c8dbafaa18817235c0ed658ca" 5f6a727a]:
 {{{
 #!CommitTicketReference repository=""
 revision="5f6a727a6a06437c8dbafaa18817235c0ed658ca"
 Refs #33355 -- Constructed SQLite list aggregate types once.
 }}}

-- 
Ticket URL: 
Django 
The Web framework for perfectionists with deadlines.

-- 
You received this message because you are subscribed to the Google Groups 
"Django updates" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to django-updates+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/django-updates/068.e0e8ec719425a36ff43ba4c466ab1071%40djangoproject.com.

Re: [Django] #33355: Optimize SQLite backend connection functions

[Django]

#33355: Optimize SQLite backend connection functions
-+-
 Reporter:  Adam Johnson |Owner:  Adam
 Type:   |  Johnson
  Cleanup/optimization   |   Status:  assigned
Component:  Database layer   |  Version:  dev
  (models, ORM)  |
 Severity:  Normal   |   Resolution:
 Keywords:   | Triage Stage:  Ready for
 |  checkin
Has patch:  1|  Needs documentation:  0
  Needs tests:  0|  Patch needs improvement:  0
Easy pickings:  0|UI/UX:  0
-+-

Comment (by Mariusz Felisiak ):

 In [changeset:"ec7554f1c28256fbe0e23fab452e7e9b96711230" ec7554f1]:
 {{{
 #!CommitTicketReference repository=""
 revision="ec7554f1c28256fbe0e23fab452e7e9b96711230"
 Refs #33355 -- Removed @none_guard from SQLite functions.

 Co-Authored-By: Nick Pope 
 }}}

-- 
Ticket URL: 
Django 
The Web framework for perfectionists with deadlines.

-- 
You received this message because you are subscribed to the Google Groups 
"Django updates" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to django-updates+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/django-updates/068.14247a099aecc14a89bda0163904e602%40djangoproject.com.

Re: [Django] #33355: Optimize SQLite backend connection functions

[Django]

#33355: Optimize SQLite backend connection functions
-+-
 Reporter:  Adam Johnson |Owner:  Adam
 Type:   |  Johnson
  Cleanup/optimization   |   Status:  assigned
Component:  Database layer   |  Version:  dev
  (models, ORM)  |
 Severity:  Normal   |   Resolution:
 Keywords:   | Triage Stage:  Ready for
 |  checkin
Has patch:  1|  Needs documentation:  0
  Needs tests:  0|  Patch needs improvement:  0
Easy pickings:  0|UI/UX:  0
-+-
Changes (by Mariusz Felisiak):

 * needs_better_patch:  1 => 0
 * stage:  Accepted => Ready for checkin


-- 
Ticket URL: 
Django 
The Web framework for perfectionists with deadlines.

-- 
You received this message because you are subscribed to the Google Groups 
"Django updates" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to django-updates+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/django-updates/068.4259016621a78dce641d4baac905eae7%40djangoproject.com.

Re: [Django] #33382: Different count and len result for a distinct QuerySet

[Django]

#33382: Different count and len result for a distinct QuerySet
-+-
 Reporter:  crazy|Owner:  nobody
 Type:  Uncategorized|   Status:  closed
Component:  Database layer   |  Version:  3.2
  (models, ORM)  |
 Severity:  Normal   |   Resolution:  duplicate
 Keywords:   | Triage Stage:
 |  Unreviewed
Has patch:  0|  Needs documentation:  0
  Needs tests:  0|  Patch needs improvement:  0
Easy pickings:  0|UI/UX:  0
-+-
Changes (by Mariusz Felisiak):

 * status:  new => closed
 * resolution:   => duplicate
 * component:  Uncategorized => Database layer (models, ORM)


Comment:

 Duplicate of #30655. Please see my
 [https://code.djangoproject.com/ticket/30655#comment:2 comment]:

 ''"`count()` calls `SELECT COUNT(*)` (as described in
 [https://docs.djangoproject.com/en/stable/ref/models/querysets/#count
 docs]) **without taking ordering into account**,..."''

 see also a
 [https://docs.djangoproject.com/en/stable/ref/models/querysets/#distinct
 note] about using `distinct()` on an ordered queryset.

-- 
Ticket URL: 
Django 
The Web framework for perfectionists with deadlines.

-- 
You received this message because you are subscribed to the Google Groups 
"Django updates" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to django-updates+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/django-updates/067.316878c068f20198c5c56251150a7519%40djangoproject.com.