Scott changed the implementation of the article image. The workaround to this issue is to create the following trigger on the article table. The trigger will assign the images correctly based on the original implementation of the metaPost provider. This means that after you execute the following SQL using the SQL tool from the hosts menu, you should be able to set the alternate text for the image you want to use as the article image to ai and the metaPost provider will associate this image as the article image.
---- Begin SQL ------
-- =============================================
-- Author: Don Worthley, Old Town IT
-- Create date: 3/29/2010
-- Description: Trigger to Update Image Files for News Articles to New Format
-- =============================================
CREATE TRIGGER {databaseOwner}{objectQualifier}itc_metapost_news_articles_image_update
ON {databaseOwner}{objectQualifier}DnnForge_NewsArticles_Article
AFTER INSERT,UPDATE
AS
BEGIN
-- SET NOCOUNT ON added to prevent extra result sets from
-- interfering with SELECT statements.
SET NOCOUNT ON;
INSERT INTO {databaseOwner}{objectQualifier}DnnForge_NewsArticles_Image(ArticleID, Title, FileName, Extension, Size, Width, Height, ContentType, Folder, SortOrder)
SELECT
a.ArticleID,
f.FileName,
f.FileName,
f.Extension,
f.Size,
f.Width,
f.Height,
f.ContentType,
f.Folder,
0
FROM
{databaseOwner}{objectQualifier}DnnForge_NewsArticles_Article a INNER JOIN
{databaseOwner}{objectQualifier}Files f ON 'FileID=' + CONVERT(varchar, f.FileID) = a.ImageUrl
UPDATE
{databaseOwner}{objectQualifier}DnnForge_NewsArticles_Article
SET
ImageUrl = NULL
WHERE
ArticleID IN (SELECT a.ArticleID FROM {databaseOwner}{objectQualifier}DnnForge_NewsArticles_Article a INNER JOIN {databaseOwner}{objectQualifier}Files f ON 'FileID=' + CONVERT(varchar, f.FileID) = a.ImageUrl)
UPDATE
{databaseOwner}{objectQualifier}DnnForge_NewsArticles_Article
SET
ImageCount = (SELECT count(*) FROM {databaseOwner}{objectQualifier}DnnForge_NewsArticles_Image i WHERE {databaseOwner}{objectQualifier}DnnForge_NewsArticles_Article.ArticleID = i.ArticleID)
END
GO