| 
                                                        
                                                            
                                                                
                                                                    |  |  
                                                                    |   Member | 
                                                                            
                                                                                sophiepvm
                                                                            - 
                                                                                7/13/2010 10:47:34 AM
                                                                            
                                                                         
                                                                        Error during import process 
                                                                            Hello,  I am using the trial version of Kentico v5.5.3789. I am trying to export/import a site.  When I import I get this error. Error during import processImporting 'Document types' objects
 Importing 'Users' objects
 Importing 'Time zones' objects
 Importing 'Badges' objects
 Importing 'Avatars' objects
 Importing 'System tables' objects
 Importing 'Modules' objects
 Importing 'Form controls' objects
 Importing 'Web part containers' objects
 Importing 'Widgets' objects
 Importing 'Widget categories' objects
 Importing 'Web parts' objects
 Importing 'Web part categories' objects
 Importing 'Inline controls' objects
 Importing 'Scheduled tasks' objects
 Importing 'Relationship names' objects
 Importing 'E-mail templates' objects
 Importing 'Cultures' objects
 Importing 'Page templates' objects
 Importing 'Page template categories' objects
 Importing 'Page layouts' objects
 Importing 'Countries' objects
 Importing 'UI cultures' objects
 Importing 'CSS stylesheets' objects
 Importing 'Settings' objects
 Importing 'Settings categories' objects
 Importing 'Settings' objects
 Importing 'Settings categories' objects
 Importing 'License keys' objects
 
 Objects are being imported
 
 
 
 
 
 
 ERROR: Error importing 'Document types' objects (Simple article)
 Message: [DataConnection.ExecuteQuery]: Query: ALTER TABLE CONTENT_SimpleArticle ALTER COLUMN [ArticleText] nvarchar(max) NOT NULL: caused exception: Cannot create a row of size 8082 which is greater than the allowable maximum row size of 8060.
 The statement has been terminated. Stack Trace: at CMS.DataProviderSQL.DataConnection.ExecuteQuery(String queryText, Object[,] queryParams, QueryTypeEnum queryType)
 at CMS.DataEngine.AbstractDataConnection.CMS.IDataConnectionLibrary.IDataConnection.ExecuteQuery(String queryText, Object[,] queryParams, QueryTypeEnum queryType)
 at CMS.DataEngine.AbstractTableManager.AlterTableColumnWithDefaultValue(String tableName, String columnName, String newColumnName, String newColumnType, Boolean newColumnAllowNull, String newColumnDefaultValue, IDataConnection conn)
 at CMS.DataEngine.AbstractTableManager.AlterTableColumn(String tableName, String columnName, String newColumnName, String newColumnType, Boolean newColumnAllowNull, String newColumnDefaultValue)
 at CMS.DataEngine.TableManager.AlterTableColumn(String tableName, String columnName, String newColumnName, String newColumnType, Boolean newColumnAllowNull, String newColumnDefaultValue)
 at CMS.DataEngine.TableManager.UpdateTableBySchema(String tableName, String schema, String excludeColumns)
 at CMS.DataEngine.TableManager.UpdateTableBySchema(String tableName, String schema)
 at CMS.CMSImportExport.ImportProvider.UpdateObject(SiteImportSettings settings, IInfoObject infoObj, Boolean siteObject, DataSet ds, TranslationHelper th, Boolean updateChild, Int32 targetSiteId, ProcessObjectEnum process, Hashtable importedParentIDs, ArrayList postProcessList)
 at CMS.CMSImportExport.ImportProvider.ImportObjects(SiteImportSettings settings, DataSet ds, String objectType, Boolean siteObjects, TranslationHelper th, Boolean importChild, ProcessObjectEnum processType, Hashtable importedParentIDs)
                                                                            
                                                                         
 
                                                                            
                                                                            
                                                                            
                                                                            
                                                                            
                                                                         
                                                                            
                                                                            
                                                                            
                                                                            
                                                                         
                                                                         |  | 
                                        
                                            
                                                | 
                                                    
                                                        
                                                            
                                                                
                                                                    |  |  
                                                                    |   Kentico Support | 
                                                                            
                                                                                kentico_radekm
                                                                            - 
                                                                                7/19/2010 6:35:58 AM
                                                                            
                                                                         
                                                                        RE:Error during import process 
                                                                            Hello.
 What is your SQL Server´s version, please? For version 5.5, you need to have SQL Server 2005 at least. SQL 2000 is not supported. Could you please check it? Thank you.
 
 Best Regards,
 Radek Macalik
 
                                                                            
                                                                         
 
                                                                            
                                                                            
                                                                            
                                                                            
                                                                            
                                                                         
                                                                            
                                                                            
                                                                            
                                                                            
                                                                         
                                                                         |  | 
                                        
                                            
                                                | 
                                                    
                                                        
                                                            
                                                                
                                                                    |  |  
                                                                    |   Member | 
                                                                            
                                                                                sophiepvm
                                                                            - 
                                                                                7/19/2010 11:11:32 AM
                                                                            
                                                                         
                                                                        RE:Error during import process 
                                                                            SqlServer 2008
                                                                         
                                                                            
                                                                         
 
                                                                            
                                                                            
                                                                            
                                                                            
                                                                            
                                                                         
                                                                            
                                                                            
                                                                            
                                                                            
                                                                         
                                                                         |  |