Re: [WebDNA] Crashing Database

This WebDNA talk-list message is from

2011


It keeps the original formatting.
numero = 106184
interpreted = N
texte = Chris my biggest concern is the [returnraw] and [setmimeheader]. Were=20 these fixed in the CICADA edition? And if so how can I get that for my=20 current servers running on RedHat 4ES? Matt Perosi On 1/25/2011 2:04 PM, christophe.billiottet@webdna.us wrote: > There is no real new feature in 7.0. It is more a transition version to= ward 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 numb= er, and causes the page not reloading. > ----- > The libmysqlclient.so.15/libmysqlclient.so.16 problem for the glibcv3 v= ersion: > Ubuntu 10.xx comes with libmysqlclient.so.16, and webdna.fcgi requests = libmysqlclient.so.15 > The two versions of libmysqlclient aren't binary compatible, which is w= hy the soname was changed from 15 to 16. There is no way to build a singl= e binary that works with both libraries. We built two binaries. > ----- > Changed: The 6.2 code always reloaded the db after 100 lines. We change= d 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 threadi= ng problem. Fixed by forcing it to use libpthread instead of libc_r > ----- > Fixed: bug when the [math] variable name includes a number like in [mat= h]thetest3=3D43[/math] > --- > New: added the new tag [thirurlplusget] > > so the [thisurl] tag will produce this: > /x/y/z/index.dna > > and 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 o= n. > --- > Bug: xerces has some flaws under OSX. See below > > [xmlparse var=3Dxml_var1&source=3D[url]http://gdata.youtube.com/feeds/a= pi/videos/-/volleyball[/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 XMLParse > Pseudo code: > [DOWNLOAD FILE source=3Dhttp://.....] > [XMLParse vars=3Dblah][include target file.xml][/XMLParse] > --- > Fixed: [setmimeheader] is now working as expected > example: [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 ma= tches the domain, we will get a "T", otherwise, we get a "F" and WebDNA w= ill run as freeware. > --- > Fixed: was not working > --- > Fixed: [decrypt] could not decrypt the seed "TEMPLATE", for use with en= crypted templates > --- > New: SMTP auth enable with [sendmail].. both a global setting and a ove= r-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=3Dthis= isasmalltest was just passing "[thetest]" in the browser: it was not inte= rpreted and showed up. > --- > Fixed: Introducing an URL variable name using a context name was produc= ing 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 exa= mple, the variable setting via GET is working, but the ?text=3D is blocke= d > --- > Fixed: [appendfile file=3Dtest.html]More text[/appendfile] was creating= an empty file when it should have written "More text" in it. File permis= sion of index.html was 644 > --- > Fixed: [writefile file=3Dtest.html]Some text[/writefile] was creating a= n empty file when it should have written "Some text" in it. File permissi= on of index.html was 660 > --- > Fixed: [ipaddress] was not working anymore under OSX > --- > Fixed: [referrer] was showing "FastCGI" instead of the real refering pa= ge under OSX. > --- > Fixed: the delete command could delete items in a database, even when i= t is not allowed as a (URL) command. > --- > Deprecated: XML-like syntax > Deprecated: [applescript] > Deprecated: phone home system > Deprecated: the URL command system > Deprecated: 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 O= SX using multiple local domains (via httpd-vhosts)? I'd love to give the = OSX version a spin. >> >> Also, is there a set of instructions for CentOS? >> >> Thanks! Olin >> >> christophe.billiottet@webdna.us wrote: >>> Sure! i mail it privately. >>> >>> - chris >>> >>> >>> On Jan 25, 2011, at 14:35, Steve Craig wrote: >>> >>> >>>> Hi Chris >>>> >>>> I'm just about to set up a new in-house server for our internal acco= unts and stuff. Could I try the version 7 please on OSX? >>>> >>>> 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 >>>> >>>> http://www.asylumweb.com >>>> >>>> Email: >>>> steve@asylumweb.com >>>> >>>> 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 >>>> >>>> >>>> >>>> >>>> On 25 Jan 2011, at 09:37, >>>> christophe.billiottet@webdna.us >>>> wrote: >>>> >>>> >>>>> 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. K= en already wrote a "manual" on how to install WebDNA 7.0 with lighttpd (h= ighly recommended if you don't need apache) and the OSX install process w= ith apache is also documented. >>>>> >>>> --------------------------------------------------------- >>>> 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 >>> --------------------------------------------------------- >>> 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 >> --------------------------------------------------------- This message= is sent to you because you are subscribed to the mailing list . To unsub= scribe, E-mail to: archives: http://mail.webdna.us/list/talk@webdna.us Bu= g Reporting: 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 > > --=20 Matthew A Perosi Computer Engineer Senior Web Developer SEO Analyst& Educator Psi Prime, Inc. 323 Union Blvd. Totowa, NJ 07512 Service: 973.413.8211 Training: 973.413.8214 Fax: 973.413.8217 http://www.psiprime.com Associated Messages, from the most recent to the oldest:

    
  1. Re: [WebDNA] Crashing Database (christophe.billiottet@webdna.us 2011)
  2. Re: [WebDNA] Crashing Database ("Dan Strong" 2011)
  3. Re: [WebDNA] Crashing Database ("Dan Strong" 2011)
  4. Re: [WebDNA] Crashing Database (Olin Lagon 2011)
  5. Re: [WebDNA] Crashing Database (Kenneth Grome 2011)
  6. Re: [WebDNA] Crashing Database ("Dan Strong" 2011)
  7. Re: [WebDNA] Crashing Database (William DeVaul 2011)
  8. Re: [WebDNA] Crashing Database (Kenneth Grome 2011)
  9. Re: [WebDNA] Crashing Database (Stuart Tremain 2011)
  10. Re: [WebDNA] Crashing Database (christophe.billiottet@webdna.us 2011)
  11. Re: [WebDNA] Crashing Database (Brian Fries 2011)
  12. Re: [WebDNA] Crashing Database (Stuart Tremain 2011)
  13. Re: [WebDNA] Crashing Database (christophe.billiottet@webdna.us 2011)
  14. Re: [WebDNA] Crashing Database ("Psi Prime Inc, Matthew A Perosi " 2011)
  15. Re: [WebDNA] Crashing Database (christophe.billiottet@webdna.us 2011)
  16. Re: [WebDNA] Crashing Database (christophe.billiottet@webdna.us 2011)
  17. Re: [WebDNA] Crashing Database (Olin Lagon 2011)
  18. Re: [WebDNA] Crashing Database (christophe.billiottet@webdna.us 2011)
  19. Re: [WebDNA] Crashing Database (Steve Craig 2011)
  20. Re: [WebDNA] Crashing Database (Jeffrey Jones 2011)
  21. Re: [WebDNA] Crashing Database (christophe.billiottet@webdna.us 2011)
  22. Re: [WebDNA] Crashing Database (William DeVaul 2011)
  23. Re: [WebDNA] Crashing Database (Marc Thompson 2011)
  24. Re: [WebDNA] Crashing Database (World Wide Art 2011)
  25. Re: [WebDNA] Crashing Database (Jeffrey Jones 2011)
  26. Re: [WebDNA] Crashing Database (Kenneth Grome 2011)
  27. [WebDNA] Crashing Database (World Wide Art 2011)
Chris my biggest concern is the [returnraw] and [setmimeheader]. Were=20 these fixed in the CICADA edition? And if so how can I get that for my=20 current servers running on RedHat 4ES? Matt Perosi On 1/25/2011 2:04 PM, christophe.billiottet@webdna.us wrote: > There is no real new feature in 7.0. It is more a transition version to= ward 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 numb= er, and causes the page not reloading. > ----- > The libmysqlclient.so.15/libmysqlclient.so.16 problem for the glibcv3 v= ersion: > Ubuntu 10.xx comes with libmysqlclient.so.16, and webdna.fcgi requests = libmysqlclient.so.15 > The two versions of libmysqlclient aren't binary compatible, which is w= hy the soname was changed from 15 to 16. There is no way to build a singl= e binary that works with both libraries. We built two binaries. > ----- > Changed: The 6.2 code always reloaded the db after 100 lines. We change= d 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 threadi= ng problem. Fixed by forcing it to use libpthread instead of libc_r > ----- > Fixed: bug when the [math] variable name includes a number like in [mat= h]thetest3=3D43[/math] > --- > New: added the new tag [thirurlplusget] > > so the [thisurl] tag will produce this: > /x/y/z/index.dna > > and 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 o= n. > --- > Bug: xerces has some flaws under OSX. See below > > [xmlparse var=3Dxml_var1&source=3D[url]http://gdata.youtube.com/feeds/a= pi/videos/-/volleyball[/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 XMLParse > Pseudo code: > [DOWNLOAD FILE source=3Dhttp://.....] > [XMLParse vars=3Dblah][include target file.xml][/XMLParse] > --- > Fixed: [setmimeheader] is now working as expected > example: [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 ma= tches the domain, we will get a "T", otherwise, we get a "F" and WebDNA w= ill run as freeware. > --- > Fixed: was not working > --- > Fixed: [decrypt] could not decrypt the seed "TEMPLATE", for use with en= crypted templates > --- > New: SMTP auth enable with [sendmail].. both a global setting and a ove= r-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=3Dthis= isasmalltest was just passing "[thetest]" in the browser: it was not inte= rpreted and showed up. > --- > Fixed: Introducing an URL variable name using a context name was produc= ing 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 exa= mple, the variable setting via GET is working, but the ?text=3D is blocke= d > --- > Fixed: [appendfile file=3Dtest.html]More text[/appendfile] was creating= an empty file when it should have written "More text" in it. File permis= sion of index.html was 644 > --- > Fixed: [writefile file=3Dtest.html]Some text[/writefile] was creating a= n empty file when it should have written "Some text" in it. File permissi= on of index.html was 660 > --- > Fixed: [ipaddress] was not working anymore under OSX > --- > Fixed: [referrer] was showing "FastCGI" instead of the real refering pa= ge under OSX. > --- > Fixed: the delete command could delete items in a database, even when i= t is not allowed as a (URL) command. > --- > Deprecated: XML-like syntax > Deprecated: [applescript] > Deprecated: phone home system > Deprecated: the URL command system > Deprecated: 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 O= SX using multiple local domains (via httpd-vhosts)? I'd love to give the = OSX version a spin. >> >> Also, is there a set of instructions for CentOS? >> >> Thanks! Olin >> >> christophe.billiottet@webdna.us wrote: >>> Sure! i mail it privately. >>> >>> - chris >>> >>> >>> On Jan 25, 2011, at 14:35, Steve Craig wrote: >>> >>> >>>> Hi Chris >>>> >>>> I'm just about to set up a new in-house server for our internal acco= unts and stuff. Could I try the version 7 please on OSX? >>>> >>>> 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 >>>> >>>> http://www.asylumweb.com >>>> >>>> Email: >>>> steve@asylumweb.com >>>> >>>> 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 >>>> >>>> >>>> >>>> >>>> On 25 Jan 2011, at 09:37, >>>> christophe.billiottet@webdna.us >>>> wrote: >>>> >>>> >>>>> 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. K= en already wrote a "manual" on how to install WebDNA 7.0 with lighttpd (h= ighly recommended if you don't need apache) and the OSX install process w= ith apache is also documented. >>>>> >>>> --------------------------------------------------------- >>>> 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 >>> --------------------------------------------------------- >>> 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 >> --------------------------------------------------------- This message= is sent to you because you are subscribed to the mailing list . To unsub= scribe, E-mail to: archives: http://mail.webdna.us/list/talk@webdna.us Bu= g Reporting: 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 > > --=20 Matthew A Perosi Computer Engineer Senior Web Developer SEO Analyst& Educator Psi Prime, Inc. 323 Union Blvd. Totowa, NJ 07512 Service: 973.413.8211 Training: 973.413.8214 Fax: 973.413.8217 http://www.psiprime.com "Psi Prime Inc, Matthew A Perosi "

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:

[authenticate] (2000) [append] vs. [appendfile] delta + question? (1997) [WebDNA] Facebook Application - Custom Tab for Fan / Non-Fan (2011) [WriteFile] problems (1997) Formating found categories (1997) default value from Lookup (was Grant, please help me) (1997) WebMerchant 1.6 and SHTML (1997) restart needed???? (1997) WebCat2 several catalogs? (1997) Dang... Sorry, WebDNA server not running (again)? (2003) TCPconnect in a DB? (1999) international time (1997) Reserved Words (2003) [OT] CSS and SSI books (2004) WebCat2b15MacPlugin - [protect] (1997) [carts] and databases (1997) rn doesn't work on date fields (1998) what characters are replaced for tab and CR? (1998) ooops...WebCatalog [FoundItems] Problem - LONG - (1997) [shownext max=?] armed (1997)