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

HomeHomeUsing DNN Platf...Using DNN Platf...Upgrading DNN P...Upgrading DNN P...Message:Procedure or function 'AddHtmlText' expects parameter '@History', which was not supplied.Message:Procedure or function 'AddHtmlText' expects parameter '@History', which was not supplied.
Previous
 
Next
New Post
8/24/2015 1:48 AM
 

Please advice, Have upgraded to 7.4.1
have tried both CKEditor and RadEditor
will always get this error when saving content to existing or new  html module

 

=========

Message:Procedure or function 'AddHtmlText' expects parameter '@History', which was not supplied.

StackTrace:

   at System.Data.SqlClient.SqlConnection. (SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)

   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)

   at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)

   at System.Data.SqlClient.SqlDataReader.TryConsumeMetaData()

   at System.Data.SqlClient.SqlDataReader.get_MetaData()

   at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)

   at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, SqlDataReader ds)

   at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean asyncWrite)

   at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)

   at System.Data.SqlClient.SqlCommand.ExecuteScalar()

   at PetaPoco.Database.ExecuteScalar[T](String sql, Object[] args)

   at DotNetNuke.Data.PetaPoco.PetaPocoHelper.ExecuteScalar[T](String connectionString, CommandType type, String sql, Object[] args) in c:\TeamCity\buildAgent\work\DNN_Platform_741_Public\Packaging\DNN.Platform\DNN Platform\Library\Data\PetaPoco\PetaPocoHelper.cs:line 81

   at DotNetNuke.Modules.Html.Components.DataProvider.AddHtmlText(Int32 ModuleID, String Content, String Summary, Int32 StateID, Boolean IsPublished, Int32 CreatedByUserID, Int32 History) in c:\TeamCity\buildAgent\work\DNN_Platform_741_Public\Packaging\DNN.Platform\DNN Platform\Modules\HTML\Components\DataProvider.cs:line 77

   at DotNetNuke.Modules.Html.HtmlTextController.UpdateHtmlText(HtmlTextInfo htmlContent, Int32 MaximumVersionHistory) in c:\TeamCity\buildAgent\work\DNN_Platform_741_Public\Packaging\DNN.Platform\DNN Platform\Modules\HTML\Components\HtmlTextController.cs:line 596

   at DotNetNuke.Modules.Html.EditHtml.OnSaveClick(Object sender, EventArgs e) in c:\TeamCity\buildAgent\work\DNN_Platform_741_Public\Packaging\DNN.Platform\DNN Platform\Modules\HTML\EditHtml.ascx.cs:line 564

 

 
New Post
8/24/2015 2:52 AM
 
Vera,

Most propably something went wrong with the installation/upgrade of the HTML module. Please check which version of the HTML module is being installed (should be 7.4.1).

If this is not the installed package, check if there is the installation package in your ~/Install/Module directory and install it manually by going to Host :: Extensions, choose the package HTML 7.4.1 from the Available Extensions tab (in the Modules panel) and install it. Make sure that there are no older HTML installation packs in the folder (if so, just delete them).

Happy DNNing!
Michael

Michael Tobisch
DNN★MVP

dnn-Connect.org - The most vibrant community around the DNN-platform
 
New Post
1/25/2016 7:51 PM
 
I ran in to the same error. This was after upgrading/downgrading from Evoq 7.03.04 to Platform 7.04.02 (via regular upgrade install then manually walking through and editing the web.config without the Evoq/Pro stuff). Taking the error literally, I diff'd Stored Procedure 'AddHtmlText' that was in my DNN 7.04.02 and a fresh install of 7.04.02. They were different. So I saved a copy of the non-working one and then replaced mine with a copy from the fresh install and I was immediately able to edit my HTML modules again.

- Accuraty / Jeremy
 
New Post
1/26/2016 3:25 AM
 
if you migrate from Evoq products to DNN platform, HTML module requires you to take some action to replace HTML Pro with HTML module without loosing the content. One option would be clearing content from "uninstall.sqldataprovider" in /dsktopmodules/html/dataprovider folder, uninstall the module and install HTML module again.
You should start with a database backup!

Cheers from Germany,
Sebastian Leupold

dnnWerk - The DotNetNuke Experts   German Spoken DotNetNuke User Group

Speed up your DNN Websites with TurboDNN
 
New Post
7/17/2016 5:12 PM
 
We have the same problem but none of the above suggestions fixed the problem.
It seems that the later version (since DNN 5 ? ) of AddHtmlText does expect the @History parameter - so could the problem lie with the HTML module that uses this SP?
If anyone has any other ideas to look into, would appreciate it.




 
Previous
 
Next
HomeHomeUsing DNN Platf...Using DNN Platf...Upgrading DNN P...Upgrading DNN P...Message:Procedure or function 'AddHtmlText' expects parameter '@History', which was not supplied.Message:Procedure or function 'AddHtmlText' expects parameter '@History', which was not supplied.


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