Products

Solutions

Resources

Partners

Community

Blog

About

QA

Ideas Test

New Community Website

Ordinarily, you'd be at the right spot, but we've recently launched a brand new community website... For the community, by the community.

Yay... Take Me to the Community!

Welcome to the DNN Community Forums, your preferred source of online community support for all things related to DNN.
In order to participate you must be a registered DNNizen

HomeHomeArchived Discus...Archived Discus...Developing Under Previous Versions of .NETDeveloping Under Previous Versions of .NETASP.Net 2.0ASP.Net 2.0installing module errorinstalling module error
Previous
 
Next
New Post
6/18/2012 8:49 AM
 
I suspect that the error is being caused by the encoding with which the 01.00.00.SqlDataProvider script was saved. Be sure that it is saved in UTF-8 encoding before the module is packaged.

Bill, WESNet Designs
Team Lead - DotNetNuke Gallery Module Project (Not Actively Being Developed)
Extensions Forge Projects . . .
Current: UserExport, ContentDeJour, ePrayer, DNN NewsTicker, By Invitation
Coming Soon: FRBO-For Rent By Owner
 
New Post
6/18/2012 8:55 AM
 

Thanks william

could you plz tell me how can i check this



 
New Post
6/18/2012 9:11 AM
 
One way is to open the 01.00.00.SqlDataProvider file in a simple text editor such as Note Pad. Do a File Save As. In Note Pad you will see a selector for the encoding in the Save File dialog. If it shows an encoding other than UTF-8 (most likely ANSI) then the script was saved with the wrong encoding. If so, change the encoding to UTF-8 and save the file.

Bill, WESNet Designs
Team Lead - DotNetNuke Gallery Module Project (Not Actively Being Developed)
Extensions Forge Projects . . .
Current: UserExport, ContentDeJour, ePrayer, DNN NewsTicker, By Invitation
Coming Soon: FRBO-For Rent By Owner
 
New Post
6/18/2012 9:46 AM
 

i did the same thing as  you said but still getting same problem :) see the below error


Info Starting Installation - ATI.Part Info Starting Installation - Script Info Begin Sql execution Info Creating backup of previous version - 01.00.00.SqlDataProvider Info Created - 01.00.00.SqlDataProvider Info Executing 01.00.00.SqlDataProvider Info Start Sql execution: 01.00.00.SqlDataProvider file Failure SQL Execution resulted in following Exceptions: System.Data.SqlClient.SqlException (0x80131904): Incorrect syntax near '{'.Incorrect syntax near '\'.Incorrect syntax near '\'.Incorrect syntax near the keyword 'with'. If this statement is a common table expression, an xmlnamespaces clause or a change tracking context clause, the previous statement must be terminated with a semicolon. at System.Data.SqlClient.SqlConnection. (SqlException exception, Boolean breakConnection) at System.Data.SqlClient.SqlInternalConnection. (SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning() 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 DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions){\rtf1\ansi\ansicpg1252\deff0\deflang1033\deflangfe1033{\fonttbl{\f0\fnil\fcharset0 Courier New;}{\f1\fswiss\fcharset0 Arial;}}{\*\generator Msftedit 5.41.15.1515;}\viewkind4\uc1\pard\f0\fs20 SET ANSI_NULLS ON\parGO\parSET QUOTED_IDENTIFIER ON\parGO\parCREATE TABLE \{databaseOwner\}\{objectQualifier\}ATI_PartMaster(\par\tab [PartID] [nvarchar](50) NOT NULL,\par\tab [Name] [nvarchar](255) NULL,\par\tab [Description] [nvarchar](max) NOT NULL,\par\tab [UnitOfMeasure] [int] NOT NULL,\par\tab [Cost] [money] NULL,\par\tab [ListPrice] [money] NOT NULL,\par\tab [CurrencyID] [int] NOT NULL,\par\tab [Notes] [ntext] NULL,\par\tab [statusID] [int] NOT NULL,\par\tab [PortalID] [int] NOT NULL,\par\tab [ModuleID] [int] NOT NULL,\par\tab [CreatedBy] [int] NOT NULL,\par\tab [UpdatedBy] [int] NOT NULL,\par\tab [CreatedDate] [datetime] NOT NULL,\par\tab [UpdateDate] [datetime] NOT NULL,\par\tab [AutoPartID] [numeric](18, 0) IDENTITY(1,1) NOT NULL,\par CONSTRAINT [PK_ATIPartMaster] PRIMARY KEY CLUSTERED \par(\par\tab [AutoPartID] ASC\par)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]\par) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]\parGO\par\f1\par} Info End Sql execution: 01.00.00.SqlDataProvider file Info Finished Sql execution Failure Installation Failed - Script Info Installation Failed - ATI.Part Info Deleted temporary install folder EndJob Installation Failed

 
New Post
6/18/2012 10:10 AM
 

sorry i did a mistake to save the file now i did the same and the problem is resolved


thanks you very very ...................................... much :) williams

grant salute to you :)


 
Previous
 
Next
HomeHomeArchived Discus...Archived Discus...Developing Under Previous Versions of .NETDeveloping Under Previous Versions of .NETASP.Net 2.0ASP.Net 2.0installing module errorinstalling module error


These Forums are dedicated to discussion of DNN Platform and Evoq Solutions.

For the benefit of the community and to protect the integrity of the ecosystem, 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 DNN.
  2. No vendor trolling / poaching. If someone posts about a vendor issue, allow the vendor or other customers to respond. Any post that looks like trolling / poaching will be removed.
  3. Discussion or promotion of DNN Platform product releases under a different brand name are strictly prohibited.
  4. No Flaming or Trolling.
  5. No Profanity, Racism, or Prejudice.
  6. Site Moderators have the final word on approving / removing a thread or post or comment.
  7. English language posting only, please.
What is Liquid Content?
Find Out
What is Liquid Content?
Find Out
What is Liquid Content?
Find Out