DevDavido / DevDavido/performance-audit-plugin

Plugin API Integration Test fails with SQL error

Open
#47 0 comments 0 reactions 0 assignees View on GitHub

Nobody has claimed this yet.

bug nostale
Dominant language
PHP
Stars
14
Forks
4
PR merge metrics
No merged PRs in 30d

Description

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.

Contributor guide

No contributing guide indexed for this repository

First steps

  1. Read the whole issue, then the project's contributing guide.
  2. Comment on the issue to say you are picking it up — it saves two people doing the same work.
  3. Fork the repository and make your change on a branch.
  4. Open a pull request that references the issue number.

Research direction

Start by running the Plugin API Integration Test and reproducing the SQL error. Inspect the test environment schema for log_link_visit_action and compare it with the INSERT statement shown, especially idaction_url. Done means the integration test completes without this column error in the supported test environment.

Written by the indexing model from the issue text.

Assessment

Tech stack
php, sql
Domain
databases, testing-qa
Issue type
Bug
Difficulty
3/5
Estimated time
1-2 days
Activity status
Stale
Clarity
Mostly clear
Newbie friendliness
35/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.