Installation and deployment
Version 3.x > Installation and deployment > DataConnection.ExecuteQuery View modes: 
User avatar
Member
Member
chebs22-gmail - 2/26/2009 4:41:48 AM
   
DataConnection.ExecuteQuery
i get the following error after i have uploaded the solution via ftp -

[DataConnection.ExecuteQuery]: Query: Proc_CMS_SqlResourceManager_SelectResourceTranslations: caused exception: Could not find stored procedure 'Proc_CMS_SqlResourceManager_SelectResourceTranslations'.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Exception: [DataConnection.ExecuteQuery]: Query: Proc_CMS_SqlResourceManager_SelectResourceTranslations: caused exception: Could not find stored procedure 'Proc_CMS_SqlResourceManager_SelectResourceTranslations'.

Source Error:

Line 27:
Line 28: // Init CMS environment
Line 29: CMSContext.Init();
Line 30: }
Line 31: }


Source File: c:\inetpub\vhosts\coachmatching.com\httpdocs\App_Code\CMS\CMSFunctions.cs Line: 29

Stack Trace:

[Exception: [DataConnection.ExecuteQuery]: Query: Proc_CMS_SqlResourceManager_SelectResourceTranslations: caused exception: Could not find stored procedure 'Proc_CMS_SqlResourceManager_SelectResourceTranslations'.]
CMS.DataProviderSQL.DataConnection.ExecuteQuery(String queryText, Object[,] queryParams, QueryTypeEnum queryType) +797
CMS.DataProviderSQL.DataConnection.CMS.IDataConnectionLibrary.IDataConnection.ExecuteQuery(String queryText, Object[,] queryParams, QueryTypeEnum queryType) +13
CMS.SettingsProvider.SqlHelperClass.ExecuteQuery(String queryText, Object[,] queryParams, QueryTypeEnum queryType, IDataConnection conn) +69
CMS.SettingsProvider.SqlHelperClass.ExecuteQuery(String queryText, Object[,] queryParams, QueryTypeEnum queryType) +11
CMS.ResourceManager.SqlResourceManager.LoadStrings() +122
CMS.ResourceManager.SqlResourceManager.ExistTranslation(String stringKey, String cultureCode) +37
CMS.GlobalHelper.ResHelper.GetFileString(String stringName, String culture, String defaultValue) +78
CMS.GlobalHelper.ResHelper.GetString(String stringName, String culture, String defaultValue) +64
CMS.GlobalHelper.ResHelper.GetString(String stringName) +37
CMS.GlobalHelper.ResHelper.Init() +11
CMS.CMSHelper.CMSContext.Init() +9
CMSFunctions.Init() in c:\inetpub\vhosts\coachmatching.com\httpdocs\App_Code\CMS\CMSFunctions.cs:29
Global.FirstRequestInitialization(Object sender, EventArgs e) in c:\inetpub\vhosts\coachmatching.com\httpdocs\App_Code\Global.asax.cs:125
Global.Application_BeginRequest(Object sender, EventArgs e) in c:\inetpub\vhosts\coachmatching.com\httpdocs\App_Code\Global.asax.cs:348
System.Web.SyncEventExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute() +68
System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously) +75


My hosting company does not know what to do to fix it and i am seeing the client tomorrow! please help me fix this

ny hosting company has said that they have configured the web.config file and the database and were also asking what script it uses!!! please help

User avatar
Kentico Support
Kentico Support
kentico_jurajo - 2/26/2009 6:21:39 AM
   
RE:DataConnection.ExecuteQuery
Hi,

Could you please follow these descriptions:
http://www.kentico.com/docs/devguide/deployment_to_the_live_server.htm
http://www.kentico.com/docs/devguide/installation_on_shared_hosting.htm

Best Regards,
Juraj Ondrus