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.
Comments
Comment #1
celston commentedI have the same problem, exact same solution. Is someone just waiting for a formal patch or something? See attached.
Comment #2
arthurf commentedThanks for the catch. Applied to D5, D6, D6-2