Re: [WebDNA] Crashing Database

This WebDNA talk-list message is from

2011


It keeps the original formatting.
numero = 106191
interpreted = N
texte = Is that what [thisport] does for us? return 80 for http and 443 for = https? Brian Fries BrainScan Software On Jan 26, 2011, at 4:34 PM, Stuart Tremain wrote: > Chris >=20 > There have been many attempts to create an easy way to determine if a = page is being served HTTP or HTTPS >=20 > Any closer with this ?? >=20 >=20 > Regards >=20 > Stuart Tremain > IDFK Web Developments > AUSTRALIA > webdna@idfk.com.au >=20 >=20 >=20 >=20 > On 26/01/2011, at 6:04 AM, christophe.billiottet@webdna.us wrote: >=20 >> 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. >>=20 >> We fixed some remaining bugs and added few things. We also changed = the [append] tag to be much much faster. Here a list: >>=20 >>=20 >> ----- >> 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.15 >> The 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] >>=20 >> so the [thisurl] tag will produce this: >> /x/y/z/index.dna >>=20 >> 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 = on. >> --- >> Bug: xerces has some flaws under OSX. See below >>=20 >> [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] >>=20 >> 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 = 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 syntax >> Deprecated: [applescript] >> Deprecated: phone home system >> Deprecated: the URL command system >> Deprecated: sandboxes and "global" >> Deprecated: old licensing system (domain limits, versions=85) >>=20 >>=20 >>=20 >>=20 >>=20 >> On Jan 25, 2011, at 16:22, Olin Lagon wrote: >>=20 >>> 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 >>=20 >> --------------------------------------------------------- >> 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 > --------------------------------------------------------- > 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:

    
  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)
Is that what [thisport] does for us? return 80 for http and 443 for = https? Brian Fries BrainScan Software On Jan 26, 2011, at 4:34 PM, Stuart Tremain wrote: > Chris >=20 > There have been many attempts to create an easy way to determine if a = page is being served HTTP or HTTPS >=20 > Any closer with this ?? >=20 >=20 > Regards >=20 > Stuart Tremain > IDFK Web Developments > AUSTRALIA > webdna@idfk.com.au >=20 >=20 >=20 >=20 > On 26/01/2011, at 6:04 AM, christophe.billiottet@webdna.us wrote: >=20 >> 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. >>=20 >> We fixed some remaining bugs and added few things. We also changed = the [append] tag to be much much faster. Here a list: >>=20 >>=20 >> ----- >> 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.15 >> The 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] >>=20 >> so the [thisurl] tag will produce this: >> /x/y/z/index.dna >>=20 >> 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 = on. >> --- >> Bug: xerces has some flaws under OSX. See below >>=20 >> [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] >>=20 >> 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 = 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 syntax >> Deprecated: [applescript] >> Deprecated: phone home system >> Deprecated: the URL command system >> Deprecated: sandboxes and "global" >> Deprecated: old licensing system (domain limits, versions=85) >>=20 >>=20 >>=20 >>=20 >>=20 >> On Jan 25, 2011, at 16:22, Olin Lagon wrote: >>=20 >>> 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 >>=20 >> --------------------------------------------------------- >> 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 > --------------------------------------------------------- > 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 Brian Fries

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:

F2 to F3 rocky transition (1997) Dummy Credit Card Number for debug? (1997) Encrypting the URL Query String (2003) [WebDNA] Webserver does not respond occasionally (2018) Trigger time setting (2002) [WebDNA] Some news (2010) WebCat2b15MacPlugin - [protect] (1997) Not reading code (1997) [subtotal] and others (1997) Re2: Calculating multiple shipping... (1997) convertwords BUG (2002) Max Record length (1997) WebCat2 - Getting to the browser's username/password data (1997) shipCost not working v2.1b4 (1997) Fun with [middle] (2002) .html to .tpl (1998) problems with 2 tags shakur (1997) [WebDNA] end of file append (2017) [WebDNA] lists opinion (2009) Search (1997)