No picture with sqlDataProvider

Jan 31, 2009 at 9:25 PM
No pictures show on the main page, but do on the post page when I use sqldataprovider with the most current build from source code tab. 
Jan 31, 2009 at 9:37 PM
Do you mean pictures that you uploaded and inserted into your posts?  Or pictures that your theme uses?

You're using changeset 24719 ?  There was a fix for a problem with broken image links that was applied in changeset 24719.  Not sure if that's the problem you are having.

On the pages where the images aren't showing up, if you View Source, you can find the <img> tags.  See what the "src" is for those images to get an idea why the images aren't coming up.
Jan 31, 2009 at 11:59 PM
Edited Feb 1, 2009 at 12:32 AM
No I am using the prior version to the 24719.  I tried looking through the documentation to apply the patch, but I could not figure it out. I downloaded the newer build and looked at the new tinyMCE.ascx file and found the reference noted in the issue tracker. I also ADDED the recommended fix to the TextBox control as recommended.  It seems to work fine now, Thanks

Feb 1, 2009 at 12:32 AM
First, you should determine if the problem is due to the issue that was fixed in changeset 24719.  If the image Urls in your posts are <img src="../../image.axd? ...> rather than <img src="image.axd? ...> then the problem you're having is due to this issue.

The "convert_urls" fix in the issue will prevent tinyMce from converting urls when you are editing the posts.  Even if you add convert_urls : false to your tinyMCE.ascx file, that won't instantly correct the problem with old posts.  You'll still want to add convert_urls : false to tinyMCE.ascx to prevent future problems, but after doing so, you can try editing each post and just re-saving the post to see if it corrects the issue.  If that doesn't work (and it might not), then you will need to go into the data store (XML files or SQL database) and remove the leading ../../ before image.axd.

If your posts are in a SQL database, this SQL statement should correct all your posts in one shot:

update be_Posts
set PostContent = replace(PostContent, '../../image.axd?', 'image.axd?')

If you edit the data store directly, BE might still show the old posts.  Re-uploading your web.config file or making a small change in the web.config file (add a single space, etc) should clear the cache so the data store is re-read.