Old Forums
Search:
Installation and deployment Questions on installation, system configuration and deployment to the live server.
Version 5.x > Installation and deployment > Error to create web site View modes: 
User avatar
Member
Member
marcelogabrielarias-gmail - 3/3/2010 6:38:38 AM
   
Error to create web site
Hi, I don´t speak english, sorry.

I run Kentico succefully in localhost, and I create web site ok.
I install Kentico succefully in my server. The database was created succefully too, but I can't create new site.
ALways (Create site with wizard or create site with template) the import process abort in "importing 'System tables' objects ":

Step 4
Import progress
Objects are being imported.
Error during import process
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
ERROR: Error importing 'System tables' objects (User)
Message: [DataConnection.ExecuteQuery]: Query: DROP VIEW 488_saasforeachtestuser.View_CMS_User: caused exception: Incorrect CMS.DataProviderSQL.DataConnection.ExecuteQuery(String queryText, Object[,] queryParams, QueryTypeEnum queryType)
at CMS.DataProviderSQL.DataConnection.CMS.IDataConnectionLibrary.IDataConnection.ExecuteQuery(String queryText, Object[,] queryParams, queryType)
at CMS.SettingsProvider.SqlHelperClass.ExecuteQuery(QueryParameters query, IDataConnection conn)
at CMS.SettingsProvider.SqlHelperClass.ExecuteQuery(String queryText, Object[,] queryParams, QueryTypeEnum queryType, IDataConnection at CMS.SettingsProvider.SqlHelperClass.ExecuteQuery(String queryText, Object[,] queryParams, QueryTypeEnum queryType)
at CMS.DataProviderSQL.TableManager.DropView(String viewName)
at CMS.DataEngine.TableManager.RefreshView(String viewName)
at CMS.DataEngine.TableManager.RefreshCustomViews(String tableName)
at CMS.CMSImportExport.ImportProvider.UpdateObject(SiteImportSettings settings, IInfoObject infoObj, Boolean siteObject, DataSet updateChild, Int32 targetSiteId, ProcessObjectEnum process, Hashtable importedParentIDs, ArrayList postProcessList)
at CMS.CMSImportExport.ImportProvider.ImportObjects(SiteImportSettings settings, DataSet ds, String objectType, Boolean siteObjects, importChild, ProcessObjectEnum processType, Hashtable importedParentIDs)

User avatar
Kentico Developer
Kentico Developer
kentico_helenag - 3/5/2010 6:49:09 AM
   
RE:Error to create web site
Hello,

Regrettably, it was a bug in the 5.0.0 version which was fixed by 5.0.1 hotfix. Could you please apply the latest hotfix on your server? You may download the hotfix here: http://devnet.kentico.com/Bugtracker/Hotfixes.aspx I am sorry for your inconveniences.


Best regards,
Helena Grulichova

User avatar
Member
Member
marcelogabrielarias-gmail - 3/5/2010 10:31:51 AM
   
RE:Error to create web site
Thank you Helena, but my version is 5.0.3670 and I install kentico in the server from link in www.seekdotnet.com.

The incomplete site is in www.mundobasquetweb.com.ar/kentico10

Best regards, Marcelo Arias

User avatar
Kentico Developer
Kentico Developer
kentico_helenag - 3/9/2010 5:25:06 AM
   
RE:Error to create web site
Hello,

your number is the build number, the number which I used relates to hotfix number. Please apply the latest hotfix from the mentioned location it should help you.

Best regards,
Helena Grulichova

User avatar
Member
Member
marcelogabrielarias-gmail - 3/9/2010 1:16:39 PM
   
RE:Error to create web site
Ok, I understand now.

I installed the hotfix 5.0.10 but hhe problem is still appearing.

- run sql scrits, ok
- copy files, ok
- update web.config, ok

The error is the same before hotfix's installation

The installation is in www.mundobasquetweb.com.ar/kentico12/cmsinstall/install.aspx

(the database name is 488_saasforeachtest and the user is 488_saasforeachtestuser) the problem is prefix 488_ ???

...

Error during import process
Importing 'System tables' objects
Importing 'Modules' objects
Importing 'Form controls' objects
Importing 'Web part containers' 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

Objects are being imported





ERROR: Error importing 'System tables' objects (User)
Message: [DataConnection.ExecuteQuery]: Query: DROP VIEW 488_saasforeachtestuser.View_CMS_User: caused exception: Incorrect syntax near '488'. Stack Trace: at CMS.DataProviderSQL.DataConnection.ExecuteQuery(String queryText, Object[,] queryParams, QueryTypeEnum queryType)
at CMS.DataProviderSQL.DataConnection.CMS.IDataConnectionLibrary.IDataConnection.ExecuteQuery(String queryText, Object[,] queryParams, QueryTypeEnum queryType)
at CMS.SettingsProvider.SqlHelperClass.ExecuteQuery(QueryParameters query, IDataConnection conn)
at CMS.SettingsProvider.SqlHelperClass.ExecuteQuery(String queryText, Object[,] queryParams, QueryTypeEnum queryType, IDataConnection conn)
at CMS.SettingsProvider.SqlHelperClass.ExecuteQuery(String queryText, Object[,] queryParams, QueryTypeEnum queryType)
at CMS.DataProviderSQL.TableManager.DropView(String viewName)
at CMS.DataEngine.TableManager.RefreshView(String viewName)
at CMS.DataEngine.TableManager.RefreshCustomViews(String tableName)
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)


Thank you, Helena.
Best regards.
Marcelo
User avatar
Kentico Developer
Kentico Developer
kentico_helenag - 3/11/2010 5:38:21 AM
   
RE:Error to create web site
Hello,


could you please change the database schema to dbo or any other which do not start with number? Yes, the numeric prefix could be the problem.

Please let me know if it helps.


Best regards,
Helena Grulichova

Top