Hi = Stuart,
Ran the = Ajax process with Linux (Centos) WebDNA v6 without issue. WebDNA 6 on = Windows and WebDNA 8.6 on Win2012R2 also no = issue.
If you = called the landing page that Ajax called directly by typing in the URL = in a browser =E2=80=A6does it work as it is supposed = to?
Ajax is = simply JS and for all intended purposes, it is simply sending out form = data. We know that the server picked up the variables cause the DB is = updated =E2=80=A6that means the issue cannot be AJAX related. = It=E2=80=99s the landing page with the REPLACE tag and onwards. Hence, = doing it manually by calling the landing page directly will show up any = possible error in the browser. AJAX call mask the server response since = I am assuming you are not doing any AJAX validation for a = response.
Also = =E2=80=A6to confirm =E2=80=A6AJAX to landing page and then the = 2nd page is called by the landing page (after it has done its = mojo jojo)? Or folks makes selection and AJAX updates in the background = with no visible result output =E2=80=A6.data sent to landing page and NO = call to 2nd page from landing page. Visitor clicks a link to = see the 2nd Page.
I find = that tapping the landing page without AJAX first to test that all is = fine and working =E2=80=A6then introducing AJAX to tap the same landing = page helped me solved numerous bugs over the years where I only used = AJAX to send and not receive back data.
Cheers = Terry Nair
From: talk@webdna.us = <talk@webdna.us>
Sent: Thursday, February 20, 2020 = 06:40 AM
To: WebDNA Talk List = <talk@webdna.us>
Subject: Re: [WebDNA] COMMITDATABASE in = linux unix 64bits FastCGI version 8.6
Hi = Scott
2) open the db to ensure that changes have been = made
3) Clear browser cache, test the page that relies on = the new value. Repeat.
4) No positive result from step 3, flush db from = /WebDNA directory link
5) 2nd test of page = that relies on the new value - page works properly now with correct = value.
I will be testing this = across the other dbs in the site and dbs in other sites that use the = same version of the fcgi and a different version of the fcgi. Currently = I know of the problem in two dbs in the same = site
Hi Stuart,
When you use Flush, to my (perhaps = limited) understanding the data is written to disk and purged from = memory, and can take a few seconds at times. Only then when another call = to that DB is made is the DB reloaded into memory. Perhaps the second = call is happening before the flush has completed? In this case, Commit = would do it I gather.
I notice below you mentioned the use of Commit already also = to no avail. One check might be just to ensure that the DB name var is = being passed properly, as no error message would be generated if it = wasn=E2=80=99t, and the Commit wouldn=E2=80=99t show the drop in DB from = memory on the admin pages.
Just my 2cents = chap.
BR
Scott
Hi = Terry
It is hard to work out who sent = email to the list now that the =E2=80=9Cfrom" has = changed.
The call is very simple, a url with = variables.
admin-switch.dna?task=3Dswitch-6&dbid=3D6&dbidname=3D= SM-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][!]<= o:p>
= [/!][DBFIELD]=3D[URL][DBVALUE][/URL][!]
The replace is 100% correct in the = db file if I open it up, the problem is that until I manually flush the = dbs it is not recognised.
I have tried putting = in [CLOSEDATABASE db=3D../data/[DBNAME].db] or [COMMITDATABASE = db=3D../data/[DBNAME].db] or even [FLUSHDATABASES] with no = resolution.
It is not the one db, I have = another ajax update for another db which has the same issue. I have not = gone through the entire system checking for = others.
You mentioned = =E2=80=9CI have = include [FLUSHDATABASES] in the ajax call=E2=80=9D =E2=80=A6.am I correct to say 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?
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.
From: talk@webdna.us <talk@webdna.us>
Sent: Wednesday, February 19, 2020 = 07:39 AM
To: WebDNA Talk List <talk@webdna.us>
Subject:<= span class=3Dapple-converted-space> [WebDNA] COMMITDATABASE = in linux unix 64bits FastCGI 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 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 after = modification"
The = problem is that another page on the site is dependant on the new value. = This new value is not being found.
I have = include [FLUSHDATABASES] in the ajax call to force the db to clear = however it is still not finding the new value.
If I use = the WebDNA admin to [FLUSHDATABASES] then the page finds the new = value.
------------= --------------------------------------------- This message is sent to = you because you are subscribed to the mailing list talk@webdna.= us To = unsubscribe, E-mail to: talk-leave@w= ebdna.us archives: http://www.w= ebdna.us/page.dna?numero=3D55 Bug = Reporting: support@webd= na.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/p= age.dna?numero=3D55 Bug Reporting: support@webdna.us=
N=EF=BF=BD=EF=BF= =BD,j=EF=BF=BD=C7=A7=EF=BF=BD=EF=BF= =BD2=EF=BF=BD=EF=BF= =BD=EF=BF=BDq=EF=BF=BD{*.j=EF=BF=BD =EF=BF=BD&=EF=BF=BDv=EF=BF=BD-=EF=BF=BD=E9=9A=8AX=EF=BF=BDX#<^_NSEDR_^#<=D6=A5=EF=BF=BD=EF=BF=BDvv=EF=BF=BD:.=EF=BF=BD=CB=9B=EF=BF=BD=EF=BF= =BD=EF=BF=BDm=EF=BF=BD&j)m#<^_NSEDR_^#<=D6=A5=EF=BF=BDW=EF=BF=BD=EF=BF= =BD=E2=80=91m=EF=BF=BD=DA=BA=C6=ABr=EF=BF=BDz=EF=BF=BDm=EF=BF=BD=EF=BF= =BD
0y=EF=BF=BDgj=EF=BF=BD?=EF=BF=BD=E2=80=91vv=EF=BF=BDg=EF=BF=BD
y=EF=BF=BDz=EF=BF=BD+=EF=BF=BD)=EF=BF=BD=EF=BF= =BDi=EF=BF=BDpy=EF=BF=BDg