Search Forum Home   Universal List  Universal List Version 4.x  Null Error on D...  Null Error on DNN 5 can't edit or add any new records    1/27/2011 11:09:48 AM DaveElliott 3 posts Null Error on DNN 5 can't edit or add any new records Hi, We are getting the following error when trying to add a new record with your module. Save Error!Cannot insert the value NULL into column 'ID', table '.dbo.Properties'; column does not allow nulls. INSERT fails. Cannot insert the value NULL into column 'RecordID', table '_2010.dbo.cDNN_UniversalList_RecordOwner'; column does not allow nulls. INSERT fails. The statement has been terminated. The statement has been terminated. We also cannot edit any of the records that we imported into the site. Any ideas what could be wrong? Have checked the primary key for the relevant table and it is set to an integer(as this was a question asked in a different thread) The sites uses DNN5 Dave  1/27/2011 11:11:26 AM DaveElliott 3 posts Re: Null Error on DNN 5 can't edit or add any new records sorry just to id. The id field has the following settings. Field Name: ID Field Required: View Type: NumericReference Length: 0=unlimited Precision: Scale: Reference Table: AffiliatesAnnouncementsAnonymousUsersaspnet_Applicationsaspnet_Membershipaspnet_Profileaspnet_Rolesaspnet_SchemaVersionsaspnet_Usersaspnet_UsersInRolesAssembliesAuthenticationBannersBlog_BlogsBlog_CategoriesBlog_CommentsBlog_EntriesBlog_Entry_CategoriesBlog_Entry_TagsBlog_SettingsBlog_TagscDNN_UniversalList_RecordOwnercDNN_UniversalList_ULFieldcDNN_UniversalList_ULTableClassificationContentItemsContentItems_MetaDataContentItems_TagsContentTypesDashboard_ControlsDesktopModulePermissionDesktopModulesDnnForge_NewsArticles_ArticleDnnForge_NewsArticles_ArticleCategoriesDnnForge_NewsArticles_CategoryDnnForge_NewsArticles_CommentDnnForge_NewsArticles_EmailTemplateDnnForge_NewsArticles_PageDnnForge_NewsArticles_RatingEFAccessLogEFConnectionEFFeatureEFFormEFFormConditionEFFormFileTempEFFormFlowAccessEFFormHistEFFormInstEFFormInstDataEFFormInstHistEFFormResourceEFFormRoleEFFormSettingEFFormStateAccessEFFormStateFlowEFFormStateFlowCondEFFormStateTypeEFFormTemplateEFFormUserRoleEFFormWOEFQueryEFReportEFReportFieldEFReportInstEFTable_2EFTable_2_v10EFTable_2_v11EFTable_2_v12EFTable_2_v13EFTable_2_v14EFTable_2_v15EFTable_2_v16EFTable_2_v17EFTable_2_v18EFTable_2_v19EFTable_2_v2EFTable_2_v20EFTable_2_v21EFTable_2_v22EFTable_2_v23EFTable_2_v24EFTable_2_v25EFTable_2_v26EFTable_2_v27EFTable_2_v28EFTable_2_v29EFTable_2_v3EFTable_2_v30EFTable_2_v31EFTable_2_v32EFTable_2_v33EFTable_2_v4EFTable_2_v5EFTable_2_v6EFTable_2_v7EFTable_2_v8EFTable_2_v9EFTable_4EFTable_4_v2EventLogEventLogConfigEventLogTypesEventQueueFilesFolderPermissionFoldersGeoLookupgoogle_mapGumbosoft_Tabs_AjaxTabsHostSettingsHtmlTextHtmlTextLogHtmlTextUsersIFrame_ParametersLanguagePacksLanguagesLinksListsMap_MapsMap_PointsMap_ProvidersMap_SourcesMessaging_MessagesMetaDataModuleControlsModuleDefinitionsModulePermissionModulesModuleSettingsPackagesPackageTypesPermissionPortalAliasPortalDesktopModulesPortalLanguagesPortalsPortalSettingsProfileProfilePropertyDefinitionPropertiesRoleGroupsRolesScheduleScheduleHistoryScheduleItemSettingsSearchCommonWordsSearchIndexerSearchItemSearchItemWordSearchItemWordPositionSearchWordSiteLogSkinControlsSkinPackagesSkinsSurveyOptionsSurveyResultsSurveysSystemMessagesTabModulesTabModuleSettingsTabPermissionTabsTaxonomy_ScopeTypesTaxonomy_TermsTaxonomy_VocabulariesTaxonomy_VocabularyTypesUrlLogUrlsUrlTrackingUserAuthenticationUserDefinedDataUserDefinedFieldsUserDefinedRowsUserGeoLookupUserPortalsUserProfileUserRolesUsersUsersOnlineVendorClassificationVendorsVersionWebServersWorkflowWorkflowStatesXml_Parameter Reference Field: Sort Enabled: Filter Enabled: Use Default Value: (when field is hidden)  1/31/2011 3:17:57 AM DaveElliott 3 posts Re: Null Error on DNN 5 can't edit or add any new records we really still can't work out the problem any ideas? Any help great fully appreciated.  Page 1 of 1   Universal List  Universal List Version 4.x  Null Error on D... Flat View Tree View Oldest To Newest Newest To Oldest