When setting MM for harvesting files from CCK fields the database table prefix was not prepended correctly by function mm_cck_harvest() in media_mover/mm_cck/mm_cck.module file.

There's is an error on line 179 in the sql query.

error line: LEFT JOIN '. $db_info['table'] .' c ON c.'. $db_info['columns']['fid']['column'] .' = f.fid
fixed line: LEFT JOIN {'. $db_info['table'] .'} c ON c.'. $db_info['columns']['fid']['column'] .' = f.fid

Because of missing parentheses table name would not get prefixed correcly by function db_prefix_tables($sql).

Took me couple of hours to trace this bug down.

Cheers everyone

Comments

arthurf’s picture

arthurf commented
Status: Active » Postponed (maintainer needs more info)

This one is fixed in the dev version of 6.1x - can you give that a try and see if it is working for you? Thanks for the bug report

Nala Zoch’s picture

Nala Zoch commented

Have tested the latest development snapshot and seems to be working fine :)

arthurf’s picture

arthurf commented
Status: Postponed (maintainer needs more info) » Fixed

Fixed in Beta3 http://drupal.org/node/595886

Status: Fixed » Closed (fixed)

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