4.0.5 issues with Actions and Goal plugins (unknown columns)

Support & Bugs
6

FYI - I manually checked the database structure and the table was missing the new columns - this is why I manually added them by using the attached SQL. I just wonder why the console command core:update did not check that the table structure was incomplete?

ALTER TABLE piwikdb.piwik_log_link_visit_action
ADD COLUMN search_cat VARCHAR(255) NULL DEFAULT NULL AFTER custom_dimension_5,
ADD COLUMN search_count VARCHAR(200) UNSIGNED NULL DEFAULT NULL AFTER search_cat,
ADD COLUMN time_dom_completion MEDIUMINT(10) UNSIGNED NULL DEFAULT NULL AFTER search_count,
ADD COLUMN time_dom_processing MEDIUMINT(10) UNSIGNED NULL DEFAULT NULL AFTER time_dom_completion,
ADD COLUMN time_network MEDIUMINT(10) UNSIGNED NULL DEFAULT NULL AFTER time_dom_processing,
ADD COLUMN time_on_load MEDIUMINT(10) UNSIGNED NULL DEFAULT NULL AFTER time_network,
ADD COLUMN time_server MEDIUMINT(10) UNSIGNED NULL DEFAULT NULL AFTER time_on_load,
ADD COLUMN time_transfer MEDIUMINT(10) UNSIGNED NULL DEFAULT NULL AFTER time_server,
ADD COLUMN idaction_product_cat INT(10) UNSIGNED NULL DEFAULT NULL AFTER time_transfer,
ADD COLUMN idaction_product_cat2 INT(10) UNSIGNED NULL DEFAULT NULL AFTER idaction_product_cat,
ADD COLUMN idaction_product_cat3 INT(10) UNSIGNED NULL DEFAULT NULL AFTER idaction_product_cat2,
ADD COLUMN idaction_product_cat4 INT(10) UNSIGNED NULL DEFAULT NULL AFTER idaction_product_cat3,
ADD COLUMN idaction_product_cat5 INT(10) UNSIGNED NULL DEFAULT NULL AFTER idaction_product_cat4,
ADD COLUMN idaction_product_name INT(10) UNSIGNED NULL DEFAULT NULL AFTER idaction_product_cat5,
ADD COLUMN product_price DOUBLE NULL DEFAULT NULL AFTER idaction_product_name,
ADD COLUMN idaction_product_sku INT(10) UNSIGNED NULL DEFAULT NULL AFTER product_price

1 Like
4.0.5 issue with GeoIP2 Core plugin