In the D2D Migrate Wizard UI (and even in default.settings.php for D7) the sqlite database path is given as an example as /path/to/db/file.sqlite

The D2D Migrate Wizard UI states to provide the full db path:
http://cgit.drupalcode.org/migrate_d2d/tree/migrate_d2d_ui/migrate_d2d_u...

But, in the D7 sqlite database drivers. The default created DB for drupal 7 .ht.sqlite is stored path relative to the drupal root, as in sites/default/files/.ht.sqlite

The sqlite db path for the source database screen should be updated to say full path, or relative to the drupal root.

This is important for servers such as Cloud instances of Drupal (such as Pantheon) where the full path may change over the lifetime of the site, as the VM instance of drupal may change, as the VMs use filesystem bindpoints for data.

I will provide a verbiage patch update.

CommentFileSizeAuthor
#2 fix-sqlite-database-path-directions.patch674 bytestenken
Support from Acquia helps fund testing for Drupal Acquia logo

Comments

tenken created an issue. See original summary.

tenken’s picture

tenken CreditAttribution: tenken commented
FileSize
fix-sqlite-database-path-directions.patch674 bytes

Attached is a patch.

Drupal 7.x Core installs the Sqlite db (and can reference an sqlite db) at /sites/SUBSITE/.ht.sqlite by default.

See the install code here:
https://github.com/drupal/drupal/blob/7.51/includes/database/sqlite/inst...

So this path need not be absolute on systems where the absolute root server path is not always known.

I'm creating a custom MigrateWizardUI instance which mimics the D7 migrate_ui wizard and on Pantheon the full path may change over time. If migrations take time to properly test, in the lifetime the migration project this path should relative and not absolute on the server.