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:

[WebDNA] improvements (2015) Help with database strategy (1998) cookies (2001) WebCatalog plugin, FireSite and PIXO (2000) problems with 2 tags (1997) [WriteFile] problems (1997) Re:quit command on NT (1997) Multiple Merchant Accounts? (1997) Logging purchases (1997) Date Math (2005) How To question on setting up downloads (1997) One other big addition... (1997) Storebuilder-AutoCategory (2003) Help formatting search results w/ table (1997) I think WebDNA-Talk died ... :( (1997) different show next (1997) [WebDNA] ReturnRAW problem with Safari (2015) WC2b15 File Corruption (1997) frames & carts (1997) WebCat2 beta 11 - new prefs ... (1997)