I have an application that is using an API that i created for a home valuation.
I can get the API to run successfully and have no issues with this.
However, when try to add a server action after the API process, its a simple database update…i get a 404 error and the page does not load. I have checked all of my connections / database…etc and i don’t see any issues.
If i remove the database update application, the page loads again without an issue.
any thoughts on what i am missing?
Maybe the query has a typo?
no, even a simple database query * from the table results in the same thing.
Is it only in combination with the API step that it doesn’t work or do database queries never work? Also turn pass errors off in the API steps.
I would always clone the same database locally as another target setting on your development machine so that you can double check the written query as it is stored in the actual Wappler file that makes the database call. Then you could really eliminate one variable in your focus.
When I go to your url I find this error –
So it already looks like you have a field whose datatype will not allow the query as you have written it to go farther than the error popping up because of this one field.
For instance if your database field can only store a binary value but your query is trying to pass or UPDATE it with a text string, for just one of hundreds of mismatches possible.
So I looked up the error above –
A local database that is a clone of the online one would have revealed your problem immediately and you would have known to correct your query first.
