Hi Stuart,
Code wise =E2=80=A6you are = right =E2=80=A6I see nothing wrong. I replicated in on our FastCGI = WebDNA Win2012R2 boxes =E2=80=A6no issue works fine and gets saved as = well (via jQuery Ajax).
Will try it on our = Linux box later to see if the same occurs as per yours.
It may work around the = issue in the interim till the mystery is resolved. Another method is to = set up a [table] in your admin-switch.dna =E2=80=A6collect and store the = incoming variables there =E2=80=A6.then do the [replace] from the stored = [table] data to see if that helps. Incidentally =E2=80=A6having the = [table] there will help shorten the post url string as you can manual = have it in the table as default if needed.
Just to confirm =E2=80=A6onc= e the Ajax runs the call =E2=80=A6.variable gets to the landing page = =E2=80=A6data is updated in RAM but not in DB. Could you write a file = output after the replace to see if the file generated has the variable = value, since you are saying that the system is not seeing the variable = when called upon by another page and only after Admin Flush it = appears.
Cheers
Terry Nair
WhatsApp / Mob : +65 9672 9540
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.