Import 1.5-db to core 1.9.2

Support & Bugs
1

hi,

i somewhat messed up my piwik. i did an update from older 1.5 core to 1.9.2 and imported a 1.5- generated db-backup (used mysqldumper), getting error " The requested website id = 1 (or its property ecommerce) couldn’t be found " after login, so i guess there is a severe mismatch…

Backtrace -->

#0 Piwik_ErrorHandler(…) called at [/srv/www/vhosts/domain.com/httpdocs/piwik/core/Site.php:260]
#1 Piwik_Site::getFor(…) called at [/srv/www/vhosts/domain.com/httpdocs/piwik/core/Site.php:326]
#2 Piwik_Site::isSiteSearchEnabledFor(…) called at [/srv/www/vhosts/domain.com/httpdocs/piwik/plugins/Actions/Actions.php:558]
#3 Piwik_Actions->isSiteSearchEnabled(…) called at [/srv/www/vhosts/domain.com/httpdocs/piwik/plugins/Actions/Actions.php:546]
#4 Piwik_Actions->addMenus(…) called at [:]
#5 call_user_func_array(…) called at [/srv/www/vhosts/domain.com/httpdocs/piwik/libs/Event/Dispatcher.php:284]
#6 Event_Dispatcher->postNotification(…) called at [/srv/www/vhosts/domain.com/httpdocs/piwik/core/PluginsManager.php:722]
#7 Piwik_PostEvent(…) called at [/srv/www/vhosts/domain.com/httpdocs/piwik/core/Menu/Main.php:65]
#8 Piwik_Menu_Main->get(…) called at [/srv/www/vhosts/domain.com/httpdocs/piwik/core/Menu/Main.php:90]
#9 Piwik_GetMenu(…) called at [/srv/www/vhosts/domain.com/httpdocs/piwik/plugins/CoreHome/Controller.php:58]
#10 Piwik_CoreHome_Controller->getDefaultIndexView(…) called at [/srv/www/vhosts/domain.com/httpdocs/piwik/plugins/CoreHome/Controller.php:92]
#11 Piwik_CoreHome_Controller->index(…) called at [:]
#12 call_user_func_array(…) called at [/srv/www/vhosts/domain.com/httpdocs/piwik/core/FrontController.php:138]
#13 Piwik_FrontController->dispatch(…) called at [/srv/www/vhosts/domain.com/httpdocs/piwik/index.php:53]

2

You can force past upgrades paths with: Update - Analytics Platform - Matomo

3

i did that (using phpmyadmin), getting the error:

CREATE TABLE piwik_log_conversion_item (
idsite int( 10 ) UNSIGNED NOT NULL ,
idvisitor BINARY( 8 ) NOT NULL ,
server_time DATETIME NOT NULL ,
idvisit INTEGER( 10 ) UNSIGNED NOT NULL ,
idorder varchar( 100 ) NOT NULL ,
idaction_sku INTEGER( 10 ) UNSIGNED NOT NULL ,
idaction_name INTEGER( 10 ) UNSIGNED NOT NULL ,
idaction_category INTEGER( 10 ) UNSIGNED NOT NULL ,
price FLOAT NOT NULL ,
quantity INTEGER( 10 ) UNSIGNED NOT NULL ,
deleted TINYINT( 1 ) UNSIGNED NOT NULL ,
PRIMARY KEY ( idvisit, idorder, idaction_sku ) ,
INDEX index_idsite_servertime( idsite, server_time )
)DEFAULT CHARSET = utf8

#1050 - Table ‘piwik_log_conversion_item’ already exists

is there a way importing the old data (1.4) into a new db (1.9.2)?

4

this table was added in 1.5 so try setting the query with 1.6 since you’re already at least running 1.5 ?

if not working increase versions number until it works (see verion numbers in piwik/core/Updates/