Happy new year to mojoportal community. I have a strange problem and after hours of searching I decided to ask your opinion about it. I have one month experience with ASP.NET but luckily i managed to make a working module for this CMS. So, I suspect my problem is more of an ASP.NET issue.

I have added some custom settings on account/profile menu (UserProfile.aspx). I made a Data and a Business class for this equivalent to dbSiteUser and SiteUser (i did not want to mess with SiteUser for easiest possible upgrading purpose.). Everything works ok till the time i press the Update button. For some reason the update functions have no effect on database when they are called in the update button click handler. When i call them anywhere else in the code-behind they work fine without problems ( that is the most worrying part for me). I tried many many things for many hours.

Here is the function with "perfectly" working functions (i do not use these fixed values,i just wrote it like this to look for the problem):

    private void UpdateProfileExtension() {
    profext.Option = 3;
    profext.ShowFriends(); // updates field "ShowFriends" to option( = 3)
    profext.Option = 2;
    profext.ShowStats();// updates field "ShowStats" to option( = 2)
    profext.Option = 1;
    profext.ShowActs();// updates field "ShowActs" to option( = 1)
    }

Here is where it is called:

    private void btnUpdate_Click(Object sender, EventArgs e)
    {
        if (siteUser != null)
       {
         Page.Validate("profile");
         if (Page.IsValid)
        {
           UpdateProfileExtension(); // i have tried copy pasting everything into UpdateUser(). no use.
           UpdateUser();
        }
      }

    }

I give you the functions from data and business part too for one of the functions (all 3 work similarly).

    public bool ShowFriends()
    {
    return DBProfileExtension.SetShowFriends(this.userID,this.option);
    }

    public static bool SetShowFriends(int UserID, int Option)
    {
    SqlParameterHelper sph = new SqlParameterHelper(GetConnectionString(), "ext_UsageStatsShowFriends", 2);
    sph.DefineSqlParameter("@UserID", SqlDbType.Int, ParameterDirection.Input, UserID);
    sph.DefineSqlParameter("@Option", SqlDbType.Int, ParameterDirection.Input, Option);
    int rowsAffected = sph.ExecuteNonQuery();
    return (rowsAffected > -1);
    }

I am about to give up on this one but I asked in case i come across this problem again in a more important function of my project. Thanks in advance and best wishes to everyone.

Hello. I just wanted to post what happened. I went today to use this extension i wrote as I moved the application to IIS (I had "The HTTP verb POST used to access path '/' is not allowed." on visual studio web server. This post helped me http://www.mojoportal.com/Forums/Thread.aspx?pageid=5&mid=34&ItemID=2&thread=4267&pagenumber=1 I bumped into it as i googled the error. I would propose including it somewhere in documentation if it is not already there.).

It magically worked on both servers (IIS , vs web server) without any issues. I cannot explain how did this happen since i did not do anything. The only thing that changed is some extra disk space. Or maybe it was some browser cache issue (although i used 2 browsers at that time). So it was either a perfomance or a browser caching problem.

Thanks again.