Re: [WebDNA] Crashing Database
This WebDNA talk-list message is from 2011
It keeps the original formatting.
numero = 106181
interpreted = N
texte = There is no real new feature in 7.0. It is more a transition version =toward the WebDNA i had in mind when we bought it to SmithMicro.We fixed some remaining bugs and added few things. We also changed the =[append] tag to be much much faster. Here a list:-----Fixed: The serial number validation routine fails out with a wrong =number, and causes the page not reloading.-----The libmysqlclient.so.15/libmysqlclient.so.16 problem for the glibcv3 =version:Ubuntu 10.xx comes with libmysqlclient.so.16, and webdna.fcgi requests =libmysqlclient.so.15The two versions of libmysqlclient aren't binary compatible, which is =why the soname was changed from 15 to 16. There is no way to build a =single binary that works with both libraries. We built two binaries.-----Changed: The 6.2 code always reloaded the db after 100 lines. We changed =this for 1,000 lines on 7.0 code.-----Fixed: the [append] tag was writing to DISK instead or writing to RAM. =It now depends on the AutoCommit value in prefs.If true, it will append each line as before.If false, it will buffer in memory.-----Fixed: the [formvariables] context bug when using =ENCTYPE=3D"multipart/form-data": issue with the processing of multipart =post.-----Fixed: [sendmail] problem with the FreeBSD version beacuse of a =threading problem. Fixed by forcing it to use libpthread instead of =libc_r-----Fixed: bug when the [math] variable name includes a number like in =[math]thetest3=3D43[/math]---New: added the new tag [thirurlplusget]so the [thisurl] tag will produce this:/x/y/z/index.dnaand the [thirurlplusget] tag will produce this:/x/y/z/index.dna?a=3Db&c=3Dd---New: /WebCatalog folder eliminated---New: config file is now webdna.ini---New: [isaccelerated] tag returns "T" or "F"---Fixed: a local copy runs as "licensed" when called through 127.0.0.1 or ="localhost"---Fixed: triggers now work with unlicensed version---Fixed: the triggers are not properly working---New: added a solid blowfish code to [encrypt]---Fixed: [returnraw] - http status codes was not working on all platforms =due of Apache 2.0 changes in the API and also the WebDNA module was not =accommodating all status codes.---Fixed: [createdate] and [moddate] were being confused on unix machines =in both the [listfiles] context and [fileinfo] context.---Fixed: [date format=3D] was not working on all platforms---Fixed: mysql Windows bug---New: xalan and xerces are now integrated into the binary---New: [thishost] shows the server name WebDNA is running on---New: [listallcontexts] shows a list of all reserved context names---New: [thisport] shows the port number of the server WebDNA is running =on.---Bug: xerces has some flaws under OSX. See below[xmlparse =var=3Dxml_var1&source=3D[url]http://gdata.youtube.com/feeds/api/videos/-/v=olleyball[/url]][/xmlparse][xmlnode ref=3Dxml_var1&path=3Dnamed:feed][name]=3D[value]
[xmlnodes] - [name]=3D[value]
[xmlnodes] - [name]=3D[value]
[/xmlnodes][/xmlnodes][/xmlnode]A workaround is to write the WEBDNA to download the XML file, and then =include it in the XMLParsePseudo code:[DOWNLOAD FILE source=3Dhttp://.....][XMLParse vars=3Dblah][include target file.xml][/XMLParse]---Fixed: [setmimeheader] is now working as expectedexample: [setmimeheader name=3DContent-Type&value=3Dtext/xml]---Fixed: [shownext] was not properly working under OSX with apache---Fixed: PATH_TRANSLATED under OSX and Solaris---New: [islicensed] with two values: "T" or "F". If the License number =matches the domain, we will get a "T", otherwise, we get a "F" and =WebDNA will run as freeware.---Fixed: was not working---Fixed: [decrypt] could not decrypt the seed "TEMPLATE", for use with =encrypted templates=20---New: SMTP auth enable with [sendmail].. both a global setting and a =over-riding local setting option (ie. within the [sendmail] context)---Fixed: [setcookie] was not writing anymore to the browser.---Fixed: [redirect] was not working anymore.---Fixed: Passing a value to a page using GET like =test.dna?thetest=3Dthisisasmalltest was just passing "[thetest]" in the =browser: it was not interpreted and showed up.---Fixed: Introducing an URL variable name using a context name was =producing strange results. The ?text=3D bug is now checking for known =contexts, and if it is not a known context, it does the appropriate =thing. For example, the variable setting via GET is working, but the =?text=3D is blocked---Fixed: [appendfile file=3Dtest.html]More text[/appendfile] was creating =an empty file when it should have written "More text" in it. File =permission of index.html was 644---Fixed: [writefile file=3Dtest.html]Some text[/writefile] was creating an =empty file when it should have written "Some text" in it. File =permission of index.html was 660---Fixed: [ipaddress] was not working anymore under OSX---Fixed: [referrer] was showing "FastCGI" instead of the real refering =page under OSX.---Fixed: the delete command could delete items in a database, even when it =is not allowed as a (URL) command.---Deprecated: XML-like syntaxDeprecated: [applescript]Deprecated: phone home systemDeprecated: the URL command systemDeprecated: sandboxes and "global"Deprecated: old licensing system (domain limits, versions=85)On Jan 25, 2011, at 16:22, Olin Lagon wrote:> Is there a list of just new features in 7, if any? Will this work on =OSX using multiple local domains (via httpd-vhosts)? I'd love to give =the OSX version a spin.>=20> Also, is there a set of instructions for CentOS?>=20> Thanks! Olin>=20> christophe.billiottet@webdna.us wrote:>> Sure! i mail it privately.>>=20>> - chris>>=20>>=20>> On Jan 25, 2011, at 14:35, Steve Craig wrote:>>=20>>=20>>> Hi Chris>>>=20>>> I'm just about to set up a new in-house server for our internal =accounts and stuff. Could I try the version 7 please on OSX?>>>=20>>> Cheers>>> =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D==3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D>>> Steve Craig - Asylum Interactive Ltd>>> Tel +44 1330 860550 Fax +44 1330 860880>>> =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D==3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D>>>=20>>> http://www.asylumweb.com>>>=20>>> Email:=20>>> steve@asylumweb.com>>>=20>>> Skype: s.craig - iChat: steve.craig>>> =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D==3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D>>>=20>>>=20>>>=20>>>=20>>> On 25 Jan 2011, at 09:37,=20>>> christophe.billiottet@webdna.us>>> wrote:>>>=20>>>=20>>>> Version 7.0 is not officially released yet: we are still working on =the Windows version and we are in the process of raising funds to launch =a successful marketing campaign. I will be glad to provide a 7.0 version =to whoever is asking for it but you will be on your own to install it. =Ken already wrote a "manual" on how to install WebDNA 7.0 with lighttpd =(highly recommended if you don't need apache) and the OSX install =process with apache is also documented.>>>>=20>>> --------------------------------------------------------->>> This message is sent to you because you are subscribed to>>> the mailing list=20>>>
>>> .>>> To unsubscribe, E-mail to:=20>>> >>>=20>>> archives:=20>>> http://mail.webdna.us/list/talk@webdna.us>>>=20>>> Bug Reporting:=20>>> support@webdna.us>>=20>> --------------------------------------------------------->> This message is sent to you because you are subscribed to>> the mailing list=20>> >> .>> To unsubscribe, E-mail to:=20>> >>=20>> archives:=20>> http://mail.webdna.us/list/talk@webdna.us>>=20>> Bug Reporting:=20>> support@webdna.us> --------------------------------------------------------- This message =is sent to you because you are subscribed to the mailing list . To =unsubscribe, E-mail to: archives: =http://mail.webdna.us/list/talk@webdna.us Bug Reporting: =support@webdna.us
Associated Messages, from the most recent to the oldest:
There is no real new feature in 7.0. It is more a transition version =toward the WebDNA i had in mind when we bought it to SmithMicro.We fixed some remaining bugs and added few things. We also changed the =[append] tag to be much much faster. Here a list:-----Fixed: The serial number validation routine fails out with a wrong =number, and causes the page not reloading.-----The libmysqlclient.so.15/libmysqlclient.so.16 problem for the glibcv3 =version:Ubuntu 10.xx comes with libmysqlclient.so.16, and webdna.fcgi requests =libmysqlclient.so.15The two versions of libmysqlclient aren't binary compatible, which is =why the soname was changed from 15 to 16. There is no way to build a =single binary that works with both libraries. We built two binaries.-----Changed: The 6.2 code always reloaded the db after 100 lines. We changed =this for 1,000 lines on 7.0 code.-----Fixed: the [append] tag was writing to DISK instead or writing to RAM. =It now depends on the AutoCommit value in prefs.If true, it will append each line as before.If false, it will buffer in memory.-----Fixed: the [formvariables] context bug when using =ENCTYPE=3D"multipart/form-data": issue with the processing of multipart =post.-----Fixed: [sendmail] problem with the FreeBSD version beacuse of a =threading problem. Fixed by forcing it to use libpthread instead of =libc_r-----Fixed: bug when the [math] variable name includes a number like in =[math]thetest3=3D43[/math]---New: added the new tag [thirurlplusget]so the [thisurl] tag will produce this:/x/y/z/index.dnaand the [thirurlplusget] tag will produce this:/x/y/z/index.dna?a=3Db&c=3Dd---New: /WebCatalog folder eliminated---New: config file is now webdna.ini---New: [isaccelerated] tag returns "T" or "F"---Fixed: a local copy runs as "licensed" when called through 127.0.0.1 or ="localhost"---Fixed: triggers now work with unlicensed version---Fixed: the triggers are not properly working---New: added a solid blowfish code to [encrypt]---Fixed: [returnraw] - http status codes was not working on all platforms =due of Apache 2.0 changes in the API and also the WebDNA module was not =accommodating all status codes.---Fixed: [createdate] and [moddate] were being confused on unix machines =in both the [listfiles] context and [fileinfo] context.---Fixed: [date format=3D] was not working on all platforms---Fixed: mysql Windows bug---New: xalan and xerces are now integrated into the binary---New: [thishost] shows the server name WebDNA is running on---New: [listallcontexts] shows a list of all reserved context names---New: [thisport] shows the port number of the server WebDNA is running =on.---Bug: xerces has some flaws under OSX. See below[xmlparse =var=3Dxml_var1&source=3D[url]http://gdata.youtube.com/feeds/api/videos/-/v=olleyball[/url]][/xmlparse][xmlnode ref=3Dxml_var1&path=3Dnamed:feed][name]=3D[value]
[xmlnodes] - [name]=3D[value]
[xmlnodes] - [name]=3D[value]
[/xmlnodes][/xmlnodes][/xmlnode]A workaround is to write the WEBDNA to download the XML file, and then =include it in the XMLParsePseudo code:[DOWNLOAD FILE source=3Dhttp://.....][XMLParse vars=3Dblah][include target file.xml][/XMLParse]---Fixed: [setmimeheader] is now working as expectedexample: [setmimeheader name=3DContent-Type&value=3Dtext/xml]---Fixed: [shownext] was not properly working under OSX with apache---Fixed: PATH_TRANSLATED under OSX and Solaris---New: [islicensed] with two values: "T" or "F". If the License number =matches the domain, we will get a "T", otherwise, we get a "F" and =WebDNA will run as freeware.---Fixed: was not working---Fixed: [decrypt] could not decrypt the seed "TEMPLATE", for use with =encrypted templates=20---New: SMTP auth enable with [sendmail].. both a global setting and a =over-riding local setting option (ie. within the [sendmail] context)---Fixed: [setcookie] was not writing anymore to the browser.---Fixed: [redirect] was not working anymore.---Fixed: Passing a value to a page using GET like =test.dna?thetest=3Dthisisasmalltest was just passing "[thetest]" in the =browser: it was not interpreted and showed up.---Fixed: Introducing an URL variable name using a context name was =producing strange results. The ?text=3D bug is now checking for known =contexts, and if it is not a known context, it does the appropriate =thing. For example, the variable setting via GET is working, but the =?text=3D is blocked---Fixed: [appendfile file=3Dtest.html]More text[/appendfile] was creating =an empty file when it should have written "More text" in it. File =permission of index.html was 644---Fixed: [writefile file=3Dtest.html]Some text[/writefile] was creating an =empty file when it should have written "Some text" in it. File =permission of index.html was 660---Fixed: [ipaddress] was not working anymore under OSX---Fixed: [referrer] was showing "FastCGI" instead of the real refering =page under OSX.---Fixed: the delete command could delete items in a database, even when it =is not allowed as a (URL) command.---Deprecated: XML-like syntaxDeprecated: [applescript]Deprecated: phone home systemDeprecated: the URL command systemDeprecated: sandboxes and "global"Deprecated: old licensing system (domain limits, versions=85)On Jan 25, 2011, at 16:22, Olin Lagon wrote:> Is there a list of just new features in 7, if any? Will this work on =OSX using multiple local domains (via httpd-vhosts)? I'd love to give =the OSX version a spin.>=20> Also, is there a set of instructions for CentOS?>=20> Thanks! Olin>=20> christophe.billiottet@webdna.us wrote:>> Sure! i mail it privately.>>=20>> - chris>>=20>>=20>> On Jan 25, 2011, at 14:35, Steve Craig wrote:>>=20>>=20>>> Hi Chris>>>=20>>> I'm just about to set up a new in-house server for our internal =accounts and stuff. Could I try the version 7 please on OSX?>>>=20>>> Cheers>>> =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D==3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D>>> Steve Craig - Asylum Interactive Ltd>>> Tel +44 1330 860550 Fax +44 1330 860880>>> =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D==3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D>>>=20>>> http://www.asylumweb.com>>>=20>>> Email:=20>>> steve@asylumweb.com>>>=20>>> Skype: s.craig - iChat: steve.craig>>> =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D==3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D>>>=20>>>=20>>>=20>>>=20>>> On 25 Jan 2011, at 09:37,=20>>> christophe.billiottet@webdna.us>>> wrote:>>>=20>>>=20>>>> Version 7.0 is not officially released yet: we are still working on =the Windows version and we are in the process of raising funds to launch =a successful marketing campaign. I will be glad to provide a 7.0 version =to whoever is asking for it but you will be on your own to install it. =Ken already wrote a "manual" on how to install WebDNA 7.0 with lighttpd =(highly recommended if you don't need apache) and the OSX install =process with apache is also documented.>>>>=20>>> --------------------------------------------------------->>> This message is sent to you because you are subscribed to>>> the mailing list=20>>> >>> .>>> To unsubscribe, E-mail to:=20>>> >>>=20>>> archives:=20>>> http://mail.webdna.us/list/talk@webdna.us>>>=20>>> Bug Reporting:=20>>> support@webdna.us>>=20>> --------------------------------------------------------->> This message is sent to you because you are subscribed to>> the mailing list=20>> >> .>> To unsubscribe, E-mail to:=20>> >>=20>> archives:=20>> http://mail.webdna.us/list/talk@webdna.us>>=20>> Bug Reporting:=20>> support@webdna.us> --------------------------------------------------------- This message =is sent to you because you are subscribed to the mailing list . To =unsubscribe, E-mail to: archives: =http://mail.webdna.us/list/talk@webdna.us Bug Reporting: =support@webdna.us
christophe.billiottet@webdna.us
DOWNLOAD WEBDNA NOW!
Top Articles:
Talk List
The WebDNA community talk-list is the best place to get some help: several hundred extremely proficient programmers with an excellent knowledge of WebDNA and an excellent spirit will deliver all the tips and tricks you can imagine...
Related Readings:
notification solutions (1997)
Forms Search Questions (1997)
DataBaseHelper Flawed (1997)
sendmail what is SIMS? (1999)
[isfile] ? (1997)
customizing the color of user's pages (1997)
This might sound silly... (2000)
Erotic Sites (1997)
[INCLUDE] Limitations (1998)
Bug? (1997)
show me your store ! (2003)
Netscape 3.01 can't see db in form (1997)
Strange Crash (1998)
default value from Lookup (was Grant, please help me) (1997)
Getting the protocol (2004)
A question on sub-categories (1997)
How can I Add several Items into the cart at once? (1997)
(2000)
Date search - yes or no (1997)
Sum of [founditems] ? (2004)