Server Error in '/' Application.

Procedure or function 'Artist_SelectActressList' cannot be found in database 'musicworld'.

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: MySql.Data.MySqlClient.MySqlException: Procedure or function 'Artist_SelectActressList' cannot be found in database 'musicworld'.

Source Error:


Line 269:                    break;
Line 270:                case "GF":
Line 271:                    artistList = ArtistBLL.SelectActressList(Origin, pageNo, rowsPerPage, ref totalRows);
Line 272:                    prefix += "Actresses-Gallery";
Line 273:                    metaDescription = "Photo Gallery Of " + origin + " Actresses: ";

Source File: g:\pleskvhosts\sangeetmehfil.com\httpdocs\Controls\Common\ArtistList.ascx.cs    Line: 271

Stack Trace:


[MySqlException (0x80004005): Procedure or function 'Artist_SelectActressList' cannot be found in database 'musicworld'.]
   MySql.Data.MySqlClient.ProcedureCache.GetProcData(MySqlConnection connection, String spName) +428
   MySql.Data.MySqlClient.ProcedureCache.AddNew(MySqlConnection connection, String spName) +39
   MySql.Data.MySqlClient.ProcedureCache.GetProcedure(MySqlConnection conn, String spName, String cacheKey) +172
   MySql.Data.MySqlClient.MySqlCommandBuilder.DeriveParameters(MySqlCommand command) +171

[TargetInvocationException: Exception has been thrown by the target of an invocation.]
   System.RuntimeMethodHandle.InvokeMethod(Object target, Object[] arguments, Signature sig, Boolean constructor) +0
   System.Reflection.RuntimeMethodInfo.UnsafeInvokeInternal(Object obj, Object[] parameters, Object[] arguments) +168
   System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture) +105
   System.RuntimeType.InvokeMember(String name, BindingFlags bindingFlags, Binder binder, Object target, Object[] providedArgs, ParameterModifier[] modifiers, CultureInfo culture, String[] namedParams) +2077
   IBatisNet.Common.Utilities.DBHelperParameterCache.DeriveParameters(IDbProvider provider, IDbCommand command) +141

[IBatisNetException: Could not retrieve parameters for the store procedure named Artist_SelectActressList]
   IBatisNet.Common.Utilities.DBHelperParameterCache.DeriveParameters(IDbProvider provider, IDbCommand command) +212
   IBatisNet.Common.Utilities.DBHelperParameterCache.InternalDiscoverSpParameterSet(IDalSession session, String spName, Boolean includeReturnValueParameter) +89
   IBatisNet.Common.Utilities.DBHelperParameterCache.GetSpParameterSet(IDalSession session, String spName, Boolean includeReturnValueParameter) +135
   IBatisNet.DataMapper.Configuration.Statements.PreparedStatementFactory.DiscoverParameter(ISqlMapSession session) +27
   IBatisNet.DataMapper.Configuration.Statements.PreparedStatementFactory.Prepare() +261
   IBatisNet.DataMapper.Configuration.Sql.Static.ProcedureSql.BuildPreparedStatement(ISqlMapSession session, RequestScope request, String commandText) +177
   IBatisNet.DataMapper.Configuration.Sql.Static.ProcedureSql.GetRequestScope(IMappedStatement mappedStatement, Object parameterObject, ISqlMapSession session) +53
   IBatisNet.DataMapper.MappedStatements.MappedStatement.ExecuteQueryForList(ISqlMapSession session, Object parameterObject) +39
   IBatisNet.DataMapper.SqlMapper.QueryForList(String statementName, Object parameterObject) +181
   MusicWorld.IbatisDAL.IbatisHelper`1.SelectList(String statementName, Object parameterObject) in E:\MusicWorld\MusicWorld.IbatisDAL\IbatisHelper.cs:47
   MusicWorld.IbatisDAL.ArtistDAL.SelectActressList(String originId, Int32 pageNo, Int32 rowsPerPage, Int32& totalRows) in E:\MusicWorld\MusicWorld.IbatisDAL\MusicWorld\ArtistDAL.cs:46
   MusicWorld.BLL.ArtistBLL.SelectActressList(String OriginID, Int32 pageNo, Int32 rowsPerPage, Int32& totalRows) in E:\MusicWorld\MusicWorld.BLL\MusicWorld\ArtistBLL.cs:60
   Controls_Common_ArtistList.LoadPageData(Int32 pageNo, Int32 rowsPerPage) in g:\pleskvhosts\sangeetmehfil.com\httpdocs\Controls\Common\ArtistList.ascx.cs:271
   Controls_Pagination.DisplayPager(Int32 pageNo, Boolean refresh) in g:\pleskvhosts\sangeetmehfil.com\httpdocs\Controls\Common\Pagination.ascx.cs:103
   Controls_Common_ArtistList.LoadGallery(String origin, Int32 style, Int32 pageNo, String mode) in g:\pleskvhosts\sangeetmehfil.com\httpdocs\Controls\Common\ArtistList.ascx.cs:157
   ArtistsGallery.LoadInfo(String origin, Int32 style, Int32 pageNo, String mode, String gender) in g:\pleskvhosts\sangeetmehfil.com\httpdocs\ArtistsGallery.aspx.cs:80
   ArtistsGallery.Page_Load(Object sender, EventArgs e) in g:\pleskvhosts\sangeetmehfil.com\httpdocs\ArtistsGallery.aspx.cs:51
   System.Web.Util.CalliEventHandlerDelegateProxy.Callback(Object sender, EventArgs e) +52
   System.Web.UI.Control.OnLoad(EventArgs e) +97
   System.Web.UI.Control.LoadRecursive() +61
   System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +693


Version Information: Microsoft .NET Framework Version:4.0.30319; ASP.NET Version:4.8.4700.0