[ZendTo] Re: 4.11 working okay?

Mon Nov 19 13:16:00 GMT 2012

I still got error ('Warning: SQLite3::exec(): table addressbook already
exists in /opt/zendto/lib/SQLite3.php on line 345 ') with your SQLite3 from
attach.

So, I changed it again and  add function DBCheckTable($table).
You can found patch, src file (from this tread) and patched file in attach.

And another one problem in DBUpdateAddressbook().

1) First string
  // SLASH $user =
sqlite_escape_string($user);

    $user = $this->database->escapeString($user);

2) End of func
      $now = time();
      $query = $this->database->exec(
                 sprintf("INSERT INTO addressbook
(username,name,email,lastused) VALUES ('%s','%s','%s','%d')",
                 $user, $name, $email, $now));

As I see 'lastused' set not NULL but in code INSERT do not use this.
I do not include DBUPdateAddressbook in patch because do not understand
exactly what it should do.

On Mon, Nov 19, 2012 at 1:24 PM, Jules <Jules at zend.to> wrote:

>
> On 16/11/2012 16:19, Artyom Aleksandrov wrote:
>
> Hi,
>
> Today I tried last version from site  (4.11-1) on Ubuntu 12.04 with
> sqlite3.
> It's not good =(
>
> 1) After install from deb I got follow error:
>
> PHP Fatal error:  Class 'SQLiteDatabase' not found in
> /opt/zendto/lib/SQLite.php on line 57
>
> Ok. 'postinst' script do not understand that I use sqlite3. It's not
> seriously but not nice for user.
> Just edit preference.conf for use SQlite3 and run dpkg-reconfigure.
>
> I can submit patch for 'postinst' here if you want.
>
> If you've got a change to postinst that would enable it to default to
> SQLite3 on Ubuntu 12 or higher, that would be great, thanks! The postinst
> script currently does not edit preferences.php *at all*, as you'll have to
> edit it by hand anyway before things will work to insert your domain in
> various places and set up the captcha keys.
>
>
> 2) Ops! I catch next error:
>
> PHP Warning:  SQLite3::exec() expects exactly 1 parameter, 2 given in
> /opt/zendto/lib/SQLite3.php on line 331
> ...
> PHP Fatal error:  Call to a member function writeToLog() on a non-object
> in /opt/zendto/lib/SQLite3.php on line 78
>
> After fast comment this if statement with $query->columnType(0) ==
> SQLITE3_NULL I can add user and login.
>
> I have already fixed those two, new (gzipped) SQLite3.php is attached.
>
> Cheers,
> Jules.
>
>
>
>
> So, it's not really good, I think. I'll continue test this case on next
> week.
>
> Good weekends and thank you.
>
>
>
> On Mon, Oct 29, 2012 at 1:00 PM, Jules <Jules at zend.to> wrote:
>
>> There isn't at the moment, but I might change that, yes.
>>
>> At the moment, I'm afraid you'll have to stick to the betas and so on
>> that I release via http://zend.to.
>>
>> Have you tried 4.11? If not, is there any way you could please?
>> Many thanks!
>>
>> Jules.
>>
>> On 26/10/2012 19:31, Brendon Baumgartner wrote:
>> > Is there an svn server we can connect to? Any plans for one if not?
>> >
>> > Sent from my SmartPhone
>> >
>> > On Oct 26, 2012, at 3:04, Jules <Jules at zend.to> wrote:
>> >
>> >> Have people tried the version 4.11 beta release I published?
>> >> Does it work okay?
>> >>
>> >> I need confirmation that there aren't any show-stopping bugs in it
>> >> before I release a "release" version of 4.11.
>> >>
>> >> Thanks all!
>> >>
>> >> Jules
>> >>
>> >> --
>> >> Julian Field MEng MBCS CITP CEng
>> >> www.Zend.To
>> >>
>> >> Twitter: @JulesFM
>> >> PGP footprint: EE81 D763 3DB0 0BFD E1DC 7222 11F6 5947 1415 B654
>> >>
>> >> 'A committee is a group of the unwilling, chosen from the unfit,
>> >>   to do the unnecessary.' - Anon
>> >>
>> >> _______________________________________________
>> >> ZendTo mailing list
>> >> 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
>> > www.Zend.To
>> >
>> > Twitter: @JulesFM
>> > PGP footprint: EE81 D763 3DB0 0BFD E1DC 7222 11F6 5947 1415 B654
>> >
>>  > 'It's in Apple's DNA that technology alone is not enough. It's
>> >   technology married with liberal arts, married with the humanities,
>> >   that yields us the result that makes our hearts sing.' - Steve Jobs
>>  _______________________________________________
>> ZendTo mailing list
>> ZendTo at zend.to
>> http://mailman.ecs.soton.ac.uk/mailman/listinfo/zendto
>>
>
>
>
> _______________________________________________
> ZendTo mailing listZendTo at zend.tohttp://mailman.ecs.soton.ac.uk/mailman/listinfo/zendto
>
>
> Jules
>
> --
> Julian Field MEng MBCS CITP CEngwww.Zend.To
>
>
> Twitter: @JulesFM
> PGP footprint: EE81 D763 3DB0 0BFD E1DC 7222 11F6 5947 1415 B654
>
> 'When a man points a finger at someone else, he should remember
>  that four of his fingers are pointing at himself.' - Louis Nizer
>
>
> _______________________________________________
> ZendTo mailing list
> ZendTo at zend.to
> http://mailman.ecs.soton.ac.uk/mailman/listinfo/zendto
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://mailman.ecs.soton.ac.uk/pipermail/zendto/attachments/20121119/f8ff23dd/attachment-0001.html 
-------------- next part --------------
A non-text attachment was scrubbed...
Name: SQLite3_zendto.tar.gz
Type: application/x-gzip
Size: 12323 bytes
Desc: not available
Url : http://mailman.ecs.soton.ac.uk/pipermail/zendto/attachments/20121119/f8ff23dd/attachment-0001.gz 