<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 14:51, Artyom Aleksandrov
wrote:<br>
</div>
<blockquote
cite="mid:CAJtYNb2fKW0zpwEDQd6pN1KHD9EJU3CJ_DSvvs9CdFNLN9KDiQ@mail.gmail.com"
type="cite">Five strings for postinst. If php5-sqlite does not
support sqlite2, sed change default data engine in preferences
file.<br>
In this case user don't get error during install.<br>
<br>
<br>
## Apache restart before<br>
<br>
# Check version of libsqlite use and change database engine if
needed<br>
libsqlite_check=`dpkg-query -W -f='${Depends}\n' php5-sqlite |
grep libsqlite0`<br>
res_libsqlite=$?<br>
if [ ! $res_libsqlite -eq 0 ]; then<br>
sed "s/^define('SqlBackend', 'SQLite')/define('SqlBackend',
'SQLite3')/" -i /opt/zendto/config/preferences.php<br>
fi &nb!
sp; &
nbsp;
<br>
<br>
</blockquote>
Will this do the same in less space?<br>
<br>
dpkg-query -W -f='${Depends}\n' php5-sqlite | grep -q libsqlite0<br>
if [ $? -eq 0 ]; then<br>
sed -e "s/^define('SqlBackend', 'SQLite')/define('SqlBackend',
'SQLite3')/" -i /opt/zendto/config/preferences.php<br>
fi<br>
<br>
No point saving the command output text if you then don't use it,
nor should an intermediate variable be necessary.<br>
:-)<br>
<br>
<br>
Cheers!<br>
Jules.<br>
<br>
<br>
<blockquote
cite="mid:CAJtYNb2fKW0zpwEDQd6pN1KHD9EJU3CJ_DSvvs9CdFNLN9KDiQ@mail.gmail.com"
type="cite">### Setup all the stats logging below<br>
<br>
<br>
<div class="gmail_extra"><br>
<br>
<div class="gmail_quote">On Mon, Nov 19, 2012 at 5:16 PM, Artyom
Aleksandrov <span dir="ltr"><<a moz-do-not-send="true"
href="mailto:mailing.list@tem4uk.ru" target="_blank">mailing.list@tem4uk.ru</a>></span>
wrote:<br>
<blockquote class="gmail_quote" style="margin:0px 0px 0px
0.8ex;border-left:1px solid
rgb(204,204,204);padding-left:1ex">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>
<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>
<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>
<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.
<div class="">
<div class="h5"><br>
<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:0px
0px 0px 0.8ex;border-left:1px solid
rgb(204,204,204);padding-left:1ex">
<div bgcolor="#FFFFFF" text="#000000">
<div> <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><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><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:0px 0px 0px
0.8ex;border-left:1px solid
rgb(204,204,204);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>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" 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>
</blockquote>
</div>
<br>
</div>
</div>
</div>
</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
'We face neither East nor West: we face forward.' - Kwame Nkrumah
</pre>
</blockquote>
</body>
</html>