The stored procedure 'mp_SiteHosts_SelectSiteIdByHost' 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.
9/16/2011 2:00:05 AM
chakrichandru8
Gravatar
Total Posts 5
View Posts

The stored procedure 'mp_SiteHosts_SelectSiteIdByHost' doesn't exist.

This is my Deployment file name  which is download from your site (mojoportal-2-3-6-7-mssql-net40-deploymentfiles) and here my source code  file name(mojoportal-0173303a15f6) both r new version now the problem is while running my source code I'm getting error called The stored procedure 'mp_SiteHosts_SelectSiteIdByHost' doesn't exist. I checked my database too there is no stored procedure in the name of  mp_SiteHosts_SelectSiteIdByHost ....so can u please help me to figure it out

 

 

9/16/2011 2:43:38 AM
Asad Samarian
Gravatar
Total Posts 550
View Posts

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

Hi,

It is better that you get latest version of code from repository by TortiuseHG. Anyway doing the following steps may solve your problem.

1-find  <add key="UseCultureOverride" value="true"/> in your user/web.config and change it as below

<add key="UseCultureOverride" value="false"/>

2-Then visit setup page [yoursite]/setup/default.aspx

3-Change it back to true.

Hope Hepls,

Asad

 

9/16/2011 4:15:39 AM
chakrichandru8
Gravatar
Total Posts 5
View Posts

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

In web.config file its already in false state...<add key="UseCultureOverride" value="false"/> and in setup/default.aspx i couldn't fine the UseCultureOverride  to make it true.

9/16/2011 4:26:25 AM
Asad Samarian
Gravatar
Total Posts 550
View Posts

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

See your user.config and sure that it is set to false. It is NOT  in setup/default.aspx. I means that change it after setup process.

 

9/16/2011 4:50:02 AM
chakrichandru8
Gravatar
Total Posts 5
View Posts

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

I checked in user.config file also in that file they didnt include that line so can i add that line in to my user.config file

9/16/2011 5:05:01 AM
Asad Samarian
Gravatar
Total Posts 550
View Posts

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

See this thread, may be helps you.

 

9/16/2011 5:59:44 AM
Joe Audette
Gravatar
Total Posts 18439
View Posts

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

To use the source code you need to get it using Tortoise HG, but you also need to understand that the latest source code is newer than the release packages and has many changes since the 2.3.6.7 release.

If you want source code that corresponds to the 2.3.6.7 release you should get the code with Tortoise HG and update to revision 2381 using HG > Update command

If you want to work with the newer code then after you rebuild the solution you must visit the /Setup/Default.aspx page so it can run upgrade scripts which would create any new stored procedures.

The download links for source code on codeplex are generated by the codeplex web site and often seem to be incomplete or incorrect, the only correct way to get the source code is using Tortoise HG.

Hope that helps,

Joe

9/16/2011 9:28:55 AM
chakrichandru8
Gravatar
Total Posts 5
View Posts

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

Thanks Joe and one more help from your side ,

I need your suggestions that i'm undergoing in one  project

Details:

we have two mojoportal server now the thing is i'm going to collect all the details(i.e table values ,site Folders...) about the particular site & its module  from one mojoportal server,I need to transfer that data to second mojoportal server.

so my question is it possible are we cant do it ....

9/16/2011 9:33:14 AM
Joe Audette
Gravatar
Total Posts 18439
View Posts

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

please in the future ask only 1 question per thread to help us keep the forums organized.

See Moving an Installation of mojoPortal to a Different Server.

9/16/2011 11:39:31 PM
chakrichandru8
Gravatar
Total Posts 5
View Posts

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

Thanks for the Post and i'm sorry for that it wont happen next time

10/2/2011 1:06:15 PM
Alexplorer
Gravatar
Total Posts 3
View Posts

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

Hello,

         After uploading files to the server(eg. http://localhost), if you try to access http://localhost, the site would throw The stored procedure 'mp_SiteHosts_SelectSiteIdByHost' doesn't exist.   error. However,  you access http://localhost/setup/Default.aspx and  after the setup is done, things turns OK

        

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