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.
8/26/2011 1:43:45 PM
cms_developer
Gravatar
Total Posts 45
View Posts
Thanks, cms_developer Contributer:http://codeissue.com/

The stored procedure 'mp_SiteHosts_SelectSiteIdByHost' doesn't exist.

Getting this error from latest build after I updated the source code?

Any ideas why I am getting this?

8/26/2011 2:16:44 PM
Asad Samarian
Gravatar
Total Posts 550
View Posts

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

Hi,

as a temporary solution change this setting in you user/web.config then visit the setup page and wait for Joe' solution.

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

Hope Helps

Asad,

8/26/2011 2:26:26 PM
Joe Audette
Gravatar
Total Posts 18439
View Posts

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

Whenever you update from the source code repository, after you rebuild the entire solution, when you run the web project you need to visit the /Setup/Default.aspx page just the same as if upgrading from a pre-compiled release.

The setup page will run any needed scripts for changes to the database.

Hope that helps,

Joe

8/26/2011 2:44:59 PM
Asad Samarian
Gravatar
Total Posts 550
View Posts

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

Hi Joe,

I trace it. It seems these SPs need in the BeginRequest method of CultureHelperHttpModule class that execute before setup process.

Best,

Asad

8/26/2011 2:47:04 PM
cms_developer
Gravatar
Total Posts 45
View Posts
Thanks, cms_developer Contributer:http://codeissue.com/

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

Thanks Joe and Ashad for your input.

I just tried the Joe solution and it worked so didn't tried the other one.

Can you please guide me to this css layout issue too.

I am just getting this content in my website.Any ideas.I was expecting these links to align horizontally on top as explained in site and videos demo.Any think I am doing wroing or I need to do?I am build from the latest version of the source till date.Also Home is repeating twice.I just renamed the footer from admin login.

mojoPortal
Skip over navigation
•Home

•Home
•Site Map
•Register
•Sign In

Welcome

Site Map | Printable View | © 2008 - 2011 Khanal Industries

Powered by mojoPortal | HTML 5 | CSS | Design by styleshout

8/26/2011 2:50:53 PM
cms_developer
Gravatar
Total Posts 45
View Posts
Thanks, cms_developer Contributer:http://codeissue.com/

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

http://www.mojoportal.com/Forums/Thread.aspx?pageid=5&mid=34&ItemID=4&thread=3177

please ignore my query i got some information here will review it.

8/26/2011 3:04:20 PM
Asad Samarian
Gravatar
Total Posts 550
View Posts

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

Hi cms_developer,

Please don't post related topics in a post. Let us to have our forums as a knowledgebase for people that search in it in future.

Do you set UseCultureOverride to true before visiting the setup pages?. I think we have this problem if UseCultureOverride be true.

 

 

8/27/2011 6:54:16 AM
Joe Audette
Gravatar
Total Posts 18439
View Posts

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

Hi Asad,

I have this fixed in my local copy. I will push the change to the repository as soon as I can but currently I'm getting an error trying to push my changes. I've contacted the codeplex team and am waiting to hear back from them. I'll post again once this fix is in the repository. In the meantime you can work around it by setting UserCultureOverride to false, run the setup page then change it back to true.

Best,

Joe

8/29/2011 11:14:36 AM
Joe Audette
Gravatar
Total Posts 18439
View Posts

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

Hi Asad,

The codeplex team helped me with the problem I was having with the repository. The fix is now in the repository.

Best,

Joe

10/12/2011 10:15:45 AM
cms_developer
Gravatar
Total Posts 45
View Posts
Thanks, cms_developer Contributer:http://codeissue.com/

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

I tried using 2.3.7.0 version today and still see the issue wasn't it supposed to fix in this version.

10/12/2011 10:18:33 AM
Joe Audette
Gravatar
Total Posts 18439
View Posts

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

Whenever there are changes to the database schema or new or changed stored procedures it is normal and expected that errors will happen until you visit the /Setup/Default.aspx page so that the upgrade scripts can run.

Hope that helps,

Joe

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