Re: [WebDNA] COMMITDATABASE in linux unix 64bits FastCGI version 8.6

This WebDNA talk-list message is from

2020


It keeps the original formatting.
numero = 115020
interpreted = N
texte = 2648 This is a multi-part message in MIME format. --------------DBD910D1BB0E81D7CE045A23 Content-Type: text/plain; charset=utf-8; format=flowed Content-Transfer-Encoding: quoted-printable as mentioned to clarify emails.. perhaps admin can see if talk list email can be configured to put the=20 sender email in cc field? jym On 2/18/2020 5:31 PM, talk@webdna.us wrote: > Hi Terry > > It is hard to work out who sent email to the =C2=A0list now that the =E2= =80=9Cfrom"=20 > has changed. > > > The call is very simple, a url with variables. > > > admin-switch.dna?task=3Dswitch-6&dbid=3D6&dbidname=3DSM-ID&dbname=3Dshi= ppingmethods&dbfield=3DSM-ACTIVE&active=3DT > > > The receiving page is very simple too. > > [REPLACE db=3D../data/[DBNAME].db&eq[DBIDNAME]datarq=3D[DBID]&max=3D1][= !] > [/!][DBFIELD]=3D[URL][DBVALUE][/URL][!] > [/!][/REPLACE] > > > The replace is 100% correct in the db file if I open it up, the=20 > problem is that until I manually flush the dbs it is not recognised. > > I have tried putting in=C2=A0[CLOSEDATABASE db=3D../data/[DBNAME].db]=20 > or=C2=A0[COMMITDATABASE db=3D../data/[DBNAME].db] or even [FLUSHDATABAS= ES]=20 > with no resolution. > > It is not the one db, I have another ajax update for another db which=20 > has the same issue. I have not gone through the entire system checking=20 > for others. > > Kind regards > > Stuart Tremain > Pharoah Lane Software > AUSTRALIA > webdna@plsoftware.com.au > > > > > > > >> On 19 Feb 2020, at 12:11, talk@webdna.us wrote= : >> >> Morning Stuart, >> You mentioned =E2=80=9CI have include [FLUSHDATABASES] in the ajax cal= l=E2=80=9D =E2=80=A6.am=20 >> I correct to say that you are either doing a GET or POST Ajax call to=20 >> a file sitting on the server that has the tags to execute the flush=20 >> webdna tag? >> If so =E2=80=A6can share the ajax call script and the page called by i= t so=20 >> that I can try to assist you. It is indeed strange that the change is=20 >> stored in RAM but not committed into the DB even with all the=20 >> settings you mentioned. Regardless =E2=80=A6after the update, the unco= mmitted=20 >> change should still be showing up when called upon by other pages=20 >> relying on it. >> Cheers TDn >> *From:*talk@webdna.us > > >> *Sent:*Wednesday, February 19, 2020 07:39 AM >> *To:*WebDNA Talk List > >> *Subject:*[WebDNA] COMMITDATABASE in linux unix 64bits FastCGI=20 >> version 8.6 >> I am having an issue with a couple of dbs. >> Permissions are correct 775 >> Ownership is correct www-data:www-data >> I am updating the db with an ajax call, I open the db ofter it has=20 >> been modified and the mod is there in the db. >> The ajax call does a replace on the db. >> There is no error reported from the ajax call. >> >> >> The WebDNA preference is "Automatically commit databases to disk=20 >> after modification" >> The problem is that another page on the site is dependant on the new=20 >> value. This new value is not being found. >> I have include [FLUSHDATABASES] in the ajax call to force the db to=20 >> clear however it is still not finding the new value. >> If I use the WebDNA admin to [FLUSHDATABASES] then the page finds the=20 >> new value. >> Any ideas ? >> Kind regards >> Stuart Tremain >> Pharoah Lane Software >> AUSTRALIA >> webdna@plsoftware.com.au >> >> --------------------------------------------------------- This=20 >> message is sent to you because you are subscribed to the mailing=20 >> listtalk@webdna.us To unsubscribe, E-mail=20 >> to:talk-leave@webdna.us=20 >> archives:http://www.webdna.us/page.dna?nu= mero=3D55Bug=20 >> Reporting:support@webdna.us >> --------------------------------------------------------- This=20 >> message is sent to you because you are subscribed to the mailing=20 >> listtalk@webdna.us To unsubscribe, E-mail=20 >> to:talk-leave@webdna.us=20 >> archives:http://www.webdna.us/page.dna?nu= mero=3D55Bug=20 >> Reporting:support@webdna.us > > --------------------------------------------------------- This message=20 > is sent to you because you are subscribed to the mailing list=20 > talk@webdna.us To unsubscribe, E-mail to: talk-leave@webdna.us=20 > archives: http://www.webdna.us/page.dna?numero=3D55 Bug Reporting:=20 > support@webdna.us=20 --=20 Jym Duane - CTO - Purpose Media Creating Your Success Story Marketing : Television - Internet -Print Phone: (877) 443-1323 Email: jym@purposemedia.com Web: www.purposemedia.com Oregon - www.GuideToOregon.com PO Box 1725, Jacksonville, OR 97530 California - www.OrangeCounty.net PO Box 2025, Capistrano Beach, CA 92624 --------------DBD910D1BB0E81D7CE045A23 Content-Type: text/html; charset=utf-8 Content-Transfer-Encoding: quoted-printable

as mentioned to clarif= y emails..

perhaps admin can see if talk list email can be configured to put the sender email in cc field?

jym


On 2/18/2020 5:31 PM, talk@webdna.us wrote:
Hi Terry

It is hard to work out who sent email to the =C2=A0= list now that the =E2=80=9Cfrom" has changed.


The call is very simple, a url with variables.=C2=A0=


admin-switch.dna?task=3Dswitch-6&dbid=3D6&d= bidname=3DSM-ID&dbname=3Dshippingmethods&dbfield=3DSM-ACTIVE&= active=3DT


The receiving page is very simple too= ..

[REPLACE db=3D../data/[DBNAME].db&eq[DBIDNAME]datarq=3D[DBID]&= max=3D1][!]
[/!][DBFIELD]=3D[URL][DBVALUE][/URL][!]
[/!][/REPLACE]


The replace is 100% correct in the db file if I ope= n it up, the problem is that until I manually flush the dbs it is not recognised.

I have tried putting in=C2=A0[CLOSEDATABASE db=3D../data/[DBNAME].db] or=C2=A0[COMMITDATABASE db=3D../data/[DBNAME].db] or even [FLUSHDATABASES] with no resolution.

It is not the one db, I have another ajax update fo= r another db which has the same issue. I have not gone through the entire system checking for others.

Kind regards

Stuart Tremain
Pharoah Lane Software
AUSTRALIA
webdna@plsoftware.com.au=







On 19 Feb 2020, at 12:11, talk@webdna.us wrote:

Morni= ng Stuart,
=C2=A0
You mentioned =E2=80=9CI have include [FLUSHDATABA= SES] in the ajax call=E2=80=9D =E2=80=A6.am I correct to sa= y that you are either doing a GET or POST Ajax call to a file sitting on the server that has the tags to execute the flush webdna tag?
=C2=A0
If so =E2=80=A6can share the ajax call script and the page = called by it so that I can try to assist you. It is indeed strange that the change is stored in RAM but not committed into the DB even with all the settings you mentioned. Regardless =E2=80=A6after the update, the uncommitted change should still be showing up when called upon by other pages relying on it.
=C2=A0
Cheer= s TDn
=C2=A0
From:=C2=A0talk@webdna.us=C2=A0&l= t;talk@webdna.us>= =C2=A0 Sent:=C2=A0We= dnesday, February 19, 2020 07:39 AM
To:=C2=A0We= bDNA Talk List <talk@webdna.us> Subject:=C2=A0[W= ebDNA] COMMITDATABASE in linux unix 64bits FastCGI version 8.6
=C2=A0
I am having an issue with a couple of dbs.
=C2=A0
Permissions are correct 775
Ownership is correct www-data:www-data
=C2=A0
I am updating the db with an ajax call, I open the db ofter it has been modified and the mod is there in the db.
=C2=A0
The ajax call does a replace on the db.
=C2=A0
There is no er= ror reported from the ajax call.=


The WebDNA preference is "Automatically commit databases to disk after modification"
=C2=A0
The problem is that another page on the site is dependant on the new value. This new value is not being found.
=C2=A0
I have include [FLUSHDATABASES] in the aja= x call to force the db to clear however it is still not finding the new value.
=C2=A0
If I use the WebDNA admin to [FLUSHDATABASES] then the page finds the new value.
=C2=A0
Any ideas ?
=C2=A0
Ki= nd regards
=C2=A0
St= uart Tremain
Ph= aroah Lane Software
AU= STRALIA
webdna@plsof= tware.com.au
=C2=A0
=C2=A0=
=C2=A0
=C2=A0

=C2=A0

=C2=A0
--------------------------------------------= ------------- This message is sent to you because you are subscribed to the mailing list=C2=A0talk@webdna.us=C2=A0To unsubscribe, E-mail to:=C2=A0talk-leave@webdna.us=C2=A0archives= :=C2=A0http://www.webdna= ..us/page.dna?numero=3D55=C2=A0Bug Repo= rting:=C2=A0support@webdna.us
---------------------------------= ------------------------ This message is sent to you because you are subscribed to the mailing list= =C2=A0talk@webdna.us=C2=A0To unsubsc= ribe, E-mail to:=C2=A0talk-leave@webdna.us=C2=A0archives:<= span class=3D"Apple-converted-space">=C2=A0http://www.webdna.us/page.dna?nu= mero=3D55=C2=A0Bug Report= ing:=C2=A0support@webdna.us

--------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list talk@webdna.us To unsubscribe, E-mail to: talk-leave@webdna.us archives: http://www.webdna.us/page.dna?numero=3D55 Bug Reporting: support@webdna.us
--=20Jym Duane - CTO - Purpose MediaCreating Your Success StoryMarketing : Television - Internet -PrintPhone: (877) 443-1323Email: jym@purposemedia.comWeb: www.purposemedia.comOregon - www.GuideToOregon.comPO Box 1725,  Jacksonville, OR 97530California - www.OrangeCounty.netPO Box 2025,  Capistrano Beach, CA 92624 
--------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list talk@webdna.us To unsubscribe, E-mail to: talk-leave@webdna.us archives: http://www.webdna.us/page.dna?numero=3D55 Bug Reporting: support@webdna.us --------------DBD910D1BB0E81D7CE045A23-- . Associated Messages, from the most recent to the oldest:

    
  1. RE: [WebDNA] COMMITDATABASE in linux unix 64bits FastCGI version 8.6 ("Terry Nair" 2020)
  2. Re: [WebDNA] COMMITDATABASE in linux unix 64bits FastCGI version 8.6 (Stuart Tremain 2020)
  3. RE: [WebDNA] COMMITDATABASE in linux unix 64bits FastCGI version 8.6 ("Terry Nair" 2020)
  4. Re: [WebDNA] COMMITDATABASE in linux unix 64bits FastCGI version 8.6 (Donovan Brooke 2020)
  5. Re: [WebDNA] COMMITDATABASE in linux unix 64bits FastCGI version 8.6 (Stuart Tremain 2020)
  6. Re: [WebDNA] COMMITDATABASE in linux unix 64bits FastCGI version 8.6 (Donovan Brooke 2020)
  7. Re: [WebDNA] COMMITDATABASE in linux unix 64bits FastCGI version 8.6 (Stuart Tremain 2020)
  8. RE: [WebDNA] COMMITDATABASE in linux unix 64bits FastCGI version 8.6 ("Scott @ Itsula" 2020)
  9. RE: [WebDNA] COMMITDATABASE in linux unix 64bits FastCGI version 8.6 ("Scott @ Itsula" 2020)
  10. Re: [WebDNA] COMMITDATABASE in linux unix 64bits FastCGI version 8.6 (Stuart Tremain 2020)
  11. RE: [WebDNA] COMMITDATABASE in linux unix 64bits FastCGI version 8.6 ("Scott @ Itsula" 2020)
  12. Re: [WebDNA] COMMITDATABASE in linux unix 64bits FastCGI version 8.6 (Stuart Tremain 2020)
  13. Re: [WebDNA] COMMITDATABASE in linux unix 64bits FastCGI version 8.6 (Stuart Tremain 2020)
  14. RE: [WebDNA] COMMITDATABASE in linux unix 64bits FastCGI version 8.6 ("Scott @ Itsula" 2020)
  15. Re: [WebDNA] COMMITDATABASE in linux unix 64bits FastCGI version 8.6 (Brian Fries 2020)
  16. Re: [WebDNA] COMMITDATABASE in linux unix 64bits FastCGI version 8.6 (Jym Duane 2020)
  17. Re: [WebDNA] COMMITDATABASE in linux unix 64bits FastCGI version 8.6 (Stuart Tremain 2020)
  18. RE: [WebDNA] COMMITDATABASE in linux unix 64bits FastCGI version 8.6 ("Terry Nair" 2020)
  19. Re: [WebDNA] COMMITDATABASE in linux unix 64bits FastCGI version 8.6 (Stuart Tremain 2020)
  20. RE: [WebDNA] COMMITDATABASE in linux unix 64bits FastCGI version 8.6 ("Terry Nair" 2020)
  21. [WebDNA] COMMITDATABASE in linux unix 64bits FastCGI version 8.6 (Stuart Tremain 2020)
2648 This is a multi-part message in MIME format. --------------DBD910D1BB0E81D7CE045A23 Content-Type: text/plain; charset=utf-8; format=flowed Content-Transfer-Encoding: quoted-printable as mentioned to clarify emails.. perhaps admin can see if Talk List email can be configured to put the=20 sender email in cc field? jym On 2/18/2020 5:31 PM, talk@webdna.us wrote: > Hi Terry > > It is hard to work out who sent email to the =C2=A0list now that the =E2= =80=9Cfrom"=20 > has changed. > > > The call is very simple, a url with variables. > > > admin-switch.dna?task=3Dswitch-6&dbid=3D6&dbidname=3DSM-ID&dbname=3Dshi= ppingmethods&dbfield=3DSM-ACTIVE&active=3DT > > > The receiving page is very simple too. > > [REPLACE db=3D../data/[DBNAME].db&eq[DBIDNAME]datarq=3D[DBID]&max=3D1][= !] > [/!][DBFIELD]=3D[url][DBVALUE][/URL][!] > [/!][/REPLACE] > > > The replace is 100% correct in the db file if I open it up, the=20 > problem is that until I manually flush the dbs it is not recognised. > > I have tried putting in=C2=A0[CLOSEDATABASE db=3D../data/[DBNAME].db]=20 > or=C2=A0[COMMITDATABASE db=3D../data/[DBNAME].db] or even [FLUSHDATABAS= ES]=20 > with no resolution. > > It is not the one db, I have another ajax update for another db which=20 > has the same issue. I have not gone through the entire system checking=20 > for others. > > Kind regards > > Stuart Tremain > Pharoah Lane Software > AUSTRALIA > webdna@plsoftware.com.au > > > > > > > >> On 19 Feb 2020, at 12:11, talk@webdna.us wrote= : >> >> Morning Stuart, >> You mentioned =E2=80=9CI have include [flushdatabases] in the ajax cal= l=E2=80=9D =E2=80=A6.am=20 >> I correct to say that you are either doing a GET or POST Ajax call to=20 >> a file sitting on the server that has the tags to execute the flush=20 >> webdna tag? >> If so =E2=80=A6can share the ajax call script and the page called by i= t so=20 >> that I can try to assist you. It is indeed strange that the change is=20 >> stored in RAM but not committed into the DB even with all the=20 >> settings you mentioned. Regardless =E2=80=A6after the update, the unco= mmitted=20 >> change should still be showing up when called upon by other pages=20 >> relying on it. >> Cheers TDn >> *From:*talk@webdna.us > > >> *Sent:*Wednesday, February 19, 2020 07:39 AM >> *To:*WebDNA Talk List > >> *Subject:*[WebDNA] COMMITDATABASE in linux unix 64bits FastCGI=20 >> version 8.6 >> I am having an issue with a couple of dbs. >> Permissions are correct 775 >> Ownership is correct www-data:www-data >> I am updating the db with an ajax call, I open the db ofter it has=20 >> been modified and the mod is there in the db. >> The ajax call does a replace on the db. >> There is no error reported from the ajax call. >> >> >> The WebDNA preference is "Automatically commit databases to disk=20 >> after modification" >> The problem is that another page on the site is dependant on the new=20 >> value. This new value is not being found. >> I have include [flushdatabases] in the ajax call to force the db to=20 >> clear however it is still not finding the new value. >> If I use the WebDNA admin to [flushdatabases] then the page finds the=20 >> new value. >> Any ideas ? >> Kind regards >> Stuart Tremain >> Pharoah Lane Software >> AUSTRALIA >> webdna@plsoftware.com.au >> >> --------------------------------------------------------- This=20 >> message is sent to you because you are subscribed to the mailing=20 >> listtalk@webdna.us To unsubscribe, E-mail=20 >> to:talk-leave@webdna.us=20 >> archives:http://www.webdna.us/page.dna?nu= mero=3D55Bug=20 >> Reporting:support@webdna.us >> --------------------------------------------------------- This=20 >> message is sent to you because you are subscribed to the mailing=20 >> listtalk@webdna.us To unsubscribe, E-mail=20 >> to:talk-leave@webdna.us=20 >> archives:http://www.webdna.us/page.dna?nu= mero=3D55Bug=20 >> Reporting:support@webdna.us > > --------------------------------------------------------- This message=20 > is sent to you because you are subscribed to the mailing list=20 > talk@webdna.us To unsubscribe, E-mail to: talk-leave@webdna.us=20 > archives: http://www.webdna.us/page.dna?numero=3D55 Bug Reporting:=20 > support@webdna.us=20 --=20 Jym Duane - CTO - Purpose Media Creating Your Success Story Marketing : Television - Internet -Print Phone: (877) 443-1323 Email: jym@purposemedia.com Web: www.purposemedia.com Oregon - www.GuideToOregon.com PO Box 1725, Jacksonville, OR 97530 California - www.OrangeCounty.net PO Box 2025, Capistrano Beach, CA 92624 --------------DBD910D1BB0E81D7CE045A23 Content-Type: text/html; charset=utf-8 Content-Transfer-Encoding: quoted-printable

as mentioned to clarif= y emails..

perhaps admin can see if Talk List email can be configured to put the sender email in cc field?

jym


On 2/18/2020 5:31 PM, talk@webdna.us wrote:
Hi Terry

It is hard to work out who sent email to the =C2=A0= list now that the =E2=80=9Cfrom" has changed.


The call is very simple, a url with variables.=C2=A0=


admin-switch.dna?task=3Dswitch-6&dbid=3D6&d= bidname=3DSM-ID&dbname=3Dshippingmethods&dbfield=3DSM-ACTIVE&= active=3DT


The receiving page is very simple too= ..

[REPLACE db=3D../data/[DBNAME].db&eq[DBIDNAME]datarq=3D[DBID]&= max=3D1][!]
[/!][DBFIELD]=3D[url][DBVALUE][/URL][!]
[/!][/REPLACE]


The replace is 100% correct in the db file if I ope= n it up, the problem is that until I manually flush the dbs it is not recognised.

I have tried putting in=C2=A0[CLOSEDATABASE db=3D../data/[DBNAME].db] or=C2=A0[COMMITDATABASE db=3D../data/[DBNAME].db] or even [flushdatabases] with no resolution.

It is not the one db, I have another ajax update fo= r another db which has the same issue. I have not gone through the entire system checking for others.

Kind regards

Stuart Tremain
Pharoah Lane Software
AUSTRALIA
webdna@plsoftware.com.au=







On 19 Feb 2020, at 12:11, talk@webdna.us wrote:

Morni= ng Stuart,
=C2=A0
You mentioned =E2=80=9CI have include [FLUSHDATABA= SES] in the ajax call=E2=80=9D =E2=80=A6.am I correct to sa= y that you are either doing a GET or POST Ajax call to a file sitting on the server that has the tags to execute the flush webdna tag?
=C2=A0
If so =E2=80=A6can share the ajax call script and the page = called by it so that I can try to assist you. It is indeed strange that the change is stored in RAM but not committed into the DB even with all the settings you mentioned. Regardless =E2=80=A6after the update, the uncommitted change should still be showing up when called upon by other pages relying on it.
=C2=A0
Cheer= s TDn
=C2=A0
From:=C2=A0talk@webdna.us=C2=A0&l= t;talk@webdna.us>= =C2=A0 Sent:=C2=A0We= dnesday, February 19, 2020 07:39 AM
To:=C2=A0We= bDNA Talk List <talk@webdna.us> Subject:=C2=A0[W= ebDNA] COMMITDATABASE in linux unix 64bits FastCGI version 8.6
=C2=A0
I am having an issue with a couple of dbs.
=C2=A0
Permissions are correct 775
Ownership is correct www-data:www-data
=C2=A0
I am updating the db with an ajax call, I open the db ofter it has been modified and the mod is there in the db.
=C2=A0
The ajax call does a replace on the db.
=C2=A0
There is no er= ror reported from the ajax call.=


The WebDNA preference is "Automatically commit databases to disk after modification"
=C2=A0
The problem is that another page on the site is dependant on the new value. This new value is not being found.
=C2=A0
I have include [flushdatabases] in the aja= x call to force the db to clear however it is still not finding the new value.
=C2=A0
If I use the WebDNA admin to [FLUSHDATABASES] then the page finds the new value.
=C2=A0
Any ideas ?
=C2=A0
Ki= nd regards
=C2=A0
St= uart Tremain
Ph= aroah Lane Software
AU= STRALIA
webdna@plsof= tware.com.au
=C2=A0
=C2=A0=
=C2=A0
=C2=A0

=C2=A0

=C2=A0
--------------------------------------------= ------------- This message is sent to you because you are subscribed to the mailing list=C2=A0talk@webdna.us=C2=A0To unsubscribe, E-mail to:=C2=A0talk-leave@webdna.us=C2=A0archives= :=C2=A0http://www.webdna= ..us/page.dna?numero=3D55=C2=A0Bug Repo= rting:=C2=A0support@webdna.us
---------------------------------= ------------------------ This message is sent to you because you are subscribed to the mailing list= =C2=A0talk@webdna.us=C2=A0To unsubsc= ribe, E-mail to:=C2=A0talk-leave@webdna.us=C2=A0archives:<= span class=3D"Apple-converted-space">=C2=A0http://www.webdna.us/page.dna?nu= mero=3D55=C2=A0Bug Report= ing:=C2=A0support@webdna.us

--------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list talk@webdna.us To unsubscribe, E-mail to: talk-leave@webdna.us archives: http://www.webdna.us/page.dna?numero=3D55 Bug Reporting: support@webdna.us
--=20Jym Duane - CTO - Purpose MediaCreating Your Success StoryMarketing : Television - Internet -PrintPhone: (877) 443-1323Email: jym@purposemedia.comWeb: www.purposemedia.comOregon - www.GuideToOregon.comPO Box 1725,  Jacksonville, OR 97530California - www.OrangeCounty.netPO Box 2025,  Capistrano Beach, CA 92624 
--------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list talk@webdna.us To unsubscribe, E-mail to: talk-leave@webdna.us archives: http://www.webdna.us/page.dna?numero=3D55 Bug Reporting: support@webdna.us --------------DBD910D1BB0E81D7CE045A23-- . Jym Duane

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:

Add - optional parameters textA=.... (1997) Re2: frames & carts (1997) First postarg not taking in $Commands (1997) process SSI (1998) WCS Newbie question (1997) I'm new be kind (1997) Search/sort in URL Was: GuestBook example (1997) PCS Frames (1997) Danger of [newcart] (1999) Can this be done? (1997) [WebDNA] WebDNA on LiveCD ... (2008) [WebDNA] More wish-list requests implemented (2016) Preventing code execution (2003) WebCatalog dying in WebTen Revisited (1998) jpeg upload compression (2002) WebCat2 several catalogs? (1997) What ports does Webcatalog use (2003) redirect with frames (1997) Document Contains no data, or showcart error. (1997) SKU lookup (1997)