Register
|
Login
Home
Universal List
Support Forums
Portfolio
Contact Us
Privacy Policy
Refund Policy
Forum
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:
Numeric
Reference
Length:
0=unlimited
Precision:
Scale:
Reference Table:
Affiliates
Announcements
AnonymousUsers
aspnet_Applications
aspnet_Membership
aspnet_Profile
aspnet_Roles
aspnet_SchemaVersions
aspnet_Users
aspnet_UsersInRoles
Assemblies
Authentication
Banners
Blog_Blogs
Blog_Categories
Blog_Comments
Blog_Entries
Blog_Entry_Categories
Blog_Entry_Tags
Blog_Settings
Blog_Tags
cDNN_UniversalList_RecordOwner
cDNN_UniversalList_ULField
cDNN_UniversalList_ULTable
Classification
ContentItems
ContentItems_MetaData
ContentItems_Tags
ContentTypes
Dashboard_Controls
DesktopModulePermission
DesktopModules
DnnForge_NewsArticles_Article
DnnForge_NewsArticles_ArticleCategories
DnnForge_NewsArticles_Category
DnnForge_NewsArticles_Comment
DnnForge_NewsArticles_EmailTemplate
DnnForge_NewsArticles_Page
DnnForge_NewsArticles_Rating
EFAccessLog
EFConnection
EFFeature
EFForm
EFFormCondition
EFFormFileTemp
EFFormFlowAccess
EFFormHist
EFFormInst
EFFormInstData
EFFormInstHist
EFFormResource
EFFormRole
EFFormSetting
EFFormStateAccess
EFFormStateFlow
EFFormStateFlowCond
EFFormStateType
EFFormTemplate
EFFormUserRole
EFFormWO
EFQuery
EFReport
EFReportField
EFReportInst
EFTable_2
EFTable_2_v10
EFTable_2_v11
EFTable_2_v12
EFTable_2_v13
EFTable_2_v14
EFTable_2_v15
EFTable_2_v16
EFTable_2_v17
EFTable_2_v18
EFTable_2_v19
EFTable_2_v2
EFTable_2_v20
EFTable_2_v21
EFTable_2_v22
EFTable_2_v23
EFTable_2_v24
EFTable_2_v25
EFTable_2_v26
EFTable_2_v27
EFTable_2_v28
EFTable_2_v29
EFTable_2_v3
EFTable_2_v30
EFTable_2_v31
EFTable_2_v32
EFTable_2_v33
EFTable_2_v4
EFTable_2_v5
EFTable_2_v6
EFTable_2_v7
EFTable_2_v8
EFTable_2_v9
EFTable_4
EFTable_4_v2
EventLog
EventLogConfig
EventLogTypes
EventQueue
Files
FolderPermission
Folders
GeoLookup
google_map
Gumbosoft_Tabs_AjaxTabs
HostSettings
HtmlText
HtmlTextLog
HtmlTextUsers
IFrame_Parameters
LanguagePacks
Languages
Links
Lists
Map_Maps
Map_Points
Map_Providers
Map_Sources
Messaging_Messages
MetaData
ModuleControls
ModuleDefinitions
ModulePermission
Modules
ModuleSettings
Packages
PackageTypes
Permission
PortalAlias
PortalDesktopModules
PortalLanguages
Portals
PortalSettings
Profile
ProfilePropertyDefinition
Properties
RoleGroups
Roles
Schedule
ScheduleHistory
ScheduleItemSettings
SearchCommonWords
SearchIndexer
SearchItem
SearchItemWord
SearchItemWordPosition
SearchWord
SiteLog
SkinControls
SkinPackages
Skins
SurveyOptions
SurveyResults
Surveys
SystemMessages
TabModules
TabModuleSettings
TabPermission
Tabs
Taxonomy_ScopeTypes
Taxonomy_Terms
Taxonomy_Vocabularies
Taxonomy_VocabularyTypes
UrlLog
Urls
UrlTracking
UserAuthentication
UserDefinedData
UserDefinedFields
UserDefinedRows
UserGeoLookup
UserPortals
UserProfile
UserRoles
Users
UsersOnline
VendorClassification
Vendors
Version
WebServers
Workflow
WorkflowStates
Xml_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
CookDNN