Mssql not updating table

[dra]

I have reached the end of tutorial 7 User Registration. I attempted to register an account the email validation worked but the data is not being inserted in the table. I have include a number of images to assist in troubleshooting this issue. Thanks in advance.

[Dave]

I do not see the variable $_POST.regEmail in your Insert fields? Is it included in your Inputs? Where is this coming from, and what happens if you remove it?

[dra]

Thanks Dave.
The $_POST.regEmail is converted to lowercase and place in the email variable.

[Hyperbytes]

A good place to start would be here as you can see if there is an error in your action

Debugging Server Connect Errors

You can easily debug issues related to server-side processing such as - form not sending email, record not inserting or updating, query not showing data etc. The first thing you need to do is to open the server connect settings. They are located in the Workflows Panel > Server Actions: [Screenshot 2021-09-27 at 10.02.35] And enable the Debug Mode: [Screenshot 2021-09-27 at 10.03.08] Click Save: [Screenshot 2021-09-27 at 10.03.26] In your browser, open the Developer tools. If you don’t k…

[dra]

Solved! The field for holding the password in mssql was less than the length of the encryption key.
Also, I needed to pass in a value for a field that was set to “not null”.