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=99= s 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 2ndPage.
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
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=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][!]
&nb= sp; [/!][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.
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.
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=1C=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=06=EF=BF=BD=11z=EF=BF=BD+=EF=BF=BD)=EF=BF=BD=EF=BF=BDi=EF=BF=BDpy=EF=BF=BDg