Form Wizard Pro 2.6.1.8 - Missing Info (CssClass in mojoportal.dbo.sts_WebFormQuestion)

This is the place to report bugs and get support. When posting in this forum, please always provide as much detail as possible.

Please do not report problems with a custom build or custom code in this forum. If you are producing your own build from the source code and have problems or questions, ask in the developer forum, do not report it as a bug.

This is the place to report bugs and get support

When posting in this forum, please try to provide as many relevant details as possible. Particularly the following:

  • What operating system were you running when the bug appeared?
  • What database platform is your site using?
  • What version of mojoPortal are you running?
  • What version of .NET do you use?
  • What steps are necessary to reproduce the issue? Compare expected results vs actual results.
Please do not report problems with a custom build or custom code in this forum. If you are producing your own build from the source code and have problems or questions, ask in the developer forum.
This thread is closed to new posts. You must sign in to post in the forums.
8/22/2014 10:54:04 AM
Gravatar
Total Posts 149
Partner
mojoPortal Skinning, Custom Development and Support in Italy?
EffectiveWeb.it

Form Wizard Pro 2.6.1.8 - Missing Info (CssClass in mojoportal.dbo.sts_WebFormQuestion)

Hi Joe,

I have updated my client's four sites to mojoPortal 2.4.0.4. (.NET 4.5).
The Client has a server license of Form Wizard Pro, so I downloaded sts-formwizardpro-2-6-1-8 from his mojoPortal profile.
Unfortunately, during the setup process, the sts-FormWizard - 2.6.1.7 script went wrong (see below).

Esecuzione script sts-FormWizard - 2.6.1.3 - 00:00:02.7212721
Esecuzione script sts-FormWizard - 2.6.1.4 - 00:00:02.7602760
Esecuzione script sts-FormWizard - 2.6.1.5 - 00:00:02.7702770
Esecuzione script sts-FormWizard - 2.6.1.6 - 00:00:02.7802780
Esecuzione script sts-FormWizard - 2.6.1.7 - 00:00:02.7902790
System.Data.SqlClient.SqlException (0x80131904): Impossibile inserire il valore NULL nella colonna 'CssClass' della tabella 'mojoportal.dbo.sts_WebFormQuestion'. La colonna non ammette valori Null. UPDATE avrà esito negativo. L'istruzione è stata interrotta. in System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) in System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) in System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) in System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout, Boolean asyncWrite) in System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean asyncWrite) in System.Data.SqlClient.SqlCommand.ExecuteNonQuery() in mojoPortal.Data.SqlHelper.ExecuteNonQuery(SqlTransaction transaction, CommandType commandType, String commandText, Int32 commandTimeout, SqlParameter[] commandParameters) in mojoPortal.Data.DBPortal.DatabaseHelperRunScript(String script, String overrideConnectionInfo) in mojoPortal.Business.DatabaseHelper.RunScript(Guid applicationId, FileInfo scriptFile, String overrideConnectionInfo) ClientConnectionId:7f37b8bc-0baf-4a4b-8f59-c6db58d30511 - 00:00:03.3253325

How can it be fixed ?

Please also note that a tag is missing in the FormWizardResources.resx file: ShowPageRightContent

Regards.
Diego

8/22/2014 11:41:38 AM
Gravatar
Total Posts 18444

Re: Form Wizard Pro 2.6.1.8 - Missing Info (CssClass in mojoportal.dbo.sts_WebFormQuestion)

Hi Diego,

Can you try editing the script, change this:

ALTER TABLE [dbo].[sts_WebFormQuestion]
ALTER COLUMN [CssClass] [nvarchar](100) NOT NULL

GO

to this:

ALTER TABLE [dbo].[sts_WebFormQuestion]
ALTER COLUMN [CssClass] [nvarchar](100) NULL

GO

I think it was a mistake that column should allow null.

I'm not sure what you mean about the missing resource key "ShowPageRightContent", there is not setting with that name in Form Wizard as far as I know.

Thanks,

Joe

8/22/2014 12:26:12 PM
Gravatar
Total Posts 149
Partner
mojoPortal Skinning, Custom Development and Support in Italy?
EffectiveWeb.it

Re: Form Wizard Pro 2.6.1.8 - Missing Info (CssClass in mojoportal.dbo.sts_WebFormQuestion)

Yes, the fix was ok.

Thanks!

 

BTW:

Yes, there is a ShowPageRightContent setting  (to be sure I checked your demo site ;-) )

It is in "File Upload Settings" there are both ShowPageLeftContent and ShowPageRightContent but only the first one has a label defined in the .resx file. I realized that while tranlsating the Italian resource file.

You must sign in to post in the forums. This thread is closed to new posts.