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 <br><br>### 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 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); <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 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 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 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 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 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 href="mailto:ZendTo@zend.to" target="_blank">ZendTo@zend.to</a><br>
>> <a 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 href="mailto:ZendTo@zend.to" target="_blank">ZendTo@zend.to</a><br>
> <a 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 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 href="mailto:ZendTo@zend.to" target="_blank">ZendTo@zend.to</a><br>
<a 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 href="mailto:ZendTo@zend.to" target="_blank">ZendTo@zend.to</a>
<a 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 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 href="mailto:ZendTo@zend.to" target="_blank">ZendTo@zend.to</a><br>
<a 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>