DNN Forums

Ask questions about your website to get help learning DNN and help resolve issues.

FirstName and LastName being set blank

 11 Replies
 3 Subscribed to this topic
 24 Subscribed to this forum
Sort:
Page 1 of 212 > >>
Author
Messages
Joe
New Around Here
Posts: 6
New Around Here

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.

Veteran Member
Posts: 370
Veteran Member
5 Helpful Replier
Helpful Replier
Thanks for being such a helpful replier!
New Poster
New Poster
Congrats on posting!
5 Engaged Reader
Engaged Reader
You are an engaged reader!
2 Avid Reader
Avid Reader
Avid Reader art thou!
2 Most Liked
Most Liked
Congrats, your posts are really liked!

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

Senior Member
Posts: 1607
Senior Member
MVP
MVP
You're an MVP!
New Poster
New Poster
Congrats on posting!
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

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.

New Around Here
Posts: 9
New Around Here
Did you ever find what was calling dbo.UpdateUser & setting it to ''? I am on 9.6.1 and SP: dbo.UpdateUser keeps setting a single users first/last name to ''.
Advanced Member
Posts: 178
Advanced Member
2 Helpful Replier
Helpful Replier
Thanks for being such a helpful replier!
New Poster
New Poster
Congrats on posting!
4 Engaged Reader
Engaged Reader
You are an engaged reader!
Avid Reader
Avid Reader
Avid Reader art thou!
What other modules are installed?
New Around Here
Posts: 9
New Around Here
Lots but most are our own C# code. Is there a way to export the list or get it using SQL?

I just noticed we still have DNNSecurityHotFix1 & "DNN Security HotFix 2017.1".
New Around Here
Posts: 9
New Around Here
Lots but most are our own C# code. Is there a way to export the list or get it using SQL?

I just noticed we still have DNNSecurityHotFix1 & "DNN Security HotFix 2017.1".
Senior Member
Posts: 1607
Senior Member
MVP
MVP
You're an MVP!
New Poster
New Poster
Congrats on posting!

It sounds like you might need to upgrade before you finish troubleshooting this. 🤔 

New Around Here
Posts: 9
New Around Here
Either the cache is not working and return "" or something is setting it to "" in the cache only. Table UserProfile always has the correct value.
Page 1 of 212 > >>

These Forums are for the discussion of the open source CMS DNN platform and ecosystem.

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