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.

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

Mysqli prepare error after upgrade to v4.0.3 (Unknown column 'log_conversion.config_browser_name') #16868

Closed
bittner opened this issue Dec 2, 2020 · 6 comments
Closed

Mysqli prepare error after upgrade to v4.0.3 (Unknown column 'log_conversion.config_browser_name') #16868

bittner opened this issue Dec 2, 2020 · 6 comments
Labels
answered For when a question was asked and we referred to forum or answered it.

Comments

@bittner
Copy link

bittner commented Dec 2, 2020 •
edited

I have just upgraded from v3.14.1 to v4.0.3 over Matomo's web interface (after being notified by email).

After automatically downloading and installing the new version Matomo reported a few "unrecognized files" and prompted me to delete them on the target system: (indentation mine)

rm -Rf \
   ~/www/analytics/home/libs/bower_components \
   ~/www/analytics/home/vendor/container-interop \
   ~/www/analytics/home/vendor/piwik \
   ~/www/analytics/home/vendor/twig/twig/ext
rm ~/www/analytics/home/misc/others/ExamplePiwikTracker.php

The subsequent update of the database schema (I assume) took a little bit longer than in all the upgrades before (I started with < v2.4.9 in 2014).

Broken dashboard widgets

Afterwards I could log in just as normal, but I notice a red warning banner for a fraction of a second after the login, and now some widgets are broken:

image

image

image

Incompatible ExampleXxx plugins

The System Check complains about a "ExampleLogTables" plugin that could not be loaded due to incompatibility:

Das Plugin ExampleLogTables konnte nicht geladen werden, da folgende Abhängigkeiten fehlen: ExampleLogTables benötigt Piwik <4.0.0-b1 Bitte kontaktieren Sie Ihren Matomo Administrator.

Note that I have 3 websites that I track with one Matomo instance. Interestingly, the widgets of the first website are not affected, but the other two are. And the dashboard for "All websites" reports serious problems:

image

Uninstall links missing

Can I uninstall all the old "ExampleXxx" plugins and install compatible ones to fix this? The Adminstration ➜ System ➜ Plugins page doesn't show an "Uninstall" link for most of them. 😟
@Findus23
Copy link
Member

Findus23 commented Dec 2, 2020

Hi,

You can delete the Example* plugins, they are no longer shipped with Matomo 4.

@tsteur
Copy link
Member

tsteur commented Dec 2, 2020

To fix the browser column issue could you run the following SQL statement and check if it works afterwards @bittner ?

ALTER TABLE log_conversion ADD COLUMN config_browser_name VARCHAR(40) NULL;

If you have DB prefix configured then you might need to replace log_conversion with eg piwik_log_conversion. This should add the column and hopefully no other columns are missing. Let me know if you get a different error afterwards.

A long upgrade time is expected unfortunately in this major Matomo upgrade since we made changes to the database tables that store the raw data.

Any plugin in plugins directory that start with Example can be deleted. The next Matomo 4.0.4 update will do this also automatically. The 4.0.4 update should be due likely tomorrow.

Hope this helps. Let me know if not and we'll reopen the issue.

@tsteur tsteur closed this as completed Dec 2, 2020
@tsteur tsteur added the answered For when a question was asked and we referred to forum or answered it. label Dec 2, 2020
@bittner
Copy link
Author

bittner commented Dec 3, 2020

Thank you, @tsteur, adding the table column fixed the issue. 🥇

I also deleted the Example plugins on the file system. For now, my Matomo instance seems to work fine again.

Thanks again! 🙇 🏆

@tsteur
Copy link
Member

tsteur commented Dec 3, 2020

Great, glad this worked @bittner 👍

@ysard ysard mentioned this issue Dec 21, 2020
Closed
@datango
Copy link

datango commented Feb 3, 2021

I still have the problem that the column config_browser_name is not added by console core:update. I had to add it manualy. Otherwise console core:archive produces errors. (Matomo 4.1.1)

@datango datango mentioned this issue Feb 3, 2021
Closed
@phaser32
Copy link

To fix the browser column issue could you run the following SQL statement and check if it works afterwards @bittner ?

ALTER TABLE log_conversion ADD COLUMN config_browser_name VARCHAR(40) NULL;

If you have DB prefix configured then you might need to replace log_conversion with eg piwik_log_conversion. This should add the column and hopefully no other columns are missing. Let me know if you get a different error afterwards.

A long upgrade time is expected unfortunately in this major Matomo upgrade since we made changes to the database tables that store the raw data.

Any plugin in plugins directory that start with Example can be deleted. The next Matomo 4.0.4 update will do this also automatically. The 4.0.4 update should be due likely tomorrow.

Hope this helps. Let me know if not and we'll reopen the issue.

THANK YOU SO MUCH !!! This solve the issue!!

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
answered For when a question was asked and we referred to forum or answered it.
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
5 participants
@tsteur @bittner @Findus23 @phaser32 @datango