Attachment: error
piwik.odt

Attachment: example error on my website
piwik.png

Hi aranud87,

I tried to reproduce this issue without success. Tried a manual update by copying the files as well as an automatic update using the UI. Can you tell me the steps you did when updating to the new version? Have you changed anything in the config file after installing Piwik in the first place? Maybe I can reproduce it then.

In addition, can you execute the following command within the Piwik directory and post the output?

./console customvariables:info

or 

php console customvariables:info

Hi,

I have done install the beta18 as the step on the website.
Many days after, i upload rc2 directly on ftp.

i can't (or i don't where) write the command.
My website is on OVH (http://www.mageia-debutant.fr/piwik)
If i check status, it is okay. (just it use NFS system and GeoIP but not important)

but i first time (beta18) all reports are empty.
So i do :

ALTER IGNORE TABLE log_visit ADD location_provider VARCHAR( 100 ) NULL

(it is not on my phpmyadmin too!, i haven't installed with prefix)
http://forum.piwik.org/read.php?8,113009,page=1#msg-113090

So after add that, my website run but with this errors

Hi,

I make re-install 2.2.0 with Adblock+ disable and now it is run fine.
But now all reports stay empty :'(

So i add :

ALTER IGNORE TABLE piwik_log_visit ADD location_provider VARCHAR( 100 ) NULL

Now, it is not empty but i have still errors :

WARN VisitsSummary14:17:04 [Failed to get data from API: SQLSTATE42S22: Column not found: 1054 Unknown column 'log_link_visit_action.custom_var_v5' in 'field list'#0 /homez.640/mageiade/www/piwik/libs/Zend/Db/Statement.php(300): Zend_Db_Statement_Pdo->execute(Array)#1 /homez.640/mageiade/www/piwik/libs/Zend/Db/Adapter/Abstract.php(479): Zend_Db_Statement->execute(Array)#2 /homez.640/mageiade/www/piwik/libs/Zend/Db/Adapter/Pdo/Abstract.php(238): Zend_Db_Adapter_Abstract->query('????SELECT?????...', Array)#3 /homez.640/mageiade/www/piwik/core/Db/Adapter/Pdo/Mysql.php(229): Zend_Db_Adapter_Pdo_Abstract->query('????SELECT?????...', Array)#4 /homez.640/mageiade/www/piwik/plugins/Actions/Archiver.php(273): Piwik\Db\Adapter\Pdo\Mysql->query('????SELECT?????...', Array)#5 /homez.640/mageiade/www/piwik/plugins/Actions/Archiver.php(247): Piwik\Plugins\Actions\Archiver->archiveDayQueryProcess('log_action.name...', Array, 'log_link_visit...', '12 DESC, name...', 'log_action.idac...', 'idaction_name', Object(Piwik\RankingQuery))#6 /homez.640/mageiade/www/piwik/plugins/Actions/Archiver.php(93): Piwik\Plugins\Actions\Archiver->archiveDayActions('50000')#7 /homez.640/mageiade/www/piwik/core/ArchiveProcessor/PluginsArchiver.php(101): Piwik\Plugins\Actions\Archiver->aggregateDayReport()#8 /homez.640/mageiade/www/piwik/core/ArchiveProcessor/Loader.php(118): Piwik\ArchiveProcessor\PluginsArchiver->callAggregateAllPlugins('1', '0')#9 /homez.640/mageiade/www/piwik/core/ArchiveProcessor/Loader.php(72): Piwik\ArchiveProcessor\Loader->prepareAllPluginsArchive(false, false)#10 /homez.640/mageiade/www/piwik/core/Archive.php(802): Piwik\ArchiveProcessor\Loader->prepareArchive('VisitsSummary')#11 /homez.640/mageiade/www/piwik/core/Archive.php(615): Piwik\Archive->prepareArchive(Array, Object(Piwik\Site), Object(Piwik\Period\Day))#12 /homez.640/mageiade/www/piwik/core/Archive.php(557): Piwik\Archive->cacheArchiveIdsAfterLaunching(Array, Array)#13 /homez.640/mageiade/www/piwik/core/Archive.php(498): Piwik\Archive->getArchiveIds(Array)#14 /homez.640/mageiade/www/piwik/core/Archive.php(342): Piwik\Archive->get(Array, 'numeric')#15 /homez.640/mageiade/www/piwik/plugins/VisitsSummary/API.php(59): Piwik\Archive->getDataTableFromNumeric(Array)#16 function: Piwik\Plugins\VisitsSummary\API->get('1', 'day', '2014-03-23,2014...', false, 'nb_visits')#17 /homez.640/mageiade/www/piwik/core/API/Proxy.php(209): call_user_func_array(Array, Array)#18 /homez.640/mageiade/www/piwik/plugins/API/API.php(452): Piwik\API\Proxy->call('\Piwik\Plugins...', 'get', Array)#19 function: Piwik\Plugins\API\API->get('1', 'day', '2014-03-23,2014...', false, 'nb_visits')#20 /homez.640/mageiade/www/piwik/core/API/Proxy.php(209): call_user_func_array(Array, Array)#21 /homez.640/mageiade/www/piwik/core/API/Request.php(215): Piwik\API\Proxy->call('\Piwik\Plugins...', 'get', Array)#22 /homez.640/mageiade/www/piwik/core/ViewDataTable/Request.php(48): Piwik\API\Request->process()#23 /homez.640/mageiade/www/piwik/core/Plugin/ViewDataTable.php(286): Piwik\ViewDataTable\Request->loadDataTableFromAPI(Array)#24 /homez.640/mageiade/www/piwik/core/Plugin/Visualization.php(166): Piwik\Plugin\ViewDataTable->loadDataTableFromAPI(Array)#25 /homez.640/mageiade/www/piwik/core/Plugin/ViewDataTable.php(373): Piwik\Plugin\Visualization->buildView()#26 /homez.640/mageiade/www/piwik/core/Plugin/Controller.php(200): Piwik\Plugin\ViewDataTable->render()#27 /homez.640/mageiade/www/piwik/plugins/VisitsSummary/Controller.php(94): Piwik\Plugin\Controller->renderView(Object(Piwik\Plugins\CoreVisualizations\Visualizations\JqplotGraph\Evolution))#28 function: Piwik\Plugins\VisitsSummary\Controller->getEvolutionGraph()#29 /homez.640/mageiade/www/piwik/core/FrontController.php(505): call_user_func_array(Array, Array)#30 /homez.640/mageiade/www/piwik/core/FrontController.php(85): Piwik\FrontController->doDispatch(NULL, NULL, NULL)#31 /homez.640/mageiade/www/piwik/core/dispatch.php(34): Piwik\FrontController->dispatch()#32 /homez.640/mageiade/www/piwik/index.php(47): require_once('/homez.640/mage...')#33 {main}

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'log_link_visit_action.custom_var_v5' in 'field list'

@aranud87 when you first installed Piwik, did you first install 2.2.0-b18 or did you upgrade from a previous older version?

asking because of a report in IRC

<esrax> hi all, 2.2.0 install is bugged in that if you're installing over a database with previously existing tables some of them are not dropped/created properly. seems to be the cause of some of the complaints in http://forum.piwik.org/read.php?2,113051
4:15 PM <esrax> i'm not registering to explain it so fix it or don't, but that's the problem

Hi,

I try :
1- 2.2.0-b18 -> 2.2.0RC2
2- New "fresh" install 2.2.0 (final)

Always bug.

I see another post :
http://forum.piwik.org/read.php?8,114216,page=1#msg-114245

Same problem :
In OVH (with ad-block in browser)

Or a new post too :
http://forum.piwik.org/read.php?8,114224

Thank you

aranud87 could you please email thomas@piwik the details to access your server & how to reproduce the issue, as we would like to solve the issue (I've seen it reported in the forums several times).

There is another (likely un-related) ticket to problems during the installation #4990

@Aranud please try the proposal in http://forum.piwik.org/read.php?8,114216,page=1#msg-114449 and maybe it will help? thanks for reporting!

Thanks for the report. This was fixed in: a96c6b0 #5005

@mattab, how i apply the patch ?

Because i edit 2 files and it is not work yet

Core/Plugin/Manager.php
plugins/Installation/Controller.php

tests/PHPUnit/UI -> PhpUnit not exist

Thank you

WARN VisitsSummary11:01:52 [Failed to get data from API: SQLSTATE42S22: Column not found: 1054 Unknown column 'log_link_visit_action.custom_var_v5' in 'field list'#0 /homez.640/mageiade/www/piwik/libs/Zend/Db/Statement.php(300): Zend_Db_Statement_Pdo->execute(Array)#1 /homez.640/mageiade/www/piwik/libs/Zend/Db/Adapter/Abstract.php(479): Zend_Db_Statement->execute(Array)#2 /homez.640/mageiade/www/piwik/libs/Zend/Db/Adapter/Pdo/Abstract.php(238): Zend_Db_Adapter_Abstract->query('????SELECT?????...', Array)#3 /homez.640/mageiade/www/piwik/core/Db/Adapter/Pdo/Mysql.php(229): Zend_Db_Adapter_Pdo_Abstract->query('????SELECT?????...', Array)#4 /homez.640/mageiade/www/piwik/plugins/Actions/Archiver.php(273): Piwik\Db\Adapter\Pdo\Mysql->query('????SELECT?????...', Array)#5 /homez.640/mageiade/www/piwik/plugins/Actions/Archiver.php(247): Piwik\Plugins\Actions\Archiver->archiveDayQueryProcess('log_action.name...', Array, 'log_link_visit...', '12 DESC, name...', 'log_action.idac...', 'idaction_name', Object(Piwik\RankingQuery))#6 /homez.640/mageiade/www/piwik/plugins/Actions/Archiver.php(93): Piwik\Plugins\Actions\Archiver->archiveDayActions('50000')#7 /homez.640/mageiade/www/piwik/core/ArchiveProcessor/PluginsArchiver.php(101): Piwik\Plugins\Actions\Archiver->aggregateDayReport()#8 /homez.640/mageiade/www/piwik/core/ArchiveProcessor/Loader.php(118): Piwik\ArchiveProcessor\PluginsArchiver->callAggregateAllPlugins('31', '0')#9 /homez.640/mageiade/www/piwik/core/ArchiveProcessor/Loader.php(72): Piwik\ArchiveProcessor\Loader->prepareAllPluginsArchive(false, false)#10 /homez.640/mageiade/www/piwik/core/Archive.php(802): Piwik\ArchiveProcessor\Loader->prepareArchive('VisitsSummary')#11 /homez.640/mageiade/www/piwik/core/Archive.php(615): Piwik\Archive->prepareArchive(Array, Object(Piwik\Site), Object(Piwik\Period\Day))#12 /homez.640/mageiade/www/piwik/core/Archive.php(557): Piwik\Archive->cacheArchiveIdsAfterLaunching(Array, Array)#13 /homez.640/mageiade/www/piwik/core/Archive.php(498): Piwik\Archive->getArchiveIds(Array)#14 /homez.640/mageiade/www/piwik/core/Archive.php(342): Piwik\Archive->get(Array, 'numeric')#15 /homez.640/mageiade/www/piwik/plugins/VisitsSummary/API.php(59): Piwik\Archive->getDataTableFromNumeric(Array)#16 function: Piwik\Plugins\VisitsSummary\API->get('1', 'day', '2014-04-03,2014...', false, 'nb_visits')#17 /homez.640/mageiade/www/piwik/core/API/Proxy.php(209): call_user_func_array(Array, Array)#18 /homez.640/mageiade/www/piwik/plugins/API/API.php(452): Piwik\API\Proxy->call('\Piwik\Plugins...', 'get', Array)#19 function: Piwik\Plugins\API\API->get('1', 'day', '2014-04-03,2014...', false, 'nb_visits')#20 /homez.640/mageiade/www/piwik/core/API/Proxy.php(209): call_user_func_array(Array, Array)#21 /homez.640/mageiade/www/piwik/core/API/Request.php(215): Piwik\API\Proxy->call('\Piwik\Plugins...', 'get', Array)#22 /homez.640/mageiade/www/piwik/core/ViewDataTable/Request.php(48): Piwik\API\Request->process()#23 /homez.640/mageiade/www/piwik/core/Plugin/ViewDataTable.php(286): Piwik\ViewDataTable\Request->loadDataTableFromAPI(Array)#24 /homez.640/mageiade/www/piwik/core/Plugin/Visualization.php(166): Piwik\Plugin\ViewDataTable->loadDataTableFromAPI(Array)#25 /homez.640/mageiade/www/piwik/core/Plugin/ViewDataTable.php(373): Piwik\Plugin\Visualization->buildView()#26 /homez.640/mageiade/www/piwik/core/Plugin/Controller.php(200): Piwik\Plugin\ViewDataTable->render()#27 /homez.640/mageiade/www/piwik/plugins/VisitsSummary/Controller.php(94): Piwik\Plugin\Controller->renderView(Object(Piwik\Plugins\CoreVisualizations\Visualizations\JqplotGraph\Evolution))#28 function: Piwik\Plugins\VisitsSummary\Controller->getEvolutionGraph()#29 /homez.640/mageiade/www/piwik/core/FrontController.php(505): call_user_func_array(Array, Array)#30 /homez.640/mageiade/www/piwik/core/FrontController.php(85): Piwik\FrontController->doDispatch(NULL, NULL, NULL)#31 /homez.640/mageiade/www/piwik/core/dispatch.php(34): Piwik\FrontController->dispatch()#32 /homez.640/mageiade/www/piwik/index.php(47): require_once('/homez.640/mage...')#33 {main}

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'log_link_visit_action.custom_var_v5' in 'field list'

I do new install with github zip (very difficult with cookies yet) but it is not run :
no stats yet :

[[Image(http://issues.piwik.org/attachments/4989/piwik.2.png)]]

Attachment: with patch
piwik.2.png