I'm trying to grab some data from an external MySQL database running Joomla. I was only given a read-only MySQL account and set up my migration class:

https://gist.github.com/humansky/5601022

But whenever I run "drush mi --all" I get the following error:

Migration failed with source plugin exception: SQLSTATE[42000]: Syntax error or access violation: 1142 SELECT command denied to user [error]
'extdb_user'@'mylocalhost.host.com' for table 'migrate_map_joomlaevent'

It looks like Migrate is trying to connect to my 'default' database with the 'for_migration' database credentials. Has anyone else ran into this issue? I'm running Migrate version 7.x-2.5+127-dev

Comments

mikeryan’s picture

mikeryan
he/him
Primary language English
Location Pittsfield, MA, USA
commented
Category: bug » support
Status: Active » Postponed (maintainer needs more info)

See http://drupal.org/node/1014558 - you need to set the 'map_joinable' option on your source constructor.

humansky’s picture

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

WOW, can't believe I missed that and it was that easy.....thank you!!!!

Status: Fixed » Closed (fixed)

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

kenorb’s picture

kenorb commented
Issue summary: View changes
Related issues: +#1811382: Migration failed with source plugin exception: SQLSTATE[42000]: Syntax error or access violation