Server Connect Table Refresh

Wappler General Need Help
1

I have a admin dashboard that I replicated for 2 sites. I just changed a field’s name and deleted one on the duplicated database.

Then I copied the dmx folders and admin dashboard folders to the new site. I changed the connection name and refreshed the database in the connection settings screen. I then opened the insert record action step and refreshed the database/table.

It is not refreshing and still picks up the old fields with the deleted one showing and the one with the changed name also still shows old name.

Is there a place in Wappler I can delete the cached db information? Or am I forced to recreate the whole dashboard again?

2

Marcel, I have found that, when I modify Server Action Steps, the JSON within the resulting PHP file will not update accordingly. I have found that the easiest approach is to delete the original and redo the steps. Alternatively, create new steps that mirror the old ones but with a different name. Do remember to change the data source under App Connect.

Maybe, if we can find a pattern when the update does not happen correctly, we can report a bug, but until then, just try to cope.

3

Can you please post a few screenshots showing step by step what exactly have you copied, where and what have you renamed, deleted and refreshed?

4

I have had the same problem when copying a php file, some data stays the same despite changing it in the wappler UI. So I end up always have to manually recreate the server action.

5

Guys, I need the exact steps with screenshots showing what are you exactly doing, deleting and changing, to be able to tell you what you are doing wrong.

6

I started with exporting the db and importing it for the new site. Just some basic stock management and sales: The original:

49

Then changed some field names - did not need year and changed sold to stock to keep stock count:

18

Then I copied over all the dmx created folders from old site + my admin screens

I wanted to change my db connection name so I deleted the config file with the db connection settings.

I created the new connection and then made sure this connection was selected in following steps like insert or query

55

06

I changed the fields in admin forms to reflect the changed server connect info - input field names, etc.

Then I re-selected the form in server connect to in post variables with new name(s). Think it was just the stock/sold change.

I opened the db dialog and tested for it to get the new fieldnames from db.

I also clicked the refresh button in the insert db dialog to retreive the new db fields.

And now that I am doing screenshots, I see it does display the correct fields… so my whole rant above seems futile…

16

I’m not sure what could have changed. I just sat down to write this now without doing any work, refreshes or anything…

Will see if I do i again in future and run into this if I can document immediately.

1 Like
7

I have had the same problem a few times and now I’m writing it down here since this is where I ended up on those occasions… :roll_eyes:

The only steps needed in the above post is:

  1. Open the associated server connect action file.
  2. Enter the query builder for each query in the action file and press refresh and ok.
  3. Save the action file and it should now be updated.

To verify; open the action file in the code editor and check that the json output section has been updated.

It would of course be very nice if this refresh business would occur automatically, but I guess there’s some logical reason why it doesn’t?

I would be even nicer if one could refresh all or selected server actions at once by pressing the refresh button in the workflow tab. As of now it is not very clear what all the different refresh buttons in the Wappler GUI 5.4.1 actually refreshes?

1 Like