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.<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: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 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 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 class="h5">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">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>