Mitchel's Forums

Forums >IowaComputerGurus Inc. Software >DNN Expandable Text/HTML
Subject: Errors at installation.
Prev Next
You are not authorized to post a reply.

AuthorMessages
MitchBUser is Offline
New Poster
New Poster
Posts:10

08/16/2008 4:28 PM  

Hello Mitchel,

Though the module appears to have installed successfully, can you tell me if I should worry about these errors:

StartJobBegin Sql execution
InfoExecuting 01.00.00.SqlDataProvider
StartJobStart Sql execution: 01.00.00.SqlDataProvider file
EndJobEnd Sql execution: 01.00.00.SqlDataProvider file
 
InfoExecuting 01.01.00.SqlDataProvider
StartJobStart Sql execution: 01.01.00.SqlDataProvider file
EndJobEnd Sql execution: 01.01.00.SqlDataProvider file
 
InfoExecuting 01.01.05.SqlDataProvider
StartJobStart Sql execution: 01.01.05.SqlDataProvider file
EndJobEnd Sql execution: 01.01.05.SqlDataProvider file
 
InfoExecuting 01.02.00.SqlDataProvider
StartJobStart Sql execution: 01.02.00.SqlDataProvider file
EndJobEnd Sql execution: 01.02.00.SqlDataProvider file
 
InfoExecuting 01.04.00.SqlDataProvider
StartJobStart Sql execution: 01.04.00.SqlDataProvider file
EndJobEnd Sql execution: 01.04.00.SqlDataProvider file
 
InfoExecuting 01.05.05.SqlDataProvider
StartJobStart Sql execution: 01.05.05.SqlDataProvider file
FailureSQL Execution resulted in following Exceptions: System.Data.SqlClient.SqlException: Incorrect syntax near 'CAST'. Incorrect syntax near '@OrderBy'. 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 DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) ALTER PROCEDURE dbo.[ICG_ETH_GetExpandableTextHtmls] @ModuleId int, @OrderBy VARCHAR(1000) AS DECLARE @SQL VARCHAR(5000) SET @SQL = ' SELECT ModuleId, ItemId, title, body, lastUpdated, isExpanded, SortOrder FROM ICG_ETH_ExpandableTextHtml WHERE ModuleId = ' CAST(@ModuleId AS VARCHAR) ' ' SET @SQL = @SQL @OrderBy EXEC(@SQL)
EndJobEnd Sql execution: 01.05.05.SqlDataProvider file
 
InfoExecuting 02.01.00.SqlDataProvider
StartJobStart Sql execution: 02.01.00.SqlDataProvider file
EndJobEnd Sql execution: 02.01.00.SqlDataProvider file
 
EndJobFinished Sql execution

 

Thank you! MitchB

PS. I'm not sure if installing PageBlaster just prior to this installation caused or added to these errors.

Mitchel SellersUser is Offline
Site Admin/Owner
Guru
Guru
Posts:5607

08/18/2008 12:58 AM  
MitchB,

You should be fine with that error. If you encounter an error with the display, I'll have to get you a modified SQL Script.

For some reason that file lost its encoding value.

I'll have to get the download fixed.
-Mitchel Sellers
MCITP, MCPD, MCTS
Director of Development
IowaComputerGurus Inc.

View Mitchel Sellers's profile on LinkedIn

3Essentials is my recommended Shared Hosting Provider

This site is hosted on a VPS from HostMySIte.com

Mosso is my recommended cloud computing provider. Use reference code REF-ICG to get $100 off your second month!

To get Guaranteed DNN Support check out our affordable DNN Technical Support Programs
TechnicaUser is Offline
New Poster
New Poster
Posts:1

08/19/2008 9:26 PM  
Downloaded version 2.02 today

Same errors during installation as MitchB.

Also found that module would not uninstall - had to remove manually from Database and file system.

DotNetNuke 4.8.4
Mitchel SellersUser is Offline
Site Admin/Owner
Guru
Guru
Posts:5607

08/19/2008 11:35 PM  
I am incredibly sorry to everyone.

I just updated the download file on http://www.iowacomputergurus.com to include a fixed version of the module that will allow the SQL Scripts to run in all installations.

As for the uninstall errors I am not aware of anything that will cause it to not uninstall.
-Mitchel Sellers
MCITP, MCPD, MCTS
Director of Development
IowaComputerGurus Inc.

View Mitchel Sellers's profile on LinkedIn

3Essentials is my recommended Shared Hosting Provider

This site is hosted on a VPS from HostMySIte.com

Mosso is my recommended cloud computing provider. Use reference code REF-ICG to get $100 off your second month!

To get Guaranteed DNN Support check out our affordable DNN Technical Support Programs
You are not authorized to post a reply.
Forums >IowaComputerGurus Inc. Software >DNN Expandable Text/HTML > Errors at installation.



ActiveForums 3.7