Database Single Query: database inters and database update does nothink

Hello. I am learning from youtube videos that provided by wappler and I am struggling to make it work Database Single Query: database inters and database update does nothink. I am repeating everythink from learning video nr15 from youtube. Checked few times if i missed somethink and couldnt find what. Page loads fine, after submiting validation code it takes me to home page but does not update validation time and does nothink in role database. Any one could help me please? thank you

Please provide screenshots and further troubleshooting details for us to help you.








Here is pics. So when I fill up register form, it does create database note with all details. but when i do validation code after submiting i dont get update on user database and nothink is added on role database

Or if you turn your debug mode on:

You should be able to debug your issue in web server logs window without leaving wappler!

Here is what you should have:
Inputs:


Query:

Query Conditions:

Update:

Update Conditions:

Role Insert:

Take a look at the developers console Fetch/XHR tab and check the output of the query contains a user_id
Select output on the update and insert queries and check the output which should show the number or rows upadted and number of records inserted, they should both be 1.THis will also confirm that leg of the api action is running

You can check that the authcode is send correctly by temporarily adding a set value line to the API action like above and checking the output in the developers console.

image

You could also do the same with $_POST.email if necessary.
I see nothing obvioulsy wrong in the code (although some info is missing), it will probably be a small and subtle mistake.

Here is a copy of the original from the tutorial as a zip file which you can add to "/app/api/registration" directory which will create an API called validate_code_reference you can use for comparison.

validate_code_reference.zip (1.4 KB)