search

PiwikPRO / plugin-SiteMigration

Migrate websites and website data between two Piwik installations
17 stars 3 forks source link

Migration fails #11

Closed deejay1 closed 9 years ago

deejay1 commented 9 years ago

We're trying to migrate some sites from Piwik 2.11.2 to another instance, unfortunately it fails even though manual mysql access works fine. Database schemas on both sides are complete. Any hints on what can be wrong - the tables on both DB use underscores instead of . but AFAIK this shouldn't be an issue?

root@status-status-dev-www1:/srv/piwik# ./console migration:site -v -H host -U migracja -N piwik  2
DEBUG SitesManager[2015-03-17 07:50:46] Db::fetchAll() executing SQL: SELECT idsite FROM piwik_site
DEBUG SitesManager[2015-03-17 07:50:46] Db::fetchAll() executing SQL: SELECT idsite FROM piwik_site
Please provide the destination database password: 
INFO SiteMigration[2015-03-17 07:50:48] Start transaction
INFO SiteMigration[2015-03-17 07:50:48] Migrating site config

  [Zend_Db_Statement_Exception]                                                         
  SQLSTATE[42S02]: Base table or view not found: 1146 Table 'piwik.site' doesn't exist  

Exception trace:
 () at /srv/piwik/libs/Zend/Db/Statement/Pdo.php:234
 Zend_Db_Statement_Pdo->_execute() at /srv/piwik/libs/Zend/Db/Statement.php:300
 Zend_Db_Statement->execute() at /srv/piwik/libs/Zend/Db/Adapter/Abstract.php:479
 Zend_Db_Adapter_Abstract->query() at /srv/piwik/libs/Zend/Db/Adapter/Pdo/Abstract.php:238
 Zend_Db_Adapter_Pdo_Abstract->query() at /srv/piwik/core/Db/Adapter/Pdo/Mysql.php:234
 Piwik\Db\Adapter\Pdo\Mysql->query() at /srv/piwik/libs/Zend/Db/Adapter/Abstract.php:575
 Zend_Db_Adapter_Abstract->insert() at /srv/piwik/plugins/SiteMigration/Helper/DBHelper.php:43
 Piwik\Plugins\SiteMigration\Helper\DBHelper->executeInsert() at /srv/piwik/plugins/SiteMigration/Migrator/TableMigrator.php:56
 Piwik\Plugins\SiteMigration\Migrator\TableMigrator->processRow() at /srv/piwik/plugins/SiteMigration/Migrator/TableMigrator.php:47
 Piwik\Plugins\SiteMigration\Migrator\TableMigrator->migrate() at /srv/piwik/plugins/SiteMigration/Migrator/Migrator.php:144
 Piwik\Plugins\SiteMigration\Migrator\Migrator->migrateSiteConfig() at /srv/piwik/plugins/SiteMigration/Migrator/Migrator.php:107
 Piwik\Plugins\SiteMigration\Migrator\Migrator->migrate() at /srv/piwik/plugins/SiteMigration/Commands/MigrateSite.php:97
 Piwik\Plugins\SiteMigration\Commands\MigrateSite->execute() at /srv/piwik/vendor/symfony/console/Symfony/Component/Console/Command/Command.php:253
 Symfony\Component\Console\Command\Command->run() at /srv/piwik/vendor/symfony/console/Symfony/Component/Console/Application.php:874
 Symfony\Component\Console\Application->doRunCommand() at /srv/piwik/vendor/symfony/console/Symfony/Component/Console/Application.php:195
 Symfony\Component\Console\Application->doRun() at n/a:n/a
 call_user_func() at /srv/piwik/core/Console.php:58
 Piwik\{closure}() at /srv/piwik/core/Access.php:454
 Piwik\Access::doAsSuperUser() at /srv/piwik/core/Console.php:59
 Piwik\Console->doRun() at /srv/piwik/vendor/symfony/console/Symfony/Component/Console/Application.php:126
 Symfony\Component\Console\Application->run() at /srv/piwik/console:27

  [PDOException]                                                                        
  SQLSTATE[42S02]: Base table or view not found: 1146 Table 'piwik.site' doesn't exist  

Exception trace:
 () at /srv/piwik/libs/Zend/Db/Statement/Pdo.php:228
 PDOStatement->execute() at /srv/piwik/libs/Zend/Db/Statement/Pdo.php:228
 Zend_Db_Statement_Pdo->_execute() at /srv/piwik/libs/Zend/Db/Statement.php:300
 Zend_Db_Statement->execute() at /srv/piwik/libs/Zend/Db/Adapter/Abstract.php:479
 Zend_Db_Adapter_Abstract->query() at /srv/piwik/libs/Zend/Db/Adapter/Pdo/Abstract.php:238
 Zend_Db_Adapter_Pdo_Abstract->query() at /srv/piwik/core/Db/Adapter/Pdo/Mysql.php:234
 Piwik\Db\Adapter\Pdo\Mysql->query() at /srv/piwik/libs/Zend/Db/Adapter/Abstract.php:575
 Zend_Db_Adapter_Abstract->insert() at /srv/piwik/plugins/SiteMigration/Helper/DBHelper.php:43
 Piwik\Plugins\SiteMigration\Helper\DBHelper->executeInsert() at /srv/piwik/plugins/SiteMigration/Migrator/TableMigrator.php:56
 Piwik\Plugins\SiteMigration\Migrator\TableMigrator->processRow() at /srv/piwik/plugins/SiteMigration/Migrator/TableMigrator.php:47
 Piwik\Plugins\SiteMigration\Migrator\TableMigrator->migrate() at /srv/piwik/plugins/SiteMigration/Migrator/Migrator.php:144
 Piwik\Plugins\SiteMigration\Migrator\Migrator->migrateSiteConfig() at /srv/piwik/plugins/SiteMigration/Migrator/Migrator.php:107
 Piwik\Plugins\SiteMigration\Migrator\Migrator->migrate() at /srv/piwik/plugins/SiteMigration/Commands/MigrateSite.php:97
 Piwik\Plugins\SiteMigration\Commands\MigrateSite->execute() at /srv/piwik/vendor/symfony/console/Symfony/Component/Console/Command/Command.php:253
 Symfony\Component\Console\Command\Command->run() at /srv/piwik/vendor/symfony/console/Symfony/Component/Console/Application.php:874
 Symfony\Component\Console\Application->doRunCommand() at /srv/piwik/vendor/symfony/console/Symfony/Component/Console/Application.php:195
 Symfony\Component\Console\Application->doRun() at n/a:n/a
 call_user_func() at /srv/piwik/core/Console.php:58
 Piwik\{closure}() at /srv/piwik/core/Access.php:454
 Piwik\Access::doAsSuperUser() at /srv/piwik/core/Console.php:59
 Piwik\Console->doRun() at /srv/piwik/vendor/symfony/console/Symfony/Component/Console/Application.php:126
 Symfony\Component\Console\Application->run() at /srv/piwik/console:27

migration:site [--skip-archive-data] [--skip-log-data] [-H|--db-host="..."] [-U|--db-username="..."] [-P|--db-password="..."] [-N|--db-name="..."] [--db-prefix[="..."]] [--db-port="..."] [-F|--date-from="..."] [-T|--date-to="..."] idSite
deejay1 commented 9 years ago

OK, my bad I had to add a "piwik_" prefix to the command line.