PDO Exception when navigating to /admin/content/migrate [#1432074]

After doing configuration (/admin/content/phpbb) I navigate to /admin/content/migrate and get following error message:

PDOException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'user_avatar' in 'where clause': SELECT COUNT(*) AS expression FROM (SELECT 1 AS expression FROM {users} u WHERE (user_avatar IS NOT NULL ) AND (user_avatar <> :db_condition_placeholder_0) ) subquery; Array ( [:db_condition_placeholder_0] => ) w MigrateSourceSQL->computeCount() (linia 215 z /srv/hosting/accounts/zeroday/usr/local/drupal/sites/all/modules/contrib/migrate/plugins/sources/sql.inc).

This is a freshly installed Drupal instance that includes:

 Core             Block (block)                          Module  7.12
 Core             Color (color)                          Module  7.12
 Core             Comment (comment)                      Module  7.12
 Core             Contextual links (contextual)          Module  7.12
 Core             Dashboard (dashboard)                  Module  7.12
 Core             Database logging (dblog)               Module  7.12
 Core             Field (field)                          Module  7.12
 Core             Field SQL storage (field_sql_storage)  Module  7.12
 Core             Field UI (field_ui)                    Module  7.12
 Core             File (file)                            Module  7.12
 Core             Filter (filter)                        Module  7.12
 Core             Forum (forum)                          Module  7.12
 Core             Help (help)                            Module  7.12
 Core             Image (image)                          Module  7.12
 Core             List (list)                            Module  7.12
 Core             Locale (locale)                        Module  7.12
 Core             Menu (menu)                            Module  7.12
 Core             Node (node)                            Module  7.12
 Core             Number (number)                        Module  7.12
 Core             Options (options)                      Module  7.12
 Core             Path (path)                            Module  7.12
 Core             RDF (rdf)                              Module  7.12
 Core             Search (search)                        Module  7.12
 Core             Shortcut (shortcut)                    Module  7.12
 Core             System (system)                        Module  7.12
 Core             Taxonomy (taxonomy)                    Module  7.12
 Core             Text (text)                            Module  7.12
 Core             Toolbar (toolbar)                      Module  7.12
 Core             Update manager (update)                Module  7.12
 Core             User (user)                            Module  7.12
 Development      Migrate (migrate)                      Module  7.x-2.2
 Development      Migrate UI (migrate_ui)                Module  7.x-2.2
 Input filters    BBCode (bbcode)                        Module  7.x-1.0
 phpBB to Drupal  Migrate core phpBB (phpbb2drupal)      Module  7.x-2.x-dev
 Core             Bartik (bartik)                        Theme   7.12
 Core             Garland (garland)                      Theme   7.12
 Core             Seven (seven)                          Theme   7.12

Comments

Comment #1

danstefan commented 8 February 2012 at 00:05

Ok, I have commented out lines 121 - 123 in phpbb2drupal_core.inc and it worked. I was able to run the import.

    if (!empty($user->user_avatar)) {
      $user->user_avatar = PhpbbAvatarMigration::getRealFilename($user->user_avatar);
    }

There is another small problem. When I try to see the import messages, for example /admin/content/migrate/messages/PhpbbUser I get this error:

PDOException: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'mhaker_home.migrate_message_phpbbtopic' doesn't exist: SELECT COUNT(*) AS expression FROM (SELECT 1 AS expression FROM {migrate_message_phpbbtopic} msg) subquery; Array ( ) w PagerDefault->execute() (linia 74 z /srv/hosting/accounts/zeroday/usr/local/drupal/includes/pager.inc).

However, I would like to say thank you for your hard work. This is a great module.