Bug#809211: tracker.debian.org: sqlite backend not usable
Package: tracker.debian.org Severity: normal I am trying to run tracker configured with debian repositories using the sqlite backend, but several tasks are giving: OperationalError: too many columns in result set Tasks that are frequently failing: UpdateRepositoriesTask UpdatePackageBugStats UpdateLintianStatsTask UpdateExcusesTask UpdateBuildLogCheckStats DebianWatchFileScannerUpdate UpdateSecurityIssuesTask UpdateUbuntuStatsTask UpdateWnppStatsTask I have tried the following with little success: Use a small subset of repositories Recompile libsqlite with #define SQLITE_MAX_COLUMN 32767 Hack the querysets like http://stackoverflow.com/questions/7106016/too-many-sql-variables-error-in-django-witih-sqlite3 I think sqlite does not scale and we should not recommend it, in the setting files: # If you want to run a development setup close to what's running on # tracker.debian.org, then uncomment the next two lines. from .debian import * - from .db_sqlite import DATABASES + from .db_postgresql import DATABASES and remove db_sqlite.py. Note we have a warning in the documentation: Distro Tracker does not rely on any database specific features and as such should be able to run on top of any database server. The only possible known issue is when using sqlite3 which has a limit on the number of query parameters of 999 on some systems. Cheers, Christophe
Bug#809213: tracker.debian.org: reveal documentation
Package: tracker.debian.org Severity: normal Currently most of the documentation is hidden: we have a link to the contributing section, but once there there is little hint about the other chapters (the left column is only a subset of the documentation and one need to click on "table of contents" to access it fully) I would replace the "How to contribute" link target with: https://tracker.debian.org/docs/index.html Note for some reason I do not remember the content of the HTML footer is customised on the server. Cheers, Christophe
Bug#778240: tracker.debian.org has much worse display clarity
Le 18/12/2015 15:38, Raphael Hertzog a écrit :
> I use v4 alpha2 currently. I have no experience rebuilding bootstrap
> currently but there are some docs:
> http://v4-alpha.getbootstrap.com/getting-started/build-tools/
>[...]
> Once rebuilt you just have to put the .css file in
> distro_tracker/html/static/css/bootstrap.min.css and you should be able to
> try it out rather quickly with a local instance.
I don't think it's a good idea to modify bootstrap with
tracker.debian.org preferences inside without changing his filename
because someone who wan to update bootstrap.min.css will remove the
custom styles if he/she doesn't notice the file is not the
basic one.
> But before spending lots of time with bootstrap, have a try by tweaking
> distro_tracker/core/static/css/style.css and adding CSS for the list-group
> and list-group-item classes to reduce the vertical padding and margin...
It's a easier start. I have done a little tweak on the file:
- background more dark
- less vertical space for list element.
There is a temporary hosted demo at
http://stephane.yaal.fr/tmp/tracker/DebianPackageTrackerMost.html
I hope this example helps for further discussion.
There is 2 minors problems in the previous example:
- some icons are not properly displayed. It's due to the save method I
used so it's not important.
- The "Go" button for the search is more or less the same color as the
new background color. It's easily fixable. I didn't do it because the
new background color will probably change between the demo and the final
version.
You can find the .diff of style.css in attachment.
--
Stéphane
2a3,6
> body{
> background-color: #eee;
> }
>
176c180
< padding: 5px 5px 5px 5px;
---
> padding: 2px 5px 2px 5px;
287a292
>
signature.asc
Description: OpenPGP digital signature
Bug#778240: tracker.debian.org has much worse display clarity
Stéphane Blondon writes ("Re: Bug#778240: tracker.debian.org has much worse
display clarity"):
> Le 18/12/2015 15:38, Raphael Hertzog a écrit :
> > But before spending lots of time with bootstrap, have a try by tweaking
> > distro_tracker/core/static/css/style.css and adding CSS for the list-group
> > and list-group-item classes to reduce the vertical padding and margin...
>
> It's a easier start. I have done a little tweak on the file:
> - background more dark
> - less vertical space for list element.
Oh, thanks for looking into this. As you see I hadn't yet managed to
do so myself. Thanks for (effectively) prodding and also for clearing
away the `how to start hacking on this' yak which I was slightly stuck
on.)
> There is a temporary hosted demo at
> http://stephane.yaal.fr/tmp/tracker/DebianPackageTrackerMost.html
I think this is an improvement.
IMO though the light weight of the font is the biggest problem.
I took what you had and messed about with it and discovered that I was
able to make the new tracker look much more like the old tracker with
some very simple further changes to the style.css:
http://www.chiark.greenend.org.uk/~ijackson/2015/tracker-font/DebianPackageTrackerMost.html
Ian.
>From 11e83091f08ee221d6748ab442bcf399ef0748c9 Mon Sep 17 00:00:00 2001
From: Ian Jackson
Date: Mon, 28 Dec 2015 12:54:23 +
Subject: [PATCH] Denser use of screen space
Override some bootstrap-provided defaults:
* Switch default font. "Helvetica Neue" is very light. These other
fonts are heavier. This is more readable at any particular font
size.
* Use black writing rather than dark grey writing.
* Use a slightly darker shade of blue for links.
* Set the font size to 100% of the user's requested size.
(Why would you ever set this to something else for ordinary
body text?!)
* Set the line-height to 1. This gets a lot more info on
the screen at any particular font size.
Signed-off-by: Ian Jackson
---
DebianPackageTrackerMost_fichiers/style.css |8
1 files changed, 8 insertions(+), 0 deletions(-)
diff --git a/DebianPackageTrackerMost_fichiers/style.css
b/DebianPackageTrackerMost_fichiers/style.css
index 0b33cbf..fd158ee 100644
--- a/DebianPackageTrackerMost_fichiers/style.css
+++ b/DebianPackageTrackerMost_fichiers/style.css
@@ -2,6 +2,14 @@
body{
background-color: #eee;
+font-family: "DejaVu Sans","Bitstream Vera Sans",sans-serif;
+color: #000;
+font-size: 100%;
+line-height: 1;
+}
+
+a:link{
+color: #0530D7;
}
.page-header {
--
1.7.2.5
[1] http://www.chiark.greenend.org.uk/~ijackson/2015/tracker-font/.git/
also, but done in a totally hacky way
Watchfile checker not updating?
Hi, It seems the watchfile checker may not be updating? This page[1] shows that it is accessing an old version of the package - new version with fixed watchfile was uploaded on 9 December. It may be related to sources.debian.net not updating for a while? [1] https://qa.debian.org/cgi-bin/watchfile-error.cgi?package=hidapi Thanks, Scott
