<html>
<head>
<meta content="text/html; charset=ISO-8859-1"
http-equiv="Content-Type">
</head>
<body bgcolor="#FFFFFF" text="#000000">
<br>
<div class="moz-cite-prefix">On 19/11/2012 13:16, Artyom Aleksandrov
wrote:<br>
</div>
<blockquote
cite="mid:CAJtYNb1GXHWWU76JX+GJCbCye+RA6=4pExdjFdBCXSmA=ZGJPg@mail.gmail.com"
type="cite">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.<br>
<br>
So, I changed it again and add function DBCheckTable($table).<br>
You can found patch, src file (from this tread) and patched file
in attach.<br>
</blockquote>
Many thanks for that. Yes, your version is far neater than the mess
I cobbled together!<br>
<br>
<blockquote
cite="mid:CAJtYNb1GXHWWU76JX+GJCbCye+RA6=4pExdjFdBCXSmA=ZGJPg@mail.gmail.com"
type="cite"><br>
<br>
<br>
And another one problem in DBUpdateAddressbook().<br>
<br>
1) First string<br>
// SLASH $user =
sqlite_escape_string($user); &!
nbsp; 
;
<br>
$user = $this->database->escapeString($user);<br>
</blockquote>
Well spotted.<br>
<blockquote
cite="mid:CAJtYNb1GXHWWU76JX+GJCbCye+RA6=4pExdjFdBCXSmA=ZGJPg@mail.gmail.com"
type="cite"><br>
2) End of func<br>
$now = time();<br>
$query = $this->database->exec(<br>
sprintf("INSERT INTO addressbook
(username,name,email,lastused) VALUES ('%s','%s','%s','%d')",<br>
$user, $name, $email, $now));<br>
</blockquote>
You can do this more neatly (I believe) with<br>
$query = $this->database->exec(<br>
sprintf("INSERT INTO addressbook
(username,name,email,lastused) VALUES ('%s','%s','%s',now())",<br>
$user, $name, $email);<br>
<br>
<br>
<blockquote
cite="mid:CAJtYNb1GXHWWU76JX+GJCbCye+RA6=4pExdjFdBCXSmA=ZGJPg@mail.gmail.com"
type="cite"><br>
As I see 'lastused' set not NULL but in code INSERT do not use
this.<br>
I do not include DBUPdateAddressbook in patch because do not
understand exactly what it should do.<br>
</blockquote>
That's fine, I think you've got everything covered above.<br>
<br>
Many thanks!<br>
Jules.<br>
<br>
<blockquote
cite="mid:CAJtYNb1GXHWWU76JX+GJCbCye+RA6=4pExdjFdBCXSmA=ZGJPg@mail.gmail.com"
type="cite">
<br>
<div class="gmail_extra"><br>
<br>
<div class="gmail_quote">On Mon, Nov 19, 2012 at 1:24 PM, Jules
<span dir="ltr"><<a moz-do-not-send="true"
href="mailto:Jules@zend.to" target="_blank">Jules@zend.to</a>></span>
wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0
.8ex;border-left:1px #ccc solid;padding-left:1ex">
<div bgcolor="#FFFFFF" text="#000000">
<div class="im"> <br>
<div>On 16/11/2012 16:19, Artyom Aleksandrov wrote:<br>
</div>
<blockquote type="cite">Hi,<br>
<br>
Today I tried last version from site (4.11-1) on
Ubuntu 12.04 with sqlite3. <br>
It's not good =(<br>
<br>
1) After install from deb I got follow error:<br>
<br>
PHP Fatal error: Class 'SQLiteDatabase' not found in
/opt/zendto/lib/SQLite.php on line 57<br>
<br>
Ok. 'postinst' script do not understand that I use
sqlite3. It's not seriously but not nice for user.<br>
Just edit preference.conf for use SQlite3 and run
dpkg-reconfigure.<br>
<br>
I can submit patch for 'postinst' here if you want.<br>
</blockquote>
</div>
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.
<div class="im"><br>
<blockquote type="cite"> <br>
2) Ops! I catch next error:<br>
<br>
PHP Warning: SQLite3::exec() expects exactly 1
parameter, 2 given in /opt/zendto/lib/SQLite3.php on
line 331<br>
...<br>
PHP Fatal error: Call to a member function
writeToLog() on a non-object in
/opt/zendto/lib/SQLite3.php on line 78<br>
<br>
After fast comment this if statement with
$query->columnType(0) == SQLITE3_NULL I can add
user and login.<br>
</blockquote>
</div>
I have already fixed those two, new (gzipped) SQLite3.php
is attached.<br>
<br>
Cheers,<br>
Jules.<br>
<br>
<br>
<br>
<blockquote type="cite">
<div>
<div class="h5"><br>
So, it's not really good, I think. I'll continue
test this case on next week.<br>
<br>
Good weekends and thank you.<br>
<br>
<div class="gmail_extra"><br>
<br>
<div class="gmail_quote">On Mon, Oct 29, 2012 at
1:00 PM, Jules <span dir="ltr"><<a
moz-do-not-send="true"
href="mailto:Jules@zend.to" target="_blank">Jules@zend.to</a>></span>
wrote:<br>
<blockquote class="gmail_quote" style="margin:0
0 0 .8ex;border-left:1px #ccc
solid;padding-left:1ex"> There isn't at the
moment, but I might change that, yes.<br>
<br>
At the moment, I'm afraid you'll have to stick
to the betas and so on<br>
that I release via <a moz-do-not-send="true"
href="http://zend.to" target="_blank">http://zend.to</a>.<br>
<br>
Have you tried 4.11? If not, is there any way
you could please?<br>
Many thanks!<br>
<br>
Jules.<br>
<div>
<div><br>
On 26/10/2012 19:31, Brendon Baumgartner
wrote:<br>
> Is there an svn server we can connect
to? Any plans for one if not?<br>
><br>
> Sent from my SmartPhone<br>
><br>
> On Oct 26, 2012, at 3:04, Jules <<a
moz-do-not-send="true"
href="mailto:Jules@zend.to"
target="_blank">Jules@zend.to</a>>
wrote:<br>
><br>
>> Have people tried the version
4.11 beta release I published?<br>
>> Does it work okay?<br>
>><br>
>> I need confirmation that there
aren't any show-stopping bugs in it<br>
>> before I release a "release"
version of 4.11.<br>
>><br>
>> Thanks all!<br>
>><br>
>> Jules<br>
>><br>
>> --<br>
>> Julian Field MEng MBCS CITP CEng<br>
>> <a moz-do-not-send="true"
href="http://www.Zend.To"
target="_blank">www.Zend.To</a><br>
>><br>
>> Twitter: @JulesFM<br>
>> PGP footprint: EE81 D763 3DB0
0BFD E1DC 7222 11F6 5947 1415 B654<br>
>><br>
>> 'A committee is a group of the
unwilling, chosen from the unfit,<br>
>> to do the unnecessary.' - Anon<br>
>><br>
>>
_______________________________________________<br>
>> ZendTo mailing list<br>
>> <a moz-do-not-send="true"
href="mailto:ZendTo@zend.to"
target="_blank">ZendTo@zend.to</a><br>
>> <a moz-do-not-send="true"
href="http://mailman.ecs.soton.ac.uk/mailman/listinfo/zendto"
target="_blank">http://mailman.ecs.soton.ac.uk/mailman/listinfo/zendto</a><br>
>
_______________________________________________<br>
> ZendTo mailing list<br>
> <a moz-do-not-send="true"
href="mailto:ZendTo@zend.to"
target="_blank">ZendTo@zend.to</a><br>
> <a moz-do-not-send="true"
href="http://mailman.ecs.soton.ac.uk/mailman/listinfo/zendto"
target="_blank">http://mailman.ecs.soton.ac.uk/mailman/listinfo/zendto</a><br>
><br>
> Jules<br>
><br>
> --<br>
> Julian Field MEng MBCS CITP CEng<br>
> <a moz-do-not-send="true"
href="http://www.Zend.To"
target="_blank">www.Zend.To</a><br>
><br>
> Twitter: @JulesFM<br>
> PGP footprint: EE81 D763 3DB0 0BFD
E1DC 7222 11F6 5947 1415 B654<br>
><br>
</div>
</div>
> 'It's in Apple's DNA that technology
alone is not enough. It's<br>
> technology married with liberal arts,
married with the humanities,<br>
> that yields us the result that makes
our hearts sing.' - Steve Jobs<br>
<div>
<div>_______________________________________________<br>
ZendTo mailing list<br>
<a moz-do-not-send="true"
href="mailto:ZendTo@zend.to"
target="_blank">ZendTo@zend.to</a><br>
<a moz-do-not-send="true"
href="http://mailman.ecs.soton.ac.uk/mailman/listinfo/zendto"
target="_blank">http://mailman.ecs.soton.ac.uk/mailman/listinfo/zendto</a><br>
</div>
</div>
</blockquote>
</div>
<br>
</div>
<br>
<fieldset></fieldset>
<br>
<pre>_______________________________________________
ZendTo mailing list
<a moz-do-not-send="true" href="mailto:ZendTo@zend.to" target="_blank">ZendTo@zend.to</a>
<a moz-do-not-send="true" href="http://mailman.ecs.soton.ac.uk/mailman/listinfo/zendto" target="_blank">http://mailman.ecs.soton.ac.uk/mailman/listinfo/zendto</a></pre>
<br>
</div>
</div>
<pre cols="72"><div><div class="h5">Jules
--
Julian Field MEng MBCS CITP CEng
<a moz-do-not-send="true" href="http://www.Zend.To" target="_blank">www.Zend.To</a></div></div>
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
</pre>
</blockquote>
</div>
<br>
_______________________________________________<br>
ZendTo mailing list<br>
<a moz-do-not-send="true" href="mailto:ZendTo@zend.to">ZendTo@zend.to</a><br>
<a moz-do-not-send="true"
href="http://mailman.ecs.soton.ac.uk/mailman/listinfo/zendto"
target="_blank">http://mailman.ecs.soton.ac.uk/mailman/listinfo/zendto</a><br>
</blockquote>
</div>
<br>
</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
'When I read Shakespeare I am struck with wonder
That such trivial people should muse and thunder
In such lovely language.' - D.H. Lawrence
</pre>
</blockquote>
</body>
</html>