Hi,

           I am modifing media module. For that I want to add mediatype field in the media table.

So that I changed 03.02.03.SqlDataProvider.sqldataprovider file. I alter the table with media type filed.

Modified add & update SP for media type. Modified GetMedia SP to get media type.

My getmedia SP is as follows

"CREATE PROCEDURE {databaseOwner}{objectQualifier}GetMedia
    @ModuleId    INT
AS

SELECT    m.ModuleID,
    --'Src' = CASE WHEN srcf.FileName IS NULL THEN m.Src ELSE srcf.Folder + srcf.FileName END,
    m.Alt,
    m.Width,
    m.Height,
  'NavigateUrl' = CASE WHEN navf.FileName IS NULL THEN m.NavigateUrl ELSE navf.Folder + navf.FileName END,
    {objectQualifier}UrlTracking.NewWindow,
    {objectQualifier}UrlTracking.TrackClicks,
    m.MediaAlignment,m.Type
FROM    {objectQualifier}Media AS m
    LEFT OUTER JOIN {objectQualifier}Files AS srcf ON m.Src = 'fileid=' + CONVERT(VARCHAR, srcf.FileID)
    LEFT OUTER JOIN {objectQualifier}Files AS navf ON m.NavigateUrl = 'fileid=' + CONVERT(VARCHAR, navf.FileID)
    LEFT OUTER JOIN {objectQualifier}UrlTracking ON m.NavigateUrl = {objectQualifier}UrlTracking.Url and {objectQualifier}UrlTracking.ModuleId = @ModuleID
WHERE    m.ModuleId = @ModuleId
GO"

Then I created new media module insatallation zip file & trried to upload file into DOTNETNUKE4.

I got sql exception ERROR .

Is it any other workaround to customize exsting sqlprovider file?

What is wrong in my case?

Thanks

Varsha