R2i DotNetNuke® Forum

R2i wants you to have the opportunity to ask questions, post reviews, help others or just rant and rave about DotNetNuke® or any of the R2i Modules and Skins. Our team spends hour upon hour, day after day, working on custom DotNetNuke® modules and services; please feel free to ask us anything.
 
aspnet_Profile table?
Last Post 01 Jan 1900 05:00 AM by . 2 Replies.
Printer Friendly
Sort:
PrevPrev NextNext
You are not authorized to post a reply.
Author Messages Informative
rabidmaxUser is Offline
New Member
New Member
Posts:2

--
26 Apr 2007 12:40 AM  
Hmm, this is an odd one... I just downloaded the gomaps PA and tried installing it into my DNN 4.4.1 installation, and had a big SQL error showing up along the lines of:
SQL Execution resulted in following Exceptions: System.Data.SqlClient.SqlException: Cannot alter table 'dbo.aspnet_Profile' because this table does not exist in database 'DotNetNuke_Dev_JK'.

I took a look at my schema and theres definitely no aspnet_Profile table, there is an aspnet_Profiles table however, but I can't see anyone else here with a reference to this problem, and can't imagine it would be an issue with my installation... it's just a stock standard install as far as I know. It's not on any hosting provider or any such, it's my local server.

Any ideas why it would bug out in such a way? Is there a pre-required module that it's supposed to 'plug in' to that I missed somewhere?

Not sure what I should do now, it looked like such a funky module, was looking forward to having a play with it.

Thanks in advance for any help,
Max
rgallaisUser is Offline
Basic Member
Basic Member
Posts:146

--
30 Apr 2007 07:00 PM  
In this version of DNN, this table is unused; the best option is to rename this table to aspnet_Profile (without 's') without any risks.
I am at a loss for why this table is named with an 's' at the end; aspnet_profile is a core dnn table that is no longer used, as profile information is now stored in the userprofile table.

Just for verification, your aspnet_profile table should have the following colums:
UserId
PropertyNames
PropertyValuesString
PropertyValuesBinary
LastUpdatedDate

Let us know.

Regards.
Romain Gallais<br>Business Intelligence Force, Inc. (bi4ce)
rabidmaxUser is Offline
New Member
New Member
Posts:2

--
30 Apr 2007 09:59 PM  
Hi Romain, thanks for the reply.

I took another look at my database and this table seems to be the one you are referring to, it has all those columns that you posted above. I'm not sure why it came to be named aspnet_Profiles, but oddly all the other dev/test/live databases we've been using have it correctly named aspnet_Profile! I guess somewhere along the line it was renamed on my version, and never noticed because like you say, it's no longer used.

Ah well, sorry for the inconvenience, I'll just trundle off and sit in the corner

Cheers,
Max
You are not authorized to post a reply.

Active Forums 4.1
 

New York, NY • Baltimore, MD • Vienna, VA • St. Louis, MO • Seatle, WA • 410.327.0007 • info@R2Integrated.com

Bookmark & Share Bookmark and Share