Errors and Warnings when using funnels

Premium Features
1

Hi

Started using funnels om matomo 5.1.1 php 8.1.29 plugin version 5.3.6

Even though i dont get any validation error on the form i get the following error on saving changes in funnels
“SQLSTATE[42S22]: Column not found: 1054 Unknown column ‘revision’ in ‘field list’”

The funnel is saved even though the error occurs

Also this warning is triggered continously
WARNING: /plugins/Funnels/API.php(150): Warning - Undefined array key "revision" - Matomo 5.1.1 - Please report this message in the Matomo forums:

Any suggestions on how to handle this?

2

Hi @Marcus_Hallenberg. Upon checking, it seems like you didn’t ran the migration. To fix this, please run this query:

UPDATE `matomo_option` SET `option_value` = '5.0.0' WHERE `matomo_option`.`option_name` = 'version_Funnels';

And after that, please run: ./console core:update

or directly add the 2 columns in DB:
ALTER TABLE `funnel` ADD COLUMN `revision` MEDIUMINT(8) UNSIGNED NOT NULL DEFAULT 0 AFTER `idgoal`;

ALTER TABLE `funnel` ADD COLUMN `name` varchar(50) AFTER `revision`;