This was noticed while Upgrading from 10.0.1->10.0.2->11.0.0:
However, when clicking on the notification icon bell with the red dot on it and then hovering over the item of notification, the INCORRECT server is shown in the tool tip display.
In fact the INCORRECT server was actually the first server used in the INITIAL setup of config.php:
‘trusted_domains’=> array (0=> ‘first_server’, 1=>others, 2=>another) which is no longer used.
Now config.php is using ‘trusted_domains’=> array (0 => ‘new_server’,).
The web notification is obtaining the (target) server (in this case first_server) from a location that is stuck with the INITIAL setup value or the value used when the notification came in. In many cases that value may no longer be valid because the server has changed.
Having read the post "Survey client notification going to wrong URL"
Survey client notification going to wrong URL
Here are further details how to fixed the problem using MySQl database:
1. Log in to MySQL
mysql -u userName -p
2. Go to nextcloud database
SHOW databases; // get name of next cloud data base for example nc_database
3. Go to oc_notification table
SHOW tables; //table of interest is oc_notifictions
SELECT * FROM oc_notifications;
4. Field of interest is link. Select a couple of fields to see what is going on
SELECT notification_id, app, link FROM oc_notification;
5. Change link field to correct value
UPDATE oc_notifications set link = “correct_server_URL” WHERE notification_id=actual_value;
//not necessary to use WHERE clause
UPDATE oc_notifications set link = “correct_server_URL”;
5. Quit MySQL
Hovering over the item of notification should display the CORRECT server in the tool tip display.