I tried to install DNN 4.3.5 on a test machine. Windows 2000 server Chinese version. SQL server2005 dev version.
and the I got several error in DotNetNuke.Schema.log and other files.

Here is an sample description of errors.

System.Data.SqlClient.SqlException: Must declare the scalar variable "@ModuleDefId".
   ...

CREATE  procedure dbo.UpdateModuleControl

@ModuleControlId               int,
@ModuleDefID                   int,
@ControlKey                    nvarchar(50),
@ControlTitle                  nvarchar(50),
@ControlSrc                    nvarchar(256),
@IconFile                      nvarchar(100),
@ControlType                   int,
@ViewOrder                     int,
@HelpUrl                       nvarchar(200)

as

update ModuleControls
set    ModuleDefId       = @ModuleDefId,
       ControlKey        = @ControlKey,
       ControlTitle      = @ControlTitle,
       ControlSrc        = @ControlSrc,
       IconFile          = @IconFile,
       ControlType       = @ControlType,
       ViewOrder         = ViewOrder,
       HelpUrl           = @HelpUrl
where  ModuleControlId = @ModuleControlId

It seems the sql server consider @ModuleDefID and @ModuleDefId is different.

I had set the collation of the sql server to SQL_Latin1_General_CP1254_CI_AS

and also changed the region settings of the Windows to US-english and the default is US-english but all these can not work.

Anybody can help?


Peter







 

This is a known bug, you need to make sure, default server collation and database collation are set to a "Latin CI AS" collation.

---

Cheers from Germany,
Sebastian Leupold

   

Speed up your DNN Websites with TurboDNN