Re: [WebDNA] Databases not staying open

This WebDNA talk-list message is from

2010


It keeps the original formatting.
numero = 104343
interpreted = N
texte = --0015174c1a0a70719f047ce6b0c3 Content-Type: text/plain; charset=UTF-8 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] 1 formID formcontact 2 formTITLE The title for the form 3 formMAILFROM no-reply@revolutionaries.ie 4 formMAILTO email1@revolutionaries.ie,email2@revolutionaries.ie 5 formMAILBCC emailfrom@revolutionaries.ie 6 formCLIENT The client 7 formMAILSPAM F [/table][!] [/!][search table=formPREFS&neprefIDdatarq=find_all][founditems][text][prefTITLE]=[prefVALUE][/text][/founditems][/search] --0015174c1a0a70719f047ce6b0c3 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable Hi all,

Ok found the code that was causing the problem (= below). =C2=A0I have a comma within the 'prefVALUE' for the fourth = field - the template chokes on this and causes all databases to be closed. = =C2=A0Is 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. =C2=A0The site was transferred to a Linux box running Ce= ntOS and WebDNA 6.2 on Friday. =C2=A0The other complication was that this t= emplate 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, b= ut it would appear that the trigger just kept hitting the page constantly c= ausing 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 li= st in the past.

- Tom




[!]

<= div>
------------------------------------
### =C2=A0Set the form prefs = =C2=A0###

[/!][table name=3DformPREFS&fields=3DprefID,prefTIT= LE,prefVALUE]
1formIDformcontact
2form= TITLEThe t= itle for the form
3formMAILFROMno-repl= y@revolutionaries.ie
4form= MAILTOemail1@revolutionaries.ie,email2@revolutionaries.ie
5form= MAILBCCemailfrom@revolutionaries.ie
6form= CLIENTThe = client
7= formMAILSPAMF
[/table][!]

[/!][search table=3DformPREFS&= ;neprefIDdatarq=3Dfind_all][founditems][text][prefTITLE]=3D[prefVALUE][/tex= t][/founditems][/search]
--0015174c1a0a70719f047ce6b0c3-- 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)
--0015174c1a0a70719f047ce6b0c3 Content-Type: text/plain; charset=UTF-8 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] 1 formID formcontact 2 formTITLE The title for the form 3 formMAILFROM no-reply@revolutionaries.ie 4 formMAILTO email1@revolutionaries.ie,email2@revolutionaries.ie 5 formMAILBCC emailfrom@revolutionaries.ie 6 formCLIENT The client 7 formMAILSPAM F [/table][!] [/!][search table=formPREFS&neprefIDdatarq=find_all][founditems][text][prefTITLE]=[prefVALUE][/text][/founditems][/search] --0015174c1a0a70719f047ce6b0c3 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable Hi all,

Ok found the code that was causing the problem (= below). =C2=A0I have a comma within the 'prefVALUE' for the fourth = field - the template chokes on this and causes all databases to be closed. = =C2=A0Is 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. =C2=A0The site was transferred to a Linux box running Ce= ntOS and WebDNA 6.2 on Friday. =C2=A0The other complication was that this t= emplate 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, b= ut it would appear that the trigger just kept hitting the page constantly c= ausing 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 li= st in the past.

- Tom




[!]

<= div>
------------------------------------
### =C2=A0Set the form prefs = =C2=A0###

[/!][table name=3DformPREFS&fields=3DprefID,prefTIT= LE,prefVALUE]
1formIDformcontact
2form= TITLEThe t= itle for the form
3formMAILFROMno-repl= y@revolutionaries.ie
4form= MAILTOemail1@revolutionaries.ie,email2@revolutionaries.ie
5form= MAILBCCemailfrom@revolutionaries.ie
6form= CLIENTThe = client
7= formMAILSPAMF
[/table][!]

[/!][search table=3DformPREFS&= ;neprefIDdatarq=3Dfind_all][founditems][text][prefTITLE]=3D[prefVALUE][/tex= t][/founditems][/search]
--0015174c1a0a70719f047ce6b0c3-- Tom Duke

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:

RE: Shopping Cart Questions (1998) method of payment (1997) Help! WebCat2 bug (1997) WebCatalog.acgi quitting with error Type 2 (1998) searching within same page (2000) Another bug to squash (WebCat2b13 Mac .acgi) (1997) Not reading blanks (1998) Need relative path explanation (1997) [showif [math (1999) Upload file limits (2000) denied access (1997) RAM variables (1997) RE: Checkboxes to add to cart... (1998) I think WebDNA-Talk died ... :( (1997) .. more on sliding discounts... (1997) Formatting date to number - more (2000) creating an email message (1998) Nested tags count question (1997) MacAuthorize order data fields WAS:How To question... (1997) Include an include file as raw webDNA (2002)