MarketingCampaignsReporting plugin startup error

After installing MarketingCampaignsReporting for Matomo4, this error appears:
Mysqli prepare error: Unknown column 'log_visit.campaign_name' in 'field list' - in plugin MarketingCampaignsReporting.

Anyone knows why? Running Matomo 4.3.1 using MySQL

I think your installation must have failed.
If you run the installation in the GUI this might time out on a large database for example. I recommend installing plugins from the console in a production environment.
When the plugin is installed there are new columns added to the table log_visit. Note this is for version 4.1.1 of MarketingCampaignsReporting

These SQL queries will be executed:

ALTER TABLE matomo_log_visit ADD COLUMN campaign_content VARCHAR(255) NULL, ADD COLUMN campaign_group VARCHAR(255) NULL, ADD COLUMN campaign_id VARCHAR(100) NULL, ADD COLUMN campaign_keyword VARCHAR(255) NULL, ADD COLUMN campaign_medium VARCHAR(255) NULL, ADD COLUMN campaign_name VARCHAR(255) NULL, ADD COLUMN campaign_placement VARCHAR(100) NULL, ADD COLUMN campaign_source VARCHAR(255) NULL;
ALTER TABLE matomo_log_conversion ADD COLUMN campaign_content VARCHAR(255) NULL, ADD COLUMN campaign_group VARCHAR(255) NULL, ADD COLUMN campaign_id VARCHAR(100) NULL, ADD COLUMN campaign_keyword VARCHAR(255) NULL, ADD COLUMN campaign_medium VARCHAR(255) NULL, ADD COLUMN campaign_name VARCHAR(255) NULL, ADD COLUMN campaign_placement VARCHAR(100) NULL, ADD COLUMN campaign_source VARCHAR(255) NULL;

if installing via ./console plugin:activate MarketingCampaignsReporting also run
./console core:update to add tables

1 Like