 |
|
|
Joined: 9/9/2008
Posts: 4
|
|
|
I have been trying to install the PageBlaster and UrlMaster modules but have been getting the same error for both so I'm pretty sure the modules are not corrupt. I currently have DNN 4.8.4.2 installed and using SQL Server 2000. Any help would be apprciated.
This the error I'm getting:
StartJob Registering DesktopModule
ExceptionSystem.ArgumentException: Parameter count does not match Parameter Value count. at Microsoft.ApplicationBlocks.Data.SqlHelper.AssignParameterValues(SqlParameter[] commandParameters, Object[] parameterValues) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteScalar(String connectionString, String spName, Object[] parameterValues) at DotNetNuke.Data.SqlDataProvider.AddDesktopModule(String ModuleName, String FolderName, String FriendlyName, String Description, String Version, Boolean IsPremium, Boolean IsAdmin, String BusinessControllerClass, Int32 SupportedFeatures, String CompatibleVersions, String Dependencies, String Permissions) at DotNetNuke.Entities.Modules.DesktopModuleController.AddDesktopModule(DesktopModuleInfo objDesktopModule) at DotNetNuke.Modules.Admin.ResourceInstaller.PaDnnInstallerBase.RegisterModules(PaFolder Folder, ArrayList Modules, ArrayList Controls) at DotNetNuke.Modules.Admin.ResourceInstaller.PaDnnInstallerBase.Install(PaFolderCollection folders) at DotNetNuke.Modules.Admin.ResourceInstaller.PaInstaller.Install()
|
| |
|
|
 | |
|
|
|
There's some sort of mismatch between the code that your site's data provider (code/assembly/DLL) and its database (SQL). Something must have gone terribly wrong during an install or upgrade. Have you recently upgraded? Did you recently install? Can you go to a previous backup?
|
| |
|
|
| |
|
|
Joined: 9/9/2008
Posts: 4
|
|
|
to fix the problem, I had to
- Login in as Host to DNN
- Click Host, SQL
- Paste the code below in the textbox and click the Run as Script checkbox and hit execute
- Then I was able to install modules
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = object_id(N'{databaseOwner}[{objectQualifier}AddDesktopModule]') AND OBJECTPROPERTY(id, N'IsPROCEDURE') = 1)
DROP PROCEDURE {databaseOwner}{objectQualifier}AddDesktopModule
GO
CREATE PROCEDURE {databaseOwner}{objectQualifier}AddDesktopModule
@ModuleName nvarchar(128),
@FolderName nvarchar(128),
@FriendlyName nvarchar(128),
@Description nvarchar(2000),
@Version nvarchar(8),
@IsPremium bit,
@IsAdmin bit,
@BusinessController nvarchar(200),
@SupportedFeatures int,
@CompatibleVersions nvarchar(500),
@Dependencies nvarchar(400),
@Permissions nvarchar(400)
AS
INSERT INTO {objectQualifier}DesktopModules (
ModuleName,
FolderName,
FriendlyName,
Description,
Version,
IsPremium,
IsAdmin,
BusinessControllerClass,
SupportedFeatures,
CompatibleVersions,
Dependencies,
Permissions
)
VALUES (
@ModuleName,
@FolderName,
@FriendlyName,
@Description,
@Version,
@IsPremium,
@IsAdmin,
@BusinessController,
@SupportedFeatures,
@CompatibleVersions,
@Dependencies,
@Permissions
)
SELECT SCOPE_IDENTITY()
GO
|
| |
|
|
| |
|
|
|
brandonhaynes.org
Joined: 2/6/2006
Posts: 1172
|
|
|
In addition to Brian's insight, I'd add that your specific issue is (perhaps obviously) with the AddDesktopModule stored procedure (or possibly with the provider itself). This does not mean that any versioning inconsistency is limited to this stored procedure, however.
Attach your database to MSSQL Enterprise Manager and view the contents of this stored procedure. A correct 4.8.4 version should read as follows:
ALTER PROCEDURE [dbo].[AddDesktopModule]
@ModuleName nvarchar(128),
@FolderName nvarchar(128),
@FriendlyName nvarchar(128),
@Description nvarchar(2000),
@Version nvarchar(8),
@IsPremium bit,
@IsAdmin bit,
@BusinessController nvarchar(200),
@SupportedFeatures int,
@CompatibleVersions nvarchar(500),
@Dependencies nvarchar(400),
@Permissions nvarchar(400)
AS
INSERT INTO DesktopModules (
ModuleName,
FolderName,
FriendlyName,
Description,
Version,
IsPremium,
IsAdmin,
BusinessControllerClass,
SupportedFeatures,
CompatibleVersions,
Dependencies,
Permissions
)
VALUES (
@ModuleName,
@FolderName,
@FriendlyName,
@Description,
@Version,
@IsPremium,
@IsAdmin,
@BusinessController,
@SupportedFeatures,
@CompatibleVersions,
@Dependencies,
@Permissions
)
SELECT SCOPE_IDENTITY()
Post what you have here, and we might be able to extrapolate where the problem started.
Hope this helps!
Brandon
|
| |
|
|
| |
|
|
Joined: 9/9/2008
Posts: 4
|
|
|
This is what my AddDesktopModule procedure looks like.
CREATE PROCEDURE dbo.AddDesktopModule
@ModuleName nvarchar(128),
@FolderName nvarchar(128),
@FriendlyName nvarchar(128),
@Description nvarchar(2000),
@Version nvarchar(8),
@IsPremium bit,
@IsAdmin bit,
@BusinessController nvarchar(200),
@SupportedFeatures int,
@CompatibleVersions nvarchar(500),
@Dependencies nvarchar(400),
@Permissions nvarchar(400)
AS
INSERT INTO DesktopModules (
ModuleName,
FolderName,
FriendlyName,
Description,
Version,
IsPremium,
IsAdmin,
BusinessControllerClass,
SupportedFeatures,
CompatibleVersions,
Dependencies,
Permissions
)
VALUES (
@ModuleName,
@FolderName,
@FriendlyName,
@Description,
@Version,
@IsPremium,
@IsAdmin,
@BusinessController,
@SupportedFeatures,
@CompatibleVersions,
@Dependencies,
@Permissions
)
SELECT SCOPE_IDENTITY()
GO
|
| |
|
|
| |