Videos not displayed after upgrading Drupal from 5 to 6

Hi,

I recently upgraded drupal from 5 to 6.25

I have flashvideo module installed. I have a content type which displays Videos using CCK and Flashvideos. Issue is that the videos doesnot display and I get message "Video not availabe".

Upon further investigation I figured out the query due to which the videos are not displayed. Below is the query in flashvideo_get_video_object()

SELECT fv.oid, f.filepath, fv.width, fv.height, f.fid FROM flashvideo fv LEFT JOIN files f ON f.fid = fv.fid LEFT JOIN upload u on u.fid = fv.fid WHERE (f.filemime = 'flv-application/octet-stream' OR f.filemime = 'application/octet-stream' OR f.filemime = 'application/x-flash-video' OR f.filemime = 'video/x-flv' ) AND (fv.status = 3) AND (fv.video_index = 0)   AND (fv.nid = '112847')  AND (u.vid = '112844')

The above query returns no result.
If I remove AND (fv.nid = '112847') then I get one row in result
and if I remove AND (u.vid = '112844') then I get another result.

Upload table was newly created in drupal 6 so there seem to be some issue due to upgrade.

Can anyone pl help me with this issue ?

Thanks in advance..!!