[ZendTo] Re: 4.11 working okay?
Jules
Jules at Zend.To
Mon Nov 19 16:09:21 GMT 2012
On 19/11/2012 13:16, Artyom Aleksandrov wrote:
> 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.
Many thanks for that. Yes, your version is far neater than the mess I
cobbled together!
>
>
>
> And another one problem in DBUpdateAddressbook().
>
> 1) First string
> // SLASH $user = sqlite_escape_string($user);
> $user = $this->database->escapeString($user);
Well spotted.
>
> 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));
You can do this more neatly (I believe) with
$query = $this->database->exec(
sprintf("INSERT INTO addressbook
(username,name,email,lastused) VALUES ('%s','%s','%s',now())",
$user, $name, $email);
>
> 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.
That's fine, I think you've got everything covered above.
Many thanks!
Jules.
>
>
>
> On Mon, Nov 19, 2012 at 1:24 PM, Jules <Jules at zend.to
> <mailto: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
>> <mailto: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
>> <mailto: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 <http://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 <mailto:ZendTo at zend.to>
>> >> http://mailman.ecs.soton.ac.uk/mailman/listinfo/zendto
>> > _______________________________________________
>> > ZendTo mailing list
>> > ZendTo at zend.to <mailto:ZendTo at zend.to>
>> > http://mailman.ecs.soton.ac.uk/mailman/listinfo/zendto
>> >
>> > Jules
>> >
>> > --
>> > Julian Field MEng MBCS CITP CEng
>> > www.Zend.To <http://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 <mailto:ZendTo at zend.to>
>> http://mailman.ecs.soton.ac.uk/mailman/listinfo/zendto
>>
>>
>>
>>
>> _______________________________________________
>> ZendTo mailing list
>> ZendTo at zend.to <mailto:ZendTo at zend.to>
>> http://mailman.ecs.soton.ac.uk/mailman/listinfo/zendto
>>
>> Jules -- Julian Field MEng MBCS CITP CEng www.Zend.To
>> <http://www.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 <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
> www.Zend.To
>
> Twitter: @JulesFM
> PGP footprint: EE81 D763 3DB0 0BFD E1DC 7222 11F6 5947 1415 B654
>
> 'When I read Shakespeare I am struck with wonder
> That such trivial people should muse and thunder
> In such lovely language.' - D.H. Lawrence
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://mailman.ecs.soton.ac.uk/pipermail/zendto/attachments/20121119/ee0839ef/attachment-0001.html
More information about the ZendTo
mailing list