Missing Stored Procedures

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

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.

2/4/2010 4:05:13 AM

MarkNijhof

Total Posts 4

View Posts

Missing Stored Procedures

Hi,

I need to create a News module and I believe the easiest way is to make a copy of the blog module and make changes in that. So I have downloaded the latest version of the source code and copied all the things I could find relating to the Blog module and just renamed Blog into News (manually so controlled, not a search and replace). Then I wanted to make this work first so I loaded the News module and added it to a page. Then it blows up on me:

The stored procedure 'mp_Blogs_GetCount' doesn't exis.

Now the site is running the downloaded DLL version, so I guess there can be differences between the blog module there and the source code. The DLL version we are running is: 2.3.3.4 MSSQL and the blog module schema version is: 0.0.1.2.

Now the interesting thing is that I cannot find the definition for the mp_Blogs_GetCount stored procedure in the downloaded source code, I also tried searching on the SVN repository but that doesn't work with CodePlex :( I believe that the definition for mp_Blogs_SelectPage is also missing.

This makes me conclude that the source version is not working, I haven't tried that yet, but I don't see how it would.

Can anybody help me out on this one?

Cheers,

-Mark

2/9/2010 2:52:03 AM

MarkNijhof

Total Posts 4

View Posts

Re: Missing Stored Procedures

Does anybody know where these Stored Procedures can be found? I can probably reverse engineer them using the name and looking at their usage, but I rather not considering future updates.

-Mark

2/9/2010 6:32:22 AM

Joe Audette

Total Posts 18439

View Posts

Re: Missing Stored Procedures

All sql scripts are located under

/Setup/applications/[appname]/SchemaInstallScripts/mssql/

and

/Setup/applications/[appname]/SchemaUpgradeScripts/mssql/

If working with the source code, these get copied on post build for the blog from mojoPortal.Features.UI/Setup/blog/...

mojoPortal version only corresponds to the version of mojoPortal core, blog version is independent of that.

If you clone the blog you should make procs with your own prefix.

To clone a feature, you need to understand the installation system.

http://www.mojoportal.com/setupandupgradeforcustomfeatures.aspx

http://www.mojoportal.com/using-the-installation-system.aspx

Hope it helps,

Joe

2/15/2010 3:32:09 AM

MarkNijhof

Total Posts 4

View Posts

Re: Missing Stored Procedures

Hi Joe,

Thanks for your reply. Unfortunate it didn't resolve my issue, the link was useful because it showed me that I pretty much did all the needed steps correctly. (I missed the index builder).

Now when I do a global text search in all files of the downloaded source code for 'mp_Blogs_GetCount' then that only returns the DBBlog.cs file (both the SQL Server and the Azure one). But not in any .config file that contains the SQL statements.

Sorry for the delayed reply, but I hope you have some more insights on what I might be missing.

-Mark

2/15/2010 5:45:31 AM

MarkNijhof

Total Posts 4

View Posts

Re: Missing Stored Procedures

Ok,

I redid the a SVN check-out and now I am getting the right files.

Thanks for your help.

-Mark

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