Smartsite Documentatie
>
Install & Config
>
Error Reference
>
Smartsite core functionality
>
007000-007999 Meta
> SCMS007016 Table reference type mismatch
|
SCMS007016 Table reference type mismatch
Problem
This error occurs if a Content Type field has a 'ForeignKey' CTFP referencing a column in the database whose type does not match with the type of the Content Type field. A common example is the Author field of a Content Type whose type is a varchar (or String in .Net) referencing the Nr field in vwUsers whose type is an integer (or Int32 in .Net).
Resolution
Remove the CTFP "ForeignKey" from the Content Type field or correct it to make sure it points to the correct column.
Install & Config
- Getting Started
- Hardware and software requirements for Smartsite iXperion
- Platform support
- Site Installation
- Smartsite 7 Manager
- iXperion Publication Server
- iXperion tools
- Database Server
- Security
- IIS Configuration
- Asp.Net Configuration
- Outscaling
- WCF
- Smartsite Configuration files
- Knowledge Base | Installation and Configuration
-
Error Reference
-
Smartsite core functionality
- 001000-001999 Core
- 002000-002999 SXML
- 003000-003999 Viper
- 004000-004999 Expression parser
- 005000-005999 CMS
- 006000-006999 Security
-
007000-007999 Meta
- SCMS007001 No provider found.
- SCMS007002 UnknownProviderFound
- SCMS007003 Number of parameters does not match sql query.
- SCMS007004 Invalid named parameter in sql query
- SCMS007005 Can't convert CLR type to database type.
- SCMS007006 Can't convert database type to CLR type.
- SCMS007007 Stored Procedure schema contains invalid table
- SCMS007008 Stored Procedure schema contains a view
- SCMS007009 View schema contains invalid table.
- SCMS007010 View schema contains view
- SCMS007011 View schema contains table twice
- SCMS007012 DatabaseSchemaContainsDuplicateObjects
- SCMS007013 Invalid foreign key schema
- SCMS007014 Unsupported MySql DataType
- SCMS007015 DataNavigator syntax error
- SCMS007017 Field has invalid default.
- SCMS007018 Invalid relation type found
- SCMS007019 Content Relation not found
- SCMS007020 CTFP ContentRelation is missing
- SCMS007021 Invalid table or view for Content Relation
- SCMS007023 Unable to open database
- SCMS007024 Database provider not installed
- 008000-008999 Storage handlers
- 009000-009999 Tools
- 010000-010999 Publication
- 011000-011999 Webservices
- 012000-012999 ASP.Net / IIS
- 013000-013999 Formatting
- 014000-014999 Licensing
- Smartsite modules and components
- Smartsite external applications
-
Smartsite core functionality
- EmptySix site
- Smartsite iXperion Release 1.3 Installation manual
- Smartsite iXperion Requirements - v3.6
- Implementatiehandleiding Active Directory Koppeling of LDAP Smartsite iXperion v1.1.3
- Installatiehandleiding iXperion 1.3 en hoger Win 2008 32bit-v1.4
- Installatiehandleiding iXperion 1.3 en hoger Win 2008 64bit-v1.4
- Installatiehandleiding iXperion Word Import - Word 2010 setup voor x64- v1.0
- Installatiehandleiding Oracle client iXperion 1.3 Windows 2008 R2 64bit- v1.0.1
- Installatiehandleiding Smartsite iXperion SMI 2.0 - v1.0.3