User ID must be unique-Registration Freezes app

[EricN]

Testing my registration method. I intentionally attempted to register using a known userid already in system. Example: sophie45. When I click submit, I get the expected (and hoped for - User ID must be unique).

But, when I attempt to change the userid to sophie44 (or anything) and click submit, the app freezes or goes into an endless loop.

I used the AlwaysUp restart app but that didn't work. I have to restart the server with each test.

Here are my registration dialog's events:
Initialize:
CurrentForm.Controls.Userid.value = ""
Dim session.__protected__UserId as C
a5ws_get_user_values(CurrentForm,request)
CurrentForm.Controls.groups.value=a5ws_get_guid_from_group("JobSeeker",request)

Validate:
request.variables.ulink=userid
a5ws_save_user_values(CurrentForm,request)
session.__protected__UserId=alltrim(CurrentForm.Controls.ulink.value)

Aftervalidate:
a5ws_get_user_values(CurrentForm,request)

dim userid as C
dim ulink as C
dim password as c
dim SecQues as c
dim SecAns as c
dim groups as C
dim tbl as P
'=================== Open user table and populate fields
tbl=table.open("[pathalias.adb_path]\users")
tbl.enter_begin(.T.)
tbl.Userid = alltrim(Userid)
tbl.Secquest = alltrim(SecQues)
tbl.Secanswer = alltrim(SecAns)
tbl.User_type = groups
tbl.Email = Email
tbl.Addcreditemail = Email
tbl.enter_end(.T.)
'=================== Set Session Variables
session.__Protected__Userid = tbl.Userid
session.ulink = tbl.Ulink
tbl.close()

' ============ Redirect to appropriate page
CurrentForm.RedirectTarget ="JSRegister.a5w?Userid=CurrentForm.controls.userid.value"

Activate:
queslist = a5ws_get_security_ques(request)
pagelist = a5ws_get_page_list(request)

Is there something in here in my events that could be the culprit?

Thanks in advance!

[Steve Wood]

Re: User ID must be unique-Registration Freezes app

I did not read through your list, but it sounds like you are using the same form, without refreshing, to attempt to enter a new user. Try again, but always leave, then come back to your screen that adds users. If that works, then the problem is your add users screen does not blank out the request.variables.guid in between attempts to register someone. The first time, it sets it to sophi45's guid, then when you reattempt, it is still set to sophi45's guid, even though you changed the userid. The function that saves the user record uses guid as the primary if it exists.

[JerryBrightbill]

Re: User ID must be unique-Registration Freezes app

If the function "a5ws_save_user_values()" finds an error, it will not save any data and will return CurrentForm.has_error = .T. which will prevent the AfterValidate from firing. The dialog processing should stop and just return you to the original dialog.

You should use the function "a5ws_Save_WebUser_Values()" in place of "a5ws_save_user_values()" as the newer function does not require changing the value of any request variables. The tutorial in the help for "Adding Users With a Web Component" shows the proper use of the function. There is also a newer function that just validates the data, "a5ws_Validate_WebUserValues()"

This help page lists all of the web security functions.

[EricN]

Re: User ID must be unique-Registration Freezes app

Thank you Steve and Jerry!

I've made changes as per the updated Adding Users with a Web Component to my newjobseeker component and tested with a unique userid.
System hangs and I have to reboot server.

I then republished my old newjobseeker component and tested with a unique userid.
System hangs and I have to reboot server.

I then attempted to register using my newemployer component (I have not touched today) and tested with a unique userid.
System hangs and I have to reboot server.

All adding a new user tests now make the app hang. :( I can't access ANY of the apps pages.

AlwaysUp does not help. I check restart app. It stops the app and then restarts but I still can't access any of my Alpha pages. I have to reboot the server.

Could something (file) now be corrupt?

Update: I deleted all files on the server and did a complete republish. Tested the add user.
System hangs and I have to reboot server.

[EricN]

Re: User ID must be unique-Registration Freezes app

Well I see my table tbl=table.open("[pathalias.adb_path]\users") is not closing. And causing the hang?

This dialog worked before now...what? I just updated to 1997_3250. A bug? If you look at my code above, it looks like I'm following the example in the Alpha help file. I'm using tbl.close()

Any thoughts appreciated.

[MikeC]

Re: User ID must be unique-Registration Freezes app

hi Eric,
As no true debug in webside, Steve Wood had suggested in a prior thread to write to a page in lieu of it....so just as a procedure, do this at points in your app prior to your tbl.close() is supposed to occur to find out where your script stops.

Just something to pass the time until someone else stops by or you experience an epiphany regarding this!! :)

[EricN]

Re: User ID must be unique-Registration Freezes app

Hello Mike,
I did follow Steve Wood's advice. My "epiphany" :) was to realize that successful code in my new user dialog's events that I have not touched for several months suddenly stopped working. Refresh is not necessary because I was attempting to register with a known non-unique userid.

I'm now playing with my aftervalidate event. I commented all of the table code and attempted to register again, it worked!
I will continue to experiment with the events and will be sure to report back when/if I find the exact line(s) causing my sudden issue.

Thanks Mike for all the advice you have given me in the past. Very much appreciated.

[Al Buchholz]

Re: User ID must be unique-Registration Freezes app

Hello Mike,
Well my :) was to realize that code that has been working for several months suddenly stopped working. I'm now playing with my aftervalidate event and will be sure to report back when/if I find the exact line(s) causing my sudden issue.

Did your code stop working after a patch?

Maybe you should roll back to the version that it was working on and try it there again........

[EricN]

Re: User ID must be unique-Registration Freezes app

Hello Al,
That is what I'm wondering. I haven't tried to test register for a week or so. I am wondering if it could be related to the patch.

Maybe I should do a "rollback"

[EricN]

Re: User ID must be unique-Registration Freezes app

I conducted simple tests such as:
dim tbl as P
tbl=table.open("[pathalias.adb_path]\posts")
tbl.enter_begin() (also included the .T.)
tbl.Userid = "yyyooo"
tbl.Company_name ="Johnson"
tbl.enter_end(.T.)
tbl.close()
? "Hello"

Even this made my app hang to the point where I had to reboot the server. At the end of a very long day, I finally decided to try an AppServer rollback.

Rollback did it. Everything works fine again. I rolled back to 1938_3239.

[Al Buchholz]

Re: User ID must be unique-Registration Freezes app

Eric

I must be missing something.. What do you think should cause the record in the table to be unique?

I don't see you testing for a key value already existing in the script.

Do you have a field rule unique-ness test?

All I see is that you enter a record in the table regardless if the record values already exist....

[EricN]

Re: User ID must be unique-Registration Freezes app

Sorry, I should have been more clear explaining my conclusion...

In my original post above I thought it was the uniqueness test causing my problem. However, the aftervalidate event in this same NewUsers dialog writes to my users table using code a little more complex than described in my post #10. It turned out that my problem was creating new records using the tbl.enter_begin().

I tested several of my other dialogs that also create new records using tbl.enter_begin() and had the same problem where the app would hang and I had to reboot the server.

Then I created this simple code page (post # 10) and tested. Same hang.

Everything else worked; code pages, grids, dialogs as long as they didn't have tbl.enter_begin(). I could update records but not create a new record using tbl.enter_begin()

But when I rolled back, all my scripts that didn't work using tbl.enter_begin() with the new patches now again work as expected.

[JaxxB]

Re: User ID must be unique-Registration Freezes app

The still did not work. The page is not redirected, the user is not added to the websecurity group.