Node.js server woes continue - Database updates, adds, server actions running after success of others all fail

Wappler General Need Help
1

Step by step getting there.

Queries all run.
Updates seem to run without error but nothing is updated
Inserts seem to run without error but nothing is inserted

I have a couple of steps that run one after the other when a successful server action runs Step 1 follows step 2 and then step 3 and then step 4 each updating different tables - This runs the first time and then when repeating the action it stops after step 1 and step 2 is not triggered.

The server(index.js) is open in terminal and I see the actions run. No errors but also no inserts, updates and data refreshes on the pages, except for all queries that ran on initial opening of page.

Screenshot 2022-03-02 at 08.40.56
Screenshot 2022-03-02 at 08.40.561162×324 74.9 KB

Not sure how to provide logs if it is a hosted server and not local…

@patrick Let me know what you need to troubleshoot something like this.

Thanks in advance!

2

Does your inserts have a WHERE clause?

3

What exactly is the problem? I see you have the debug on for the database actions, so nothing is executed but just the generated sql is displayed …

4

Hi, thanks for the replies. I have a deadline to get the app running for the client today. Trying Digital Ocean, but without Docker. So will get back to this problem(probably tomorrow) once I am sorted on DO.

@Apple The inserts have a where

@George I will make comparitive videos of how it runs locally vs on the server

appreciate your help

5

Is “persentage” with an “s” the literal name of the table field which you want to update ?

And “queryTotalPersentage” with “s” is a deliberate naming that runs locally with values updated?

6

Going to close this issue - I just went with a docker container and Linode which works and is fairly easy to setup. Got everything up and running except SSL with Traefik. Port already in use which is an error I got most of the time trying to manually install a certificate using ssh with the lets encrypt command line tools before using wappler’s easy solution which as I say does not work on Linode.