-
-
Notifications
You must be signed in to change notification settings - Fork 2.7k
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.
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
Error after upgrading to 2.7.0 #6280
Comments
Have you already executed the database updates for Piwik 2.7.0? |
I did: UPDATE 1 row affected.ALTER TABLE 2849 rows affected.UPDATE MySQL returned an empty result set (i.e. zero rows).Looked good. But then I ran into the issue mentioned. |
Can you try to run it again? There should be 2 updates |
Hi, Mysqli prepare error: Unknown column 'log_link_visit_action.idaction_content_name' in 'where clause' |
@tsteur . What do you mean with 2 updates. This is all there was. (As far as I could see). |
In theory there should be two updates. So after the first one was executed there should be another one. In case the update does not appear can you maybe execute |
I run the upgrade in the browser. |
I did it twice, as explained here : http://piwik.org/faq/how-to-update/#faq_179 |
Here is what i see when I go to another tab (Action tab) : WARN CoreHome[2014-09-24 07:25:00] [c52e7] Failed to get data from API: Mysqli prepare error: Unknown column 'log_link_visit_action.idaction_content_name' in 'where clause'#0 /home/chineast/public_html/piwik/libs/Zend/Db/Statement.php(115): Zend_Db_Statement_Mysqli->_prepare('\n\t\t\tSELECT\n\t\t\t\t...')#1 /home/chineast/public_html/piwik/libs/Zend/Db/Adapter/Mysqli.php(381): Zend_Db_Statement->_construct(Object(Piwik\Db\Adapter\Mysqli), '\n\t\t\tSELECT\n\t\t\t\t...')#2 /home/chineast/public_html/piwik/libs/Zend/Db/Adapter/Abstract.php(478): Zend_Db_Adapter_Mysqli->prepare('\n\t\t\tSELECT\n\t\t\t\t...')#3 /home/chineast/public_html/piwik/plugins/Actions/Archiver.php(273): Zend_Db_Adapter_Abstract->query('\n\t\t\tSELECT\n\t\t\t\t...', Array)#4 /home/chineast/public_html/piwik/plugins/Actions/Archiver.php(247): Piwik\Plugins\Actions\Archiver->archiveDayQueryProcess('log_action.name...', Array, 'log_link_visit...', ' |
@mattab : The Contents plugin is "Inactive" in my install. |
same for me |
Ha..! Enabling it gives me an other SQL statment. Thanx @mattab |
I can't enable it, as it says "The Piwik configuration file (config/config.ini.php) is not writable, some of your changes might not be saved. Please change permissions of the config file to make it writable." |
@mikeingz : My config.ini.php has also the 644. So it seems the owner of your file is incorrect. You may ask your ISP to take a look at this. |
I was finally able to enable the Contents plugin, and it also fixes the problem. Thank you |
Also experienced this. Enabling the "Contents" plugin and then doing Can I turn off "Contents" again now? Do I need it? (Why was it inactive? I don't recall turning it off.) |
you can try (if there is a problem let us know!) The Contents plugin though is an awesome new feature! it lets you easily track when certain blocks of your websites (image banners, text links, etc.) are seen by the user, and when they are clicked. See http://piwik.org/docs/content-tracking/ for more info |
@mattab So if this "Contents" plugin doesn't exist in a piwiki install upgraded to v2.7.0 where would one get it? Ran:
Getting:
|
Go to SETTINGS > Plugins > Contents > Activate. |
or type: |
This is weird, claims to be piwik 2.7 (I also just downloaded piwik.zip and unzip'ed over the directory just in case)
|
i see the |
The contents plugin wasn't activated after the upgrade of a piwik installation for me either, so I only got one update and the broken dashboard. Upon activating it I got the second update and everything was fixed. |
I can confirm that activating the plugin (it wasn't activated after the update), running db-upgrade again made things working again. |
Hello,
After upgrading to 2.7.0 (automatic update) I had to manualy execute the SQL statements:
Now i get the following error after loading the site:
API returned an error: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'log_link_visit_action.idaction_content_name' in 'where clause' at Pdo.php:234
Please help.
The text was updated successfully, but these errors were encountered: