DNN Forums

Ask questions about your website to get help learning DNN and help resolve issues.
Prev
Next
Forums Development and Extensions SQL and SQL Server

FirstName and LastName being set blank

 3 Replies
 1 Subscribed to this topic
 16 Subscribed to this forum
Sort:
Author
Messages
Joe
New Around Here
Posts: 6
New Around Here
11/23/2023 11:46 AM

    I realize this is not the correct place for this, but I really dont know where to look and hopefully you can point me to the correct location.

    DNN has started setting the users.firstname, users.lastname to '' (Blank).  I ran a trace on the DB and here is the code see where @2=N'',@3=N'' is set to blank.

    exec sp_executesql N';Exec dbo.UpdateUser @0, @1, @2, @3, @4, @5, @6, @7, @8, @9, @10, @11, @12, @13, @14, @15',N'@0 int,@1 int,@2 nvarchar(4000),@3 nvarchar(4000),@4 int,@5 nvarchar(4000),@6 nvarchar(4000),@7 nvarchar(4000),@8 int,@9 int,@10 int,@11 nvarchar(4000),@12 nvarchar(40),@13 datetime,@14 int,@15 int',@0=13,@1=0,@2=N'',@3=N'',@4=0,@5=Ncorrectemail,@6=Ncorrectemail,@7=N'',@8=0,@9=1,@10=0,@11=N'73.237.35.66',@12=N'268a0392-05de-4eef-b786-baf461f54566',@13='2023-06-01 22:40:54.767',@14=0,@15=-1

    I believe this is a result of us setting the user first name and user last name as required.  This is DNN calling this when the user logs into the system.  I dont know where DNN is getting the ''.  The user names are correct in the users table AND the userprofile table.  If I leave the users table blank, DNN will update the userprofile table to blank as well.

     

    Has anyone seen this?  I found this

    https://www.dnnsharp.com/...e-being-erased-64846

    With the same issues, but NO updates as to what it was.  

    Any help would be appreciated.

    0
    Marco Alvarado
    Advanced Member
    Posts: 235
    Advanced Member
    11/23/2023 5:07 PM

      Have you looked into GitHub for existent errors already logged (https://github.com/dnnsof...nn.Platform/issues)?

      Will Strohl
      Senior Member
      Posts: 1430
      Senior Member
      11/28/2023 12:59 PM
        This sounds like the DNN instance you're working on may have been modified by someone. Meaning, there are very likely core code changes that are causing this unusual behavior. I'd suggest auditing the database and file system to restore all of the core code back to its original state.
        Joe
        New Around Here
        Posts: 6
        New Around Here
        11/29/2023 5:42 PM

          Posted By Marco Alvarado on 11/23/2023 5:07 PM

          Have you looked into GitHub for existent errors already logged (https://github.com/dnnsof...nn.Platform/issues)?

          Thanks, I did a search and could not find a similar issue.

          1

          These Forums are dedicated to the discussion of DNN Platform.

          For the benefit of the community and to protect the integrity of the ecosystem, please observe the following posting guidelines:

          1. If you have (suspected) security issues, please DO NOT post them in the forums but instead follow the official DNN security policy. 
          2. No Advertising. This includes the promotion of commercial and non-commercial products or services which are not directly related to DNN.
          3. No vendor trolling / poaching. If someone posts about a vendor issue, allow the vendor or other customers to respond. Any post that looks like trolling / poaching will be removed.
          4. Discussion or promotion of DNN Platform product releases under a different brand name are strictly prohibited.
          5. No Flaming or Trolling.
          6. No Profanity, Racism, or Prejudice.
          7. Site Moderators have the final word on approving / removing a thread or post or comment.
          8. English language posting only, please.

          Would you like to help us?

          Awesome! Simply post in the forums using the link below and we'll get you started.

          Get Involved