Hi!

Everything was just perfect until... My customer try to put by itself is email campain and then she never be able to do it.

Now, I can not change the email campain font text.

Here it is the error when I try to save and I'm prompt out of the control panel.


A critical error has occurred. String or binary data would be truncated. The statement has been terminated.


Here it is the log entry :

DefaultDataProvider: DotNetNuke.Data.SqlDataProvider, DotNetNuke.SqlDataProvider
ExceptionGUID: c4d6f312-68ca-4bcb-8f4e-64c2771dafe7
InnerException: String or binary data would be truncated. The statement has been terminated.
FileName:
FileLineNumber: 0
FileColumnNumber: 0
Method: System.Data.SqlClient.SqlConnection.OnError
StackTrace:
Message: DotNetNuke.Services.Exceptions.PageLoadException: String or binary data would be truncated. The statement has been terminated. ---> System.Data.SqlClient.SqlException: String or binary data would be truncated. The statement has been terminated. 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() at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) 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) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result) 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, String spName, Object[] parameterValues) at Dataspring.DNN.Modules.OptInAdvanceEmail.SqlDataProvider.UpdateEmailCampaign(Guid EmailCampaignID, String CampaignName, DateTime StartDate, DateTime EndDate, Int32 NewSubscribersOnly, Guid PreCampaignID, Int32 PreDays, String FromEmailName, String FromEmailAddress, String BCCEmailAddress, String EmailSubject, String EmailMessage, Int32 PortalID, Int32 InActive, Int32 TestMode, Int32 EmailType, String FileAttachment) at Dataspring.DNN.Modules.OptInAdvanceEmail.EmailCampaignController.UpdateEmailCampaign(EmailCampaignInfo EInfo) at Dataspring.DNN.Modules.OptInAdvanceEmail.__EmailCampaign.AddUpdateEmailCampaignItem() at Dataspring.DNN.Modules.OptInAdvanceEmail.__EmailCampaign.lnkUpdate_Click(Object sender, EventArgs e) at System.Web.UI.WebControls.LinkButton.OnClick(EventArgs e) at System.Web.UI.WebControls.LinkButton.RaisePostBackEvent(String eventArgument) at System.Web.UI.WebControls.LinkButton.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument) at System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) at System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) --- End of inner exception stack trace ---
Source:
Server Name: WIN-7JAG35P5CMG

When I look in firebug it shows me the break point is at this line code :

$dnnDialog = $("").html(opts.text).dialog(opts);

I'm on MAC and my customer on PC.

Thanks to help me with this !

So... I still working to find the solution...

Here is the wording of the FireBug Error :

TypeError: $(...).html(...).dialog is not a function

For this line
$dnnDialog = $("

").html(opts.text).dialog(opts);


The problem is on PC and MAC IE, FireFox, Chrome and Safari.

hmmm... The error appear only in the Campain page and appear even if I didn't select a campain

It is very frustrating because everything was working perfectly one week ago.

Thanks again to helping me with this.

Fadelle

Hi - The actual error related to the "Truncation" is because you are trying to insert more details into the campaign that are allowed. So for example, if you are trying to insert 4001 characters for the email campaign message and it only allows for maybe 4000 etc... Does it happen only when creating a new campaign, or updating an existing one etc?

Thanks,

Chad

Hi - The actual error related to the "Truncation" is because you are trying to insert more details into the campaign that are allowed. So for example, if you are trying to insert 4001 characters for the email campaign message and it only allows for maybe 4000 etc... Does it happen only when creating a new campaign, or updating an existing one etc?

Thanks,

Chad

Hi Chad,

Hi,

I'm still waiting for hint to help me with this issue.
I just want to know if there is a possibility that the module keep somewhere the history of the modifications and didn't dump it?

Is there a problem with Rad Editor and OptIn?

Is there a problem with CSS and OptIn?

I also found that the DNN TOP MENU (in grey for the admin, host module and pages) is in white and have no dropdown when we are in the Control Panel of the OptIn Email (is it normal?) maybe a clue if it is not.

The fact is, like it's only happened with existing campaign, and that we can sometime modify it twice or 3 times before the error occurred, we tried to put not too much text and just modify the font characters in the drop down menu of the rad editor.

We are not reach the 4000 in the text code area (always near 3200)...

So please could you take the time to let me know what information can help you to HELPING ME?

Thanks