[ZendTo] Re: 4.11 working okay?
Artyom Aleksandrov
mailing.list at tem4uk.ru
Wed Nov 21 16:04:26 GMT 2012
> No point saving the command output text if you then don't use it, nor
should an intermediate variable be necessary. :-)
Of course. =)
I had tested 4.11 little bit but do not caught any bug more.
On Mon, Nov 19, 2012 at 8:19 PM, Jules <Jules at zend.to> wrote:
>
> On 19/11/2012 14:51, Artyom Aleksandrov wrote:
>
> Five strings for postinst. If php5-sqlite does not support sqlite2, sed
> change default data engine in preferences file.
> In this case user don't get error during install.
>
>
> ## Apache restart before
>
> # Check version of libsqlite use and change database engine if needed
> libsqlite_check=`dpkg-query -W -f='${Depends}\n' php5-sqlite | grep
> libsqlite0`
> res_libsqlite=$?
> if [ ! $res_libsqlite -eq 0 ]; then
> sed "s/^define('SqlBackend', 'SQLite')/define('SqlBackend',
> 'SQLite3')/" -i /opt/zendto/config/preferences.php
> fi &nb!
> sp; & nbsp;
>
> Will this do the same in less space?
>
> dpkg-query -W -f='${Depends}\n' php5-sqlite | grep -q libsqlite0
> if [ $? -eq 0 ]; then
> sed -e "s/^define('SqlBackend', 'SQLite')/define('SqlBackend',
> 'SQLite3')/" -i /opt/zendto/config/preferences.php
> fi
>
> No point saving the command output text if you then don't use it, nor
> should an intermediate variable be necessary.
> :-)
>
>
> Cheers!
> Jules.
>
>
> ### Setup all the stats logging below
>
>
>
>
> On Mon, Nov 19, 2012 at 5:16 PM, Artyom Aleksandrov <
> mailing.list at tem4uk.ru> 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.
>>
>>
>>
>> And another one problem in DBUpdateAddressbook().
>>
>> 1) First string
>> // SLASH $user =
>> sqlite_escape_string($user); &!
>> nbsp;  ;
>> $user = $this->database->escapeString($user);
>>
>> 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));
>>
>> 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.
>>
>>
>>
>>
>> On Mon, Nov 19, 2012 at 1:24 PM, Jules <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> 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> 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
>>>> >>
>>>> >> 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
>>>> >> 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
>>>> >
>>>> > '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
>>>> http://mailman.ecs.soton.ac.uk/mailman/listinfo/zendto
>>>>
>>>
>>>
>>>
>>> _______________________________________________
>>> ZendTo mailing listZendTo at zend.tohttp://mailman.ecs.soton.ac.uk/mailman/listinfo/zendto
>>>
>>>
>>> Jules
>>>
>>> --
>>> Julian Field MEng MBCS CITP CEngwww.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
>>> http://mailman.ecs.soton.ac.uk/mailman/listinfo/zendto
>>>
>>
>>
>
>
> _______________________________________________
> ZendTo mailing listZendTo at zend.tohttp://mailman.ecs.soton.ac.uk/mailman/listinfo/zendto
>
>
> Jules
>
> --
> Julian Field MEng MBCS CITP CEngwww.Zend.To
>
>
> 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
>
>
> _______________________________________________
> ZendTo mailing list
> ZendTo at zend.to
> http://mailman.ecs.soton.ac.uk/mailman/listinfo/zendto
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://mailman.ecs.soton.ac.uk/pipermail/zendto/attachments/20121121/3eda771c/attachment-0001.html
More information about the ZendTo
mailing list