Import fails with the following error:

An AJAX HTTP error occurred. HTTP Result Code: 500 Debugging information follows. Path: /drupal/?q=batch&id=72&op=do StatusText: Service unavailable (with message) ResponseText: PDOException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'post_approved' in 'where clause': SELECT COUNT(*) AS expression FROM (SELECT 1 AS expression FROM {posts} p LEFT OUTER JOIN {topics} t ON p.topic_id = t.topic_id WHERE (post_approved = :db_condition_placeholder_0) AND (p.post_id = t.topic_first_post_id) ) subquery; Array ( [:db_condition_placeholder_0] => 1 ) in MigrateSourceSQL->computeCount() (line 233 of /drupal/sites/all/modules/migrate/plugins/sources/sql.inc).

PHPBB version 3.2.0-a1-dev.

Regards,
Aaron

Comments

aaronmchale’s picture

aaronmchale
Primary language English
Location Edinburgh, Scotland
commented

Quick solution is to insert the column post_approved into phpbb_posts table as a Boolean insuring that all values are set to 1 and not 0, otherwise topics and posts will be skipped and won't be imported.

There were a few other minor issues that needed to be resolved before the migration would run successfully, however I'll make another issue detailing all of these. I'll also update this issue when I perform the next migration with the exact SQL query that needs to be performed in order to overcome this.