Hi Daniel

Seems like your update script did not execute as it should.

Between versions, Dynamicweb will apply database schema changes using an update script - if upgrade is not done following the update stesp (see https://doc.dynamicweb.com/get-started/introduction/installation/upgrading-dynamicweb#sideNavTitle1) this can happen. Also if the database user does not have the right database permissions, updates can also not be added between versions. See https://doc.dynamicweb.com/get-started/introduction/installation/installing-dynamicweb#4522

Also, sometimes the update scrip simply fails.

You can rerun the update script in 2 ways

• From backend (see dump #1)
  • Go to settings, System, System Information node and scroll to the bottom (you have to be administrator)
  • Change the "updates.xml.aspx" field to 2000 - this means that all update scripts from that file/database version will be re-applied if not applied already
  • Click "Rerun updates"
  • Now the error in forms should have gone away.
  • If not, check the update log - in the above screen, click "Download update log" - scroll to the bottom and see what error is there. Your error is related to the missing column "formfieldinputpattern" - so you can search for that in the log file. Hint: rename the log file to html to view it better in a browser.
• By changing the update file directly (see dump #2)
  • On the server, finde the folder /Files and the file Updates.xml or Updates.xml.aspx
  • Open it in a text editor
  • Change the version to 2000
  • Run a IISRESET (run it in a command prompt using administrative privileges - or use the UI

BR Nicolai

Hi Nicolai thanks for the quick reply and great guide.

Unfortunately reruning the script did not work :(

I downloaded the UpdatesLog, and it contains a lot of errors. (But I upgraded, downgraded and upgraded again)
 

The only error about the forms was this:

4/28/2020 9:03:53 AM   file D:\home\site\wwwroot\Dynamicweb\Solution\System\BulkDataEdit\BasicForms.xml already exists.
4/28/2020 9:03:53 AM   file D:\home\site\wwwroot\Dynamicweb\Solution\System\BulkDataEdit\DM_Form.xml already exists.
4/28/2020 9:03:53 AM   file D:\home\site\wwwroot\Dynamicweb\Solution\System\BulkDataEdit\eCom_CartV2.xml already exists.
4/28/2020 9:03:53 AM   file D:\home\site\wwwroot\Dynamicweb\Solution\System\BulkDataEdit\eCom_Catalog.xml already exists.
4/28/2020 9:03:53 AM   file D:\home\site\wwwroot\Dynamicweb\Solution\System\BulkDataEdit\eCom_CustomerCenter.xml already exists.
4/28/2020 9:03:53 AM   file D:\home\site\wwwroot\Dynamicweb\Solution\System\BulkDataEdit\UserManagementFrontend.xml already exists.
4/28/2020 9:03:53 AM   file D:\home\site\wwwroot\Dynamicweb\Solution\System\BulkDataEdit\UserManagementFrontendExtended.xml already exists.

I could not find anything with the "formfieldinputpattern". I have attached my UpdateLog.

Hi Daniel

That indicates that you have updated the /bin but not your /admin to the right version.

BR Nicolai

I followed the guide here for custom solution:

https://doc.dynamicweb.com/get-started/introduction/installation/upgrading-dynamicweb#sideNavTitle1-3

I downloaded the new version of DW and pointed my virtual directory to the new folder, and after that I moved my custom dll's
The new folder in DW 9.8.5 contains both an /Admin and /bin folder - So I don't think that is the problem... :/ 

I'm having the same issue 

An error occurred while attaching module (Dynamicweb.Frontend.Content)

System.IndexOutOfRangeException: FormFieldInputPattern
   at System.Data.ProviderBase.FieldNameLookup.GetOrdinal(String fieldName)
   at System.Data.SqlClient.SqlDataReader.GetOrdinal(String name)
   at System.Data.SqlClient.SqlDataReader.get_Item(String name)
   at Dynamicweb.Forms.Field.Fill(IDataReader datareader)
   at Dynamicweb.Forms.Field.GetFieldsBySql(String sql)
   at Dynamicweb.Forms.Frontend.RenderForm()
   at Dynamicweb.Forms.Frontend.GetContent()
   at Dynamicweb.Frontend.Content.GetModuleOutp

Server Error in '/' Application.

FormFieldInputPattern

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.IndexOutOfRangeException: FormFieldInputPattern

Source Error:
 

Stack Trace:
 

[IndexOutOfRangeException: FormFieldInputPattern]
   System.Data.ProviderBase.FieldNameLookup.GetOrdinal(String fieldName) +2151215
   System.Data.SqlClient.SqlDataReader.GetOrdinal(String name) +141
   System.Data.SqlClient.SqlDataReader.get_Item(String name) +21
   Dynamicweb.Forms.Field.Fill(IDataReader datareader) +2013
   Dynamicweb.Forms.Field.GetFieldsBySql(String sql) +180
   Dynamicweb.Admin.ListForms.Page_Load(Object sender, EventArgs e) in E:\Agent\_work\163\s\01 - Applications\Dynamicweb.Admin\DW98\Dynamicweb.Admin\Admin\Module\BasicForms\ListForms.aspx.vb:42
   System.Web.UI.Control.OnLoad(EventArgs e) +108
   System.Web.UI.Control.LoadRecursive() +90
   System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +1607

Version Information: Microsoft .NET Framework Version:4.0.30319; ASP.NET Version:4.8.4075.0

Same problem here.

Is there any other solution available?

Hi All

Will look into this. Maybe we have released the 9.9 forms package by mistake with 9.8.5 or something.

You can downgrade the Dynamicweb.Forms package to 3.7.1

Hi Morten I had to add this aswell

ALTER TABLE [FormField] ADD [FormFieldTitle] [nvarchar](255) NULL;

But after that my forms work agian!  :D :D 

Thanks a lot!

/ Daniel 

We also solved it, thanks for the help!

BR Tomas