I am using drupal with table prefix set to 'drupal6_'. I got SQL error that said "table doesn't exist" when harvesting from cck field.
I looked up line 179 in mm_cck.module file and found this code :

<?php
LEFT JOIN '. $db_info['table'] .' c ON c.'. $db_info['columns']['fid']['column'] .' = f.fid
?>

Drupal didn't prefixed the table name properly. So I changed this code to :

<?php
LEFT JOIN {'. $db_info['table'] .'} c ON c.'. $db_info['columns']['fid']['column'] .' = f.fid
?>

and table name gets prefixed and harvesting process works great.

CommentFileSizeAuthor
#1 mm_cck.patch270 bytescelston

Comments

celston’s picture

StatusFileSize
new270 bytes

I have the same problem, exact same solution. Is someone just waiting for a formal patch or something? See attached.

arthurf’s picture

Status: Active » Fixed

Thanks for the catch. Applied to D5, D6, D6-2

Status: Fixed » Closed (fixed)

Automatically closed -- issue fixed for 2 weeks with no activity.