Parameter '?IsDeleted' must be defined.

Post here if you have questions about creating SuperFlexi Solutions.

The SuperFlexi documentation is very thorough, so you might want to start there.

This thread is closed to new posts. You must sign in to post in the forums.
1/1/2019 10:08:53 PM
Total Posts 7

Parameter '?IsDeleted' must be defined.

When I add or editing superflexi item, it says something like this. Have someone figured it out?

MySql.Data.MySqlClient.MySqlException (0x80004005): Fatal error encountered during command execution. ---> MySql.Data.MySqlClient.MySqlException (0x80004005): Parameter '?IsDeleted' must be defined.
   at MySql.Data.MySqlClient.Statement.SerializeParameter(MySqlParameterCollection parameters, MySqlPacket packet, String parmName, Int32 parameterIndex)
   at MySql.Data.MySqlClient.Statement.InternalBindParameters(String sql, MySqlParameterCollection parameters, MySqlPacket packet)
   at MySql.Data.MySqlClient.Statement.BindParameters()
   at MySql.Data.MySqlClient.PreparableStatement.Execute()
   at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior)
   at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior)
   at MySql.Data.MySqlClient.MySqlCommand.ExecuteScalar()
   at MySql.Data.MySqlClient.MySqlHelper.ExecuteScalar(MySqlConnection connection, String commandText, MySqlParameter[] commandParameters)
   at MySql.Data.MySqlClient.MySqlHelper.ExecuteScalar(String connectionString, String commandText, MySqlParameter[] commandParameters)
   at SuperFlexiData.DBFields.Update(Guid siteGuid, Guid featureGuid, Guid definitionGuid, Guid fieldGuid, String definitionName, String name, String label, String defaultValue, String controlType, String controlSrc, Int32 sortOrder, String helpKey, Boolean required, String requiredMessageFormat, String regex, String regexMessageFormat, String token, String preTokenString, String postTokenString, String preTokenStringWhenTrue, String postTokenStringWhenTrue, String preTokenStringWhenFalse, String postTokenStringWhenFalse, Boolean searchable, String editPageControlWrapperCssClass, String editPageLabelCssClass, String editPageControlCssClass, Boolean datePickerIncludeTimeForDate, Boolean datePickerShowMonthList, Boolean datePickerShowYearList, String datePickerYearRange, String imageBrowserEmptyUrl, String options, Boolean checkBoxReturnBool, String checkBoxReturnValueWhenTrue, String checkBoxReturnValueWhenFalse, String dateFormat, String textBoxMode, String attributes, Boolean isDeleted, Boolean isGlobal, String viewRoles, String eeditRoles)
   at SuperFlexiBusiness.Field.Update()
   at SuperFlexiBusiness.Field.Save()
   at SuperFlexiUI.FieldUtils.SaveFieldsToDB(List`1 definedFields, Guid siteGuid, Guid featureGuid, Boolean deleteOrphans)
   at SuperFlexiUI.FieldUtils.EnsureFields(Guid siteGuid, ModuleConfiguration config, List`1& savedFields, Boolean deleteOrphanedFieldValues)
   at SuperFlexiUI.EditItems.PopulateCustomControls()
   at SuperFlexiUI.EditItems.Page_Load(Object sender, EventArgs e)
   at System.Web.UI.Control.OnLoad(EventArgs e)
   at mojoPortal.Web.mojoBasePage.OnLoad(EventArgs e)
   at System.Web.UI.Control.LoadRecursive()
   at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)

I'm running version and just purchased Form wizard pro,,

Thank you in advance

1/2/2019 3:53:09 PM
Total Posts 2239

Re: Parameter '?IsDeleted' must be defined.

Hi Randy,

I can confirm this is a bug in mojoPortal 2.7 for MySQL. I have it fixed in my branch and will test it, along with some other changes, tonight. I hope to have a bugfix release ready this week.


1/2/2019 8:32:31 PM
Total Posts 7

Re: Parameter '?IsDeleted' must be defined.

Thank you, I can't wait to see it.

Is there any way I can use them immediately? laugh

1/3/2019 12:50:44 AM
Total Posts 7

Re: Parameter '?IsDeleted' must be defined.

or you may know any 'hack' to add or edit the superflexi item? i'm stuck on it right now..

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