Drop-down list 'Website' on Dashboard is missing

[riede]

Hello,

the Drop-down list ‘Website’ on the Dashboard is missing.
There is none available.

Also the Dashboard for all websites is empty.
There is only the menu for the periods of time on the top left corner.
This happens for the settings “All websites” too. I am not able to add new websites.

I don’t know since when the problem exists.

There are:

• no php errors
• no mysql errors
• the table are all clean (mysqlcheck)
• latest piwik version
• tracking works for id 1
• archiving works for id 1
• no debug messages from piwik
• no sql errors
• processed: Piwik reporting UI doesn't have any css style or, the menu text appears on a white background, or I get JavaScript errors in the Piwik UI. How to fix this display problem? - Analytics Platform - Matomo
• processed: I'm a developer, how do I enable logging (and / or SQL profiling) in Piwik? - Analytics Platform - Matomo

Can I check the database manually or execute a specific query to verify the data?
Do you have any ideas?

Best regards
Mark

[riede]

Is it maybe necessary or possible to reinstall or update the module SiteManager?
Maybe this function is broken?

I’ve logged the queries but I don’t find the broken one.

Dashboard > All Websites

SET NAMES 'utf8'
SELECT DATABASE()
SELECT option_value, option_name FROM `piwik_option` WHERE autoload = 1
SELECT option_value FROM `piwik_option` WHERE option_name = 'TestingIfDatabaseConnectionWorked'
SELECT * FROM piwik_user WHERE login = '<BLACKENED>'
SELECT language FROM piwik_user_language WHERE login = '<BLACKENED>'
SELECT data FROM piwik_session WHERE id = '<BLACKENED>' AND modified + lifetime >= '<BLACKENED>'
SELECT * FROM piwik_site
            WHERE idsite = '1'
SELECT language FROM piwik_user_language WHERE login = '<BLACKENED>'
SELECT login, email, token_auth
             FROM piwik_user
             WHERE superuser_access = 1
             ORDER BY date_registered ASC
SELECT login, email, token_auth
             FROM piwik_user
             WHERE superuser_access = 1
             ORDER BY date_registered ASC
SELECT * FROM piwik_user WHERE login = '<BLACKENED>'
SELECT option_value FROM `piwik_option` WHERE option_name = '<BLACKENED>_defaultReport'
SELECT option_value FROM `piwik_option` WHERE option_name = '<BLACKENED>_defaultReportDate'
SELECT option_value FROM `piwik_option` WHERE option_name = 'TaskScheduler.timetable'
SELECT idsite FROM piwik_site
SELECT report.*
                                FROM piwik_report AS `report`
                                        JOIN piwik_site
                                        USING (idsite)
                                WHERE deleted = 0
SELECT option_value FROM `piwik_option` WHERE option_name = 'UpdateCheck_LatestVersion'
SELECT * FROM piwik_user WHERE login = '<BLACKENED>'
SELECT language FROM piwik_user_language WHERE login = '<BLACKENED>'

Settings > Administration > Websites

SET NAMES 'utf8'
SELECT DATABASE()
SELECT option_value, option_name FROM `piwik_option` WHERE autoload = 1
SELECT option_value FROM `piwik_option` WHERE option_name = 'TestingIfDatabaseConnectionWorked'
SELECT * FROM piwik_user WHERE login = '<BLACKENED>'
SELECT language FROM piwik_user_language WHERE login = '<BLACKENED>'
SELECT data FROM piwik_session WHERE id = '<BLACKENED>' AND modified + lifetime >= '<BLACKENED>'
SELECT * FROM piwik_site
            WHERE idsite = '1'
SELECT login, email, token_auth
             FROM piwik_user
             WHERE superuser_access = 1
             ORDER BY date_registered ASC
SELECT login, email, token_auth
             FROM piwik_user
             WHERE superuser_access = 1
             ORDER BY date_registered ASC
SELECT * FROM piwik_user WHERE login = '<BLACKENED>'
SELECT option_value FROM `piwik_option` WHERE option_name = '<BLACKENED>_defaultReport'
SELECT option_value FROM `piwik_option` WHERE option_name = '<BLACKENED>_defaultReportDate'
SELECT option_value FROM `piwik_option` WHERE option_name = 'TaskScheduler.timetable'
SELECT idsite FROM piwik_site
SELECT report.*
                                FROM piwik_report AS `report`
                                        JOIN piwik_site
                                        USING (idsite)
                                WHERE deleted = 0
SELECT login, email, token_auth
             FROM piwik_user
             WHERE superuser_access = 1
             ORDER BY date_registered ASC
SELECT idsite,access FROM piwik_access WHERE login = 'anonymous'
SELECT option_value FROM `piwik_option` WHERE option_name = 'UpdateCheck_LatestVersion'
SELECT * FROM piwik_user WHERE login = '<BLACKENED>'
SELECT language FROM piwik_user_language WHERE login = '<BLACKENED>'

[riede]

Ticket can be closed.
Foo with loadbalancing and SSL.

I am not a bot.