Hi, I just purchased and installed Form Wizard Pro. I'm connecting to a MySql db. I copied the mysql db provider into the bin folder and then copied the contents of wwwroot into my root folder and went through setup. The setup did install the new tables into the mysql db. When I went to add a FWPro feature to a page, it allowed me to do so, but when I went to view and edit the page, I got the following error:

Unknown column 'TotalPages' in 'field list'

Exception Details: MySql.Data.MySqlClient.MySqlException: Unknown column 'TotalPages' in 'field list'

[MySqlException (0x80004005): Unknown column 'TotalPages' in 'field list']
   MySql.Data.MySqlClient.MySqlStream.ReadPacket() +195
   MySql.Data.MySqlClient.NativeDriver.GetResult(Int32& affectedRow, Int32& insertedId) +73
   MySql.Data.MySqlClient.Driver.GetResult(Int32 statementId, Int32& affectedRows, Int32& insertedId) +20
   MySql.Data.MySqlClient.Driver.NextResult(Int32 statementId) +90
   MySql.Data.MySqlClient.MySqlDataReader.NextResult() +365
   MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior) +1286
   MySql.Data.MySqlClient.MySqlCommand.ExecuteNonQuery() +36
   MySql.Data.MySqlClient.MySqlHelper.ExecuteNonQuery(MySqlConnection connection, String commandText, MySqlParameter[] commandParameters) +125
   MySql.Data.MySqlClient.MySqlHelper.ExecuteNonQuery(String connectionString, String commandText, MySqlParameter[] parms) +80
   sts.FormWizard.Data.DBWebForm.Create(Guid guid, Int32 moduleId, Guid moduleGuid, Guid siteGuid, String name, String title, String instructions, String completedMessage, Int32 totalPages, DateTime createdUtc, Guid creatorId) +1703
   sts.Business.WebForm.Create() +143
   sts.Business.WebForm.GetByModule(Module module) +153
   sts.FormWizard.Web.UI.FormWizardModule.LoadSettings() +249
   sts.FormWizard.Web.UI.FormWizardModule.Page_Load(Object sender, EventArgs e) +43
   System.Web.UI.Control.OnLoad(EventArgs e) +91
   System.Web.UI.Control.LoadRecursive() +74
   System.Web.UI.Control.LoadRecursive() +146
   System.Web.UI.Control.LoadRecursive() +146
   System.Web.UI.Control.LoadRecursive() +146
   System.Web.UI.Control.LoadRecursive() +146
   System.Web.UI.Control.LoadRecursive() +146
   System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +2207

I am using .Net 4.0

I would really appreciate any help as I am at a loss to figure out what is going on.

Well, I just figured out that the mysql script does not include a 'TotalPages' field in the sts_webform table, but looking at the SqlServer scripts indicates that it does have this field. I'm going to add it manually and see if that works.

Oops, I did look at 0.0.1.2 and you are correct. The file is not empty and it contains sql to update the table with the new field. I don't know what the heck could have happened, but I strongly suspect when I FTP'd the files over that something in the upgrade scripts didn't get copied over. I will follow up later just to close the thread.

Thanks everybody.