Download & Extend

Filtering on specific source ids fails with mysql error

Project:Migrate
Version:6.x-1.x-dev
Component:Code
Category:bug report
Priority:normal
Assigned:Unassigned
Status:closed (fixed)

Issue Summary

On admin/content/migrate/process it's possible to enter in a comma separated list of source ids that you want to migrate. When you use this it fails with a mysql error :

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 'IN (123))' at line 24 query "SELECT .... AND (cms_content. IN (123)) in /sites/all/modules/migrate/migrate.module on line 521."

Note the where clause doesn't have a column name specified. It's because $sourceid is used instead of $sourcekey. The attached patch fixes this issue.

Cheers,
Stella

AttachmentSize
sourceid_filtering.patch504 bytes

Comments

#1

Status:needs review» fixed

Committed, thanks!

#2

Status:fixed» closed (fixed)

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

nobody click here