{"action":"reopened","issue":{"url":"https://api.github.com/repos/PiwikPRO/plugin-SiteMigration/issues/8","labels_url":"https://api.github.com/repos/PiwikPRO/plugin-SiteMigration/issues/8/labels{/name}","comments_url":"https://api.github.com/repos/PiwikPRO/plugin-SiteMigration/issues/8/comments","events_url":"https://api.github.com/repos/PiwikPRO/plugin-SiteMigration/issues/8/events","html_url":"https://github.com/PiwikPRO/plugin-SiteMigration/issues/8","id":58325047,"number":8,"title":"SQLSTATE[42S22]: Column not found: 1054 Unknown column 'referer_visit_server_date' in 'field list'","user":{"login":"angileriDE","id":11087717,"avatar_url":"https://avatars.githubusercontent.com/u/11087717?v=3","gravatar_id":"","url":"https://api.github.com/users/angileriDE","html_url":"https://github.com/angileriDE","followers_url":"https://api.github.com/users/angileriDE/followers","following_url":"https://api.github.com/users/angileriDE/following{/other_user}","gists_url":"https://api.github.com/users/angileriDE/gists{/gist_id}","starred_url":"https://api.github.com/users/angileriDE/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/angileriDE/subscriptions","organizations_url":"https://api.github.com/users/angileriDE/orgs","repos_url":"https://api.github.com/users/angileriDE/repos","events_url":"https://api.github.com/users/angileriDE/events{/privacy}","received_events_url":"https://api.github.com/users/angileriDE/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/PiwikPRO/plugin-SiteMigration/labels/bug","name":"bug","color":"fc2929"}],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":12,"created_at":"2015-02-20T09:02:37Z","updated_at":"2015-09-08T07:08:04Z","closed_at":null,"body":"Hi mattab,\r\n\r\nI'm currently running 2 piwik installations both version 2.11.0 and your plugin installed via piwiki-marketplace. I tried to merge them but I get following errors:\r\n\r\n\t[piwik@xxxxx analytics]# ./console migration:site -v --db-prefix=\"piwik_\" 1\r\n\tDEBUG SitesManager[2015-02-20 08:43:58] Db::fetchAll() executing SQL: SELECT idsite FROM stats_site\r\n\tDEBUG SitesManager[2015-02-20 08:43:58] Db::fetchAll() executing SQL: SELECT idsite FROM stats_site\r\n\tPlease provide the destination database password: \r\n\tINFO SiteMigration[2015-02-20 08:44:03] Start transaction\r\n\tINFO SiteMigration[2015-02-20 08:44:03] Migrating site config\r\n\tINFO SiteMigration[2015-02-20 08:44:03] Loading existing actions\r\n\tINFO SiteMigration[2015-02-20 08:44:03] Migrating log data - visits\r\n\tINFO SiteMigration[2015-02-20 08:44:03] Migrating log data - link visit action\r\n\tINFO SiteMigration[2015-02-20 08:44:04] Migrating log data - conversions and conversion items\r\n\r\n\r\n\t\t                                                                                              \r\n\t  [Zend_Db_Statement_Exception]                                                                       \r\n\t  SQLSTATE[42S22]: Column not found: 1054 Unknown column 'referer_visit_server_date' in 'field list'  \r\n\r\n\r\n\tException trace:\r\n\t () at /var/www/vhosts/mydomain.com/application/public/analytics/libs/Zend/Db/Statement/Pdo.php:234\r\n\t Zend_Db_Statement_Pdo->_execute() at /var/www/vhosts/mydomain.com/application/public/analytics/libs/Zend/Db/Statement.php:300\r\n\t Zend_Db_Statement->execute() at /var/www/vhosts/mydomain.com/application/public/analytics/libs/Zend/Db/Adapter/Abstract.php:479\r\n\t Zend_Db_Adapter_Abstract->query() at /var/www/vhosts/mydomain.com/application/public/analytics/libs/Zend/Db/Adapter/Pdo/Abstract.php:238\r\n\t Zend_Db_Adapter_Pdo_Abstract->query() at /var/www/vhosts/mydomain.com/application/public/analytics/core/Db/Adapter/Pdo/Mysql.php:234\r\n\t Piwik\\Db\\Adapter\\Pdo\\Mysql->query() at /var/www/vhosts/mydomain.com/application/public/analytics/libs/Zend/Db/Adapter/Abstract.php:575\r\n\t Zend_Db_Adapter_Abstract->insert() at /var/www/vhosts/mydomain.com/application/public/analytics/plugins/SiteMigration/Helper/DBHelper.php:43\r\n\t Piwik\\Plugins\\SiteMigration\\Helper\\DBHelper->executeInsert() at /var/www/vhosts/mydomain.com/application/public/analytics/plugins/SiteMigration/Migrator/TableMigrator.php:56\r\n\t Piwik\\Plugins\\SiteMigration\\Migrator\\TableMigrator->processRow() at /var/www/vhosts/mydomain.com/application/public/analytics/plugins/SiteMigration/Migrator/TableMigrator.php:47\r\n\t Piwik\\Plugins\\SiteMigration\\Migrator\\TableMigrator->migrate() at /var/www/vhosts/mydomain.com/application/public/analytics/plugins/SiteMigration/Migrator/Migrator.php:204\r\n\t Piwik\\Plugins\\SiteMigration\\Migrator\\Migrator->migrateLogVisitConversions() at /var/www/vhosts/mydomain.com/application/public/analytics/plugins/SiteMigration/Migrator/Migrator.php:114\r\n\t Piwik\\Plugins\\SiteMigration\\Migrator\\Migrator->migrate() at /var/www/vhosts/mydomain.com/application/public/analytics/plugins/SiteMigration/Commands/MigrateSite.php:97\r\n\t Piwik\\Plugins\\SiteMigration\\Commands\\MigrateSite->execute() at /var/www/vhosts/mydomain.com/application/public/analytics/vendor/symfony/console/Symfony/Component/Console/Command/Command.php:253\r\n\t Symfony\\Component\\Console\\Command\\Command->run() at /var/www/vhosts/mydomain.com/application/public/analytics/vendor/symfony/console/Symfony/Component/Console/Application.php:874\r\n\t Symfony\\Component\\Console\\Application->doRunCommand() at /var/www/vhosts/mydomain.com/application/public/analytics/vendor/symfony/console/Symfony/Component/Console/Application.php:195\r\n\t Symfony\\Component\\Console\\Application->doRun() at n/a:n/a\r\n\t call_user_func() at /var/www/vhosts/mydomain.com/application/public/analytics/core/Console.php:58\r\n\t Piwik\\Console->Piwik\\{closure}() at /var/www/vhosts/mydomain.com/application/public/analytics/core/Access.php:454\r\n\t Piwik\\Access::doAsSuperUser() at /var/www/vhosts/mydomain.com/application/public/analytics/core/Console.php:59\r\n\t Piwik\\Console->doRun() at /var/www/vhosts/mydomain.com/application/public/analytics/vendor/symfony/console/Symfony/Component/Console/Application.php:126\r\n\t Symfony\\Component\\Console\\Application->run() at /var/www/vhosts/mydomain.com/application/public/analytics/console:27\r\n"}}