performance-audit-plugin icon indicating copy to clipboard operation
performance-audit-plugin copied to clipboard

Plugin API Integration Test fails with SQL error

Open DevDavido opened this issue 5 months ago • 0 comments

Currently, the Plugin API Integration Test fails with SQL error:

[20-Dec-2023 12:34:03 UTC] [localhost] Error in Matomo (tracker): Error query: Error query: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'idaction_url' in 'field list' In query:
INSERT INTO log_link_visit_action (idvisit, idsite, idvisitor, idaction_url, idaction_url_ref, idaction_name_ref, server_time, idpageview, pageview_position, time_spent_ref_action, idaction_name) VALUES (?,?,?,?,?,?,?,?,?,?,?)
Parameters: array (   0 => '1',   1 => 1,   2 => '���m?��',   3 => '2',   4 => 0,   5 => 0,   6 => '2020-06-14 23:00:00',   7 => 'd7c98e',   8 => 1,   9 => 0,   10 => '1', )
In query: INSERT INTO log_link_visit_action (idvisit, idsite, idvisitor, idaction_url, idaction_url_ref, idaction_name_ref, server_time, idpageview, pageview_position, time_spent_ref_action, idaction_name) VALUES (?,?,?,?,?,?,?,?,?,?,?)
Parameters: array (   0 => '1',   1 => 1,   2 => '���m?��',   3 => '2',   4 => 0,   5 => 0,   6 => '2020-06-14 23:00:00',   7 => 'd7c98e',   8 => 1,   9 => 0,   10 => '1', )

Tested with Matomo 4.x and the column supposed to exist, so potentially an issue of the test environment.

DevDavido avatar Dec 20 '23 13:12 DevDavido