Question regarding how the stored procedures are updated.

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.
1/12/2009 4:08:01 PM
Gravatar
Total Posts 22
Kenneth Haugland

Question regarding how the stored procedures are updated.

Question regarding how the stored procedures are updated.

I cloned the Blog feature and in the latest version the exceprt colum is removed as shown in the upgrade script

 

DELETE FROM mp_Blogs
WHERE ModuleID IN (SELECT ModuleID FROM mp_Modules WHERE SiteID = @SiteID)
 

but where is the code to update the stored procedures, ie all of them is changed du to the missing column. Is this in the innstall script?

Regards

Kenneth

1/13/2009 7:27:49 AM
Gravatar
Total Posts 18439

Re: Question regarding how the stored procedures are updated.

Well the blog has a long history and was only recently split off from the core of mojoportal. My guess is any reference to excerpt column was already removed before we split the feature off from core so you don't see an changes related to it in the blog procs (they are probably somewhere in very old upgrade scripts for mojoportal core). The original Excerpt field was a varchar and the implementation was poor because it could truncate html and lose closing tags. So recently we re-implemented an Excerpt but used a new text field named Abstract and finally removed excerpt to avid confusion.

All schema changes do happen in the upgrade scripts including changes to procs. In many cases the select procs have select * which makes it require less maintenance, so in some cases only insert and update procs have to be updated when adding a new column.

Hope it helps,

Joe

1/13/2009 11:26:05 AM
Gravatar
Total Posts 22
Kenneth Haugland

Re: Question regarding how the stored procedures are updated.

That explains why i did not find any reference to it.

I will just modify the upgrade script myself.

Thanks for the help.

Regards

Kenneth

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