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:

Q: writefile and uploads. (1998) 2.0Beta Command Ref (can't find this instruction) (1997) Help! (2000) Running _every_ page through WebCat ? (1997) Separate SSL Server (1997) WebCat2: multiple currency support (1997) (1997) Summing fields (1997) Variables for chat (1997) [WebDNA] form data compared to existing database (2016) can I get formvariables for an include? (1999) MS Bug (2003) RE: [WebDNA] Installation problems for IIS 6 (2010) Not really WebCat (1997) Re:Emailer tracking (1997) WebDNA Running Out of RAM? (2004) [sendmail] on NT? (1997) Apache2 + WebCatalog 4.5.1 requires username/password (2003) Variable Math (1998) apostrophe in search item (1997)