Re: [fossil-users] email testing - no subscriber table?

2018-06-26 Thread Sam Putman
On Mon, Jun 25, 2018 at 2:51 PM, Richard Hipp wrote: > On 6/25/18, jungle Boogie wrote: > > If I inadvertently forward my email along > > to someone/group without modifying the footer, the person/group would > > be able to alter my subscription. > > How can I fix that? > > -- > D. Richard Hipp >

Re: [fossil-users] email testing - no subscriber table?

2018-06-26 Thread Olivier R.
Le 26/06/2018 à 09:25, j. van den hoff a écrit : On Mon, 25 Jun 2018 23:57:35 +0200, jungle Boogie wrote: On 25 June 2018 at 14:51, Richard Hipp wrote: On 6/25/18, jungle Boogie wrote: If I inadvertently forward my email along to someone/group without modifying the footer, the person/grou

Re: [fossil-users] email testing - no subscriber table?

2018-06-26 Thread j. van den hoff
On Mon, 25 Jun 2018 23:57:35 +0200, jungle Boogie wrote: On 25 June 2018 at 14:51, Richard Hipp wrote: On 6/25/18, jungle Boogie wrote: If I inadvertently forward my email along to someone/group without modifying the footer, the person/group would be able to alter my subscription. How c

Re: [fossil-users] email testing - no subscriber table?

2018-06-25 Thread Dingyuan Wang
Yes. 2018-06-26 02:28, Richard Hipp: > On 6/24/18, Dingyuan Wang wrote: >> >> I just got 50 exactly same "[fossil-src] activity alert" emails >> describing 5 check-ins in three minutes. What's happening to the server? >> > > Did today's digest arrive successfully, and only once? > _

Re: [fossil-users] email testing - no subscriber table?

2018-06-25 Thread jungle Boogie
On 25 June 2018 at 14:51, Richard Hipp wrote: > On 6/25/18, jungle Boogie wrote: >> If I inadvertently forward my email along >> to someone/group without modifying the footer, the person/group would >> be able to alter my subscription. > > How can I fix that? > I don't know, but maybe that idea

Re: [fossil-users] email testing - no subscriber table?

2018-06-25 Thread Richard Hipp
On 6/25/18, jungle Boogie wrote: > If I inadvertently forward my email along > to someone/group without modifying the footer, the person/group would > be able to alter my subscription. How can I fix that? -- D. Richard Hipp d...@sqlite.org ___ fossil-

Re: [fossil-users] email testing - no subscriber table?

2018-06-25 Thread jungle Boogie
On 23 June 2018 at 13:07, Richard Hipp wrote: > Just FYI: > > I have opened up email notifications on the canonical Fossil > repository. To subscribe, visit: > > https://fossil-scm.org/fossil/subscribe > > Your help in finding creative ways of breaking the new system is appreciated. > This i

Re: [fossil-users] email testing - no subscriber table?

2018-06-25 Thread Richard Hipp
On 6/24/18, Dingyuan Wang wrote: > > I just got 50 exactly same "[fossil-src] activity alert" emails > describing 5 check-ins in three minutes. What's happening to the server? > Did today's digest arrive successfully, and only once? -- D. Richard Hipp d...@sqlite.org

Re: [fossil-users] email testing - no subscriber table?

2018-06-25 Thread j. van den hoff
On Mon, 25 Jun 2018 05:08:53 +0200, Andy Goth wrote: On 06/24/18 05:27, j. van den hoff wrote: additionally, mabye shorten the footer separation line to exactly two `--', treating the footer as the sender's "affiliation/identity" (which usually leads to a less prominent display by the ema

Re: [fossil-users] email testing - no subscriber table?

2018-06-24 Thread Andy Goth
On 06/24/18 05:27, j. van den hoff wrote: additionally, mabye shorten the footer separation line to exactly two `--', treating the footer as the sender's "affiliation/identity" (which usually leads to a less prominent display by the email client). If you're talking about email signatures, they

Re: [fossil-users] email testing - no subscriber table?

2018-06-24 Thread Andreas Kupries
> On 6/23/18, Jungle Boogie wrote: > > > > no such table: subscriber SELECT 1 FROM subscriber WHERE suname='jungle' > > The email notification tables are created on-demand. Apparently I > have missed a call to "email_schema()" someplace in the code. Fix > this by running the command: > >

Re: [fossil-users] email testing - no subscriber table?

2018-06-24 Thread Stéphane Aulery
Le 24/06/2018 à 21:04, Richard Hipp a écrit : On 6/24/18, Stéphane Aulery wrote: Hello, Le 23/06/2018 à 22:07, Richard Hipp a écrit : Just FYI: I have opened up email notifications on the canonical Fossil repository. To subscribe, visit: https://fossil-scm.org/fossil/subscribe Your

Re: [fossil-users] email testing - no subscriber table?

2018-06-24 Thread The Tick
On 6/24/2018 2:04 PM, Richard Hipp wrote: I do not (yet) have the bounce-processing logic working in the new email notification system working, and so Fossil was not able to detect that your confirmation request had bounced. Thought I'd mention this. My ISP implements an anti-spam technique

Re: [fossil-users] email testing - no subscriber table?

2018-06-24 Thread Richard Hipp
On 6/24/18, Stéphane Aulery wrote: > Hello, > > Le 23/06/2018 à 22:07, Richard Hipp a écrit : >> Just FYI: >> >> I have opened up email notifications on the canonical Fossil >> repository. To subscribe, visit: >> >> https://fossil-scm.org/fossil/subscribe >> >> Your help in finding creative

Re: [fossil-users] email testing - no subscriber table?

2018-06-24 Thread Stéphane Aulery
Hello, Le 23/06/2018 à 22:07, Richard Hipp a écrit : Just FYI: I have opened up email notifications on the canonical Fossil repository. To subscribe, visit: https://fossil-scm.org/fossil/subscribe Your help in finding creative ways of breaking the new system is appreciated. I subscrib

Re: [fossil-users] email testing - no subscriber table?

2018-06-24 Thread Richard Hipp
On 6/24/18, Dingyuan Wang wrote: > > I just got 50 exactly same "[fossil-src] activity alert" emails Thanks for the report. The problem should be fixed now. There is a variable in the database that remembers when the last digest was sent. Do to a missed COMMIT, that variable was never being up

Re: [fossil-users] email testing - no subscriber table?

2018-06-24 Thread Jungle Boogie
On Sat 23 Jun 2018 4:07 PM, Richard Hipp wrote: > Just FYI: > > I have opened up email notifications on the canonical Fossil > repository. To subscribe, visit: > > https://fossil-scm.org/fossil/subscribe > > Your help in finding creative ways of breaking the new system is appreciated. Not

Re: [fossil-users] email testing - no subscriber table?

2018-06-24 Thread Dingyuan Wang
Hello, I previously set to receive these before unsubscribing: [x] Announcements [x] Check-ins [ ] Ticket changes [x] Wiki [x] Daily digest only I just got 50 exactly same "[fossil-src] activity alert" emails describing 5 check-ins in three minutes. What's happening to the server? Besides the m

Re: [fossil-users] email testing - no subscriber table?

2018-06-24 Thread j. van den hoff
On Sun, 24 Jun 2018 12:22:07 +0200, Richard Hipp wrote: On 6/24/18, j. van den hoff wrote: On Sun, 24 Jun 2018 12:08:30 +0200, Richard Hipp wrote: The UPDATE syntax error should be fixed now. Please try it again. yes, it works now. thank you. NB: I received the notification email rega

Re: [fossil-users] email testing - no subscriber table?

2018-06-24 Thread Richard Hipp
On 6/24/18, j. van den hoff wrote: > On Sun, 24 Jun 2018 12:08:30 +0200, Richard Hipp wrote: > >> The UPDATE syntax error should be fixed now. Please try it again. > > yes, it works now. thank you. NB: I received the notification email > regarding the fix prior to actually confirming the subscri

Re: [fossil-users] email testing - no subscriber table?

2018-06-24 Thread j. van den hoff
On Sun, 24 Jun 2018 12:08:30 +0200, Richard Hipp wrote: The UPDATE syntax error should be fixed now. Please try it again. yes, it works now. thank you. NB: I received the notification email regarding the fix prior to actually confirming the subscription again -- so my confirmation went t

Re: [fossil-users] email testing - no subscriber table?

2018-06-24 Thread Richard Hipp
The UPDATE syntax error should be fixed now. Please try it again. On 6/24/18, j. van den hoff wrote: > I get an sqlite error when following the verification link and hitting the > > `submit' button there: > > SQLITE_ERROR: near "WHERE": syntax error > > Database Error > near "WHERE": syntax erro

Re: [fossil-users] email testing - no subscriber table?

2018-06-24 Thread j. van den hoff
I get an sqlite error when following the verification link and hitting the `submit' button there: SQLITE_ERROR: near "WHERE": syntax error Database Error near "WHERE": syntax error: {UPDATE subscriber SET sdonotcall=0, sdigest=0, ssub='c', smtime=julianday('now'), smip='*', WHERE subsc

Re: [fossil-users] email testing - no subscriber table?

2018-06-23 Thread Olivier R.
Le 23/06/2018 à 22:07, Richard Hipp a écrit : Just FYI: I have opened up email notifications on the canonical Fossil repository. To subscribe, visit: https://fossil-scm.org/fossil/subscribe Your help in finding creative ways of breaking the new system is appreciated. Please note that th

Re: [fossil-users] email testing - no subscriber table?

2018-06-23 Thread Jungle Boogie
On Sat 23 Jun 2018 11:26 PM, Svyatoslav Mishyn wrote: > (Sat, 23 Jun 23:03) Svyatoslav Mishyn: > > quick typos: > > another one (+ previous one): > > -generated once the email notification systems stablizes. > +generated once the email notification systems stabilizes. > > and > > - of the

Re: [fossil-users] email testing - no subscriber table?

2018-06-23 Thread Jungle Boogie
On Sat 23 Jun 2018 4:07 PM, Richard Hipp wrote: > Just FYI: > > I have opened up email notifications on the canonical Fossil > repository. To subscribe, visit: > > https://fossil-scm.org/fossil/subscribe > > Your help in finding creative ways of breaking the new system is appreciated. >

Re: [fossil-users] email testing - no subscriber table?

2018-06-23 Thread Svyatoslav Mishyn
(Sat, 23 Jun 23:03) Svyatoslav Mishyn: > quick typos: another one (+ previous one): -generated once the email notification systems stablizes. +generated once the email notification systems stabilizes. and - of the source tree that shows how to this is done. + of the source tree that s

Re: [fossil-users] email testing - no subscriber table?

2018-06-23 Thread Richard Hipp
Just FYI: I have opened up email notifications on the canonical Fossil repository. To subscribe, visit: https://fossil-scm.org/fossil/subscribe Your help in finding creative ways of breaking the new system is appreciated. Please note that this is still a work-in-progress. All subscription

Re: [fossil-users] email testing - no subscriber table?

2018-06-23 Thread Svyatoslav Mishyn
Hi, (Sat, 23 Jun 13:12) Richard Hipp: > Rough developers notes are available at > https://www.fossil-scm.org/fossil/doc/trunk/www/emaildesign.md for > anybody who wants to experiment with or contribute to this > work-in-progress. quick typos: Index: src/email.c ==

Re: [fossil-users] email testing - no subscriber table?

2018-06-23 Thread Richard Hipp
Rough developers notes are available at https://www.fossil-scm.org/fossil/doc/trunk/www/emaildesign.md for anybody who wants to experiment with or contribute to this work-in-progress. -- D. Richard Hipp d...@sqlite.org ___ fossil-users mailing list foss

Re: [fossil-users] email testing - no subscriber table?

2018-06-23 Thread Richard Hipp
On 6/23/18, Jungle Boogie wrote: > > no such table: subscriber SELECT 1 FROM subscriber WHERE suname='jungle' The email notification tables are created on-demand. Apparently I have missed a call to "email_schema()" someplace in the code. Fix this by running the command: fossil email rese

[fossil-users] email testing - no subscriber table?

2018-06-22 Thread Jungle Boogie
Hi All, I think I've brought my repo up to trunk, did a little configuring of the email page and attempted to add a subscriber, but I have a database error: SQLITE_ERROR: no such table: subscriber Database Error no such table: subscriber SELECT 1 FROM subscriber WHERE suname='jungle' --