error : mp_links_select doesn't exists

Post here for help with installing or upgrading mojoPortal pre-compiled release packages. When posting in this forum, please provide all relevant details. You may also want to review the installation or upgrading documentation.

If you have questions about using the source code or working with mojoPortal in Visual Studio, please post in the Developer forum.

Post here for help with installation of mojoPortal pre-compiled release packages

When posting in this forum, please try to provide as many relevant details as possible. Particularly the following:

  • What operating system were you running when the bug appeared?
  • What database platform is your site using?
  • What version of mojoPortal are you running?
  • What version of .NET do you use?
  • What steps are necessary to reproduce the issue? Compare expected results vs actual results.

You may also want to review the installation or upgrading documentation.

If you have questions about using the source code or working with mojoPortal in Visual Studio, please post in the Developer forum.

This thread is closed to new posts. You must sign in to post in the forums.
3/19/2010 10:39:26 AM
achristis
Gravatar
Total Posts 6
View Posts

error : mp_links_select doesn't exists

Hi all,

when I add a "simple/link list" to a page and then view the page, the following error goes in the log :

-03-19 14:35:36,619 ERROR mojoPortal.Web.mojoBasePage - 80.200.24.217-nl-BE - /home.aspx
System.InvalidOperationException: The stored procedure 'mp_Links_Select' doesn't exist.
 

Version 2.3.3.9 MSSQL
Windows Server 2008 IIS 7
medium trust installation

Any idea how to solve this ?

Tx,

Alain Christis

3/19/2010 12:15:46 PM
achristis
Gravatar
Total Posts 6
View Posts

Re: error : mp_links_select doesn't exists

some extra info!

I run setup again on the server and saw this message in the setup screen :

Running script linksmodule - 0.0.0.3 - 00:00:01.9657008
System.Data.SqlClient.SqlException: Invalid object name 'dbo.mp_Links_Select'. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at mojoPortal.Data.SqlHelper.ExecuteNonQuery(SqlTransaction transaction, CommandType commandType, String commandText, SqlParameter[] commandParameters) at mojoPortal.Data.DBPortal.DatabaseHelperRunScript(String script, String overrideConnectionInfo) at mojoPortal.Data.DBPortal.DatabaseHelperRunScript(FileInfo scriptFile, String overrideConnectionInfo) at mojoPortal.Business.DatabaseHelper.RunScript(Guid applicationId, FileInfo scriptFile, String overrideConnectionInfo) - 00:00:01.9813016

 

Alain Christis

3/20/2010 6:46:54 AM
Joe Audette
Gravatar
Total Posts 18439
View Posts

Re: error : mp_links_select doesn't exists

Hi Alain,

Please edit that script with a text editor.

/Setup/applications/linksmodule/SchemaUpgradeScripts/mssql/0.0.0.3.config

change dbo.mp_Links_Select to [dbo].mp_Links_Select

Then visit setup page again.

I have corrected this in my copy of the script so it will be fixed in the next release. This issue does not affect most installations because most installations use a user with dbo membership.

Hope it helps,

Joe

3/21/2010 5:56:21 AM
achristis
Gravatar
Total Posts 6
View Posts

Re: error : mp_links_select doesn't exists

Hi Joe,

thank you for the response.

The 0.0.0.3.config file has this content :

SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

ALTER PROCEDURE [dbo].[mp_Links_Select]


@ModuleID int

AS

SELECT *

FROM
mp_Links

WHERE
ModuleID = @ModuleID

ORDER BY
ViewOrder, Title


GO

I changed [dbo].[mp_Links_Select] to [dbo].mp_Links_Select but it didn't made any difference.

 

An other idea,

 

Alain

3/21/2010 7:18:24 AM
Joe Audette
Gravatar
Total Posts 18439
View Posts

Re: error : mp_links_select doesn't exists

Hi Alain,

You could try removing the [dbo]. part. I'm starting to wonder if you had some file transfer problems and not all the files made it. That proc should have been created when it ran the script /Setup/applications/linksmodule/SchemaInstallScripts/mssql/0.0.0.1.config 

Does that file exist?

All the scripts have objects prefixed with [dbo]. the only mistake in the upgrade script was dbo. without the brackets. But the error you get could also be because it is an ALTER PROCEDURE statement and if the procedure does not already exist it will cause an error like the one you see.

Hope it helps,

Joe

3/21/2010 8:05:37 AM
achristis
Gravatar
Total Posts 6
View Posts

Re: error : mp_links_select doesn't exists

Hi Joe,

 

/Setup/applications/linksmodule/SchemaInstallScripts/mssql/0.0.0.1.config does exist.

I copied the content of /Setup/applications/linksmodule/SchemaInstallScripts/mssql/0.0.0.1.config to the 0.0.0.3.config and ran setup again.

Then I get this error :

Running script linksmodule - 0.0.0.3 - 00:00:00.9360420
System.Data.SqlClient.SqlException: There is already an object named 'PK_Links' in the database. Could not create constraint. See previous errors. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at mojoPortal.Data.SqlHelper.ExecuteNonQuery(SqlTransaction transaction, CommandType commandType, String commandText, SqlParameter[] commandParameters) at mojoPortal.Data.DBPortal.DatabaseHelperRunScript(String script, String overrideConnectionInfo) at mojoPortal.Data.DBPortal.DatabaseHelperRunScript(FileInfo scriptFile, String overrideConnectionInfo) at mojoPortal.Business.DatabaseHelper.RunScript(Guid applicationId, FileInfo scriptFile, String overrideConnectionInfo) - 00:00:00.9672434
 

Alain

3/21/2010 8:54:16 AM
Joe Audette
Gravatar
Total Posts 18439
View Posts

Re: error : mp_links_select doesn't exists

I never told you to copy anything from one script to another, I only asked if the file existed on disk or not.

Pleas undo what you did and try just removing the [dbo]. in 0.0.03.config

If you still get an error then try changing ALTER PROCEDURE to CREATE PROCEDURE with [dbo]. if that fails try CREATE PROCEDURE without [dbo].

Hope it helps,

Joe

3/22/2010 2:01:45 AM
achristis
Gravatar
Total Posts 6
View Posts

Re: error : mp_links_select doesn't exists

Joe,

 

I tried the ALTER PROCEDURE without the [dbo] part, but same error.

The CREATE PROCEDURE failed both with [dbo] and without [dbo] with this error :

System.Data.SqlClient.SqlException: Invalid object name 'dbo.mp_Links_SelectByPage'. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at mojoPortal.Data.SqlHelper.ExecuteNonQuery(SqlTransaction transaction, CommandType commandType, String commandText, SqlParameter[] commandParameters) at mojoPortal.Data.DBPortal.DatabaseHelperRunScript(String script, String overrideConnectionInfo) at mojoPortal.Data.DBPortal.DatabaseHelperRunScript(FileInfo scriptFile, String overrideConnectionInfo) at mojoPortal.Business.DatabaseHelper.RunScript(Guid applicationId, FileInfo scriptFile, String overrideConnectionInfo) - 00:00:01.7160770
 

 

Alain

3/22/2010 11:37:05 AM
achristis
Gravatar
Total Posts 6
View Posts

Re: error : mp_links_select doesn't exists

Joe,

 

I fixed it, i.e. the error is gone when I add a simple/list to a page.

What I did :

- there was an error about PK_Links already exists
- this PK existed on the table Portal_Links
- I removed the PK_Links from this table
- then I ran setup again
- no errors anymore in the setup log
- no errors anaymore when adding an simple/list to a page

 

I'll do some extra testing this evening and keep you informed.

Greetz,

Alain

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