Re: [WebDNA] Crashing Database
This WebDNA talk-list message is from 2011
It keeps the original formatting.
numero = 106185
interpreted = N
texte = Both are fixed with WebDNA 7.0 - chris On Jan 25, 2011, at 19:00, Psi Prime Inc, Matthew A Perosi wrote: > Chris my biggest concern is the [returnraw] and [setmimeheader]. Were = these fixed in the CICADA edition? And if so how can I get that for my = current servers running on RedHat 4ES? >=20 > Matt Perosi >=20 > 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 = 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 >> --- >> 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: >>>>> 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, >>>>> 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 >>>>>
>>>>> . >>>>> To unsubscribe, E-mail to: >>>>> >>>>>=20 >>>>> archives: >>>>> http://mail.webdna.us/list/talk@webdna.us >>>>>=20 >>>>> Bug Reporting: >>>>> support@webdna.us >>>> --------------------------------------------------------- >>>> This message is sent to you because you are subscribed to >>>> the mailing list >>>> >>>> . >>>> To unsubscribe, E-mail to: >>>> >>>>=20 >>>> archives: >>>> http://mail.webdna.us/list/talk@webdna.us >>>>=20 >>>> 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 unsubscribe, E-mail to: >> archives: http://mail.webdna.us/list/talk@webdna.us >> Bug Reporting: support@webdna.us >>=20 >>=20 >=20 > --=20 > Matthew A Perosi > Computer Engineer > Senior Web Developer > SEO Analyst& Educator >=20 > Psi Prime, Inc. > 323 Union Blvd. > Totowa, NJ 07512 >=20 > Service: 973.413.8211 > Training: 973.413.8214 > Fax: 973.413.8217 >=20 > http://www.psiprime.com >=20 >=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:
Both are fixed with WebDNA 7.0 - chris On Jan 25, 2011, at 19:00, Psi Prime Inc, Matthew A Perosi wrote: > Chris my biggest concern is the [returnraw] and [setmimeheader]. Were = these fixed in the CICADA edition? And if so how can I get that for my = current servers running on RedHat 4ES? >=20 > Matt Perosi >=20 > 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 = 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 >> --- >> 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: >>>>> 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, >>>>> 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 >>>>> >>>>> . >>>>> To unsubscribe, E-mail to: >>>>> >>>>>=20 >>>>> archives: >>>>> http://mail.webdna.us/list/talk@webdna.us >>>>>=20 >>>>> Bug Reporting: >>>>> support@webdna.us >>>> --------------------------------------------------------- >>>> This message is sent to you because you are subscribed to >>>> the mailing list >>>> >>>> . >>>> To unsubscribe, E-mail to: >>>> >>>>=20 >>>> archives: >>>> http://mail.webdna.us/list/talk@webdna.us >>>>=20 >>>> 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 unsubscribe, E-mail to: >> archives: http://mail.webdna.us/list/talk@webdna.us >> Bug Reporting: support@webdna.us >>=20 >>=20 >=20 > --=20 > Matthew A Perosi > Computer Engineer > Senior Web Developer > SEO Analyst& Educator >=20 > Psi Prime, Inc. > 323 Union Blvd. > Totowa, NJ 07512 >=20 > Service: 973.413.8211 > Training: 973.413.8214 > Fax: 973.413.8217 >=20 > http://www.psiprime.com >=20 >=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
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:
Multiple prices (1997)
[listdatabases] feature request. (2003)
[SQL] & ODBC on Mac - Reposted (2000)
Grep -- remove extra returns first (2003)
E-Mailer (WebCatb15acgiMac) (1997)
WebDNA wholesale ... (2002)
Macos8.6 to X migration problems (2000)
Nitro plugin? (1998)
Simple way to create unique SKU (1997)
Blocking form spam (2006)
WebCatalog 2.0 & WebDNA docs in HTML ... (1997)
math problems (2000)
empty shopping cart message (1997)
Multiple ShipTo Addresses (2003)
Closing db's & caching templates (was: Shippingcalculations) (1997)
PCS Customer submissions ? (1997)
Re:no [search] with NT (1997)
Price + Texte (1999)
WebCat2b13MacPlugIn - [include] (1997)
WebCatalog2 Feature Feedback (1996)