Re: [fossil-users] TH1: expr -2147483648

2014-02-05 Thread Sergei Gavrikov
On Tue, 4 Feb 2014, Joe Mistachkin wrote: This should now be fixed, along with another issue. Thanks! Sergei ___ fossil-users mailing list fossil-users@lists.fossil-scm.org http://lists.fossil-scm.org:8080/cgi-bin/mailman/listinfo/fossil-users

Re: [fossil-users] https-over-proxy

2014-02-05 Thread Jan Nijtmans
2014-02-04 Jan Nijtmans jan.nijtm...@gmail.com: Currently, the jan-httpsproxytunnel has a single left bug: when checking certificates, the host being compared is the one from the proxy while it should be the end-point host. As soon as that bug is fixed (should be easy for you), I would

[fossil-users] Query to fetch ancestors of a wiki page

2014-02-05 Thread Stephan Beal
Hi, all, here's a query which can fetch the entire lineage of a given wiki page... WITH RECURSIVE page_name(name) AS( SELECT -- 'home' -- long history 'HackersGuide' -- short history ), wiki_tagids(rid,mtime) AS ( SELECT x.rid AS rid, x.mtime AS mtime FROM tag t, tagxref x,

Re: [fossil-users] Query to fetch ancestors of a wiki page

2014-02-05 Thread Stephan Beal
On Wed, Feb 5, 2014 at 8:03 PM, Stephan Beal sgb...@googlemail.com wrote: Hi, all, here's a query which can fetch the entire lineage of a given wiki page... Or for all pages with just minor modifications... WITH RECURSIVE page_name(name) AS( select substr(t.tagname,6) from tag t where