What app is this about, and its version: Matomo, 5.9.0~ynh1
What YunoHost version are you running: YunoHost 12.1.39
What type of hardware are you using: VPS bought online
Describe your issue
Problem
After a clean install I had this error after login in the Matomo page:
“Error: no website was found in this Matomo installation.”
“Check the table ‘matomo_site’ in your database, it should contain your Matomo websites.”
When I looked in the MySQL database created the matomo_site table is indeed empty.
Solution
I added manually a new wesbite in this table:
INSERT INTO matomo_site (name, main_url, ecommerce, ts_created, sitesearch_keyword_parameters, sitesearch_category_parameters, timezone, currency, excluded_ips, excluded_parameters, excluded_user_agents, excluded_referrers, type,
keep_url_fragment,`group`)
VALUES ('matomo', 'https://yourdomainpath/matomo', 0, NOW(),'', '', 'Europe/Paris', 'EUR', '','','','','',0, '');
/!\ be careful to use backticks (`) around group column as it is a SQL reserved keyword
Share relevant logs or error messages
N/A