Installation error
Last Post 04-18-2011 06:31 AM by Ryan Bakerink. 6 Replies.
AddThis - Bookmarking and Sharing Button
Author Messages
jonathangmillerUser is Offline
Posts:4
Avatar

--
03-22-2011 12:47 PM
    After installing the DUD on a page, I get the error:

    Error: User Directory is currently unavailable.
    DotNetNuke.Services.Exceptions.ModuleLoadException: A column named 'Email' already belongs to this DataTable. ---> System.Data.DuplicateNameException: A column named 'Email' already belongs to this DataTable. at System.Data.DataColumnCollection.RegisterColumnName(String name, DataColumn column, DataTable table) at System.Data.DataColumnCollection.BaseAdd(DataColumn column) at System.Data.DataColumnCollection.AddAt(Int32 index, DataColumn column) at System.Data.DataColumnCollection.Add(String columnName) at effority.UserDirectory.View.GetUserTable(Boolean FromCache) at effority.UserDirectory.View.Page_Load(Object sender, EventArgs e) --- End of inner exception stack trace ---


    Any idea on what is going wrong?
    CandaceUser is Offline
    river guide
    river guide
    Posts:2431
    Avatar

    --
    03-22-2011 02:37 PM
    Hi Jonathan,

    Can you please check in Admin, User Accounts and see if you have a profile field called Email?

    Email is considered a built in credential so it can cause a conflict if you create a profile property with the same name. You will need to delete this and if you're using Dynamic Registration, please map your field to the email credential under DNN Core Integration.

    Thanks!
    Candace
    jonathangmillerUser is Offline
    Posts:4
    Avatar

    --
    03-22-2011 03:47 PM
    Yes - there is a profile field email. The site is already running, so I don't want to loose the data. What are the specific steps to delete and remap, without loosing the data.
    jonathangmillerUser is Offline
    Posts:4
    Avatar

    --
    03-27-2011 12:48 PM
    Bump.
    Chad NashUser is Offline
    Posts:5260
    Avatar

    --
    03-28-2011 05:51 AM
    Hi Jonathan - Unfortunatly there is not a direct 'easy' way for changing all previously mapped content that was mapped somewhere else to being mapped into another profile field or user credential. Basically all data is saved in the DynamicRegistration_QuestionResponse table but then after that its based on where the fields is mapped with DNN.

    The only way to really handle this is to write up some SQL queries to find the old data in either our tables or in the DNN Core (the other field where you mapped it) and then update the DNN users table based on that)

    1st - Maybe there isn't a problem at all? I know you specified this in a new email profile field that is set under advanced question options, DNN Core field, but was it also set under the DNN Core Integration area? If it was set under the DNN Core Integration area as well then you should already have the data.

    If you don't then you would need to do a few things....

    1. Write a SQL Statement to update the Users table based on the previous User Profile Property Definition ID
    OR
    2. Write a SQL statement to update the users table based on the DynamicRegistratin_QuestionResponse table.


    Your SQL statement might be slightly changed from some other customers that needed this because I believe this is the first time that a customer needed the main users table / user credentials updates. Sometimes customers have needed the user profile table itself updated.

    I would check into this thread:
    http://www.datasprings.com/products...s/aft/3041



    -Chad



    -Chad
    jonathangmillerUser is Offline
    Posts:4
    Avatar

    --
    04-16-2011 07:25 AM
    It turned out that there was some other existing module on the page that was creating the conflict. I deleted all other modules (making sure there was nothing in the Existing Modules drop down) and then added a new module and it worked.
    Ryan BakerinkUser is Offline
    river guide
    river guide
    Posts:1900
    Avatar

    --
    04-18-2011 06:31 AM
    Hello Jonathan,

    Glad to hear this was resolved.

    If you ever have any questions please let us know.

    Thanks,

    Ryan


    ---
  • film izle
  • 720 izle
  • film
  • sinema izle
  • film makinesi
  • T�rk�e dublaj film
  • film izle
  • film izle
  • baglan film izle
  • sinema izle
  • 1080 film izle
  • film mercegi