CS 2.1 beta install. expects parameter '@TimeZoneAdjustment'

Reply

madkidd Posted: Sat, Jul 15 2006 2:43 AM

rated by 0 users

I just tried to do a clean install of CS 2.1 beta running on ASP.NET 2.0 and I get this error:

Procedure or Function 'aspnet_Profile_GetProperties' expects parameter '@TimeZoneAdjustment', which was not supplied.

I've searched the forums and tried the listed solutions but can't try others because this is 2.1 beta (some required the SDK which Telligent doesn't give out for betas).

Reply

Ken Robertson replied on Mon, Jul 17 2006 3:37 PM

rated by 0 users

What did you do a clean install of, and how did you do it?

Are you using the ASP.NET 1.1 download or the ASP.NET 2.0 download?

Are you installing the DB manually, or are you using the web install? 

Reply

madkidd replied on Mon, Jul 17 2006 3:47 PM

rated by 0 users

Ken Robertson:

What did you do a clean install of, and how did you do it?

Are you using the ASP.NET 1.1 download or the ASP.NET 2.0 download?

Are you installing the DB manually, or are you using the web install? 

Installing CS 2.1 beta Web Installer on ASP.NET 2.0. (Not upgradeding a site.)

Reply

madkidd replied on Mon, Jul 17 2006 4:21 PM

rated by 0 users

michael:

I had the same error back in 2.0. You are using CS2.x against the .net 2.0 Membership provider. Run the cs_ASPNET2_Membership_Schema_Update.sql and it should resolve the issue.

 It already has the ASP.NET 2.0 Membership Schema in the DB so if I ran that sql script it would cause all kinds of errors.

Reply

Ken Robertson replied on Mon, Jul 17 2006 5:08 PM

rated by 0 users

Ken Robertson:

What did you do a clean install of, and how did you do it?

Are you using the ASP.NET 1.1 download or the ASP.NET 2.0 download?

Are you installing the DB manually, or are you using the web install? 

Bump.

I am trying to reproduce your issue, though have not been able to so far.  The only way I have so far is to be using ASP.NET 2.0 without running the ASP.NET 2.0 membership schema upgrade.  Nothing actually related to the CS 2.1 upgrade.

You said this happened to you on a clean install.  What file did you download?  What steps did you take to install? 

Reply

madkidd replied on Mon, Jul 17 2006 6:06 PM

rated by 0 users

I downloaded from here: http://communityserver.org/files/folders/betareleases/entry538186.aspx

I'm running ASP.NET 2.0. I extracted the files to my directory. Created the DB in SQL Express 2005 and then open http://v2.hopejunction.us/Installer/

After running the Installation Wizard it sent me to the homepage and I get the listed error. I tried extracting the files again and am still getting the same error.

Reply

madkidd replied on Mon, Jul 17 2006 6:17 PM

rated by 0 users

Yes, I tried to run the script and it returned a bunch of errors saying the tables where already there and what-not.

 I can run it again and give you the exact errors if needed.

Reply

Ken Robertson replied on Mon, Jul 17 2006 6:28 PM

rated by 0 users

After you installed, did you make the changes it mentions regarding the appSettings section of the web.config?

One additional thing that you will need to do that the installer doesn't mention (and I'll enter an item to fix it) is that you need to change the connection string on the <connectionStrings> section.  These are all of the things you should be updating:

    <connectionStrings>
        <add name="SiteSqlServer" connectionString="server=(local);uid=;pwd=;Trusted_Connection=yes;database=communityserver" />
    </connectionStrings>

    <appSettings>
        <add key="SiteSqlServer" value="server=(local);uid=;pwd=;Trusted_Connection=yes;database=communityserver" />
        <add key="SiteSqlServerOwner" value="dbo" />
        <add key="MachineValidationKey" value="F9D1A2D3E1D3E2F7B3D9F90FF3965ABDAC304902" />
        <add key="MachineDecryptionKey" value="F9D1A2D3E1D3E2F7B3D9F90FF3965ABDAC304902F8D923AC" />
        <add key="MachineValidationMode" value="SHA1" />
        <add key="ComponentArt.Web.UI.ClientScriptLocation" value="~/Utility/componentart_webui_client" />
        <add key="Telligent.Web.UI.ClientScriptPath" value="~/Utility/telligent_web_ui" />
    </appSettings>

If you updated the connection string in the <appSettings> section, but not the <connectionStrings> section, then that is likely your problem. 

Reply

madkidd replied on Mon, Jul 17 2006 6:29 PM

rated by 0 users

Ken Robertson:

Ken Robertson:

What did you do a clean install of, and how did you do it?

Are you using the ASP.NET 1.1 download or the ASP.NET 2.0 download?

Are you installing the DB manually, or are you using the web install? 

Bump.

I am trying to reproduce your issue, though have not been able to so far.  The only way I have so far is to be using ASP.NET 2.0 without running the ASP.NET 2.0 membership schema upgrade.  Nothing actually related to the CS 2.1 upgrade.

You said this happened to you on a clean install.  What file did you download?  What steps did you take to install? 

 Ken,

 I can give you whatever access and any information you need to troubleshoot this.

Reply

madkidd replied on Mon, Jul 17 2006 6:34 PM

rated by 0 users

Ken,

 Yes, I made the updates to the Web.config file that it said to make. You were correct and the <connectionStrings> settings didn't get changed. I just went in and changed that line but I am still getting the same error.