Hi.
This is the error message I get after starting any import (avatars, forums) from the Migrate UI:

PDOException: SQLSTATE[42000]: Syntax error or access violation: 1142 SELECT command denied to user 'SITENAME'@'localhost' for table 'migrate_map_phpbbforums': SELECT f.forum_id AS forum_id, f.parent_id AS parent_id, f.forum_name AS forum_name, f.forum_desc AS forum_desc, f.forum_type AS forum_type, map.destid1 AS migrate_map_destid1, map.needs_update AS migrate_map_needs_update FROM {forums} f LEFT OUTER JOIN {SITENAME_phpbb_test.migrate_map_phpbbforums} map ON forum_id = map.sourceid1 WHERE (forum_type <> :db_condition_placeholder_0) AND( (map.sourceid1 IS NULL ) OR (map.needs_update = :db_condition_placeholder_1) ) ORDER BY parent_id ASC, right_id ASC, left_id ASC; Array ( [:db_condition_placeholder_0] => 2 [:db_condition_placeholder_1] => 1 ) in MigrateSourceSQL->performRewind() (line 318 of /home/SITENAME/public_html/drupal/drupal7/sites/all/modules/migrate/plugins/sources/sql.inc).

Any ideas?

Comments

mbutelman’s picture

mbutelman commented

Update:

after moving the tables to the local database and removing the table prefix (phpbb_) I got another error:

An AJAX HTTP error occurred. HTTP Result Code: 500 Debugging information follows. Path: /sitename/drupal7/?q=batch&id=8412&op=do StatusText: Service unavailable (with message) ResponseText: EntityMalformedException: Missing bundle property on entity of type taxonomy_term. in entity_extract_ids() (line 7501 of /var/www/sitename/drupal7/includes/common.inc)

Disabling and uninstalling Migrate and phpbb2drupal modules, and afterwards disabling and reenabling first the forum module and then Migrate and phpbb2drupal fixed this error.

adammalone’s picture

adammalone
Primary language English
Location San Francisco
commented

This error could be due to the settings within phpbb2drupal settings.
You must untick the box 'use local settings' for it not to query the drupal database. Regarding the issue with the table prefix see this issue.

Z2222’s picture

Z2222 commented

EDIT: sorry, I was on the wrong thread. Reposted here:
https://drupal.org/node/1483564#comment-5807056

ghankstef’s picture

ghankstef commented

I worked around this by dumping the phpbb db 

mysqldump -uusername -p  thennameofyourphpbbdb > thennameofyourphpbbdb.sql

opening the dump file in vim and doing a search and replace and saving the file like this 

vim thennameofyourphpbbdb.sql
:%s/phpbb_//g
:wq

dropped the database and recreated it 

DROP DATABASE thennameofyourphpbbdb;
CREATE DATABASE thennameofyourphpbbdb;

then reimport the db. 

mysql -uusername -p thennameofyourphpbbdb < thennameofyourphpbbdb.sql

Then it worked fine.

JeremyFrench’s picture

JeremyFrench commented
Status: Active » Closed (duplicate)

I think this is a dupe of #1483564: Table prefix is prefixing the database solution may be to make sure you are using latest drupal (7.14+) and migrate.