Inserting and updating a new record in multiple tables joined by a foreign key?

HI @Teodor I completed the steps you described and from what I can see (Firefox) dev tools XHR I can only see the name of the repeating group under the json tab like this “user_reset ” which suggests that the it is not storing the values?

Steven, just out of interest. This is not a production website, right? If so you need to go for a more secure crypto to store the user password.

Hi JonL No not production, just trying to work out the process before I get there. In the database itself the Password is sha256 salted by a random string.

That is not very secure either :slight_smile:
Better use Argon. It was implemented recently.

1 Like

Hi @JonL, sorry but i have no idea what that is or how to use it. Is there a tutorial?

Yep.

Thanks! Once I get the other bits to work I will look at swapping it out.

1 Like

HI Teodor I am completely stumped!

It appears that the server action is not showing any of the data, been trying for days and nothing :sob:

I can see that one session variable I added is being picked up “YES” and I have simplified the condition to make sure that its not the way it is pulling the parameters and it would show the session variable as YES unless the condition was passed.

What on earth am i doing wrong here?

jason

work space

hI @Teodor I think I found the issue or why it was not doing what it was supposed to do.

In the above provided setup I did not have anything on the page “blank page” however, i put on this page the ‘hashok: “Yes”’ session value and everything started to work.

I added the input Parameters in the page server connect like this

And it worked.

Is this the step I was missing from the process??

Sorry, i am not sure I understand what you put where that fixed the issue :slight_smile:
Also from your last couple of posts I don really understand what are you doing and what session variables are you referring to …

Also you are using GET variables in your conditions? I really lost your whole idea for this server action here.

Thanks @Teodor

Basically it’s working now (two days of frustration) and I think I have figured out why and also I have been able to update the database which was my original objective.

After trying what must have been hundreds of combinations and I think I figured out when to use a Set Value and where to use a Session Value and what can be used from within a repeat and what can’t without exposing sensitive data.

I was basically doing a variation on what was described here:

but after following the process it did not work, so was trying to fix it and include a database update in the process. Which I have now done successfully.

HY @JonL I updated the password encryption to Argon and it works, but my automated processes don’t seem to.

So I had a email address check condition which uses {{email.sha256(password == $GET.hash)}} but this no longer appears to work - so assume it is the encryption method won’t let me do this anymore?

You need to use verify hash method inside the crypto formatters.

Thanks @JonL that’s a bit foreign to me at this stage. Is this different to hash method checkbox on the security manager? It sounds like inside the hash method there is an additional setting I should be using?

Are you able to point me in the right direction.

Sure.

image

And some literature about the formatter(php method).

https://www.php.net/manual/en/function.password-verify.php

1 Like

You can learn how to do this here:

2 Likes

Also I don’t know what your intentions are with that. It seems you are trying to hash the email value using TRUE/FALSE value as string salt. Weird stuff it you ask me :smiley:

It is in one of the tutorials in how to create a verifiable hash, such as password reset, so was following this process.

Condition being if the email encrypted 256 salted with password = the ?hash Then do x

It’s in a Wappler tutorial.

Ah the link is very useful, thanks.

So much to learn. But given myself 12 months to get there :scream:

1 Like

Thank @Teodor I got that to work!