Closed (works as designed)
Project:
DBTNG Migrator
Version:
7.x-1.0
Component:
Code
Priority:
Normal
Category:
Bug report
Assigned:
Unassigned
Reporter:
Created:
18 Apr 2012 at 18:34 UTC
Updated:
24 Oct 2013 at 06:58 UTC
I am testing out this module for a client. They need to migrate from MySQL to SQLite entirely from the CLI. I was able to migrate some test databases using the web ui, but am continuing to get the following error message via drush-
Failed to CREATE a test table on your database server with the command CREATE TABLE {drupal_install_test} (id int NULL). The server reports the following message: SQLSTATE[HY000]: General error: 14 unable to open database file
Are you sure the configured username has the necessary permissions to create tables in the database?
in DatabaseTasks-runTasks() (line 418 of /includes/install.inc).
PDOException: SQLSTATE[HY000]: General error: 1 no such table: watchdog: INSERT INTO {watchdog} (uid, type, message, variables, severity, link, location, referer, hostname, timestamp) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?); Array(there's more, but I figured i'd leave it at that for now, I can share the entire error message if that's helpful though).
I double-checked the write permissions for the database file and they look fine, also as I mentioned earlier, I was able to complete the exact same migration through the web ui with no problem so I'm not sure why it's failing on drush's end.
Comments
Comment #1
josh waihi commentedIt is a permissions issue. The permissions must work for the user you're executing drush as, not the webserver.