<html>
<head>
<meta content="text/html; charset=windows-1252"
http-equiv="Content-Type">
</head>
<body text="#000000" bgcolor="#FFFFFF">
Wonderful news!<br>
No fixing earlier databases required. :-)<br>
<br>
Thanks!<br>
Jules.<br>
<br>
<br>
<div class="moz-cite-prefix">On 27/05/2015 15:57, Eythor
Thorsteinsson wrote:<br>
</div>
<blockquote
cite="mid:7088209F-D107-4C3D-932B-BC23D04AA4BB@menandmice.com"
type="cite">
<meta http-equiv="Content-Type" content="text/html;
charset=windows-1252">
I noticed that there were duplicate entries in the db when I added
the autocomplete.
<div class="">So the duplicate names/emails are simply ignored
when collecting addresses for the autocomplete. </div>
<div class="">The users should therefore not notice whether there
are (old) duplicate entries in the db, or not.</div>
<div class=""><br class="">
</div>
<div class="">Eythor</div>
<div class=""><br class="">
</div>
<div class=""><br class="">
<div class=""><br class="">
<div>
<blockquote type="cite" class="">
<div class="">On 27 May 2015, at 13:32, Jules <<a
moz-do-not-send="true" href="mailto:Jules@zend.to"
class="">Jules@zend.to</a>> wrote:</div>
<br class="Apple-interchange-newline">
<div class="">
<meta content="text/html; charset=windows-1252"
http-equiv="Content-Type" class="">
<div text="#000000" bgcolor="#FFFFFF" class=""> I can't
remember how much of the address book code was in
4.11. Are there production DBs out there with this
issue in them already, caused by version 4.11?<br
class="">
<br class="">
If so, fancy writing a tiny bit of PHP for me (in
cleanup.php) that does this please?<br class="">
<br class="">
Thanks!<br class="">
Jules.<br class="">
<br class="">
<br class="">
<div class="moz-cite-prefix">On 27/05/2015 14:18, Rini
van Zetten wrote:<br class="">
</div>
<blockquote cite="mid:5565C40B.4010401@arvoo.nl"
type="cite" class="">
<meta content="text/html; charset=windows-1252"
http-equiv="Content-Type" class="">
Jules,<br class="">
<br class="">
It may be a good idea to remove the duplicate items
in de sqlite db inserted to this 'bug'.<br class="">
<br class="">
<br class="">
I use : 'delete from addressbook where rowid not in
(select min(rowid) from addressbook group by
username,name,email) ;'<br class="">
<br class="">
Regards,<br class="">
<br class="">
Rini<br class="">
<br class="">
<br class="">
<div class="moz-cite-prefix">On 27-05-15 15:07,
Jules wrote:<br class="">
</div>
<blockquote cite="mid:5565C180.6040606@Zend.To"
type="cite" class="">
<pre class="" wrap="">Many thanks for that fix. You're exactly right, that is what I intended.
I have applied the fix to the main code and will do another release very
soon.
Thanks!
Jules.
On 27/05/2015 13:25, Rini van Zetten wrote:
</pre>
<blockquote type="cite" class="">
<pre class="" wrap="">Hi Jules.
I've updated my system and it seems to work ok !
One problem is that adding names to the addressbook in sqlite3 is not always ok.
I've created a patch which resolves it for my system.
--- <a moz-do-not-send="true" href="http://SQLite3.php.org" class="">SQLite3.php.org</a> 2015-05-27 11:32:21.000000000 +0200
+++ SQLite3.php 2015-05-27 14:16:10.828570997 +0200
@@ -1007,8 +1007,8 @@
$name = $this->database->escapeString(trim($recip[0]));
$email = $this->database->escapeString(trim($recip[1]));
$query = $this->arrayQuery(
- sprintf("SELECT COUNT(*) FROM addressbook WHERE username='%s'",
- $name),
+ sprintf("SELECT COUNT(*) FROM addressbook WHERE username='%s' AND name='%s' and email='%s'",
+ $user,$name,$email),
SQLITE3_NUM);
$now = time();
if ($query[0][0]>=1) {
I think the same applies for the SQLite.php file. the Mysql.php is fine.
Regards,
Rini
On 26-05-15 11:44, Jules wrote:
</pre>
<blockquote type="cite" class="">
<pre class="" wrap="">To make life easier for you, I have just put an RPM and a DEB package in
the Beta area of the website:
<a moz-do-not-send="true" class="moz-txt-link-freetext" href="http://zend.to/downloads.php">http://zend.to/downloads.php</a>
Please do try these out and let me know how you get on.
I haven't added them to either of the repos, so you won't automatically
upgrade by mistake.
Cheers,
Jules.
On 25/05/2015 19:54, Jules wrote:
</pre>
<blockquote type="cite" class="">
<pre class="" wrap="">Hi folks!
I've been hard at work today (for a change :-)
The attached tgz file contains **only** the new files that have
changed from the last stable release on the website.
Before you copy them all into place, take a copy of your
/opt/zendto/www
/opt/zendto/templates
/opt/zendto/lib
/opt/zendto/sql
directories, so you aren't about to break anything.
When you unpack the tgz file and copy them into place, make sure they
are readable by all, so their permissions are
-rw-r--r--
There is now a database table 'addressbook' which you probably won't
have. If you are using MySQL then you'll need to re-apply the schema
in /opt/zendto/sql. Read the README.MySQL in there. Don't worry, it
won't delete or overwrite any of your existing tables, but it does
need to play with the indexes (indices?) in the 'addressbook' table to
fix an earlier bug.
Please give this a try **NOT** on a production server, and let me know
if it works for you or not. If there are any problems at all, please
get in touch with me straightaway, I'll keep a close eye on this
address+list for the rest of the week at least.
Here's what's new:
- Added an address book of previously used names and addresses of
recipients.
Many thanks to Eythor Thorsteinsson for providing the UI part to get
this
going.
- Replaced support for old Google CAPTCHA with much nicer new reCAPTCHA.
This is now the default, give it a try! You'll need a pair of free keys
from <a moz-do-not-send="true" class="moz-txt-link-freetext" href="https://www.google.com/recaptcha/admin">https://www.google.com/recaptcha/admin</a>.
- You can now remove a file from the list when creating a new dropoff,
just
click on the X to the right of the file description.
Contributions for a nice little icon would be much appreciated!
(The winner gets an entry in the ChangeLog ;-)
- Resending a dropoff resets the 'created' time so the dropoff will
not be
deleted early. Thanks to Greg Clarke for spotting this one.
- Fixed a bug stopping you removing recipients in the middle of the list.
- Fixed a bug reporting Invalid_email_address incorrectly when doing an
anonymous pickup.
- Fixed a couple of minor bugs.
Jules
Jules
--
Julian Field MEng MBCS CITP CEng
'There is silent poetry in the stillness of morning;
in the calm, the cries & sighs of life sound like gentle music.'
- @Astro_Wheels
<a moz-do-not-send="true" class="moz-txt-link-abbreviated" href="http://www.zend.to/">www.Zend.To</a>
Twitter: @JulesFM
PGP footprint: EE81 D763 3DB0 0BFD E1DC 7222 11F6 5947 1415 B654
</pre>
</blockquote>
<pre class="" wrap="">_______________________________________________
ZendTo mailing list
<a moz-do-not-send="true" class="moz-txt-link-abbreviated" href="mailto:ZendTo@zend.to">ZendTo@zend.to</a>
<a moz-do-not-send="true" class="moz-txt-link-freetext" href="http://mailman.ecs.soton.ac.uk/mailman/listinfo/zendto">http://mailman.ecs.soton.ac.uk/mailman/listinfo/zendto</a>
</pre>
</blockquote>
<pre class="" wrap="">Jules
--
Julian Field MEng MBCS CITP CEng
'When I read Shakespeare I am struck with wonder
That such trivial people should muse and thunder
In such lovely language.' - D.H. Lawrence
<a moz-do-not-send="true" class="moz-txt-link-abbreviated" href="http://www.zend.to/">www.Zend.To</a>
Twitter: @JulesFM
PGP footprint: EE81 D763 3DB0 0BFD E1DC 7222 11F6 5947 1415 B654
</pre>
</blockquote>
<pre class="" wrap="">_______________________________________________
ZendTo mailing list
<a moz-do-not-send="true" class="moz-txt-link-abbreviated" href="mailto:ZendTo@zend.to">ZendTo@zend.to</a>
<a moz-do-not-send="true" class="moz-txt-link-freetext" href="http://mailman.ecs.soton.ac.uk/mailman/listinfo/zendto">http://mailman.ecs.soton.ac.uk/mailman/listinfo/zendto</a>
</pre>
</blockquote>
<br class="">
<div class="moz-signature">-- <br class="">
<b class="">Rini van Zetten<b class=""><br
class="">
<i class="">Senior Software Engineer</i><br
class="">
<br class="">
-------------------------<br class="">
ARVOO Engineering B.V.<br class="">
Tasveld 13<br class="">
3417 XS Montfoort<br class="">
The Netherlands<br class="">
<br class="">
Tel : 0348-418412<br class="">
<br class="">
E-mail : <a moz-do-not-send="true"
href="mailto:rini@arvoo.com" class="">rini@arvoo.com</a><br
class="">
<br class="">
Web : <a moz-do-not-send="true"
href="http://www.arvoo.com/" class="">www.arvoo.com</a><br
class="">
</b></b></div>
<br class="">
<fieldset class="mimeAttachmentHeader"></fieldset>
<br class="">
<pre class="" wrap="">_______________________________________________
ZendTo mailing list
<a moz-do-not-send="true" class="moz-txt-link-abbreviated" href="mailto:ZendTo@zend.to">ZendTo@zend.to</a>
<a moz-do-not-send="true" class="moz-txt-link-freetext" href="http://mailman.ecs.soton.ac.uk/mailman/listinfo/zendto">http://mailman.ecs.soton.ac.uk/mailman/listinfo/zendto</a></pre>
<br class="">
<pre class="moz-signature" cols="72">Jules
--
Julian Field MEng MBCS CITP CEng
<a moz-do-not-send="true" class="moz-txt-link-abbreviated" href="http://www.zend.to/">www.Zend.To</a>
Twitter: @JulesFM
PGP footprint: EE81 D763 3DB0 0BFD E1DC 7222 11F6 5947 1415 B654
</pre>
</blockquote>
</div>
_______________________________________________<br
class="">
ZendTo mailing list<br class="">
<a moz-do-not-send="true" href="mailto:ZendTo@zend.to"
class="">ZendTo@zend.to</a><br class="">
<a class="moz-txt-link-freetext" href="http://mailman.ecs.soton.ac.uk/mailman/listinfo/zendto">http://mailman.ecs.soton.ac.uk/mailman/listinfo/zendto</a></div>
</blockquote>
</div>
<br class="">
</div>
</div>
<br>
<fieldset class="mimeAttachmentHeader"></fieldset>
<br>
<pre wrap="">_______________________________________________
ZendTo mailing list
<a class="moz-txt-link-abbreviated" href="mailto:ZendTo@zend.to">ZendTo@zend.to</a>
<a class="moz-txt-link-freetext" href="http://mailman.ecs.soton.ac.uk/mailman/listinfo/zendto">http://mailman.ecs.soton.ac.uk/mailman/listinfo/zendto</a></pre>
<br>
<pre class="moz-signature" cols="72">Jules
--
Julian Field MEng MBCS CITP CEng
'The paths we take sometimes lead us away from people we know and
love. But in the end what matters is that we affect the lives of
others for the better somehow, whomever we are, whatever our story.
Obsession always destroys what it intended to nurture: but if
you're able to let yourself love honestly and without fear, maybe
that huge heart you have will somehow set you free.' - Eve Lockhart
<a class="moz-txt-link-abbreviated" href="http://www.Zend.To">www.Zend.To</a>
Twitter: @JulesFM
PGP footprint: EE81 D763 3DB0 0BFD E1DC 7222 11F6 5947 1415 B654
</pre>
</blockquote>
</body>
</html>