Moving Mojo from server to server - helpfull sql

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.
6/17/2010 11:18:00 AM
scott
Gravatar
Total Posts 19
View Posts

Moving Mojo from server to server - helpfull sql

Hello, I made the mistake of not using the correct URL's on my development site and had the common image issue described in the documentation.

Here is some sql to help you fix the image soource URL in your HTML content.

select Body from mp_HtmlContent
where Body like '%src="/wrongpath%'

update mp_HtmlContent set Body = REPLACE(CAST(Body as varchar(MAX)), '/wrongpath','')
where Body like '%src="/wrongpath%'
 

6/17/2010 11:19:54 AM
scott
Gravatar
Total Posts 19
View Posts

Re: Moving Mojo from server to server - helpfull sql

update mp_HtmlContent set Body = REPLACE(CAST(Body as varchar(MAX)), 'src="/willowbend','')
where Body like '%src="/willowbend%'
 

 

Updated.

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