<html>
<head>
<meta content="text/html; charset=windows-1252"
http-equiv="Content-Type">
</head>
<body text="#000000" bgcolor="#FFFFFF">
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>
<br>
If so, fancy writing a tiny bit of PHP for me (in cleanup.php) that
does this please?<br>
<br>
Thanks!<br>
Jules.<br>
<br>
<br>
<div class="moz-cite-prefix">On 27/05/2015 14:18, Rini van Zetten
wrote:<br>
</div>
<blockquote cite="mid:5565C40B.4010401@arvoo.nl" type="cite">
<meta content="text/html; charset=windows-1252"
http-equiv="Content-Type">
Jules,<br>
<br>
It may be a good idea to remove the duplicate items in de sqlite
db inserted to this 'bug'.<br>
<br>
<br>
I use : 'delete from addressbook where rowid not in (select
min(rowid) from addressbook group by username,name,email) ;'<br>
<br>
Regards,<br>
<br>
Rini<br>
<br>
<br>
<div class="moz-cite-prefix">On 27-05-15 15:07, Jules wrote:<br>
</div>
<blockquote cite="mid:5565C180.6040606@Zend.To" type="cite">
<pre 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">
<pre 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.
--- SQLite3.php.org 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">
<pre 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">
<pre 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 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 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 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>
<div class="moz-signature">-- <br>
<b>Rini van Zetten<b><br>
<i>Senior Software Engineer</i><br>
<br>
-------------------------<br>
ARVOO Engineering B.V.<br>
Tasveld 13<br>
3417 XS Montfoort<br>
The Netherlands<br>
<br>
Tel : 0348-418412<br>
<br>
E-mail : <a moz-do-not-send="true"
href="mailto:rini@arvoo.com">rini@arvoo.com</a><br>
<br>
Web : <a moz-do-not-send="true" href="http://www.arvoo.com">www.arvoo.com</a><br>
</b></b></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
<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>