Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

DNN 4.0 Sql error message

Posted on 2006-03-29
2
Medium Priority
?
203 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
0
Comment
Question by:Sanjeet
2 Comments
 
LVL 9

Accepted Solution

by:
udayshankar earned 500 total points
ID: 16326708
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--

0
 

Author Comment

by:Sanjeet
ID: 16326787
Which version of DNN are you using?
0

Featured Post

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Why is this different from all of the other step by step guides?  Because I make a living as a DBA and not as a writer and I lived through this experience. Defining the name: When I talk to people they say different names on this subject stuff l…
Ever wondered why sometimes your SQL Server is slow or unresponsive with connections spiking up but by the time you go in, all is well? The following article will show you how to install and configure a SQL job that will send you email alerts includ…
Via a live example, show how to extract information from SQL Server on Database, Connection and Server properties
Via a live example, show how to shrink a transaction log file down to a reasonable size.
Suggested Courses

580 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question