| |
|
|
|
|
|
|
|
|
|
 |  | |
| | |
| | |
| | |
 | | |
|
|
|
|
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() |
|
|
|
| |
|
|
| Re: Can't Install modules |
|
|
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?
The leading provider of DotNetNuke support, training and custom module development. |
|
|
|
| |
|
|
| Re: Can't Install modules |
|
|
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
|
|
|
|
| |
|
|
| Re: Can't Install modules |
|
|
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
Brandon Haynes
BrandonHaynes.org |
|
|
|
| |
|
|
| Re: Can't Install modules |
|
|
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
|
|
|
|
| |
| | |
| | |
| | |
|  |
| |
|
|
|
These Discussion Forums are dedicated to the discussion of the DotNetNuke Web Application Framework.
For the benefit of the community and to protect the integrity of the project, please observe the following posting guidelines:
1. No Advertising. This includes promotion of commercial and non-commercial products or services which are not directly related to DotNetNuke.
2. Discussion or promotion of DotNetNuke product releases under a different brand name are strictly prohibited.
3. No Flaming or Trolling.
4. No Profanity, Racism, or Prejudice.
5. Site Moderators have the final word on approving/removing a thread or post or comment.
6. English language posting only, please.
|
| |
|
|
|
|
|
|
|
|