The stored procedure 'mp_Links_SelectByPage' doesn't exist.

This forum is only for questions or discussions about working with the mojoPortal source code in Visual Studio, obtaining the source code from the repository, developing custom features, etc. If your question is not along these lines this is not the right forum. Please try to post your question in the appropriate forum.

Please do not post questions about design, CSS, or skinning here. Use the Help With Skins Forum for those questions.

This forum is for discussing mojoPortal development

This forum is only for questions or discussions about working with the mojoPortal source code in Visual Studio, obtaining the source code from the repository, developing custom features, etc. If your question is not along these lines this is not the right forum. Please try to post your question in the appropriate forum.

You can monitor commits to the repository from this page. We also recommend developers to subscribe to email notifications in the developer forum as occasionally important things are announced.

Before posting questions here you might want to review the developer documentation.

Do not post questions about design, CSS, or skinning here. Use the Help With Skins Forum for those questions.
This thread is closed to new posts. You must sign in to post in the forums.
3/12/2009 4:14:36 PM
bitfix
Gravatar
Total Posts 5
View Posts

The stored procedure 'mp_Links_SelectByPage' doesn't exist.

Hi,

I have started to develop a new module on MP and have run into a problem with a SP that seems to be missing.

At random time running the developed site, I get an error with this message: The stored procedure 'mp_Links_SelectByPage' doesn't exist.

My stack at the point of error is this:

> mojoPortal.Data.DLL!mojoPortal.Data.SqlHelperParameterCache.DiscoverSPParameterSet(System.Data.SqlClient.SqlConnection connection = {System.Data.SqlClient.SqlConnection}, string spName = "mp_Links_SelectByPage", bool includeReturnValueParameter = false) Line 2513 C#
mojoPortal.Data.DLL!mojoPortal.Data.SqlHelperParameterCache.GetSPParameterSetInternal(System.Data.SqlClient.SqlConnection connection = {System.Data.SqlClient.SqlConnection}, string spName = "mp_Links_SelectByPage", bool includeReturnValueParameter = false) Line 2685 + 0x10 bytes C#
mojoPortal.Data.DLL!mojoPortal.Data.SqlHelperParameterCache.GetSPParameterSet(string connectionString = "server=FASTFIX;UID=mp;PWD=mp_develop;database=mp_develop", string spName = "mp_Links_SelectByPage", bool includeReturnValueParameter = false) Line 2629 + 0x10 bytes C#
mojoPortal.Data.DLL!mojoPortal.Data.SqlHelperParameterCache.GetSPParameterSet(string connectionString = "server=FASTFIX;UID=mp;PWD=mp_develop;database=mp_develop", string spName = "mp_Links_SelectByPage") Line 2609 + 0xd bytes C#
mojoPortal.Data.DLL!mojoPortal.Data.SqlParameterHelper.InitializeArray() Line 63 + 0x17 bytes C#
mojoPortal.Data.DLL!mojoPortal.Data.SqlParameterHelper.BeginDefineSqlParameters() Line 51 + 0x8 bytes C#
mojoPortal.Data.DLL!mojoPortal.Data.SqlParameterHelper.Initialize(string pConnectionInfo = "server=FASTFIX;UID=mp;PWD=mp_develop;database=mp_develop", string pCommandText = "mp_Links_SelectByPage", System.Data.CommandType pCmdType = StoredProcedure, int pParamCnt = 2) Line 86 + 0x8 bytes C#
mojoPortal.Data.DLL!mojoPortal.Data.SqlParameterHelper.SqlParameterHelper(string connectionString = "server=FASTFIX;UID=mp;PWD=mp_develop;database=mp_develop", string commandText = "mp_Links_SelectByPage", int paramCnt = 2) Line 43 + 0x13 bytes C#
mojoPortal.Features.Data.DLL!mojoPortal.Data.DBLinks.GetLinksByPage(int siteId = 1, int pageId = 0) Line 129 + 0x28 bytes C#
mojoPortal.Features.Business.DLL!mojoPortal.Business.Link.GetLinksByPage(int siteId = 1, int pageId = 0) Line 292 + 0xb bytes C#
mojoPortal.Features.UI.DLL!mojoPortal.Features.LinksIndexBuilderProvider.RebuildIndex(mojoPortal.Business.PageSettings pageSettings = {mojoPortal.Business.PageSettings}, string indexPath = "C:\\Documents and Settings\\hkl\\Dokumenter\\Visual Studio 2008\\Projects\\MojoPortal\\Web\\Data\\Sites\\1\\index\\") Line 55 + 0x31 bytes C#
mojoPortal.Business.WebHelpers.DLL!mojoPortal.Business.WebHelpers.IndexHelper.RebuildPageIndex(mojoPortal.Business.PageSettings pageSettings = {mojoPortal.Business.PageSettings}) Line 601 + 0xe bytes C#
mojoPortal.Business.WebHelpers.DLL!mojoPortal.Business.WebHelpers.IndexHelper.RebuildPageIndexAsyncCallback(object o = {mojoPortal.Business.PageSettings}) Line 571 + 0x8 bytes C#
 

I have downloaded the source code as instructed and as installed on my developer machine. I have created a new solution from the full version without silverlight and have had this error on almost every run.

I tried to fix it in the update sql scripts, but the error comes back somehow.

Btw. mojoPortal is the best CMS and portal system and I am very impressed with the code structure and quality. Very good work indeed. You guys are very talented.

I hope you can help me to understand why this happens to me.

Thanks.

3/13/2009 6:54:08 AM
Joe Audette
Gravatar
Total Posts 18439
View Posts

Re: The stored procedure 'mp_Links_SelectByPage' doesn't exist.

Hi,

I don't know what you mean by tried to fix the script. This procedure is created by the script as far as I know and this procedure has not changed since 2005. It does exist in my installations so I don't know why it would disappear on your system. 

Sorry I don't have more help for you.

Best,

Joe

You must sign in to post in the forums. This thread is closed to new posts.