Create page through database.

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.
2/19/2013 5:59:04 AM
Dilip Wanave
Gravatar
Total Posts 44
View Posts
Regards, Dilip Wanave

Create page through database.

Hi Everyone,

I want some different functionality in mojoPortal, as we are creating pages from admin, but I want to add page from database by creating and executing scripts on DB. Along with this I want to add HtmlContent on page that also from DB.

 

To do this I have gone through database and noticed tables those need to be updated as follows:

-mp_HtmlContent

-mp_Modules

-mp_Pages

-mp_PageModules

-mp_FriendlyUrls

-mp_ModuleSettings

I have created scripts with data and executed on these tables then also I am not able see the pages on site.

Once I will add one more page through admin then other pages displayed on site, but they does not contains content on the page.

 

If I am missing something, please guide me.

 

Thanks in advance.

 

2/19/2013 10:28:13 AM
Joe Audette
Gravatar
Total Posts 18439
View Posts

Re: Create page through database.

The SiteMap that the menu is based on is cached by the runtime. When you add a page from the UI we clear the cache but there is no way to do that from sql.

I would compare the data from content created in the UI to see what you are doing wrong, probably some missing or incorrect guid or relationship fields.

2/20/2013 1:15:02 AM
Dilip Wanave
Gravatar
Total Posts 44
View Posts
Regards, Dilip Wanave

Re: Create page through database.

Thanks Joe for quick reply.

As you are saying mojoPortal cache the pages so I have tried by closing the browser and checked for dates in all tables and reopen it then pages gets created.

 

Thanks once again.

2/20/2013 6:15:57 AM
Joe Audette
Gravatar
Total Posts 18439
View Posts

Re: Create page through database.

The SiteMap is cached on the server not in the browser. Closing the browser does not affect it.

2/20/2013 6:18:58 AM
Dilip Wanave
Gravatar
Total Posts 44
View Posts
Regards, Dilip Wanave

Re: Create page through database.

Hi Joe,

I am implementing it just as learning purpose on local machine and it works.

As you are saying it may cause problem when site is hosted on server, very soon I will test it also.

Thanks for more information.

3/28/2013 8:08:44 AM
Dilip Wanave
Gravatar
Total Posts 44
View Posts
Regards, Dilip Wanave

Re: Create page through database.

Hi Joe,

As you said before "The SiteMap is cached on the server not in the browser. Closing the browser does not affect it."

When I have tried same process on server I have faced same problem, but i got alternative solution for that as "Just create a new page, then after creation of the page we will get all the pages".

 

 

Thanks,

Dilip Wanave

 

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