[ZendTo] Re: Trial release of new code for ZendTo 4.12-1
Jules
Jules at Zend.To
Wed May 27 16:24:57 BST 2015
Wonderful news!
No fixing earlier databases required. :-)
Thanks!
Jules.
On 27/05/2015 15:57, Eythor Thorsteinsson wrote:
> I noticed that there were duplicate entries in the db when I added the
> autocomplete.
> So the duplicate names/emails are simply ignored when collecting
> addresses for the autocomplete.
> The users should therefore not notice whether there are (old)
> duplicate entries in the db, or not.
>
> Eythor
>
>
>
>> On 27 May 2015, at 13:32, Jules <Jules at zend.to
>> <mailto:Jules at zend.to>> wrote:
>>
>> 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?
>>
>> If so, fancy writing a tiny bit of PHP for me (in cleanup.php) that
>> does this please?
>>
>> Thanks!
>> Jules.
>>
>>
>> On 27/05/2015 14:18, Rini van Zetten wrote:
>>> Jules,
>>>
>>> It may be a good idea to remove the duplicate items in de sqlite db
>>> inserted to this 'bug'.
>>>
>>>
>>> I use : 'delete from addressbook where rowid not in (select
>>> min(rowid) from addressbook group by username,name,email) ;'
>>>
>>> Regards,
>>>
>>> Rini
>>>
>>>
>>> On 27-05-15 15:07, Jules wrote:
>>>> 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:
>>>>> 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 <http://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:
>>>>>> To make life easier for you, I have just put an RPM and a DEB package in
>>>>>> the Beta area of the website:
>>>>>> http://zend.to/downloads.php
>>>>>>
>>>>>> 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:
>>>>>>> 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
>>>>>>> fromhttps://www.google.com/recaptcha/admin.
>>>>>>> - 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
>>>>>>>
>>>>>>> www.Zend.To
>>>>>>> Twitter: @JulesFM
>>>>>>> PGP footprint: EE81 D763 3DB0 0BFD E1DC 7222 11F6 5947 1415 B654
>>>>>> _______________________________________________
>>>>>> ZendTo mailing list
>>>>>> ZendTo at zend.to
>>>>>> http://mailman.ecs.soton.ac.uk/mailman/listinfo/zendto
>>>>>>
>>>>> 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
>>>>>
>>>>> www.Zend.To
>>>>> Twitter: @JulesFM
>>>>> PGP footprint: EE81 D763 3DB0 0BFD E1DC 7222 11F6 5947 1415 B654
>>>> _______________________________________________
>>>> ZendTo mailing list
>>>> ZendTo at zend.to
>>>> http://mailman.ecs.soton.ac.uk/mailman/listinfo/zendto
>>>>
>>>
>>> --
>>> *Rini van Zetten*
>>> /Senior Software Engineer/
>>>
>>> -------------------------
>>> ARVOO Engineering B.V.
>>> Tasveld 13
>>> 3417 XS Montfoort
>>> The Netherlands
>>>
>>> Tel : 0348-418412
>>>
>>> E-mail : rini at arvoo.com <mailto:rini at arvoo.com>
>>>
>>> Web : www.arvoo.com <http://www.arvoo.com/>
>>> **
>>>
>>>
>>> _______________________________________________
>>> ZendTo mailing list
>>> ZendTo at zend.to
>>> http://mailman.ecs.soton.ac.uk/mailman/listinfo/zendto
>>>
>>> Jules
>>>
>>> --
>>> Julian Field MEng MBCS CITP CEng
>>>
>>>
>>> www.Zend.To
>>> Twitter: @JulesFM
>>> PGP footprint: EE81 D763 3DB0 0BFD E1DC 7222 11F6 5947 1415 B654
>> _______________________________________________
>> ZendTo mailing list
>> ZendTo at zend.to <mailto:ZendTo at zend.to>
>> http://mailman.ecs.soton.ac.uk/mailman/listinfo/zendto
>
>
>
> _______________________________________________
> ZendTo mailing list
> ZendTo at zend.to
> http://mailman.ecs.soton.ac.uk/mailman/listinfo/zendto
>
> 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
>
> www.Zend.To
> Twitter: @JulesFM
> PGP footprint: EE81 D763 3DB0 0BFD E1DC 7222 11F6 5947 1415 B654
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://mailman.ecs.soton.ac.uk/pipermail/zendto/attachments/20150527/e503794d/attachment-0001.html
More information about the ZendTo
mailing list