Lukas
(Lukas Winkler)
October 6, 2022, 7:19pm
#2
@SteveG That code was newly added in 4.12.0 (with https://github.com/matomo-org/matomo/pull/19490 )
@SSFGizmo Do you know what exactly you did, when that error occured?
SteveG
(Stefan Giehl)
October 7, 2022, 8:42am
#3
@SSFGizmo could you maybe also check your database if the goals table has a description column or not?
@SteveG
DESCRIBE matomo_goal;
+------------------------+--------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+------------------------+--------------+------+-----+---------+-------+
| idsite | int(11) | NO | PRI | NULL | |
| idgoal | int(11) | NO | PRI | NULL | |
| name | varchar(50) | NO | | NULL | |
| match_attribute | varchar(20) | NO | | NULL | |
| pattern | varchar(255) | NO | | NULL | |
| pattern_type | varchar(25) | NO | | NULL | |
| case_sensitive | tinyint(4) | NO | | NULL | |
| allow_multiple | tinyint(4) | NO | | NULL | |
| revenue | float | NO | | NULL | |
| deleted | tinyint(4) | NO | | 0 | |
| event_value_as_revenue | tinyint(4) | NO | | 0 | |
+------------------------+--------------+------+-----+---------+-------+
On the another Server with the same matomo version (without warnings)
DESCRIBE matomo_goal;
+------------------------+--------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+------------------------+--------------+------+-----+---------+-------+
| idsite | int(11) | NO | PRI | NULL | |
| idgoal | int(11) | NO | PRI | NULL | |
| name | varchar(50) | NO | | NULL | |
| description | varchar(255) | NO | | | |
| match_attribute | varchar(20) | NO | | NULL | |
| pattern | varchar(255) | NO | | NULL | |
| pattern_type | varchar(25) | NO | | NULL | |
| case_sensitive | tinyint(4) | NO | | NULL | |
| allow_multiple | tinyint(4) | NO | | NULL | |
| revenue | float | NO | | NULL | |
| deleted | tinyint(4) | NO | | 0 | |
| event_value_as_revenue | tinyint(4) | NO | | 0 | |
+------------------------+--------------+------+-----+---------+-------+
@Lukas
Mouse click on ‘Administration’.
index.php?module=CoreAdminHome&action=home&idSite=XXX&period=day&date=yesterday
SteveG
(Stefan Giehl)
October 7, 2022, 10:02am
#6
@SteveG OK, thank you
ALTER TABLE matomo_goal ADD COLUMN description VARCHAR(255) NOT NULL DEFAULT '' AFTER name;