search

PiwikPRO / plugin-SiteMigration

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

Base table or view not found: 1146 Table 'piwik.site' doesn't exist #28

Closed shivateja-madipalli closed 8 years ago

shivateja-madipalli commented 8 years ago

I am trying to migrate my piwik data from current Piwik to my Target Piwik, I am able to connect to my target piwik's mysql.

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

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

What I am not able to understand is error says it is unable to connect with "piwik.site" where as all the tables I have are like "piwik_site".

Can someone pls look into this.

shivateja-madipalli commented 8 years ago

Explicitly mentioning Piwik Table's prefix text worked for this issue. I have another issue though, the data isn't transmitting and it is taking lot of time.