DevDavido / DevDavido/performance-audit-plugin
Plugin API Integration Test fails with SQL error
Open
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
- Read the whole issue, then the project's contributing guide.
- Comment on the issue to say you are picking it up — it saves two people doing the same work.
- Fork the repository and make your change on a branch.
- 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