Re: [WebDNA] Databases not staying open

This WebDNA talk-list message is from

2010


It keeps the original formatting.
numero = 104344
interpreted = N
texte = --Apple-Mail-3--691498706 Content-Type: text/plain; charset=US-ASCII; format=flowed; delsp=yes Content-Transfer-Encoding: 7bit Hi Tom you mean 4th *record* (3rd field), where you were saying "4th field". ...anyway maybe it will solve it by [url]ing the value you stuff in the offending [table] field(s) and then [unurl]ing later down where you spit the value out. I have got myself out of various kinds of hotwater using [table] by this method... -G On Jan 11, 2010, at 10:15 AM, Tom Duke wrote: > Hi all, > > Ok found the code that was causing the problem (below). I have a > comma within the 'prefVALUE' for the fourth field - the template > chokes on this and causes all databases to be closed. Is it > documented anywhere that commas cannot be used in values within > WebDNA tables? > > What makes this more odd is that the template worked no problem on a > Mac. The site was transferred to a Linux box running CentOS and > WebDNA 6.2 on Friday. The other complication was that this template > was being hit by a trigger once a day at 16:05. The trigger was set > at the standard retry at ten second intervals and timeout after 30 > secs, but it would appear that the trigger just kept hitting the > page constantly causing the databases to be constantly closed. > > I fixed it by removing the fourth field from the table and then > adding it using [append] - someone mentioned this method on the list > in the past. > > - Tom > > > > > [!] > > > ------------------------------------ > ### Set the form prefs ### > > [/!][table name=formPREFS&fields=prefID,prefTITLE,prefVALUE] > 1formIDformcontact > 2formTITLEThe title for the form > 3formMAILFROMno-reply@revolutionaries.ie > 4formMAILTOemail1@revolutionaries.ie,email2@revolutionaries.ie > 5formMAILBCCemailfrom@revolutionaries.ie > 6formCLIENTThe client > 7formMAILSPAMF > [/table][!] > > [/!][search table=formPREFS&neprefIDdatarq=find_all][founditems] > [text][prefTITLE]=[prefVALUE][/text][/founditems][/search] ------------ Govinda govinda.webdnatalk@gmail.com --Apple-Mail-3--691498706 Content-Type: text/html; charset=US-ASCII Content-Transfer-Encoding: quoted-printable Hi Tom

you = mean 4th *record* (3rd field), where you were saying "4th = field".
...anyway maybe it will solve it by [url]ing the value = you stuff in the offending [table] field(s) and then [unurl]ing later = down where you spit the value out.
I have got myself out of = various kinds of hotwater using [table] by this method... =  

-G

On Jan 11, = 2010, at 10:15 AM, Tom Duke wrote:

Hi = all,

Ok found the code that was causing the problem = (below).  I have a comma within the 'prefVALUE' for the fourth = field - the template chokes on this and causes all databases to be = closed.  Is it documented anywhere that commas cannot be used in = values within WebDNA tables?

What makes this = more odd is that the template worked no problem on a Mac.  The site = was transferred to a Linux box running CentOS and WebDNA 6.2 on Friday. =  The other complication was that this template was being hit by a = trigger once a day at 16:05. The trigger was set at the standard retry = at ten second intervals and timeout after 30 secs, but it would appear = that the trigger just kept hitting the page constantly causing the = databases to be constantly closed.

I fixed it = by removing the fourth field from the table and then adding it using = [append] - someone mentioned this method on the list in the = past.

- Tom

=


[!]

=

= ------------------------------------
### =  Set the form prefs  ###

[/!][table = name=3DformPREFS&fields=3DprefID,prefTITLE,prefVALUE]
1= formID= formcontact
2formTITLEThe title = for the form




= --Apple-Mail-3--691498706-- Associated Messages, from the most recent to the oldest:

    
  1. Re: [WebDNA] Databases not staying open (Donovan Brooke 2010)
  2. Re: [WebDNA] Databases not staying open (Kenneth Grome 2010)
  3. Re: [WebDNA] Databases not staying open (christophe.billiottet@webdna.us 2010)
  4. Re: [WebDNA] Databases not staying open (Govinda 2010)
  5. Re: [WebDNA] Databases not staying open (Kenneth Grome 2010)
  6. Re: [WebDNA] Databases not staying open (christophe.billiottet@webdna.us 2010)
  7. Re: [WebDNA] Databases not staying open (Govinda 2010)
  8. Re: [WebDNA] Databases not staying open (christophe.billiottet@webdna.us 2010)
  9. Re: [WebDNA] Databases not staying open (Donovan Brooke 2010)
  10. Re: [WebDNA] Databases not staying open (Tom Duke 2010)
  11. Re: [WebDNA] Databases not staying open (Govinda 2010)
  12. Re: [WebDNA] Databases not staying open (Tom Duke 2010)
  13. Re: [WebDNA] Databases not staying open (Dan Strong 2010)
  14. Re: [WebDNA] Databases not staying open (Tom Duke 2010)
  15. Re: [WebDNA] Databases not staying open (Kenneth Grome 2010)
  16. Re: [WebDNA] Databases not staying open (Dan Strong 2010)
  17. Re: [WebDNA] Databases not staying open (Govinda 2010)
  18. Re: [WebDNA] Databases not staying open (Tom Duke 2010)
  19. Re: [WebDNA] Databases not staying open (Donovan Brooke 2010)
  20. Re: [WebDNA] Databases not staying open (Kenneth Grome 2010)
  21. Re: [WebDNA] Databases not staying open (Tom Duke 2010)
  22. Re: [WebDNA] Databases not staying open (Kenneth Grome 2010)
  23. Re: [WebDNA] Databases not staying open (Tom Duke 2010)
  24. Re: [WebDNA] Databases not staying open (christophe.billiottet@webdna.us 2010)
  25. Re: [WebDNA] Databases not staying open (Kenneth Grome 2010)
  26. [WebDNA] Databases not staying open (Tom Duke 2010)
--Apple-Mail-3--691498706 Content-Type: text/plain; charset=US-ASCII; format=flowed; delsp=yes Content-Transfer-Encoding: 7bit Hi Tom you mean 4th *record* (3rd field), where you were saying "4th field". ...anyway maybe it will solve it by
[url]ing the value you stuff in the offending
[table] field(s) and then [unurl]ing later down where you spit the value out. I have got myself out of various kinds of hotwater using [table] by this method... -G On Jan 11, 2010, at 10:15 AM, Tom Duke wrote: > Hi all, > > Ok found the code that was causing the problem (below). I have a > comma within the 'prefVALUE' for the fourth field - the template > chokes on this and causes all databases to be closed. Is it > documented anywhere that commas cannot be used in values within > WebDNA tables? > > What makes this more odd is that the template worked no problem on a > Mac. The site was transferred to a Linux box running CentOS and > WebDNA 6.2 on Friday. The other complication was that this template > was being hit by a trigger once a day at 16:05. The trigger was set > at the standard retry at ten second intervals and timeout after 30 > secs, but it would appear that the trigger just kept hitting the > page constantly causing the databases to be constantly closed. > > I fixed it by removing the fourth field from the table and then > adding it using [append] - someone mentioned this method on the list > in the past. > > - Tom > > > > > [!] > > > ------------------------------------ > ### Set the form prefs ### > > [/!][table name=formPREFS&fields=prefID,prefTITLE,prefVALUE] > 1formIDformcontact > 2formTITLEThe title for the form > 3formMAILFROMno-reply@revolutionaries.ie > 4formMAILTOemail1@revolutionaries.ie,email2@revolutionaries.ie > 5formMAILBCCemailfrom@revolutionaries.ie > 6formCLIENTThe client > 7formMAILSPAMF > [/table][!] > > [/!][search table=formPREFS&neprefIDdatarq=find_all][founditems] > [text][prefTITLE]=[prefVALUE][/text][/founditems][/search] ------------ Govinda govinda.webdnatalk@gmail.com --Apple-Mail-3--691498706 Content-Type: text/html; charset=US-ASCII Content-Transfer-Encoding: quoted-printable Hi Tom

you = mean 4th *record* (3rd field), where you were saying "4th = field".
...anyway maybe it will solve it by [url]ing the value = you stuff in the offending [table] field(s) and then [unurl]ing later = down where you spit the value out.
I have got myself out of = various kinds of hotwater using [table] by this method... =  

-G

On Jan 11, = 2010, at 10:15 AM, Tom Duke wrote:

Hi = all,

Ok found the code that was causing the problem = (below).  I have a comma within the 'prefVALUE' for the fourth = field - the template chokes on this and causes all databases to be = closed.  Is it documented anywhere that commas cannot be used in = values within WebDNA tables?

What makes this = more odd is that the template worked no problem on a Mac.  The site = was transferred to a Linux box running CentOS and WebDNA 6.2 on Friday. =  The other complication was that this template was being hit by a = trigger once a day at 16:05. The trigger was set at the standard retry = at ten second intervals and timeout after 30 secs, but it would appear = that the trigger just kept hitting the page constantly causing the = databases to be constantly closed.

I fixed it = by removing the fourth field from the table and then adding it using = [append] - someone mentioned this method on the list in the = past.

- Tom

=



=

= ------------------------------------
### =  Set the form prefs  ###

[/!][table = name=3DformPREFS&fields=3DprefID,prefTITLE,prefVALUE]
1= formID= formcontact
2formTITLEThe title = for the form
4= formMAILTO= email1@revolutionaries.ie,email2@revolutionaries.ie
6= formCLIENT= The client
7formMAILSPAMF
=

[/!][search = table=3DformPREFS&neprefIDdatarq=3Dfind_all][founditems][text][prefTIT= LE]=3D[prefVALUE][/text][/founditems][/search]
=




= --Apple-Mail-3--691498706-- Govinda

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:

WebCat2b13MacPlugIn - [showif][search][/showif] (1997) More Applescript (1997) shipping calcs (1998) Smart caching problems with 2.1b3? (1997) Can't open order file error II (2004) Bug? (1997) Transferring textareas (1997) SSL, WebSTAR, WebCatalog (1998) Wierd thing in ViewOrder.tpl (1999) WC1.6 to WC2 date formatting (1997) [WebDNA] caret in db path? (2017) WebCatalog and barcodes (2000) ANYONE (1999) Email encryption (1998) Serving Images from SSL (was NT vs Mac) (1997) A multi-processor savvy WebCatalog? (1997) no time stamp & different times from emailer (1998) [!] not working? (1999) WebCatalog can't find database (1997) WebCatalog can't find database (1997)