What would cause a simple query, add and delete server actions to work on local server with the same remote database, but not on the remote server.
On local query, add and delete works.
Remote, not…
Seems mysql is v8
PHP on remote is:
PHP on local is 7.3.x
Ok, good news is the server actions run.
BUT, I have to clear the browser cache every time I run an add or delete to refresh the list query.
It is set to run onsuccess of form submit and does run, but for some reason the data is cached on first run.
Any idea what could cause this?
I see the serverconnect query actually does not run. I think it might be because I have a form within a repeat section. Not sure
<ul class="list-group list-group-flush" is="dmx-repeat" id="repeat1" dmx-bind:repeat="api_track.data.results.trackmatches.track" dmx-hide="api_track.state.executing">
<li class="list-group-item">
<form id="formAddItem_{{$index}}" is="dmx-serverconnect-form" method="post" action="dmxConnect/api/songAdd.php" dmx-on:success="notifies1.success('Song added');serverconnectTest.load({})" dmx-on:unauthorized="notifies1.danger('Already selected 3 songs.')">
<div class="d-flex">
<div class="d-flex w-75 align-items-center text-start" dmx-text="name+'-'+artist"></div>
<input id="addedLeerling" name="addedLeerling" type="hidden" class="form-control" dmx-bind:value="query1.data.ref">
<input id="addedItemName" name="addItemName" type="hidden" class="form-control" dmx-bind:value="name">
<input id="addedItemArtist" name="addItemArtist" type="hidden" class="form-control" dmx-bind:value="artist">
<div class="d-flex align-items-center justify-content-end w-25 text-end">
<button id="btn2" class="btn mb-0 btn-primary btn-sm" type="submit">
<i class="fas fa-plus"></i></button>
</div>
</div>
</form>
</li>
</ul>Does this work? I think you should use dmx-bind:id instead