Tag manager, create new variable, SQL problem

Support & Bugs
1

Hi there,
running Matomo on a FreeBSD system, v4.16.0 with core saying all is up to date. I’ve activated the Tag Manager plugin, and created a container for one of the managed websites. I then created a Matomo Analytics tag, but for that I need to create a new Variable. But when I try to create one I get

SQLSTATE[42S22]: Column not found: 1054 Unknown column ‘description’ in ‘field list’

at the top of the page and nothing gets created. What must I do to get past this ? Where - in which table - must I create that missing ‘description’ column ?

Thanks

j.

2

Ok I’ll reply to myself :slight_smile:
In this post I found the solution.

So if you have the same issue, please try :

ALTER TABLE `matomo_tagmanager_tag` ADD COLUMN `description` VARCHAR(1000) NOT NULL DEFAULT '' AFTER `name`;
ALTER TABLE `matomo_tagmanager_trigger` ADD COLUMN `description` VARCHAR(1000) NOT NULL DEFAULT '' AFTER `name`;
ALTER TABLE `matomo_tagmanager_variable` ADD COLUMN `description` VARCHAR(1000) NOT NULL DEFAULT '' AFTER `name`;

Regards,

j.

1 Like