I've just uninstalled Contour and have replaced it with Forms using the back-office installation button, and I checked all the old Contour database tables were deleted.
I've been able to create a new form based on the the built in 'Contact form', but when I submit the form I receive a YSOD stating
Cannot insert the value NULL into column 'Alias', table 'mydomain.co.uk.dbo.UFRecordFields'; column does not allow nulls. INSERT fails.
The statement has been terminated.
Entries are recorded correctly in the back-office and may be reviewed. Stack trace and screenshots follow...
Any pointers would be greatly appreciated.
Cheers,
Chris
Umbraco v7.4.3
Forms v4.3.0 beta (as installed by the back-office)
Thanks for the reply. I deleted all the Contour tables using:
DROP TABLE UFRecordDataBit
DROP TABLE UFRecordDataDateTime
DROP TABLE UFRecordDataInteger
DROP TABLE UFRecordDataLongString
DROP TABLE UFRecordDataString
DROP TABLE UFRecordFields
DROP TABLE UFRecords
DROP TABLE UFRecordsXml
and ran Tim's create script as he posted in your link, but I still get the same error.
I tried doing what you suggested with the 4.3.0beta version, but ran into the same issue. I also retried with the NuGet version of 4.3.0beta, and again no success. However, NuGeting the 4.2.1 version install fine, so maybe there is a bug in 4.3.0beta?
Hello Chris,
Sorry to hear you are having problems installing Umbraco Forms 4.3.0 beta.
Is there anything in the UmbracoTraceLog that we can take a look at to see if there is anything that may be causing the DB tables not to be created correctly.
However the YSOD you are showing is that the field/db column 'Alias' has been submitted with a null & that DB table does not allow nulls.
So can you tell me what steps you did please to recreate this?
Have you tried creating a form without using the template, just so I can see if the problem lies with the template itself.
Initially I uninstalled Contour using Umbraco’s package manager, checked all Contour related database tables were removed, and installed Forms 4.3.0beta using the install button in the back-office. I then used the Contact template and updated a few fields (see screenshot later). This resulted in the error Cannot insert the value NULL into column 'Alias', table ‘domain.co.uk.dbo.UFRecordFields'; column does not allow nulls. INSERT fails.
Subsequently I’ve tried (see test of success):
Forms 4.3.0beta from a NuGet install – same error
Forms 4.3.0beta
download from Umbraco project and installing as a local package –
same error
Forms 4.2.1 from NuGet – worked fine
Following your post, I reinstalled Forms 4.3.0beta via the back-office, and tried (trace log for this this and the following actions attached):
Creating a test form with a single field ‘Name’ of type ‘Short Answer’. This worked fine.
Creating a form based on the built-in ’Contact us’ form (no amends). This worked fine.
Creating a form based on the built-in ’Contact us’ form and making the amends I detailed below. This resulted in the error I’ve been experiencing.
Therefore I suspect there is either an issue in some of the amends I’m doing, or built-in form fields don’t like being renamed.
I’ll carry out a little more experimentation, but let me know if there is anything you’d like me to try.
Cheers,
Chris
Notes:
SQL I used to ensure all Contour/Forms database table removed:
DROP TABLE UFRecordDataBit
DROP TABLE UFRecordDataDateTime
DROP TABLE UFRecordDataInteger
DROP TABLE UFRecordDataLongString
DROP TABLE UFRecordDataString
DROP TABLE UFRecordFields
DROP TABLE UFRecords
DROP TABLE UFRecordsXml
DROP TABLE UFUserFormSecurity
DROP TABLE UFUserSecurity
I’m pretty sure when I uninstall all Forms all related files are removed as the solution is in source control.
Umbraco: 7.4.3
My test of success has been to create a form based on the built in ‘Contact us’ one, amend some fields:
‘Name’ renamed to ‘First Name’ and make mandatory
Add ‘Last Name’ field and make mandatory
Add ‘Company’ field
Make ‘email’ field mandatory
Make ‘Message’ field mandatory
Finally I add the form to an RTE using the macro picker and submit a form.
Trace log for reinstalling Forms 4.3.0beta via the back-office and creating 3 forms in above post (last form is the one that fails) (I can't seem to attach .zip files, but I can send one over if that is any easier):
2016-05-25 10:11:31,496 [P10860/D2/T16] INFO Umbraco.Core.Publishing.PublishingStrategy - Content 'Home' with Id '1060' has been published.
2016-05-25 10:11:31,653 [P10860/D2/T16] INFO Umbraco.Core.PluginManager - Starting resolution types of umbraco.interfaces.ICacheRefresher
2016-05-25 10:11:31,677 [P10860/D2/T16] INFO Umbraco.Core.PluginManager - Completed resolution of types of umbraco.interfaces.ICacheRefresher, found 0 (took 23ms)
2016-05-25 10:11:35,896 [P10860/D2/T13] INFO umbraco.content - Save Xml to file...
2016-05-25 10:11:36,054 [P10860/D2/T27] INFO umbraco.content - Saved Xml to file.
2016-05-25 10:12:01,343 [P10860/D2/T25] INFO Umbraco.Web.Scheduling.BackgroundTaskRunner - [KeepAlive] Terminating
2016-05-25 10:12:01,343 [P10860/D2/T25] INFO Umbraco.Web.Scheduling.BackgroundTaskRunner - [KeepAlive] Waiting for tasks to complete
2016-05-25 10:12:01,346 [P10860/D2/T25] INFO Umbraco.Web.Scheduling.BackgroundTaskRunner - [Umbraco.Web.Scheduling.IBackgroundTask] Terminating
2016-05-25 10:12:01,346 [P10860/D2/T25] INFO Umbraco.Web.Scheduling.BackgroundTaskRunner - [Umbraco.Web.Scheduling.IBackgroundTask] Waiting for tasks to complete
2016-05-25 10:12:01,347 [P10860/D2/T11] INFO Umbraco.Web.Scheduling.BackgroundTaskRunner - [KeepAlive] Tasks completed, terminated
2016-05-25 10:12:01,347 [P10860/D2/T14] INFO Umbraco.Web.Scheduling.BackgroundTaskRunner - [Umbraco.Web.Scheduling.IBackgroundTask] Tasks completed, terminated
2016-05-25 10:12:01,386 [P10860/D2/T25] INFO Umbraco.Web.Scheduling.BackgroundTaskRunner - [LogScrubber] Terminating
2016-05-25 10:12:01,386 [P10860/D2/T25] INFO Umbraco.Web.Scheduling.BackgroundTaskRunner - [LogScrubber] Waiting for tasks to complete
2016-05-25 10:12:01,386 [P10860/D2/T25] INFO Umbraco.Web.Scheduling.BackgroundTaskRunner - [ScheduledPublishing] Terminating
2016-05-25 10:12:01,386 [P10860/D2/T25] INFO Umbraco.Web.Scheduling.BackgroundTaskRunner - [ScheduledPublishing] Waiting for tasks to complete
2016-05-25 10:12:01,386 [P10860/D2/T11] INFO Umbraco.Web.Scheduling.BackgroundTaskRunner - [LogScrubber] Tasks completed, terminated
2016-05-25 10:12:01,386 [P10860/D2/T25] INFO Umbraco.Web.Scheduling.BackgroundTaskRunner - [ScheduledPublishing] Tasks completed, terminated
2016-05-25 10:12:01,386 [P10860/D2/T25] INFO Umbraco.Web.Scheduling.BackgroundTaskRunner - [ScheduledTasks] Terminating
2016-05-25 10:12:01,386 [P10860/D2/T25] INFO Umbraco.Web.Scheduling.BackgroundTaskRunner - [ScheduledTasks] Waiting for tasks to complete
2016-05-25 10:12:01,386 [P10860/D2/T11] INFO Umbraco.Web.Scheduling.BackgroundTaskRunner - [ScheduledTasks] Tasks completed, terminated
2016-05-25 10:12:01,455 [P10860/D2/T9] INFO Umbraco.Core.PluginManager - Starting resolution types of umbraco.interfaces.IPackageAction
2016-05-25 10:12:01,512 [P10860/D2/T9] INFO Umbraco.Core.PluginManager - Completed resolution of types of umbraco.interfaces.IPackageAction, found 0 (took 56ms)
2016-05-25 10:12:04,472 [P10860/D6/T24] INFO Umbraco.Core.CoreBootManager - Umbraco 7.4.3 application starting on TAMARYN-W10
2016-05-25 10:12:04,502 [P10860/D6/T24] INFO Umbraco.Core.PluginManager - Determining hash of code files on disk
2016-05-25 10:12:04,512 [P10860/D6/T24] INFO Umbraco.Core.PluginManager - Hash determined (took 11ms)
2016-05-25 10:12:04,590 [P10860/D6/T24] INFO Umbraco.Core.PluginManager - Starting resolution types of umbraco.interfaces.IApplicationStartupHandler
2016-05-25 10:12:04,931 [P10860/D6/T24] INFO Umbraco.Core.PluginManager - Completed resolution of types of umbraco.interfaces.IApplicationStartupHandler, found 0 (took 340ms)
2016-05-25 10:12:04,953 [P10860/D6/T24] INFO Umbraco.Core.PluginManager - Starting resolution types of Umbraco.Core.PropertyEditors.IPropertyEditorValueConverter
2016-05-25 10:12:04,965 [P10860/D6/T24] INFO Umbraco.Core.PluginManager - Completed resolution of types of Umbraco.Core.PropertyEditors.IPropertyEditorValueConverter, found 0 (took 12ms)
2016-05-25 10:12:04,965 [P10860/D6/T24] INFO Umbraco.Core.PluginManager - Starting resolution types of Umbraco.Core.PropertyEditors.IPropertyValueConverter
2016-05-25 10:12:04,982 [P10860/D6/T24] INFO Umbraco.Core.PluginManager - Completed resolution of types of Umbraco.Core.PropertyEditors.IPropertyValueConverter, found 0 (took 16ms)
2016-05-25 10:12:04,999 [P10860/D6/T24] INFO Umbraco.Core.PluginManager - Starting resolution types of Umbraco.Web.Mvc.SurfaceController
2016-05-25 10:12:05,011 [P10860/D6/T24] INFO Umbraco.Core.PluginManager - Completed resolution of types of Umbraco.Web.Mvc.SurfaceController, found 0 (took 11ms)
2016-05-25 10:12:05,011 [P10860/D6/T24] INFO Umbraco.Core.PluginManager - Starting resolution types of Umbraco.Web.WebApi.UmbracoApiController
2016-05-25 10:12:05,053 [P10860/D6/T24] INFO Umbraco.Core.PluginManager - Completed resolution of types of Umbraco.Web.WebApi.UmbracoApiController, found 0 (took 42ms)
2016-05-25 10:12:05,091 [P10860/D6/T24] INFO Umbraco.Core.PluginManager - Starting resolution types of Umbraco.Core.Media.IThumbnailProvider
2016-05-25 10:12:05,103 [P10860/D6/T24] INFO Umbraco.Core.PluginManager - Completed resolution of types of Umbraco.Core.Media.IThumbnailProvider, found 0 (took 11ms)
2016-05-25 10:12:05,103 [P10860/D6/T24] INFO Umbraco.Core.PluginManager - Starting resolution types of Umbraco.Core.Media.IImageUrlProvider
2016-05-25 10:12:05,116 [P10860/D6/T24] INFO Umbraco.Core.PluginManager - Completed resolution of types of Umbraco.Core.Media.IImageUrlProvider, found 0 (took 13ms)
2016-05-25 10:12:06,399 [P10860/D6/T24] INFO Umbraco.Core.DatabaseContext - CanConnect = True
2016-05-25 10:12:06,618 [P10860/D6/T24] INFO Umbraco.Core.DatabaseContext - CanConnect = True
2016-05-25 10:12:06,621 [P10860/D6/T24] INFO Umbraco.Core.DatabaseContext - CanConnect = True
2016-05-25 10:12:06,640 [P10860/D6/T24] INFO Umbraco.Web.Cache.CacheRefresherEventHandler - Initializing Umbraco internal event handlers for cache refreshing
2016-05-25 10:12:06,666 [P10860/D6/T24] INFO Umbraco.Web.Search.ExamineEvents - Initializing Examine and binding to business logic events
2016-05-25 10:12:06,860 [P10860/D6/T24] INFO UmbracoExamine.LocalStorage.LocalTempStorageIndexer - Successfully sync'd main index to local temp storage for index: ~/App_Data/TEMP/ExamineIndexes/TAMARYN-W10/Internal/
2016-05-25 10:12:06,906 [P10860/D6/T24] INFO UmbracoExamine.LocalStorage.LocalTempStorageIndexer - Successfully sync'd main index to local temp storage for index: ~/App_Data/TEMP/ExamineIndexes/TAMARYN-W10/InternalMember/
2016-05-25 10:12:06,941 [P10860/D6/T24] INFO UmbracoExamine.LocalStorage.LocalTempStorageIndexer - Successfully sync'd main index to local temp storage for index: ~/App_Data/TEMP/ExamineIndexes/TAMARYN-W10/External/
2016-05-25 10:12:06,987 [P10860/D6/T24] INFO UmbracoExamine.LocalStorage.LocalTempStorageIndexer - Successfully sync'd main index to local temp storage for index: ~/App_Data/TEMP/ExamineIndexes/TAMARYN-W10/exampleSearch/
2016-05-25 10:12:07,013 [P10860/D6/T24] INFO Umbraco.Web.Search.ExamineEvents - Adding examine event handlers for index providers: 4
2016-05-25 10:12:07,147 [P10860/D6/T24] INFO Umbraco.Forms.Core.Cache.CacheEventHandler - Initializing Umbraco Forms Events to trigger Cache Refreshers
2016-05-25 10:12:07,199 [P10860/D6/T24] INFO Umbraco.Core.Persistence.Database - Create Table sql -1:
CREATE TABLE [UFRecords] ([Id] INTEGER NOT NULL IDENTITY(1,1),
[Form] UniqueIdentifier NOT NULL,
[Created] DATETIME NOT NULL,
[Updated] DATETIME NOT NULL,
[CurrentPage] UniqueIdentifier NULL,
[UmbracoPageId] INTEGER NULL,
[IP] NVARCHAR(255) NULL,
[MemberKey] NVARCHAR(255) NULL,
[UniqueId] UniqueIdentifier NOT NULL,
[State] NVARCHAR(50) NULL,
[RecordData] NTEXT NOT NULL)
2016-05-25 10:12:07,203 [P10860/D6/T24] INFO Umbraco.Core.Persistence.Database - Primary Key sql -1:
ALTER TABLE [UFRecords] ADD CONSTRAINT [PK_UFRecords] PRIMARY KEY CLUSTERED ([Id])
2016-05-25 10:12:07,204 [P10860/D6/T24] INFO Umbraco.Core.Persistence.Migrations.Initial.BaseDataCreation - Creating data in table UFRecords
2016-05-25 10:12:07,205 [P10860/D6/T24] INFO Umbraco.Core.Persistence.Migrations.Initial.BaseDataCreation - Done creating data in table UFRecords
2016-05-25 10:12:07,207 [P10860/D6/T24] INFO Umbraco.Core.Persistence.Database - New table 'UFRecords' was created
2016-05-25 10:12:07,211 [P10860/D6/T24] INFO Umbraco.Core.Persistence.Database - Create Table sql -1:
CREATE TABLE [UFRecordFields] ([Key] UniqueIdentifier NOT NULL,
[FieldId] UniqueIdentifier NOT NULL,
[Record] INTEGER NOT NULL,
[Alias] NVARCHAR(255) NOT NULL,
[DataType] NVARCHAR(255) NOT NULL)
2016-05-25 10:12:07,213 [P10860/D6/T24] INFO Umbraco.Core.Persistence.Database - Primary Key sql -1:
ALTER TABLE [UFRecordFields] ADD CONSTRAINT [PK_UFRecordFields] PRIMARY KEY CLUSTERED ([Key])
2016-05-25 10:12:07,213 [P10860/D6/T24] INFO Umbraco.Core.Persistence.Migrations.Initial.BaseDataCreation - Creating data in table UFRecordFields
2016-05-25 10:12:07,213 [P10860/D6/T24] INFO Umbraco.Core.Persistence.Migrations.Initial.BaseDataCreation - Done creating data in table UFRecordFields
2016-05-25 10:12:07,213 [P10860/D6/T24] INFO Umbraco.Core.Persistence.Database - New table 'UFRecordFields' was created
2016-05-25 10:12:07,224 [P10860/D6/T24] INFO Umbraco.Core.Persistence.Database - Create Table sql -1:
CREATE TABLE [UFRecordDataString] ([Id] INTEGER NOT NULL IDENTITY(1,1),
[Key] UniqueIdentifier NOT NULL,
[Value] NVARCHAR(255) NOT NULL)
2016-05-25 10:12:07,226 [P10860/D6/T24] INFO Umbraco.Core.Persistence.Database - Primary Key sql -1:
ALTER TABLE [UFRecordDataString] ADD CONSTRAINT [PK_UFRecordDataString] PRIMARY KEY CLUSTERED ([Id])
2016-05-25 10:12:07,226 [P10860/D6/T24] INFO Umbraco.Core.Persistence.Migrations.Initial.BaseDataCreation - Creating data in table UFRecordDataString
2016-05-25 10:12:07,226 [P10860/D6/T24] INFO Umbraco.Core.Persistence.Migrations.Initial.BaseDataCreation - Done creating data in table UFRecordDataString
2016-05-25 10:12:07,227 [P10860/D6/T24] INFO Umbraco.Core.Persistence.Database - Create Index sql -1:
CREATE NONCLUSTERED INDEX [IX_datastring_recordfield] ON [UFRecordDataString] ([Key])
2016-05-25 10:12:07,228 [P10860/D6/T24] INFO Umbraco.Core.Persistence.Database - Create Foreign Key sql -1:
ALTER TABLE [UFRecordDataString] ADD CONSTRAINT [FK_UFRecordDataString_UFRecordFields_Key] FOREIGN KEY ([Key]) REFERENCES [UFRecordFields] ([Key])
2016-05-25 10:12:07,230 [P10860/D6/T24] INFO Umbraco.Core.Persistence.Database - New table 'UFRecordDataString' was created
2016-05-25 10:12:07,233 [P10860/D6/T24] INFO Umbraco.Core.Persistence.Database - Create Table sql -1:
CREATE TABLE [UFRecordDataLongString] ([Id] INTEGER NOT NULL IDENTITY(1,1),
[Key] UniqueIdentifier NOT NULL,
[Value] NTEXT NULL)
2016-05-25 10:12:07,235 [P10860/D6/T24] INFO Umbraco.Core.Persistence.Database - Primary Key sql -1:
ALTER TABLE [UFRecordDataLongString] ADD CONSTRAINT [PK_UFRecordDataLongString] PRIMARY KEY CLUSTERED ([Id])
2016-05-25 10:12:07,235 [P10860/D6/T24] INFO Umbraco.Core.Persistence.Migrations.Initial.BaseDataCreation - Creating data in table UFRecordDataLongString
2016-05-25 10:12:07,235 [P10860/D6/T24] INFO Umbraco.Core.Persistence.Migrations.Initial.BaseDataCreation - Done creating data in table UFRecordDataLongString
2016-05-25 10:12:07,236 [P10860/D6/T24] INFO Umbraco.Core.Persistence.Database - Create Index sql -1:
CREATE NONCLUSTERED INDEX [IX_datalongstring_recordfield] ON [UFRecordDataLongString] ([Key])
2016-05-25 10:12:07,237 [P10860/D6/T24] INFO Umbraco.Core.Persistence.Database - Create Foreign Key sql -1:
ALTER TABLE [UFRecordDataLongString] ADD CONSTRAINT [FK_UFRecordDataLongString_UFRecordFields_Key] FOREIGN KEY ([Key]) REFERENCES [UFRecordFields] ([Key])
2016-05-25 10:12:07,237 [P10860/D6/T24] INFO Umbraco.Core.Persistence.Database - New table 'UFRecordDataLongString' was created
2016-05-25 10:12:07,240 [P10860/D6/T24] INFO Umbraco.Core.Persistence.Database - Create Table sql -1:
CREATE TABLE [UFRecordDataInteger] ([Id] INTEGER NOT NULL IDENTITY(1,1),
[Key] UniqueIdentifier NOT NULL,
[Value] INTEGER NULL)
2016-05-25 10:12:07,241 [P10860/D6/T24] INFO Umbraco.Core.Persistence.Database - Primary Key sql -1:
ALTER TABLE [UFRecordDataInteger] ADD CONSTRAINT [PK_UFRecordDataInteger] PRIMARY KEY CLUSTERED ([Id])
2016-05-25 10:12:07,242 [P10860/D6/T24] INFO Umbraco.Core.Persistence.Migrations.Initial.BaseDataCreation - Creating data in table UFRecordDataInteger
2016-05-25 10:12:07,242 [P10860/D6/T24] INFO Umbraco.Core.Persistence.Migrations.Initial.BaseDataCreation - Done creating data in table UFRecordDataInteger
2016-05-25 10:12:07,243 [P10860/D6/T24] INFO Umbraco.Core.Persistence.Database - Create Index sql -1:
CREATE NONCLUSTERED INDEX [IX_datainteger_recordfield] ON [UFRecordDataInteger] ([Key])
2016-05-25 10:12:07,244 [P10860/D6/T24] INFO Umbraco.Core.Persistence.Database - Create Foreign Key sql -1:
ALTER TABLE [UFRecordDataInteger] ADD CONSTRAINT [FK_UFRecordDataInteger_UFRecordFields_Key] FOREIGN KEY ([Key]) REFERENCES [UFRecordFields] ([Key])
2016-05-25 10:12:07,245 [P10860/D6/T24] INFO Umbraco.Core.Persistence.Database - New table 'UFRecordDataInteger' was created
2016-05-25 10:12:07,248 [P10860/D6/T24] INFO Umbraco.Core.Persistence.Database - Create Table sql -1:
CREATE TABLE [UFRecordDataBit] ([Id] INTEGER NOT NULL IDENTITY(1,1),
[Key] UniqueIdentifier NOT NULL,
[Value] BIT NULL)
2016-05-25 10:12:07,249 [P10860/D6/T24] INFO Umbraco.Core.Persistence.Database - Primary Key sql -1:
ALTER TABLE [UFRecordDataBit] ADD CONSTRAINT [PK_UFRecordDataBit] PRIMARY KEY CLUSTERED ([Id])
2016-05-25 10:12:07,250 [P10860/D6/T24] INFO Umbraco.Core.Persistence.Migrations.Initial.BaseDataCreation - Creating data in table UFRecordDataBit
2016-05-25 10:12:07,250 [P10860/D6/T24] INFO Umbraco.Core.Persistence.Migrations.Initial.BaseDataCreation - Done creating data in table UFRecordDataBit
2016-05-25 10:12:07,250 [P10860/D6/T24] INFO Umbraco.Core.Persistence.Database - Create Index sql -1:
CREATE NONCLUSTERED INDEX [IX_databit_recordfield] ON [UFRecordDataBit] ([Key])
2016-05-25 10:12:07,251 [P10860/D6/T24] INFO Umbraco.Core.Persistence.Database - Create Foreign Key sql -1:
ALTER TABLE [UFRecordDataBit] ADD CONSTRAINT [FK_UFRecordDataBit_UFRecordFields_Key] FOREIGN KEY ([Key]) REFERENCES [UFRecordFields] ([Key])
2016-05-25 10:12:07,252 [P10860/D6/T24] INFO Umbraco.Core.Persistence.Database - New table 'UFRecordDataBit' was created
2016-05-25 10:12:07,255 [P10860/D6/T24] INFO Umbraco.Core.Persistence.Database - Create Table sql -1:
CREATE TABLE [UFRecordDataDateTime] ([Id] INTEGER NOT NULL IDENTITY(1,1),
[Key] UniqueIdentifier NOT NULL,
[Value] DATETIME NULL)
2016-05-25 10:12:07,256 [P10860/D6/T24] INFO Umbraco.Core.Persistence.Database - Primary Key sql -1:
ALTER TABLE [UFRecordDataDateTime] ADD CONSTRAINT [PK_UFRecordDataDateTime] PRIMARY KEY CLUSTERED ([Id])
2016-05-25 10:12:07,257 [P10860/D6/T24] INFO Umbraco.Core.Persistence.Migrations.Initial.BaseDataCreation - Creating data in table UFRecordDataDateTime
2016-05-25 10:12:07,257 [P10860/D6/T24] INFO Umbraco.Core.Persistence.Migrations.Initial.BaseDataCreation - Done creating data in table UFRecordDataDateTime
2016-05-25 10:12:07,257 [P10860/D6/T24] INFO Umbraco.Core.Persistence.Database - Create Index sql -1:
CREATE NONCLUSTERED INDEX [IX_datadatetime_recordfield] ON [UFRecordDataDateTime] ([Key])
2016-05-25 10:12:07,259 [P10860/D6/T24] INFO Umbraco.Core.Persistence.Database - Create Foreign Key sql -1:
ALTER TABLE [UFRecordDataDateTime] ADD CONSTRAINT [FK_UFRecordDataDateTime_UFRecordFields_Key] FOREIGN KEY ([Key]) REFERENCES [UFRecordFields] ([Key])
2016-05-25 10:12:07,260 [P10860/D6/T24] INFO Umbraco.Core.Persistence.Database - New table 'UFRecordDataDateTime' was created
2016-05-25 10:12:07,263 [P10860/D6/T24] INFO Umbraco.Core.Persistence.Database - Create Table sql -1:
CREATE TABLE [UFUserSecurity] ([User] NVARCHAR(50) NOT NULL,
[ManageDataSources] BIT NOT NULL,
[ManagePreValueSources] BIT NOT NULL,
[ManageWorkflows] BIT NOT NULL,
[ManageForms] BIT NOT NULL)
2016-05-25 10:12:07,263 [P10860/D6/T24] INFO Umbraco.Core.Persistence.Migrations.Initial.BaseDataCreation - Creating data in table UFUserSecurity
2016-05-25 10:12:07,263 [P10860/D6/T24] INFO Umbraco.Core.Persistence.Migrations.Initial.BaseDataCreation - Done creating data in table UFUserSecurity
2016-05-25 10:12:07,263 [P10860/D6/T24] INFO Umbraco.Core.Persistence.Database - New table 'UFUserSecurity' was created
2016-05-25 10:12:07,266 [P10860/D6/T24] INFO Umbraco.Core.Persistence.Database - Create Table sql -1:
CREATE TABLE [UFUserFormSecurity] ([Id] INTEGER NOT NULL IDENTITY(1,1),
[User] NVARCHAR(50) NOT NULL,
[Form] UniqueIdentifier NOT NULL,
[HasAccess] BIT NOT NULL,
[AllowInEditor] BIT NOT NULL,
[SecurityType] INTEGER NOT NULL)
2016-05-25 10:12:07,268 [P10860/D6/T24] INFO Umbraco.Core.Persistence.Database - Primary Key sql -1:
ALTER TABLE [UFUserFormSecurity] ADD CONSTRAINT [Id] PRIMARY KEY CLUSTERED ([Id])
2016-05-25 10:12:07,268 [P10860/D6/T24] INFO Umbraco.Core.Persistence.Migrations.Initial.BaseDataCreation - Creating data in table UFUserFormSecurity
2016-05-25 10:12:07,268 [P10860/D6/T24] INFO Umbraco.Core.Persistence.Migrations.Initial.BaseDataCreation - Done creating data in table UFUserFormSecurity
2016-05-25 10:12:07,269 [P10860/D6/T24] INFO Umbraco.Core.Persistence.Database - New table 'UFUserFormSecurity' was created
2016-05-25 10:12:07,279 [P10860/D6/T24] INFO Umbraco.Core.PluginManager - Starting resolution types of umbraco.interfaces.IApplication
2016-05-25 10:12:07,300 [P10860/D6/T24] INFO Umbraco.Core.PluginManager - Completed resolution of types of umbraco.interfaces.IApplication, found 0 (took 20ms)
2016-05-25 10:12:07,321 [P10860/D6/T24] INFO Umbraco.Core.PluginManager - Starting resolution types of Umbraco.Core.Persistence.Mappers.BaseMapper
2016-05-25 10:12:07,332 [P10860/D6/T24] INFO Umbraco.Core.PluginManager - Completed resolution of types of Umbraco.Core.Persistence.Mappers.BaseMapper, found 0 (took 11ms)
2016-05-25 10:12:07,739 [P10860/D6/T24] INFO Umbraco.Core.PluginManager - Starting resolution types of Umbraco.Web.Trees.TreeController
2016-05-25 10:12:07,756 [P10860/D6/T24] INFO Umbraco.Core.PluginManager - Completed resolution of types of Umbraco.Web.Trees.TreeController, found 0 (took 16ms)
2016-05-25 10:12:07,760 [P10860/D6/T24] INFO Umbraco.Core.PluginManager - Starting resolution types of umbraco.interfaces.ITree
2016-05-25 10:12:07,780 [P10860/D6/T24] INFO Umbraco.Core.PluginManager - Completed resolution of types of umbraco.interfaces.ITree, found 0 (took 20ms)
2016-05-25 10:12:07,802 [P10860/D6/T24] INFO Umbraco.Core.CoreBootManager - Umbraco application startup complete (took 3436ms)
2016-05-25 10:12:08,848 [P10860/D6/T9] INFO Umbraco.Web.Scheduling.BackgroundTaskRunner - [ScheduledPublishing] Terminating
2016-05-25 10:12:08,848 [P10860/D6/T9] INFO Umbraco.Web.Scheduling.BackgroundTaskRunner - [ScheduledPublishing] Waiting for tasks to complete
2016-05-25 10:12:08,850 [P10860/D6/T9] INFO Umbraco.Web.Scheduling.BackgroundTaskRunner - [ScheduledPublishing] Tasks completed, terminated
2016-05-25 10:12:08,850 [P10860/D6/T9] INFO Umbraco.Web.Scheduling.BackgroundTaskRunner - [ScheduledTasks] Terminating
2016-05-25 10:12:08,850 [P10860/D6/T9] INFO Umbraco.Web.Scheduling.BackgroundTaskRunner - [ScheduledTasks] Waiting for tasks to complete
2016-05-25 10:12:08,850 [P10860/D6/T9] INFO Umbraco.Web.Scheduling.BackgroundTaskRunner - [ScheduledTasks] Tasks completed, terminated
2016-05-25 10:12:08,854 [P10860/D6/T9] INFO Umbraco.Web.Scheduling.BackgroundTaskRunner - [LogScrubber] Terminating
2016-05-25 10:12:08,854 [P10860/D6/T9] INFO Umbraco.Web.Scheduling.BackgroundTaskRunner - [LogScrubber] Waiting for tasks to complete
2016-05-25 10:12:08,854 [P10860/D6/T9] INFO Umbraco.Web.Scheduling.BackgroundTaskRunner - [LogScrubber] Tasks completed, terminated
2016-05-25 10:12:08,854 [P10860/D6/T9] INFO Umbraco.Web.Scheduling.BackgroundTaskRunner - [Umbraco.Web.Scheduling.IBackgroundTask] Terminating
2016-05-25 10:12:08,854 [P10860/D6/T9] INFO Umbraco.Web.Scheduling.BackgroundTaskRunner - [Umbraco.Web.Scheduling.IBackgroundTask] Waiting for tasks to complete
2016-05-25 10:12:08,854 [P10860/D6/T9] INFO Umbraco.Web.Scheduling.BackgroundTaskRunner - [Umbraco.Web.Scheduling.IBackgroundTask] Tasks completed, terminated
2016-05-25 10:12:08,854 [P10860/D6/T9] INFO Umbraco.Web.Scheduling.BackgroundTaskRunner - [KeepAlive] Terminating
2016-05-25 10:12:08,854 [P10860/D6/T9] INFO Umbraco.Web.Scheduling.BackgroundTaskRunner - [KeepAlive] Waiting for tasks to complete
2016-05-25 10:12:08,854 [P10860/D6/T9] INFO Umbraco.Web.Scheduling.BackgroundTaskRunner - [KeepAlive] Tasks completed, terminated
2016-05-25 10:12:09,083 [P10860/D6/T15] INFO Umbraco.Core.Sync.ApplicationUrlHelper - ApplicationUrl: http://example.local:80/umbraco (UmbracoModule request)
2016-05-25 10:12:09,868 [P10860/D6/T15] INFO Umbraco.Core.Configuration.ClientDependencyConfiguration - Updated version number from 770369973 to 1373727316
2016-05-25 10:12:09,871 [P10860/D6/T15] INFO Umbraco.Core.PluginManager - Starting resolution types of umbraco.interfaces.ITree
2016-05-25 10:12:09,887 [P10860/D6/T15] INFO Umbraco.Core.PluginManager - Completed resolution of types of umbraco.interfaces.ITree, found 0 (took 16ms)
2016-05-25 10:12:10,699 [P10860/D8/T24] INFO Umbraco.Core.CoreBootManager - Umbraco 7.4.3 application starting on TAMARYN-W10
2016-05-25 10:12:10,727 [P10860/D8/T24] INFO Umbraco.Core.PluginManager - Determining hash of code files on disk
2016-05-25 10:12:10,739 [P10860/D8/T24] INFO Umbraco.Core.PluginManager - Hash determined (took 11ms)
2016-05-25 10:12:10,819 [P10860/D8/T24] INFO Umbraco.Core.PluginManager - Starting resolution types of umbraco.interfaces.IApplicationStartupHandler
2016-05-25 10:12:11,135 [P10860/D8/T24] INFO Umbraco.Core.PluginManager - Completed resolution of types of umbraco.interfaces.IApplicationStartupHandler, found 0 (took 315ms)
2016-05-25 10:12:11,155 [P10860/D8/T24] INFO Umbraco.Core.PluginManager - Starting resolution types of Umbraco.Core.PropertyEditors.IPropertyEditorValueConverter
2016-05-25 10:12:11,168 [P10860/D8/T24] INFO Umbraco.Core.PluginManager - Completed resolution of types of Umbraco.Core.PropertyEditors.IPropertyEditorValueConverter, found 0 (took 12ms)
2016-05-25 10:12:11,168 [P10860/D8/T24] INFO Umbraco.Core.PluginManager - Starting resolution types of Umbraco.Core.PropertyEditors.IPropertyValueConverter
2016-05-25 10:12:11,186 [P10860/D8/T24] INFO Umbraco.Core.PluginManager - Completed resolution of types of Umbraco.Core.PropertyEditors.IPropertyValueConverter, found 0 (took 17ms)
2016-05-25 10:12:11,202 [P10860/D8/T24] INFO Umbraco.Core.PluginManager - Starting resolution types of Umbraco.Web.Mvc.SurfaceController
2016-05-25 10:12:11,214 [P10860/D8/T24] INFO Umbraco.Core.PluginManager - Completed resolution of types of Umbraco.Web.Mvc.SurfaceController, found 0 (took 13ms)
2016-05-25 10:12:11,215 [P10860/D8/T24] INFO Umbraco.Core.PluginManager - Starting resolution types of Umbraco.Web.WebApi.UmbracoApiController
2016-05-25 10:12:11,257 [P10860/D8/T24] INFO Umbraco.Core.PluginManager - Completed resolution of types of Umbraco.Web.WebApi.UmbracoApiController, found 0 (took 42ms)
2016-05-25 10:12:11,300 [P10860/D8/T24] INFO Umbraco.Core.PluginManager - Starting resolution types of Umbraco.Core.Media.IThumbnailProvider
2016-05-25 10:12:11,313 [P10860/D8/T24] INFO Umbraco.Core.PluginManager - Completed resolution of types of Umbraco.Core.Media.IThumbnailProvider, found 0 (took 14ms)
2016-05-25 10:12:11,313 [P10860/D8/T24] INFO Umbraco.Core.PluginManager - Starting resolution types of Umbraco.Core.Media.IImageUrlProvider
2016-05-25 10:12:11,324 [P10860/D8/T24] INFO Umbraco.Core.PluginManager - Completed resolution of types of Umbraco.Core.Media.IImageUrlProvider, found 0 (took 10ms)
2016-05-25 10:12:12,688 [P10860/D8/T24] INFO Umbraco.Core.DatabaseContext - CanConnect = True
2016-05-25 10:12:12,920 [P10860/D8/T24] INFO Umbraco.Core.DatabaseContext - CanConnect = True
2016-05-25 10:12:12,925 [P10860/D8/T24] INFO Umbraco.Core.DatabaseContext - CanConnect = True
2016-05-25 10:12:12,947 [P10860/D8/T24] INFO Umbraco.Web.Cache.CacheRefresherEventHandler - Initializing Umbraco internal event handlers for cache refreshing
2016-05-25 10:12:12,973 [P10860/D8/T24] INFO Umbraco.Web.Search.ExamineEvents - Initializing Examine and binding to business logic events
2016-05-25 10:12:13,182 [P10860/D8/T24] INFO UmbracoExamine.LocalStorage.LocalTempStorageIndexer - Successfully sync'd main index to local temp storage for index: ~/App_Data/TEMP/ExamineIndexes/TAMARYN-W10/Internal/
2016-05-25 10:12:13,215 [P10860/D8/T24] INFO UmbracoExamine.LocalStorage.LocalTempStorageIndexer - Successfully sync'd main index to local temp storage for index: ~/App_Data/TEMP/ExamineIndexes/TAMARYN-W10/InternalMember/
2016-05-25 10:12:13,222 [P10860/D8/T24] INFO UmbracoExamine.LocalStorage.LocalTempStorageIndexer - Successfully sync'd main index to local temp storage for index: ~/App_Data/TEMP/ExamineIndexes/TAMARYN-W10/External/
2016-05-25 10:12:13,232 [P10860/D8/T24] INFO UmbracoExamine.LocalStorage.LocalTempStorageIndexer - Successfully sync'd main index to local temp storage for index: ~/App_Data/TEMP/ExamineIndexes/TAMARYN-W10/exampleSearch/
2016-05-25 10:12:13,245 [P10860/D8/T24] INFO Umbraco.Web.Search.ExamineEvents - Adding examine event handlers for index providers: 4
2016-05-25 10:12:13,302 [P10860/D8/T24] INFO Umbraco.Forms.Core.Cache.CacheEventHandler - Initializing Umbraco Forms Events to trigger Cache Refreshers
2016-05-25 10:12:13,391 [P10860/D8/T24] INFO Umbraco.Core.CoreBootManager - Umbraco application startup complete (took 2798ms)
2016-05-25 10:12:14,635 [P10860/D8/T21] INFO Umbraco.Core.Sync.ApplicationUrlHelper - ApplicationUrl: http://example.local:80/umbraco (UmbracoModule request)
2016-05-25 10:12:17,395 [P10860/D8/T26] INFO Umbraco.Core.PluginManager - Starting resolution types of Umbraco.Core.PropertyEditors.IParameterEditor
2016-05-25 10:12:17,425 [P10860/D8/T26] INFO Umbraco.Core.PluginManager - Completed resolution of types of Umbraco.Core.PropertyEditors.IParameterEditor, found 0 (took 29ms)
2016-05-25 10:12:19,134 [P10860/D8/T16] INFO Umbraco.Core.PluginManager - Starting resolution types of Umbraco.Web.Trees.TreeController
2016-05-25 10:12:19,153 [P10860/D8/T16] INFO Umbraco.Core.PluginManager - Completed resolution of types of Umbraco.Web.Trees.TreeController, found 0 (took 18ms)
2016-05-25 10:12:19,315 [P10860/D8/T16] INFO Umbraco.Core.PluginManager - Starting resolution types of umbraco.interfaces.ITree
2016-05-25 10:12:19,335 [P10860/D8/T16] INFO Umbraco.Core.PluginManager - Completed resolution of types of umbraco.interfaces.ITree, found 0 (took 20ms)
2016-05-25 10:12:19,354 [P10860/D8/T16] INFO Umbraco.Core.PluginManager - Starting resolution types of Umbraco.Web.Trees.TreeController
2016-05-25 10:12:19,354 [P10860/D8/T16] INFO Umbraco.Core.PluginManager - Completed resolution of types of Umbraco.Web.Trees.TreeController, found 0 (took 0ms)
2016-05-25 10:12:19,356 [P10860/D8/T16] INFO Umbraco.Core.PluginManager - Starting resolution types of umbraco.interfaces.ITree
2016-05-25 10:12:19,372 [P10860/D8/T16] INFO Umbraco.Core.PluginManager - Completed resolution of types of umbraco.interfaces.ITree, found 0 (took 16ms)
2016-05-25 10:12:19,390 [P10860/D8/T16] INFO Umbraco.Core.PluginManager - Starting resolution types of umbraco.interfaces.IApplication
2016-05-25 10:12:19,413 [P10860/D8/T16] INFO Umbraco.Core.PluginManager - Completed resolution of types of umbraco.interfaces.IApplication, found 0 (took 23ms)
2016-05-25 10:12:23,641 [P10860/D8/T35] INFO Umbraco.Core.PluginManager - Starting resolution types of Umbraco.Core.Persistence.Mappers.BaseMapper
2016-05-25 10:12:23,650 [P10860/D8/T35] INFO Umbraco.Core.PluginManager - Completed resolution of types of Umbraco.Core.Persistence.Mappers.BaseMapper, found 0 (took 8ms)
2016-05-25 10:12:31,411 [P10860/D2/T25] INFO Umbraco.Core.UmbracoApplicationBase - Application shutdown. Details: BinDirChangeOrDirectoryRename
_shutDownMessage=Change Notification for critical directories.
bin dir change or directory rename
HostingEnvironment initiated shutdown
Change Notification for critical directories.
bin dir change or directory rename
Change Notification for critical directories.
bin dir change or directory rename
Change Notification for critical directories.
bin dir change or directory rename
Change Notification for critical directories.
bin dir change or directory rename
Change Notification for critical directories.
bin dir change or directory rename
Change in C:\Windows\Microsoft.NET\Framework64\v4.0.30319\Temporary ASP.NET Files\root\422788f3\a8000fbb\hash\hash.web
Change in C:\Windows\Microsoft.NET\Framework64\v4.0.30319\Temporary ASP.NET Files\root\422788f3\a8000fbb\hash\hash.web
CONFIG change
CONFIG change
CONFIG change
CONFIG change
HostingEnvironment caused shutdown
_shutDownStack= at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo)
at System.Environment.get_StackTrace()
at System.Web.Hosting.HostingEnvironment.InitiateShutdownInternal()
at System.Web.Hosting.HostingEnvironment.InitiateShutdownWithoutDemand()
at System.Web.HttpRuntime.ShutdownAppDomain(String stackTrace)
at System.Web.HttpRuntime.OnCriticalDirectoryChange(Object sender, FileChangeEvent e)
at System.Web.FileChangesMonitor.OnCriticaldirChange(Object sender, FileChangeEvent e)
at System.Web.DirectoryMonitor.FireNotifications()
at System.Web.Util.WorkItem.CallCallbackWithAssert(WorkItemCallback callback)
at System.Web.Util.WorkItem.OnQueueUserWorkItemCompletion(Object state)
at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
at System.Threading.QueueUserWorkItemCallback.System.Threading.IThreadPoolWorkItem.ExecuteWorkItem()
at System.Threading.ThreadPoolWorkQueue.Dispatch()
2016-05-25 10:12:38,878 [P10860/D6/T9] INFO Umbraco.Core.UmbracoApplicationBase - Application shutdown. Details: ConfigurationChange
_shutDownMessage=CONFIG change
HostingEnvironment initiated shutdown
HostingEnvironment caused shutdown
_shutDownStack= at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo)
at System.Environment.get_StackTrace()
at System.Web.Hosting.HostingEnvironment.InitiateShutdownInternal()
at System.Web.Hosting.HostingEnvironment.InitiateShutdownWithoutDemand()
at System.Web.HttpRuntime.ShutdownAppDomain(String stackTrace)
at System.Web.Configuration.HttpConfigurationSystem.OnConfigurationChanged(Object sender, InternalConfigEventArgs e)
at System.Configuration.Internal.InternalConfigRoot.OnConfigChanged(InternalConfigEventArgs e)
at System.Configuration.BaseConfigurationRecord.OnStreamChanged(String streamname)
at System.Web.DirectoryMonitor.FireNotifications()
at System.Web.Util.WorkItem.CallCallbackWithAssert(WorkItemCallback callback)
at System.Web.Util.WorkItem.OnQueueUserWorkItemCompletion(Object state)
at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
at System.Threading.QueueUserWorkItemCallback.System.Threading.IThreadPoolWorkItem.ExecuteWorkItem()
at System.Threading.ThreadPoolWorkQueue.Dispatch()
2016-05-25 10:13:16,930 [P10860/D8/T9] INFO umbraco.content - Load Xml from file...
2016-05-25 10:13:16,968 [P10860/D8/T9] INFO umbraco.content - Loaded Xml from file.
2016-05-25 10:13:17,007 [P10860/D8/T26] INFO umbraco.BusinessLogic.Log - Log scrubbed. Removed all items older than 2016-05-24 10:13:16
2016-05-25 10:15:23,950 [P10860/D8/T40] INFO Umbraco.Core.PluginManager - Starting resolution types of umbraco.interfaces.ICacheRefresher
2016-05-25 10:15:23,982 [P10860/D8/T40] INFO Umbraco.Core.PluginManager - Completed resolution of types of umbraco.interfaces.ICacheRefresher, found 0 (took 32ms)
2016-05-25 10:15:32,213 [P10860/D8/T14] INFO Umbraco.Core.PluginManager - Starting resolution types of Umbraco.Core.PropertyEditors.IParameterEditor
2016-05-25 10:15:32,213 [P10860/D8/T14] INFO Umbraco.Core.PluginManager - Completed resolution of types of Umbraco.Core.PropertyEditors.IParameterEditor, found 0 (took 0ms)
2016-05-25 10:15:32,245 [P10860/D8/T14] INFO Umbraco.Core.PluginManager - Starting resolution types of umbraco.cms.businesslogic.macro.IMacroEngine
2016-05-25 10:15:32,253 [P10860/D8/T14] INFO Umbraco.Core.PluginManager - Completed resolution of types of umbraco.cms.businesslogic.macro.IMacroEngine, found 0 (took 8ms)
2016-05-25 10:15:33,373 [P10860/D8/T14] WARN umbraco.macro - Error loading partial view macro (View: ~/Views/MacroPartials/InsertUmbracoForm.cshtml). Exception: System.Web.HttpException (0x80004005): Error executing child request for handler 'System.Web.Mvc.HttpHandlerUtil+ServerExecuteHttpHandlerAsyncWrapper'. ---> System.NullReferenceException: Unable to get Form with ID: 'a6c1726f-c43f-472e-a9cf-980fe7e3d1f5' off disk or from the cache. Check the file exists on disk
at Umbraco.Forms.Data.Storage.FormStorage.GetForm(Guid id)
at Umbraco.Forms.Web.Controllers.UmbracoFormsController.GetForm(Guid formId)
at Umbraco.Forms.Web.Controllers.UmbracoFormsController.Render(Guid formId, Guid recordId, String view, String mode)
at lambda_method(Closure , ControllerBase , Object[] )
at System.Web.Mvc.ReflectedActionDescriptor.Execute(ControllerContext controllerContext, IDictionary`2 parameters)
at System.Web.Mvc.ControllerActionInvoker.InvokeActionMethod(ControllerContext controllerContext, ActionDescriptor actionDescriptor, IDictionary`2 parameters)
at System.Web.Mvc.Async.AsyncControllerActionInvoker.<BeginInvokeSynchronousActionMethod>b__39(IAsyncResult asyncResult, ActionInvocation innerInvokeState)
at System.Web.Mvc.Async.AsyncResultWrapper.WrappedAsyncResult`2.CallEndDelegate(IAsyncResult asyncResult)
at System.Web.Mvc.Async.AsyncControllerActionInvoker.EndInvokeActionMethod(IAsyncResult asyncResult)
at System.Web.Mvc.Async.AsyncControllerActionInvoker.AsyncInvocationWithFilters.<InvokeActionMethodFilterAsynchronouslyRecursive>b__3d()
at System.Web.Mvc.Async.AsyncControllerActionInvoker.AsyncInvocationWithFilters.<>c__DisplayClass46.<InvokeActionMethodFilterAsynchronouslyRecursive>b__3f()
at System.Web.Mvc.Async.AsyncControllerActionInvoker.AsyncInvocationWithFilters.<>c__DisplayClass46.<InvokeActionMethodFilterAsynchronouslyRecursive>b__3f()
at System.Web.Mvc.Async.AsyncControllerActionInvoker.AsyncInvocationWithFilters.<>c__DisplayClass46.<InvokeActionMethodFilterAsynchronouslyRecursive>b__3f()
at System.Web.Mvc.Async.AsyncControllerActionInvoker.AsyncInvocationWithFilters.<>c__DisplayClass46.<InvokeActionMethodFilterAsynchronouslyRecursive>b__3f()
at System.Web.Mvc.Async.AsyncControllerActionInvoker.EndInvokeActionMethodWithFilters(IAsyncResult asyncResult)
at System.Web.Mvc.Async.AsyncControllerActionInvoker.<>c__DisplayClass21.<>c__DisplayClass2b.<BeginInvokeAction>b__1c()
at System.Web.Mvc.Async.AsyncControllerActionInvoker.<>c__DisplayClass21.<BeginInvokeAction>b__1e(IAsyncResult asyncResult)
at System.Web.Mvc.Async.AsyncControllerActionInvoker.EndInvokeAction(IAsyncResult asyncResult)
at System.Web.Mvc.Controller.<BeginExecuteCore>b__1d(IAsyncResult asyncResult, ExecuteCoreState innerState)
at System.Web.Mvc.Async.AsyncResultWrapper.WrappedAsyncVoid`1.CallEndDelegate(IAsyncResult asyncResult)
at System.Web.Mvc.Controller.EndExecuteCore(IAsyncResult asyncResult)
at System.Web.Mvc.Async.AsyncResultWrapper.WrappedAsyncVoid`1.CallEndDelegate(IAsyncResult asyncResult)
at System.Web.Mvc.Controller.EndExecute(IAsyncResult asyncResult)
at System.Web.Mvc.MvcHandler.<BeginProcessRequest>b__5(IAsyncResult asyncResult, ProcessRequestState innerState)
at System.Web.Mvc.Async.AsyncResultWrapper.WrappedAsyncVoid`1.CallEndDelegate(IAsyncResult asyncResult)
at System.Web.Mvc.MvcHandler.EndProcessRequest(IAsyncResult asyncResult)
at System.Web.Mvc.HttpHandlerUtil.ServerExecuteHttpHandlerWrapper.<>c__DisplayClass4.<Wrap>b__3()
at System.Web.Mvc.HttpHandlerUtil.ServerExecuteHttpHandlerWrapper.Wrap[TResult](Func`1 func)
at System.Web.HttpServerUtility.ExecuteInternal(IHttpHandler handler, TextWriter writer, Boolean preserveForm, Boolean setPreviousPage, VirtualPath path, VirtualPath filePath, String physPath, Exception error, String queryStringOverride)
at System.Web.HttpServerUtility.ExecuteInternal(IHttpHandler handler, TextWriter writer, Boolean preserveForm, Boolean setPreviousPage, VirtualPath path, VirtualPath filePath, String physPath, Exception error, String queryStringOverride)
at System.Web.HttpServerUtility.Execute(IHttpHandler handler, TextWriter writer, Boolean preserveForm, Boolean setPreviousPage)
at System.Web.HttpServerUtility.Execute(IHttpHandler handler, TextWriter writer, Boolean preserveForm)
at System.Web.Mvc.Html.ChildActionExtensions.ActionHelper(HtmlHelper htmlHelper, String actionName, String controllerName, RouteValueDictionary routeValues, TextWriter textWriter)
at System.Web.Mvc.Html.ChildActionExtensions.RenderAction(HtmlHelper htmlHelper, String actionName, String controllerName, Object routeValues)
at ASP._Page_Views_MacroPartials_InsertUmbracoForm_cshtml.Execute() in c:\inetpub\wwwSites\example.local\website\Views\MacroPartials\InsertUmbracoForm.cshtml:line 17
at System.Web.WebPages.WebPageBase.ExecutePageHierarchy()
at System.Web.Mvc.WebViewPage.ExecutePageHierarchy()
at System.Web.WebPages.WebPageBase.ExecutePageHierarchy(WebPageContext pageContext, TextWriter writer, WebPageRenderingBase startPage)
at Umbraco.Core.Profiling.ProfilingView.Render(ViewContext viewContext, TextWriter writer)
at Umbraco.Web.Mvc.ControllerExtensions.RenderViewResultAsString(ControllerBase controller, ViewResultBase viewResult)
at Umbraco.Web.Macros.PartialViewMacroEngine.Execute(MacroModel macro, IPublishedContent content)
at umbraco.macro.LoadPartialViewMacro(MacroModel macro)
at umbraco.macro.renderMacro(Hashtable pageElements, Int32 pageId)
2016-05-25 10:15:33,374 [P10860/D8/T14] WARN umbraco.macro - Error loading Partial View (file: ~/Views/MacroPartials/InsertUmbracoForm.cshtml). Exception: System.Web.HttpException (0x80004005): Error executing child request for handler 'System.Web.Mvc.HttpHandlerUtil+ServerExecuteHttpHandlerAsyncWrapper'. ---> System.NullReferenceException: Unable to get Form with ID: 'a6c1726f-c43f-472e-a9cf-980fe7e3d1f5' off disk or from the cache. Check the file exists on disk
at Umbraco.Forms.Data.Storage.FormStorage.GetForm(Guid id)
at Umbraco.Forms.Web.Controllers.UmbracoFormsController.GetForm(Guid formId)
at Umbraco.Forms.Web.Controllers.UmbracoFormsController.Render(Guid formId, Guid recordId, String view, String mode)
at lambda_method(Closure , ControllerBase , Object[] )
at System.Web.Mvc.ReflectedActionDescriptor.Execute(ControllerContext controllerContext, IDictionary`2 parameters)
at System.Web.Mvc.ControllerActionInvoker.InvokeActionMethod(ControllerContext controllerContext, ActionDescriptor actionDescriptor, IDictionary`2 parameters)
at System.Web.Mvc.Async.AsyncControllerActionInvoker.<BeginInvokeSynchronousActionMethod>b__39(IAsyncResult asyncResult, ActionInvocation innerInvokeState)
at System.Web.Mvc.Async.AsyncResultWrapper.WrappedAsyncResult`2.CallEndDelegate(IAsyncResult asyncResult)
at System.Web.Mvc.Async.AsyncControllerActionInvoker.EndInvokeActionMethod(IAsyncResult asyncResult)
at System.Web.Mvc.Async.AsyncControllerActionInvoker.AsyncInvocationWithFilters.<InvokeActionMethodFilterAsynchronouslyRecursive>b__3d()
at System.Web.Mvc.Async.AsyncControllerActionInvoker.AsyncInvocationWithFilters.<>c__DisplayClass46.<InvokeActionMethodFilterAsynchronouslyRecursive>b__3f()
at System.Web.Mvc.Async.AsyncControllerActionInvoker.AsyncInvocationWithFilters.<>c__DisplayClass46.<InvokeActionMethodFilterAsynchronouslyRecursive>b__3f()
at System.Web.Mvc.Async.AsyncControllerActionInvoker.AsyncInvocationWithFilters.<>c__DisplayClass46.<InvokeActionMethodFilterAsynchronouslyRecursive>b__3f()
at System.Web.Mvc.Async.AsyncControllerActionInvoker.AsyncInvocationWithFilters.<>c__DisplayClass46.<InvokeActionMethodFilterAsynchronouslyRecursive>b__3f()
at System.Web.Mvc.Async.AsyncControllerActionInvoker.EndInvokeActionMethodWithFilters(IAsyncResult asyncResult)
at System.Web.Mvc.Async.AsyncControllerActionInvoker.<>c__DisplayClass21.<>c__DisplayClass2b.<BeginInvokeAction>b__1c()
at System.Web.Mvc.Async.AsyncControllerActionInvoker.<>c__DisplayClass21.<BeginInvokeAction>b__1e(IAsyncResult asyncResult)
at System.Web.Mvc.Async.AsyncControllerActionInvoker.EndInvokeAction(IAsyncResult asyncResult)
at System.Web.Mvc.Controller.<BeginExecuteCore>b__1d(IAsyncResult asyncResult, ExecuteCoreState innerState)
at System.Web.Mvc.Async.AsyncResultWrapper.WrappedAsyncVoid`1.CallEndDelegate(IAsyncResult asyncResult)
at System.Web.Mvc.Controller.EndExecuteCore(IAsyncResult asyncResult)
at System.Web.Mvc.Async.AsyncResultWrapper.WrappedAsyncVoid`1.CallEndDelegate(IAsyncResult asyncResult)
at System.Web.Mvc.Controller.EndExecute(IAsyncResult asyncResult)
at System.Web.Mvc.MvcHandler.<BeginProcessRequest>b__5(IAsyncResult asyncResult, ProcessRequestState innerState)
at System.Web.Mvc.Async.AsyncResultWrapper.WrappedAsyncVoid`1.CallEndDelegate(IAsyncResult asyncResult)
at System.Web.Mvc.MvcHandler.EndProcessRequest(IAsyncResult asyncResult)
at System.Web.Mvc.HttpHandlerUtil.ServerExecuteHttpHandlerWrapper.<>c__DisplayClass4.<Wrap>b__3()
at System.Web.Mvc.HttpHandlerUtil.ServerExecuteHttpHandlerWrapper.Wrap[TResult](Func`1 func)
at System.Web.HttpServerUtility.ExecuteInternal(IHttpHandler handler, TextWriter writer, Boolean preserveForm, Boolean setPreviousPage, VirtualPath path, VirtualPath filePath, String physPath, Exception error, String queryStringOverride)
at System.Web.HttpServerUtility.ExecuteInternal(IHttpHandler handler, TextWriter writer, Boolean preserveForm, Boolean setPreviousPage, VirtualPath path, VirtualPath filePath, String physPath, Exception error, String queryStringOverride)
at System.Web.HttpServerUtility.Execute(IHttpHandler handler, TextWriter writer, Boolean preserveForm, Boolean setPreviousPage)
at System.Web.HttpServerUtility.Execute(IHttpHandler handler, TextWriter writer, Boolean preserveForm)
at System.Web.Mvc.Html.ChildActionExtensions.ActionHelper(HtmlHelper htmlHelper, String actionName, String controllerName, RouteValueDictionary routeValues, TextWriter textWriter)
at System.Web.Mvc.Html.ChildActionExtensions.RenderAction(HtmlHelper htmlHelper, String actionName, String controllerName, Object routeValues)
at ASP._Page_Views_MacroPartials_InsertUmbracoForm_cshtml.Execute() in c:\inetpub\wwwSites\example.local\website\Views\MacroPartials\InsertUmbracoForm.cshtml:line 17
at System.Web.WebPages.WebPageBase.ExecutePageHierarchy()
at System.Web.Mvc.WebViewPage.ExecutePageHierarchy()
at System.Web.WebPages.WebPageBase.ExecutePageHierarchy(WebPageContext pageContext, TextWriter writer, WebPageRenderingBase startPage)
at Umbraco.Core.Profiling.ProfilingView.Render(ViewContext viewContext, TextWriter writer)
at Umbraco.Web.Mvc.ControllerExtensions.RenderViewResultAsString(ControllerBase controller, ViewResultBase viewResult)
at Umbraco.Web.Macros.PartialViewMacroEngine.Execute(MacroModel macro, IPublishedContent content)
at umbraco.macro.LoadPartialViewMacro(MacroModel macro)
at umbraco.macro.renderMacro(Hashtable pageElements, Int32 pageId)
2016-05-25 10:15:53,522 [P10860/D8/T45] INFO Umbraco.Core.Publishing.PublishingStrategy - Content 'Contact us' with Id '3125' has been published.
2016-05-25 10:15:57,827 [P10860/D8/T8] INFO umbraco.content - Save Xml to file...
2016-05-25 10:15:57,942 [P10860/D8/T40] INFO umbraco.content - Saved Xml to file.
2016-05-25 10:16:28,737 [P10860/D8/T28] INFO Umbraco.Web.Mvc.UmbracoPageResult - Executing Umbraco RouteDefinition controller
2016-05-25 10:16:28,813 [P10860/D8/T28] INFO Umbraco.Web.Mvc.UmbracoPageResult - Finished (took 76ms)
2016-05-25 10:18:00,395 [P10860/D8/T40] INFO Umbraco.Core.Publishing.PublishingStrategy - Content 'Contact us' with Id '3125' has been published.
2016-05-25 10:18:04,502 [P10860/D8/T37] INFO umbraco.content - Save Xml to file...
2016-05-25 10:18:04,620 [P10860/D8/T30] INFO umbraco.content - Saved Xml to file.
2016-05-25 10:18:23,362 [P10860/D8/T41] INFO Umbraco.Web.Mvc.UmbracoPageResult - Executing Umbraco RouteDefinition controller
2016-05-25 10:18:23,425 [P10860/D8/T41] INFO Umbraco.Web.Mvc.UmbracoPageResult - Finished (took 63ms)
2016-05-25 10:20:31,211 [P10860/D8/T40] INFO Umbraco.Core.Publishing.PublishingStrategy - Content 'Contact us' with Id '3125' has been published.
2016-05-25 10:20:35,319 [P10860/D8/T36] INFO umbraco.content - Save Xml to file...
2016-05-25 10:20:35,483 [P10860/D8/T46] INFO umbraco.content - Saved Xml to file.
2016-05-25 10:21:04,663 [P10860/D8/T34] ERROR Umbraco.Core.Persistence.UmbracoDatabase - Database exception occurred
System.Data.SqlClient.SqlException (0x80131904): Cannot insert the value NULL into column 'Alias', table 'example.co.uk.dbo.UFRecordFields'; column does not allow nulls. INSERT fails.
The statement has been terminated.
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
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, Int32 timeout, Task& task, Boolean asyncWrite, SqlDataReader ds, Boolean describeParameterEncryptionRequest)
at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean asyncWrite)
at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean asyncWrite)
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at Umbraco.Core.Persistence.PetaPocoCommandExtensions.<>c__DisplayClass1.<ExecuteNonQueryWithRetry>b__0()
at Umbraco.Core.Persistence.FaultHandling.RetryPolicy.ExecuteAction[TResult](Func`1 func)
at Umbraco.Core.Persistence.Database.Execute(String sql, Object[] args)
ClientConnectionId:9f2572ae-3a2f-4e96-964d-46b3e68cba9b
Error Number:515,State:2,Class:16
2016-05-25 10:21:04,672 [P10860/D8/T34] ERROR Umbraco.Core.UmbracoApplicationBase - An unhandled exception occurred
System.Data.SqlClient.SqlException (0x80131904): Cannot insert the value NULL into column 'Alias', table 'example.co.uk.dbo.UFRecordFields'; column does not allow nulls. INSERT fails.
The statement has been terminated.
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
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, Int32 timeout, Task& task, Boolean asyncWrite, SqlDataReader ds, Boolean describeParameterEncryptionRequest)
at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean asyncWrite)
at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean asyncWrite)
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at Umbraco.Core.Persistence.PetaPocoCommandExtensions.<>c__DisplayClass1.<ExecuteNonQueryWithRetry>b__0()
at Umbraco.Core.Persistence.FaultHandling.RetryPolicy.ExecuteAction[TResult](Func`1 func)
at Umbraco.Core.Persistence.Database.Execute(String sql, Object[] args)
at Umbraco.Forms.Data.Storage.RecordFieldStorage.InsertRecordField(RecordField recordfield)
at Umbraco.Forms.Data.Storage.RecordStorage.InsertRecord(Record record, Form form)
at Umbraco.Forms.Web.Services.RecordService.storeRecord(Record record, Form form)
at Umbraco.Forms.Web.Services.RecordService.Approve(Record record, Form form)
at Umbraco.Forms.Web.Services.RecordService.Submit(Record record, Form form)
at Umbraco.Forms.Web.Controllers.UmbracoFormsController.SubmitForm(Form form, FormViewModel model, Dictionary`2 state, ControllerContext context)
at Umbraco.Forms.Web.Controllers.UmbracoFormsController.GoForward(Form form, FormViewModel model, Dictionary`2 state)
at Umbraco.Forms.Web.Controllers.UmbracoFormsController.HandleForm(FormViewModel model, Boolean captchaIsValid)
at lambda_method(Closure , ControllerBase , Object[] )
at System.Web.Mvc.ReflectedActionDescriptor.Execute(ControllerContext controllerContext, IDictionary`2 parameters)
at System.Web.Mvc.ControllerActionInvoker.InvokeActionMethod(ControllerContext controllerContext, ActionDescriptor actionDescriptor, IDictionary`2 parameters)
at System.Web.Mvc.Async.AsyncControllerActionInvoker.<BeginInvokeSynchronousActionMethod>b__39(IAsyncResult asyncResult, ActionInvocation innerInvokeState)
at System.Web.Mvc.Async.AsyncResultWrapper.WrappedAsyncResult`2.CallEndDelegate(IAsyncResult asyncResult)
at System.Web.Mvc.Async.AsyncControllerActionInvoker.EndInvokeActionMethod(IAsyncResult asyncResult)
at System.Web.Mvc.Async.AsyncControllerActionInvoker.AsyncInvocationWithFilters.<InvokeActionMethodFilterAsynchronouslyRecursive>b__3d()
at System.Web.Mvc.Async.AsyncControllerActionInvoker.AsyncInvocationWithFilters.<>c__DisplayClass46.<InvokeActionMethodFilterAsynchronouslyRecursive>b__3f()
at System.Web.Mvc.Async.AsyncControllerActionInvoker.AsyncInvocationWithFilters.<>c__DisplayClass46.<InvokeActionMethodFilterAsynchronouslyRecursive>b__3f()
at System.Web.Mvc.Async.AsyncControllerActionInvoker.AsyncInvocationWithFilters.<>c__DisplayClass46.<InvokeActionMethodFilterAsynchronouslyRecursive>b__3f()
at System.Web.Mvc.Async.AsyncControllerActionInvoker.AsyncInvocationWithFilters.<>c__DisplayClass46.<InvokeActionMethodFilterAsynchronouslyRecursive>b__3f()
at System.Web.Mvc.Async.AsyncControllerActionInvoker.AsyncInvocationWithFilters.<>c__DisplayClass46.<InvokeActionMethodFilterAsynchronouslyRecursive>b__3f()
at System.Web.Mvc.Async.AsyncControllerActionInvoker.EndInvokeActionMethodWithFilters(IAsyncResult asyncResult)
at System.Web.Mvc.Async.AsyncControllerActionInvoker.<>c__DisplayClass21.<>c__DisplayClass2b.<BeginInvokeAction>b__1c()
at System.Web.Mvc.Async.AsyncControllerActionInvoker.<>c__DisplayClass21.<BeginInvokeAction>b__1e(IAsyncResult asyncResult)
at System.Web.Mvc.Async.AsyncControllerActionInvoker.EndInvokeAction(IAsyncResult asyncResult)
at System.Web.Mvc.Controller.<BeginExecuteCore>b__1d(IAsyncResult asyncResult, ExecuteCoreState innerState)
at System.Web.Mvc.Async.AsyncResultWrapper.WrappedAsyncVoid`1.CallEndDelegate(IAsyncResult asyncResult)
at System.Web.Mvc.Controller.EndExecuteCore(IAsyncResult asyncResult)
at System.Web.Mvc.Async.AsyncResultWrapper.WrappedAsyncVoid`1.CallEndDelegate(IAsyncResult asyncResult)
at System.Web.Mvc.Controller.EndExecute(IAsyncResult asyncResult)
at System.Web.Mvc.MvcHandler.<BeginProcessRequest>b__5(IAsyncResult asyncResult, ProcessRequestState innerState)
at System.Web.Mvc.Async.AsyncResultWrapper.WrappedAsyncVoid`1.CallEndDelegate(IAsyncResult asyncResult)
at System.Web.Mvc.MvcHandler.EndProcessRequest(IAsyncResult asyncResult)
at System.Web.HttpApplication.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute()
at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously)
ClientConnectionId:9f2572ae-3a2f-4e96-964d-46b3e68cba9b
Error Number:515,State:2,Class:16
2016-05-25 10:38:10,159 [P10860/D8/T27] INFO Umbraco.Core.Security.BackOfficeSignInManager - Event Id: 0, state: Login attempt succeeded for username chrisashton from IP address 10.211.55.2
2016-05-25 10:38:10,159 [P10860/D8/T27] INFO Umbraco.Core.Security.BackOfficeSignInManager - Event Id: 0, state: User: chrisashton logged in from IP address 10.211.55.2
Hi Chris,
In this UmbracoTraceLog.txt file I see the following:
2016-05-25 10:15:33,374 [P10860/D8/T14] WARN umbraco.macro - Error loading Partial View (file: ~/Views/MacroPartials/InsertUmbracoForm.cshtml). Exception: System.Web.HttpException (0x80004005): Error executing child request for handler 'System.Web.Mvc.HttpHandlerUtil+ServerExecuteHttpHandlerAsyncWrapper'. ---> System.NullReferenceException: Unable to get Form with ID: 'a6c1726f-c43f-472e-a9cf-980fe7e3d1f5' off disk or from the cache. Check the file exists on disk
Note the end part of that line:
Unable to get Form with ID: 'a6c1726f-c43f-472e-a9cf-980fe7e3d1f5' off
disk or from the cache. Check the file exists on disk
This maybe unrelated or just you testing out things.
Hi Chris,
After being able to replicate this issue. I would like to verify if this resolved or the problem goes away if you do the following please.
Reopen your form in the form designer and simply re-save it for me please. Then can you go back to the front end of the site where the form is used to see if this has fixed the problem.
From my investigation the field alias is not set on the initial create/save of a form. I am surprised this has not come up before, but perhaps people make a few saves before.
YSOD on form submission page
Hi all,
I've just uninstalled Contour and have replaced it with Forms using the back-office installation button, and I checked all the old Contour database tables were deleted.
I've been able to create a new form based on the the built in 'Contact form', but when I submit the form I receive a YSOD stating
Entries are recorded correctly in the back-office and may be reviewed. Stack trace and screenshots follow...
Any pointers would be greatly appreciated.
Cheers, Chris
Hi Chris,
Perhaps something went wrong in the installation so the database tables not was created correctly.
Try to see Tim's comment in this thread https://our.umbraco.org/forum/umbraco-pro/contour/63644-Umbraco-forms-database-table?p=0
Hope this can help you a step further.
/Dennis
Hi Dennis,
Thanks for the reply. I deleted all the Contour tables using:
and ran Tim's create script as he posted in your link, but I still get the same error.
Anything else spring to mind?
Cheers, Chris
Hi Chris,
Okay, could you try to uninstall the Umbraco Forms package, and the install it as a local package, to see if this solve the issue that you have.
So first uninstall the current Umbraco Forms package. and then
Hope this helps,
/Dennis
Thanks for the reply Dennis.
I tried doing what you suggested with the 4.3.0beta version, but ran into the same issue. I also retried with the NuGet version of 4.3.0beta, and again no success. However, NuGeting the 4.2.1 version install fine, so maybe there is a bug in 4.3.0beta?
Thanks for your help Dennis.
Hello Chris,
Sorry to hear you are having problems installing Umbraco Forms 4.3.0 beta.
Is there anything in the UmbracoTraceLog that we can take a look at to see if there is anything that may be causing the DB tables not to be created correctly.
However the YSOD you are showing is that the field/db column 'Alias' has been submitted with a null & that DB table does not allow nulls.
So can you tell me what steps you did please to recreate this?
Have you tried creating a form without using the template, just so I can see if the problem lies with the template itself.
Thanks,
Warren
Hi Warren,
Thanks for taking an interest.
Initially I uninstalled Contour using Umbraco’s package manager, checked all Contour related database tables were removed, and installed Forms 4.3.0beta using the install button in the back-office. I then used the Contact template and updated a few fields (see screenshot later). This resulted in the error
Cannot insert the value NULL into column 'Alias', table ‘domain.co.uk.dbo.UFRecordFields'; column does not allow nulls. INSERT fails.
Subsequently I’ve tried (see test of success):
Following your post, I reinstalled Forms 4.3.0beta via the back-office, and tried (trace log for this this and the following actions attached):
Therefore I suspect there is either an issue in some of the amends I’m doing, or built-in form fields don’t like being renamed.
I’ll carry out a little more experimentation, but let me know if there is anything you’d like me to try.
Cheers, Chris
Notes:
SQL I used to ensure all Contour/Forms database table removed:
I’m pretty sure when I uninstall all Forms all related files are removed as the solution is in source control.
Umbraco: 7.4.3
My test of success has been to create a form based on the built in ‘Contact us’ one, amend some fields:
Finally I add the form to an RTE using the macro picker and submit a form.
Trace log for reinstalling Forms 4.3.0beta via the back-office and creating 3 forms in above post (last form is the one that fails) (I can't seem to attach .zip files, but I can send one over if that is any easier):
Hi Chris,
In this UmbracoTraceLog.txt file I see the following:
Note the end part of that line:
This maybe unrelated or just you testing out things.
Cheers,
Warren
Hello Chris,
I am able to replicate this so I will investigate what is going wrong.
Thanks for bringing this to my attention.
Cheers,
Warren :)
Nice one Warren, if you you want me to do any testing I'm happy to help.
Cheers,
Chris
Hi Chris,
After being able to replicate this issue. I would like to verify if this resolved or the problem goes away if you do the following please.
Reopen your form in the form designer and simply re-save it for me please. Then can you go back to the front end of the site where the form is used to see if this has fixed the problem.
From my investigation the field alias is not set on the initial create/save of a form. I am surprised this has not come up before, but perhaps people make a few saves before.
I have created an issue here which you can follow along: http://issues.umbraco.org/issue/CON-1051
Thanks,
Warren
Hi Warren – bang on, saving the form in the form designer a second time resolves this issue.
I'll follow the issue, and thanks for investigating.
Cheers, Chris
is working on a reply...