We help IT Professionals succeed at work.

DNN 4.0 Sql error message

Sanjeet
Sanjeet asked
on
Medium Priority
243 Views
Last Modified: 2008-02-01
In order to register a Module in DNN 4 some entries in the database need to be made.

I tried using the template provided modied it to this:

/************************************************************/
/*****              RegisterModule                      *****/
/*****                                                  *****/
/***** Use this script to register a module in the      *****/
/***** database using Query Analyzer                    *****/
/*****                                                  *****/
/*****                                                  *****/
/***** Note: To manually execute this script you must   *****/
/*****       perform a search and replace operation     *****/
/*****       for {databaseOwner} and {objectQualifier}  *****/
/*****                                                  *****/
/************************************************************/

exec {dbo}[{ct_}AddDesktopModule]
  @ModuleName = N'CustomerTracking',
  @FolderName = N'CustomerTracking',
  @FriendlyName = N'CustomerTracking',
  @Description = N'A CustomerTracking module',
  @Version = N'01.00.00',
  @IsPremium = 0,
  @IsAdmin = 0,
  @BusinessController = N'Digerati.Modules.CustomerTracking.CustomerTrackingController',
  @SupportedFeatures = 3

declare @DesktopModuleId int
select @DesktopModuleId = DesktopModuleId
from {dbo}[{ct_}DesktopModules]
where ModuleName = 'CustomerTracking'

exec {dbo}[{ct_}AddModuleDefinition] @DesktopModuleId,
  @FriendlyName = N'CustomerTracking',
  @DefaultCacheTime = 0

declare @ModuleDefID int
select @ModuleDefID = ModuleDefID
from {dbo}[{ct_}ModuleDefinitions]
where FriendlyName = 'CustomerTracking'

exec {dbo}[{ct_}AddModuleControl]
  @ModuleDefID,
  @ControlKey = NULL,
  @ControlTitle = NULL,
  @ControlSrc = N'DesktopModules/CustomerTracking/ViewCustomerTracking.ascx',
  @IconFile = NULL,
  @ControlType = 0,
  @ViewOrder = NULL,
  @HelpUrl = NULL

exec {dbo}[{ct_}AddModuleControl]
  @ModuleDefID,
  @ControlKey = 'Edit',
  @ControlTitle = 'Edit Content',
  @ControlSrc = N'DesktopModules/CustomerTracking/EditCustomerTracking.ascx',
  @IconFile = NULL,
  @ControlType = 1,
  @ViewOrder = NULL,
  @HelpUrl = NULL

exec {dbo}[{ct_}AddModuleControl]
  @ModuleDefID,
  @ControlKey = 'Settings',
  @ControlTitle = 'CustomerTracking Settings',
  @ControlSrc = N'DesktopModules/CustomerTracking/Settings.ascx',
  @IconFile = NULL,
  @ControlType = 1,
  @ViewOrder = NULL,
  @HelpUrl = NULL




But got this error message:




System.Data.SqlClient.SqlException: Incorrect syntax near '{'. Incorrect syntax near '}'. Incorrect syntax near '}'. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(SqlConnection connection, CommandType commandType, String commandText, SqlParameter[] commandParameters) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(String connectionString, CommandType commandType, String commandText, SqlParameter[] commandParameters) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(String connectionString, CommandType commandType, String commandText) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) in C:\customerreporting\Library\Providers\DataProviders\SqlDataProvider\SqlDataProvider.vb:line 247 /************************************************************/ /***** RegisterModule *****/ /***** *****/ /***** Use this script to register a module in the *****/ /***** database using Query Analyzer *****/ /***** *****/ /***** *****/ /***** Note: To manually execute this script you must *****/ /***** perform a search and replace operation *****/ /***** for dbo. and *****/ /***** *****/ /************************************************************/ exec {dbo}[{ct_}AddDesktopModule] @ModuleName = N'CustomerTracking', @FolderName = N'CustomerTracking', @FriendlyName = N'CustomerTracking', @Description = N'A CustomerTracking module', @Version = N'01.00.00', @IsPremium = 0, @IsAdmin = 0, @BusinessController = N'Digerati.Modules.CustomerTracking.CustomerTrackingController', @SupportedFeatures = 3 declare @DesktopModuleId int select @DesktopModuleId = DesktopModuleId from {dbo}[{ct_}DesktopModules] where ModuleName = 'CustomerTracking' exec {dbo}[{ct_}AddModuleDefinition] @DesktopModuleId, @FriendlyName = N'CustomerTracking', @DefaultCacheTime = 0 declare @ModuleDefID int select @ModuleDefID = ModuleDefID from {dbo}[{ct_}ModuleDefinitions] where FriendlyName = 'CustomerTracking' exec {dbo}[{ct_}AddModuleControl] @ModuleDefID, @ControlKey = NULL, @ControlTitle = NULL, @ControlSrc = N'DesktopModules/CustomerTracking/ViewCustomerTracking.ascx', @IconFile = NULL, @ControlType = 0, @ViewOrder = NULL, @HelpUrl = NULL exec {dbo}[{ct_}AddModuleControl] @ModuleDefID, @ControlKey = 'Edit', @ControlTitle = 'Edit Content', @ControlSrc = N'DesktopModules/CustomerTracking/EditCustomerTracking.ascx', @IconFile = NULL, @ControlType = 1, @ViewOrder = NULL, @HelpUrl = NULL exec {dbo}[{ct_}AddModuleControl] @ModuleDefID, @ControlKey = 'Settings', @ControlTitle = 'CustomerTracking Settings', @ControlSrc = N'DesktopModules/CustomerTracking/Settings.ascx', @IconFile = NULL, @ControlType = 1, @ViewOrder = NULL, @HelpUrl = NULL
Comment
Watch Question

www.asp.net --> forums and dotnetnuke is i think a better place for this.
they have excellent suggestions and it has helped me a lot.

just my suggestion -- nothing more--

Not the solution you were looking for? Getting a personalized solution is easy.

Ask the Experts

Author

Commented:
Which version of DNN are you using?
Access more of Experts Exchange with a free account
Thanks for using Experts Exchange.

Create a free account to continue.

Limited access with a free account allows you to:

  • View three pieces of content (articles, solutions, posts, and videos)
  • Ask the experts questions (counted toward content limit)
  • Customize your dashboard and profile

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.