Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

Database is sometimes not initilialised correctly after a fresh install #4989

Closed
anonymous-matomo-user opened this issue Apr 14, 2014 · 15 comments
Closed

Database is sometimes not initilialised correctly after a fresh install #4989

anonymous-matomo-user opened this issue Apr 14, 2014 · 15 comments
Labels
Bug For errors / faults / flaws / inconsistencies etc. Major Indicates the severity or impact or benefit of an issue is much higher than normal but not critical.
Milestone
2.2.1

Comments

@anonymous-matomo-user
Copy link

Hi !

I am new user and i am french(sorry for my bad english)
I have remove google-analistic for open source Piwik (my website is about Mageia Linux ahah)

I begin install 2.2.0-b18 and today, I upload the 2.2.0-RC2, i have this bug yet.
many errors.

about " Column not found: 1054 Unknown column 'log_link_visit_action.custom_var_v5' in 'field list'"

It is very long text, so i put in the file.

Thank you
Arnaud.
Keywords: SQLSTATE
@anonymous-matomo-user
Copy link
Author

Attachment: error
piwik.odt

@anonymous-matomo-user
Copy link
Author

Attachment: example error on my website
piwik.png

@tsteur
Copy link
Member

tsteur commented Apr 15, 2014

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

@anonymous-matomo-user
Copy link
Author

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

@anonymous-matomo-user
Copy link
Author

Hi,

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

@anonymous-matomo-user
Copy link
Author

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'

@mattab
Copy link
Member

mattab commented Apr 23, 2014

@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

@anonymous-matomo-user
Copy link
Author

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

@mattab
Copy link
Member

mattab commented Apr 28, 2014

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

@mattab
Copy link
Member

mattab commented Apr 28, 2014

@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!

@anonymous-matomo-user
Copy link
Author

@mattab
Copy link
Member

mattab commented May 3, 2014

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

@anonymous-matomo-user
Copy link
Author

@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'

@anonymous-matomo-user
Copy link
Author

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)]]

@anonymous-matomo-user
Copy link
Author

Attachment: with patch
piwik.2.png

@anonymous-matomo-user anonymous-matomo-user added this to the 2.2.1 - Piwik 2.2.1 milestone Jul 8, 2014
@dev-101 dev-101 mentioned this issue May 14, 2014
Closed
@ToBeReplaced ToBeReplaced mentioned this issue Nov 9, 2014
Closed
This issue was closed.
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
Bug For errors / faults / flaws / inconsistencies etc. Major Indicates the severity or impact or benefit of an issue is much higher than normal but not critical.
Projects
None yet
Milestone
2.2.1
Development

No branches or pull requests
3 participants
@tsteur @mattab @anonymous-matomo-user