I get this error when installing MM on drupal 6.22.

user warning: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ' fid (cid, fid) ) /*!40100 DEFAULT CHARACTER SET utf8 */' at line 19 query: CREATE TABLE media_mover_files ( `mmfid` INT auto_increment DEFAULT NULL, `nid` INT unsigned DEFAULT NULL, `fid` INT unsigned DEFAULT NULL, `cid` VARCHAR(255) DEFAULT '', `step_order` INT unsigned DEFAULT NULL, `source_filepath` MEDIUMTEXT DEFAULT NULL, `filepath` MEDIUMTEXT DEFAULT NULL, `filesize` INT unsigned DEFAULT NULL, `status` VARCHAR(255) DEFAULT NULL, `date` INT NOT NULL DEFAULT 0, `lock_date` INT NOT NULL DEFAULT 0, `data` LONGTEXT DEFAULT NULL, PRIMARY KEY (mmfid), INDEX mmfid (mmfid), INDEX nid (nid), INDEX cid (cid), INDEX fid (fid), INDEX cid, fid (cid, fid) ) /*!40100 DEFAULT CHARACTER SET utf8 */ in /var/www/clients/client1/web10/web/includes/database.inc on line 550.

Comments

newmember’s picture

Status: Active » Closed (duplicate)

i see the fix and manually corrected it.

media_mover_api.install line 87:
'cid, fid' => array('cid', 'fid'),
change to:
'cid_fid' => array('cid', 'fid'),