If you use the Internationalization module on Drupal, this add-on migrates your multilingual data from Drupal to WordPress, assigning the right language to each node and each taxonomy.
WordPress uses tools such as Git, Github or WP-CLI (which is similar to Drush on Drupal). Just like Drupal CCK and Views, you can use Toolset’s plugins to reduce the need for custom code. WordPress.org hosts a repository of plugins and themes just like Drupal.org. Hooks in both are similar.
You also need WPML to manage your multilingual content in WordPress.
The add-on migrates:
- the nodes languages
- the taxonomies languages
- Install and activate FG Drupal to WordPress plugin by logging into your new WordPress site. Once it is installed, you need to find out your Drupal DB parameters. Locate the specific parameters like Drupal username, password, hostname, DB name, etc. If you are unsure of the other parameters, you can find the rest by looking into Drupal.
- FAQ I get the message: “fg-drupal-to-wp Couldn’t connect to the Drupal database. Please check your parameters. And be sure the WordPress server can access the Drupal database.
- Once inside, type FG Drupal to WordPress on the search bar at the right side of the screen: In the event that you typed the name correctly, only one plugin should come up. Snap on the Install Now button close to its name: After the plugin installs itself, the button will change to read and Activate. Snap on it again, and we’re finished!
The add-on requires the main plugin FG Drupal to WordPress Premium.
It also requires the WPML plugin.
- Install and activate WPML
- Install and activate FG Drupal to WordPress Premium
- Install and activate the Internationalization add-on
- Set your languages and your default language in WPML > Languages
- Run the migration in Tools > Import > Drupal
Internationalization Change log
Fixed: [ERROR] Error:SQLSTATE: Syntax error or access violation: 1066 Not unique table/alias: ‘nd’
Fixed: Wrong total number in the progress bar
Fixed: Missing terms translations from Drupal 8
Fixed: Missing nodes translations from Drupal 8
Compatible with FG Drupal to WordPress Premium 2.34.0
Tested with WordPress 5.6
New: Add WP-CLI and CRON support
Tested with WordPress 5.5
Compatible with FG Drupal to WordPress Premium 2.13.1
Tested with WordPress 5.4 Yeti usb microphone drivers.
Fixed: Some field values were not imported
New: Import the node translations using the table “field_data_title_field”
Tested with WordPress 5.3
Fixed: Translations not imported on Drupal 8
Fixed: [ERROR] Error:SQLSTATE: Integrity constraint violation: 1052 Column ‘langcode’ in where clause is ambiguous
Fixed: The progress bar exceeds 100% with Drupal 8 sites
Tested with WordPress 5.2
Fixed: Categories translations whose name is the same as in the original language were not imported
Tested with WordPress 5.1
Tested with WPML 4.2
Fixed: Some categories imported in wrong language
Tested with WordPress 4.8
Tested with WPML 4.8
Fixed: The language codes with more than 2 characters (eg. pt-br) were not imported
This plugin migrates articles, stories, pages, categories, tags and images from Drupal to WordPress.
It has been tested with Drupal 4, 5, 6, 7, 8 & 9 and WordPress 5.7. It is compatible with multisite installations.
Major features include:
- migrates the Drupal articles
- migrates the Drupal 6 stories
- migrates the Drupal basic pages
- migrates the Drupal categories
- migrates the Drupal tags
- migrates the Drupal images
- uploads all the posts media in WP uploads directories
- uploads external media (option)
- modifies the post content to keep the media links
- resizes images according to the sizes defined in WP
- defines the featured image to be the first post image (option)
- keeps the alt image attribute
- modifies the internal links
- compatible with the MySQL, PostgreSQL and SQLite Drupal database drivers
No need to subscribe to an external web site.
The Premium version includes these extra features:
- migrates the comments
- migrates the authors
- migrates the administrators
- migrates the users
- migrates the custom post types
- migrates the custom taxonomies
- migrates the custom fields
- migrates the custom users fields
- migrates the users pictures
- migrates the navigation menus
- migrates the blocks as inactive widgets
- authenticates the users with their Drupal passwords
- SEO: redirects the Drupal URLs to the corresponding WordPress URLs
- ability to not import some data
- ability to import only specific node types
- imports and replaces the Image Assist shortcodes
- imports the images managed by the Image Attach Drupal module
- imports the nodes relationships
- imports the Drupal 8 Media entities
- imports the Drupal Media
- imports the Video Embed fields
The Premium version can be purchased on: https://www.fredericgilles.net/fg-drupal-to-wordpress/
The Premium version allows the use of add-ons that enhance functionality:
- CCK Custom Content Kit
- Meta tags
- Location custom fields
- Ubercart store
- Drupal Commerce store
- Name custom fields
- Addressfield custom fields
- NodeBlock fields
- EntityReference relationships
- Media Provider (S3, SoundCloud, YouTube media)
- Field collections
- Domain Access
- Profile2 user fields
These modules can be purchased on: https://www.fredericgilles.net/fg-drupal-to-wordpress/add-ons/
- English (default)
- French (fr_FR)
- other can be translated
- Install the plugin in the Admin => Plugins menu => Add New => Upload => Select the zip file => Install Now
- Activate the plugin in the Admin => Plugins menu
- Run the importer in Tools > Import > Drupal
- Configure the plugin settings. You can find the Drupal database parameters in the Drupal file sites/default/settings.php
I get the message: “[fg-drupal-to-wp] Couldn’t connect to the Drupal database. Please check your parameters. And be sure the WordPress server can access the Drupal database. SQLSTATE  Access denied for user ‘xxx’@’localhost’ (using password: YES)”
- First verify your login and password to the Drupal database.
If Drupal and WordPress are not installed on the same host:
- If you use CPanel on the Drupal server, a solution is to allow a remote MySQL connection.
- go into the Cpanel of the Drupal server
- go down to Database section and click “Remote MySQL”
- There you can add an access host (WordPress host). Enter the access host as the SOME-WEBSITE-DOMAIN-OR-IP-ADDRESS and click add host.
- Another solution is to copy the Drupal database on the WordPress database:
- export the Drupal database to a SQL file (with phpMyAdmin for example)
- import this SQL file on the same database as WordPress
- run the migration by using WordPress database credentials (host, user, password, database) instead of the Drupal ones in the plugin settings.
I get this error when testing the connection: “SQLSTATE[HY000]  Connection refused” or “SQLSTATE[HY000]  No such file or directory”
- This error happens when the host is set like localhost:/tmp/mysql5d.sock
Instead, you must set the host to be localhost;unix_socket=/tmp/mysql5d.sock
The migration stops and I get the message: “Fatal error: Allowed memory size of XXXXXX bytes exhausted” or I get the message: “Internal server error”
- First, deactivate all the WordPress plugins except the ones used for the migration
- You can run the migration again. It will continue where it stopped.
- You can add:
define('WP_MEMORY_LIMIT', '512M');in your wp-config.php file to increase the memory allowed by WordPress
- You can also increase the memory limit in php.ini if you have write access to this file (ie: memory_limit = 1G). See the increase memory limit procedure.
The media are not imported
- Check the URL field that you filled in the plugin settings. It must be your Drupal home page URL and must start with http:// or https://
The media are not imported and I get the error message: “Warning: copy() [function.copy]: URL file-access is disabled in the server configuration”
- The PHP directive “Allow URL fopen” must be turned on in php.ini to copy the medias. If your remote host doesn’t allow this directive, you will have to do the migration on localhost.
I get the message: “Fatal error: Class ‘PDO’ not found”
- PDO and PDO_MySQL libraries are needed. You must enable them in php.ini on the WordPress host.
Or on Ubuntu:
sudo php5enmod pdo
sudo service apache2 reload
I get this error: PHP Fatal error: Undefined class constant ‘MYSQL_ATTR_INIT_COMMAND’
- You have to enable PDO_MySQL in php.ini on the WordPress host. That means uncomment the line extension=pdo_mysql.so in php.ini
Does the migration process modify the Drupal site it migrates from?
Fg Drupal To Wordpress
- No, it only reads the Drupal database.
I get this error: Erreur !: SQLSTATE[HY000]  Unknown system variable ‘NAMES’
- It comes from MySQL 4.0. It will work if you move your database to MySQL 5.0 before running the migration.
I get this error “Parse error: syntax error, unexpected T_PAAMAYIM_NEKUDOTAYIM”
- You must use at least PHP 5.3 on your WordPress site.
I get this error: SQLSTATE[HY000]  The server requested authentication method unknown to the client
- It is a compatibility issue with your version of MySQL.
You can read this post to fix it: http://forumsarchive.laravel.io/viewtopic.php?id=8667
None image get transferred into the WordPress uploads folder. I’m using Xampp on Windows.
- Xampp puts the htdocs in the applications folder which is write protected. You need to move the htdocs to a writeable folder.
Do I need to keep the plugin activated after the migration?
- No, you can deactivate or even uninstall the plugin after the migration (for the free version only).
Fg Drupal To Wordpress
My screen hangs because of a lot of errors in the log window
- You can stop the log auto-refresh by unselecting the log auto-refresh checkbox
Don’t hesitate to let a comment on the forum or to report bugs if you found some.